Microsoft Access Advanced

Microsoft Access

Advanced

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

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

$1,200.00

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.

Read our Course Terms and Conditions

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.

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

call (03) 9999 7780 or email us at info@keystrokelearning.com.au

(03) 9999 7780

Training Centre

(03) 9999 7780

Microsoft Access Advanced