Australia
New Zealand
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
Microsoft Access Advanced Training Courses - Singapore
Enhance your database skills with advanced Microsoft Access techniques
Enhance your database skills with advanced Microsoft Access techniques
5.00
Enhance your database skills with advanced Microsoft Access techniques
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.
Instructor-led courses, delivered remotely across Singapore.
Course Details
Download Course PDF
Upcoming Courses
We currently have no public courses scheduled. Please contact us to register your interest.
Access Training Courses
Access EssentialsThis 2-day Microsoft Access Essentials course is designed to introduce you to the fundamentals of database design using Microsoft Access. Gain practical skills in creating tables, managing data, designing queries, and generating reports to effectively manage and utilise your databases.
Instructor-led courses, delivered remotely across Singapore.
Access AdvancedThis 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.
Instructor-led courses, delivered remotely across Singapore.
Access Advanced Singapore 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
Frequently Asked Questions
What is Remote Training?
Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
Which courses are available if I am working from home?
Currently all of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions in the days before your course.
How can I prepare if I am attending an online course?
The browser you use is very important. It is recommended you use Chrome, Edge, or Firefox. The latest version must also be installed. Note that Internet Explorer is not compatible with our delivery technologies.
Windows 10 is highly recommended as the operating system you use. If you are using an apple device, use Safari or a similar modern browser if you cannot use any of the browsers recommended above. Your training experience may diminish due to different features and appearances. Nexacu's trainers are unable to provide detailed guidance for macOS.
To download and unzip files, log in to your student portal. Click on the "Materials" tab and download your exercise files.
Extract your Exercise Files to the specified folder below. Note you will have to create this folder first.
