Course Specifications: MS Access Advanced
Course length: 1 Day


Course Description:
Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar. This course meets the Microsoft Proficiency Guidelines for Microsoft Access at the Expert level.

Course Outline - MS Access Advanced

• Parameter and Action Queries
• Query Joins and Crosstab Queries
• Using Advanced Form Techniques
• Creating Basic Macros to Automate Forms
• Using Macros to Provide User Interaction and Automate Tasks
• Using Advanced Report Techniques
• Web Capabilities and Data Integration
• Replicating Databases
• Encrypting Databases
• Mailing Labels