The Intermediate course is for individuals whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Access and other applications.
Your training and experience using Microsoft Access will give you basic database management skills such as creating tables, designing forms and reports, and building queries.
In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports.
Special Offer Multiple Delegate / Course Discounts Available - Contact Us for Details
19 results
19 results
Learning Objectives
Delegates will learn how to:
- Design a relational database
- Join tables to retrieve data from unrelated tables
- Streamline data entry and maintain data integrity
- Share data across applications
- Customise reports to organise and format the displayed information
Course Content
Advanced File Tasks
• Using Windows Explorer within Access • Database Management • Saving Your Files • Exporting Files • Linking Files
Working with Tables
• Customising Tables • Table Properties: Formatting • More Table Properties • Data Validation and Lookup Wizard
Working with Forms
• Basic Form Controls • Advanced Form Controls • Formatting Your Form • Formatting Controls • Using Themes
Working with Reports
• Organizing Report Data • Formatting Reports • Common Report Tasks
Working with Queries
• Basic Queries • Doing More with Queries • Creating Advanced Queries • Creating Management (Action) Queries
