![](/media/dl2lpqgu/access-advanced.jpg)
Microsoft Access Advanced Training Courses
Enhance your database skills with advanced Microsoft Access techniques
All courses available in-class or remotely. To attend remotely, select "Remote East" or "Remote West" as your location on book now.
This 2-day Microsoft Access Advanced course is designed for individuals looking to expand their knowledge and skills in database management. Learn to create complex queries, customise reports, implement macros, and optimise database performance to meet advanced data management needs.
Microsoft Access Advanced Training Courses
![](/media/dl2lpqgu/access-advanced.jpg)
Advance your Microsoft Access skills in 2 days. Create complex queries, customise reports, and optimise database performance.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Advanced Course Details
![microsoft_gold](/media/d2mn3ivo/ms-partner-gold.png)
Access Course Outlines
Microsoft Access City Pages
Contact Us
What do I need to know to attend?
This course is ideal for individuals who already have a basic understanding of Microsoft Access and want to enhance their database management skills. It is recommended that you complete the Access Essentials course or have equivalent knowledge before attending.
Access Advanced Learning Outcomes
Upon completion of this course you will be able to:
- Apply advanced table, query, form, and report design techniques
- Customise user access to database objects
- Design user interfaces for automated processes
- Perform database maintenance and optimisation
Access Advanced Course Content
- Customising Tables and Relationships
- Advanced field properties and data types
- Managing complex relationships between tables
- Setting up referential integrity and cascade options
- Creating Applied Queries
- Performing calculations within queries
- Designing multi-table queries for advanced data extraction
- Using the Find Unmatched Query Wizard
- Advanced Query Techniques
- Creating Top Value Queries for ranked data
- Implementing Complex Calculations within queries
- Using Directional Join Queries for data analysis
- Running Parameter Queries through forms
- Understanding and creating SQL-specific queries
- Using Action Queries
- Introduction to Action Query types
- Creating Update, Append, and Delete Queries
- Automating data management with Action Queries
- Advanced Report Design
- Adding Custom Expressions to reports
- Integrating Mail Merge with Microsoft Word
- Designing reports for complex data presentation
- Working with Macros
- Recording, running, and assigning Macros
- Using Conditional Macros and IF statements
- Implementing SubMacros for complex automation
- Setting Database Start-up options with Macros
- Macros Workshop
- Updating Combo Box contents dynamically
- Controlling Form behaviour (Disable/Enable, Show/Hide controls)
- Importing data from Excel and updating tables through Macros
- Database Tools and Optimisation
- Compacting, repairing, and backing up databases
- Using the Database Documenter for in-depth analysis
- Analysing database performance and optimisation strategies
- Importing and Exporting data across applications
- Switchboards and Start-Up Forms
- Using the Switchboard Manager to create navigation menus
- Designing and customising Switchboard Forms
- Setting up Start-up Forms for streamlined user experience