Access 2007 Level 1

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. 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