Microsoft Office Access 2003 Level 1

Outcomes Upon completion of this course, students will be able to: Understand common database elements -- Navigate and modify tables -- Use Datasheet view to enter and manipulate table data -- Create new databases and tables -- Create relationships using referential integrity -- Create and modify forms -- Filter data and run queries -- Work with basic reports Assessment Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery. Look At Microsoft Office Access 2003 -- Launch Microsoft Office Access 2003 -- Open Access Databases And Examine The Database Window -- Change The Default File Format In Access -- Close Access Databases And Exit Access -- Understand Tables -- Navigate In Tables -- Modify Columns And Rows -- View Multiple Tables -- Enter Data In Datasheet View -- Use AutoCorrect -- Modify Table Data -- Find Records -- Delete Table Data -- Sort Table Data -- Explore And Use The Database Wizard -- Create Blank Databases From Scratch -- Examine Primary Keys -- Understand Data Types -- Create Tables In Design View And Set Primary Keys -- Use The Table Wizard -- Switch Between Views -- Understand Relationships -- Add Tables To The Relationships Window -- Create Table Relationships -- Enforce And Test Referential Integrity -- Edit Existing Relationships -- Organize And Print Relationships -- View Subdatasheets -- Understand Forms -- Create AutoForms -- Create Forms Using The Form Wizard -- Navigate Among Records -- Enter Data Using A Form -- Look At Form Design View -- Modify Control Properties -- Move And Delete Controls -- Align And Space Controls -- Understand Filters -- Use Filter By Form -- Use Filter By Selection And Sort Records -- Understand Queries -- Create Single-table Queries In Query Design View -- Create Select Queries Using A Wizard -- Delete, Move, And Hide Query Fields -- Find Duplicate Records -- Find Unmatched Records -- Understand Reports -- Create And Save AutoReports -- Create Reports Using A Wizard -- Navigate In Reports -- Preview Report Pages -- Modify Page Orientation And Margins -- Print Reports -- Examine The Help Task Pane -- Ask Help A Question -- Look At The Office Assistant Contact Hours: 24