Learn how to create more sophisticated queries, forms and reports. Intermediate Access walks you through the application’s advanced tools for retrieving and manipulating data. The course teaches you how to create queries for modifying and/or deleting records and tables, the techniques for inserting calculations into reports and many time-saving methods to create user-friendly forms.
Note: this course covers Versions 2000, 2002, XP and 2003.
Learning Objectives
Advanced Tables and Queries
- Modify tables
- Use queries with operators
- Advanced query design
- Import database objects
- Use action queries
- Use File/Database utilities
Forms and Reports
- Manipulate controls
- Use design view
- Advanced form design
- Option groups and tab order
- Advanced report design
- Use editing tools
Prerequisite: Access Fundamentals
Non-members register at www.kpsminnesota.com