print
Course Name
Microsoft Office Access 2003 Level 1

Contact Hours: 24
Course Description
PIN code provided for this course allows unlimited on-line access for 90 days. This course is designed to introduce students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. After they learn how to manipulate the Access interface and create their own databases, students will receive instruction in how to create and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data.
Outcome
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.
Outline

  1. Look At Microsoft Office Access 2003
  2. Launch Microsoft Office Access 2003
  3. Open Access Databases And Examine The Database Window
  4. Change The Default File Format In Access
  5. Close Access Databases And Exit Access
  6. Understand Tables
  7. Navigate In Tables
  8. Modify Columns And Rows
  9. View Multiple Tables
  10. Enter Data In Datasheet View
  11. Use AutoCorrect
  12. Modify Table Data
  13. Find Records
  14. Delete Table Data
  15. Sort Table Data
  16. Explore And Use The Database Wizard
  17. Create Blank Databases From Scratch
  18. Examine Primary Keys
  19. Understand Data Types
  20. Create Tables In Design View And Set Primary Keys
  21. Use The Table Wizard -- Switch Between Views
  22. Understand Relationships
  23. Add Tables To The Relationships Window
  24. Create Table Relationships
  25. Enforce And Test Referential Integrity
  26. Edit Existing Relationships
  27. Organize And Print Relationships
  28. View Subdatasheets
  29. Understand Forms
  30. Create AutoForms
  31. Create Forms Using The Form Wizard
  32. Navigate Among Records
  33. Enter Data Using A Form
  34. Look At Form Design View
  35. Modify Control Properties
  36. Move And Delete Controls
  37. Align And Space Controls
  38. Understand Filters
  39. Use Filter By Form
  40. Use Filter By Selection And Sort Records
  41. Understand Queries
  42. Create Single-table Queries In Query Design View
  43. Create Select Queries Using A Wizard
  44. Delete, Move, And Hide Query Fields
  45. Find Duplicate Records
  46. Find Unmatched Records
  47. Understand Reports
  48. Create And Save AutoReports
  49. Create Reports Using A Wizard
  50. Navigate In Reports
  51. Preview Report Pages
  52. Modify Page Orientation And Margins
  53. Print Reports
  54. Examine The Help Task Pane
  55. Ask Help A Question
  56. Look At The Office Assistant