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.
Course content
Advanced Tables and Queries
- Modify tables
- Use queries with operators
- Advanced query design
- Import databse objects
- Use action queries
- Use File/Database utilities
Forms and Reports
- Manipulatie controls
- Use design view
- Advanced form design
- Option groups and tab order
- Advanced report design
- Use editing tools
Prerequisite: Access Fundamentals