Microsoft Access Intermediate

Users with a basic understanding of Microsoft Office Access who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. 

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

- Organising Report Data
- Formatting Reports
- Common Report Tasks

Working with Queries

- Basic Queries
- Doing More with Queries
- Creating Advanced Queries
- Creating Management (Action) Queries

Please note that this training can focus on either Microsoft versions 2007, 2010 or 2013 - please state at the time of enquiry which version you would like this training to be held on. 

Delegates can also bring their own device to take the training on - please state that you wish to do this at the time of booking so that we can inform the training provider.