Access 2007 Level 1


Full Description
Access 2007 Level 1


This entry-level course introduces 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. They will learn the importance of establishing relationships, as well as how to establish and edit relationships and enforce referential integrity. After learning to manipulate the Access interface and create their own databases, students will discover how to create and use the basic tools of the Access application: tables, forms, filters, sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data.


Outcomes:


Upon completion of this course, students will learn:
  1. What a database is
  2. How an effective database should be designed
  3. The importance of establishing relationships
  4. How to establish and edit relationships
  5. And how to enforce referential integrity


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.


Course Information (see above or below lessons, outlines, activities, etc.)
Program Outline


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

Contact Hours: 6