Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Close this search box.
Keystroke Learning - Microsoft Access Training Course

Microsoft Access Advanced

Microsoft Access


Microsoft Access Computer Training Course

Course Overview

Participants on this Microsoft Access Advanced 2 day course will build on their existing knowledge and skills using Access. You will review database design principles and Relationships, before moving on to advanced tools such as Parameter Queries and Custom Forms and Reports.

The course assumes you have a solid working knowledge of Access, those needing to extend their database skills will benefit from this course.

Am I Ready For This Training?

Participants should have a solid understanding of the fundamentals of Microsoft Access. Ideally you will have completed our Microsoft Access Introduction training course, or have some prior experience using Access Databases.

Once you’ve completed this Access Advanced course, you may like to compliment it with our Microsoft Power BI course.

Course Details

Course Skill Level


Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

2 Day Training Course

Class Times

9:00am – 4:00pm

Your Course Includes



Upcoming Public Courses


We currently do not have this course on our public schedule, but don’t let that deter you!

Exciting news! We are currently offering special prices for one-on-one training for this program.

Call us on (03) 9999 7780 or email us to discuss you options.

Psst… We can also organise group training sessions.

Course Content

Review of Relationships
  • Exploring Database Relationships
Parameter Queries
  • Setting up Flexible Queries
  • Modifying Parameter Queries
Using Query by Form
  • Designing a Query by Form
  • Setting up the Form Properties
Setting up Action Queries
  • Understanding Action Queries
  • Designing Action Queries
  • Delete Queries
  • Update Queries
  • Make Table Queries
  • Append Queries
Customising Reports
  • Creating Custom Fields
  • Report Layout Options
Customising Forms
  • Building Custom Forms
  • Adding Form Fields
  • Adding Controls to a Form
Using Expressions in Forms
  • Working with Expressions
  • Using Calculations
  • Building Macros
  • Using the Macro Builder

*Our outlines are a guide to the content covered in a typical class.
 We may change the course topics to meet the objectives of a particular class.

Keystroke Learning - Building Computer Skills to Enable Success

Learn Today Face to Face Online with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses
Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success in Melbourne

Melbourne Training Centre

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Skip to content