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

Advance your Microsoft Access skills in 2 days. Create complex queries, customise reports, and optimise database performance.

$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days
$946
10 max
2 days

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Upcoming Courses:
Remote East

We currently have no public courses scheduled. Please contact us to register your interest.

Brisbane

We currently have no public courses scheduled. Please contact us to register your interest.

Sydney

We currently have no public courses scheduled. Please contact us to register your interest.

Parramatta

We currently have no public courses scheduled. Please contact us to register your interest.

Melbourne

We currently have no public courses scheduled. Please contact us to register your interest.

Canberra

We currently have no public courses scheduled. Please contact us to register your interest.

Adelaide

We currently have no public courses scheduled. Please contact us to register your interest.

Perth

We currently have no public courses scheduled. Please contact us to register your interest.

Remote West

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Access Advanced Course Details

Price
$946
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
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000
microsoft_gold

Access Advanced Course Details

Price
$946
Duration
2 days
Time
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
Training Computer
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000
microsoft_gold

Access Advanced Course Details

Price
$946
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
microsoft_gold

Access Course Outlines

Microsoft Access City Pages

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

Contact Us

Why Nexacu?

Valued by Individuals

4.72 / 5
Over 76973 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us