Access 2007 Level 1

Training Provided by Online Training Directory 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. 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.

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

About The Training Provider: Online Training Directory

More Access Training from Online Training Directory

• Access 2000
• Access 2000 Expert
• Access 2000 Level 1
• Access 2000 Level 2
• Access 2000 Level 3
• Access 2000 MOUS
• Access 2000 Proficient
• Access 2002
• Access 2002 MOUS
• Access 2007 Level 2
• Microsoft Access 2002 Core
• Microsoft Access 2002 Expert
• Microsoft Access 2002 Level 1
• Microsoft Access 2002 Level 2
• Microsoft Access 2002 Level 3
• Microsoft Access 2003 (Levels 1-2-3)