(03) 9999 7780

Call for Queries?

Training Centre

View on Map

Keystroke Learning - Microsoft Access Training Course

Microsoft Access Advanced

Microsoft Access

Advanced

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

Intermediate/Advanced

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

Price

$960+GST

Upcoming Public Courses

Courses

There are no upcoming courses at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

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
Macros
  • 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

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???