Course Specifications: MS Access Level 2
Course length: 1 Day


Course Description:
Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data by establishing relationships and enforcing referential integrity. In addition, students will save data entry time by using sound table design techniques to control data entry and automate tasks.

Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports, and to share data over an intranet or the Internet by creating and using data access pages.

Course Outline - MS Access Level 2

• Principles of Table Design
• Principles of Table Relationships
• Table Design Techniques
• Designing Select Queries
• Customizing Form Designs
• Working with Data Access Pages
• Customizing Reports