Microsoft Access Intermediate - 2 Day Course - Brisbane

Event Information

Share this event

Date and Time



Odyssey Training (RACQ Building)

Level 1, 60 Edward St

Brisbane, QLD 4000


View Map

Event description


This course is ideal for

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.

What you will learn

  • Import, link and export tables

  • Work with advanced table properties

  • Use advanced select queries and create crosstab queries and charts, as well as use action queries

  • Design forms and use subforms

  • Create simple macros

  • Design reports

Topics covered in this training course

Introductory revision

Importing and linking tables

  • Drag and drop import

  • Troubleshooting importing

  • Import a CSV file

  • Linking tables

  • Modify data in linked tables

  • Importing vs linked tables

  • Export data from Access

  • Export to Excel

  • Export to Access

Advanced table properties

  • Review basic field properties

  • Create a custom format

  • Custom date formats

  • Input mask property

  • Validation rules

  • Validation text property

  • Table properties

  • Modify lookup field properties

Table relationships

  • The relationships window

  • Set table relationships manually

  • Relationship rules

  • Referential integrity

  • Cascade updates and deletes

Advanced select queries

  • Find null values

  • To exclude null values

  • NOT queries

  • Parameter queries

  • Parameter data types

  • Query multiple tables

  • Table joins

  • Find orphan (unmatched) records

Advanced query expressions

  • Use expression builder

  • Convert nulls to zeros

  • Concatenation

  • StrConv function

  • Date functions

  • DateAdd()

  • DateDiff()

  • IIF function

  • Aggregate queries

  • Format query field properties

  • Format the query headings

  • Top values query

Action queries

  • Make table query

  • Delete query

  • Update query

  • Append query

Crosstab queries

  • Create a crosstab query using the wizard

  • Modify a crosstab query

  • Create a crosstab query manually

Form design

  • Form design view

  • Breaking form layouts

  • Selecting form controls

  • Form properties

  • Form control properties

  • Create an unbound control

  • Add a calculation

  • Add a drop-down control

  • Change combo box properties

  • Add a button

  • Change tab order

  • Align controls

  • Resize controls

  • Evenly spacing controls

  • Add a logo to a form

  • Link a query to a form


  • Create a subform from control wizard

  • Modify the subform

  • Datasheet view

  • Subform properties

  • Continuous forms view

  • Calculations on a subform

Advanced report design

  • Report design view

  • Add a logo to a report

  • Add calculations to reports

  • Concatenation

  • Add calculations to a footer

  • Sum calculated fields

  • Advanced report properties

  • Show and hide report sections

  • Add page breaks

Share with friends

Date and Time


Odyssey Training (RACQ Building)

Level 1, 60 Edward St

Brisbane, QLD 4000


View Map

Save This Event

Event Saved