This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced Access tools and concepts in order to increase their knowledge and productivity.
Who Should Attend?
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.
Course Outline:
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
Additional Information:
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.
This course can be offered both as an open course and as a one-to-one private session with the trainer.