Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
Microsoft Access Advanced Training Courses
Enhance your database skills with advanced Microsoft Access techniques
Delivered remotely across APAC.
Microsoft Access Advanced Training Courses
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.
Delivered remotely across APAC.
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
US$0
10 max
2 days
Select your country to view prices, and course dates.
Upcoming Courses:
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Advanced Course Details
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Access Course Outlines
Other Courses
Other Courses
Course Rating
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
phone
email
enquiry
