Advanced Techniques for Microsoft Access

PT1181
Summary
In this course, the student will learn to create advanced queries, create more efficient forms and reports and work with macros.
Prerequisites
The student should have completed the Introduction to Access 7.0 and Intermediate Access 7.0 courses or have the equivalent knowledge and experience.
Duration
1 Day/Lecture & Lab
Audience
This course is intended for users who are already familiar with Access 7.0
Topics
  • Designing parameter and action queries
  • Outer join and crosstab query techniques
  • Form design enhancements
  • Subform design
  • Using command buttons and macros with forms
  • Using macros to provide user interaction and to automate tasks
  • Advanced report techniques
  • Replicating database files
  • Using Access with other applications
  • Customizing Access

Related Scheduled Courses