Microsoft Access - Intermediate Course


The objectives of this course are to give participants an understanding of multi-table relational databases, the design and application of complex queries and tips and techniques for the design of forms and reports. 



Review of Introductory concepts

  • Overview of topics covered during Intermediate Access course

Table Field Properties

  • Required fields
  • Validating data
  • Lookup fields

Action Queries

  • Make table queries
  • Delete, append & update queries
  • Parameter queries
  • Calculating queries
  • Crosstab queries

Table Relationships

  • Create relationships between tables
  • Relational database concepts
  • Referential integrity settings

Complex Query Design

  • Multi-table queries
  • Creating and using joins

Designing Forms and Reports

  • Create forms and reports using the wizard
  • Using the design view to modify forms and reports
  • Form/report component properties
  • Using combo boxes, option buttons, toggle buttons and option groups

 Special Design Options

  • Use design effects for forms and reports
  • Create sub forms and sub reports
  • Use sections and grouping for Report analysis


Learning outcomes

Upon completion of this course, participants will have an understanding of multi-table database relationships, designing complex queries and design techniques for forms and reports.


Completion of the Access Introduction course or equivalent knowledge is required.



1 day

Software versions

Availlable for 2010, 2013, 2016 & 365


Certification Options: Microsoft Office Specialist

Microsoft Office User Certification in Access.

Further development

Access Advanced


Is this the right course for you?

Find out here > 



Book Now





Course Information


  • Interactive, practical and hands on learning
  • Facilitator led training
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

Enjoy Perth's best CBD training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD

Real People, Real Conversations, Real Results

Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   


Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email


Logo Bulb

Enriching lives.
Empowering organisations.