Course Details close

Course Details

(inc GST)
$ 990
Duration:2 days
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

   (4.74 out of 5)
275 Access advanced student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 2 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 990
Sale Price:
(inc GST)

Quick links

Access Advanced 2010 Course

Course Overview

This course caters for people who have attended the Access Essentials course or have a comprehensive working knowledge of Access. They should be confident in designing tables, forms, queries and reports.

Upon completion of the 2 day Advanced Access course students will be able to create and run action queries, build crosstab queries, create calculations in forms, create pivot tables and charts as well as being able to work confidently with properties and expressions in forms, reports and queries. Students will gain a deeper understanding of the impact of relationships, cascade update and delete options when designing the relationships of an Access database. This course also covers basic macro design and an introduction to the concept and use of VBA in Access database design.

Course Prerequisites

Microsoft Access Fast Track 2010 or equivalent

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

With each course we provide you with a comprehensive course manual for you to practice post course.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status

There are currently no virtual course dates scheduled for this course.

Call us today to discuss - 1300 937 782.

Public Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

Navigation Pane

  • Tables and Views
  • Objects
  • Custom Groups

Standardise and Validate Data

  • Default Values
  • Field Validation
  • Require Field Completion
  • Date Picker
  • Rich Text - Memo Fields
  • Validation Rules

Table Relationships

  • Find Orphan Records
  • Cascade Updates and Deletes
  • Join Types

Access SQL

  • Common SQL Keywords

Advanced Select Queries

  • Left and Mid
  • LEN Function
  • IF Function
  • LCASE Function
  • TRIM Function

Action Queries

  • Make/Update Table Queries
  • Append/Delete Queries
  • Action Query Workflow
  • Maintain Record History

Aggregate Queries

  • Group Data
  • Aggregate Queries Criteria

Cross Tab Queries

  • Create/Modify CrossTab Queries

Pivot Tables

  • Pivot Tables in Access

Access Macros and VBA Introduction

  • Macro Definition and Review
  • Create/Edit Macros
  • Enhance using TempVars
  • Conditions
  • Access VBA Intro

Advanced Form Design

  • GUI Design
  • Standard User Interface Model
  • Form Filters
  • Form Data Validation
  • Cascading Combo Boxes

Design in Layout View

  • Explore Layout View
  • Quick Form Tool

Advanced Reports

  • NoData Event
  • User Selections to Show/Hide Report Sections
  • Running Sums
  • Watermarks

Reporting Systems

  • Run Reports Methods
  • Fully Featured Reporting Module

Prepare for User Access

  • User Access Restrictions
  • Convert Format to ACCDE

Split Databases

  • Reasons for Splitting Databases
  • Database Splitter
  • Relink Tables
  • Manual Linking and Using Multiple Linked Table

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us