Microsoft Access Intermediate

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

2 days course
4.55  (170 reviews)
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
What you'll get:
Capped class sizes
Post Course Support
Course prerequisites

Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Topics covered in this training course
  • Introduction revision
  • 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
  • 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
  • The relationships window
  • Set table relationships
  • Relationship types
  • Referential integrity
  • Cascade updates and deletes
  • Find null values
  • To exclude null values
  • NOT queries
  • Parameter queries
  • Parameter data types
  • Query multiple tables
  • Table joins
  • Find orphan (unmatched) records
  • 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
  • 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 crosstab query using the wizard
  • Modify a crosstab query
  • Create a crosstab query manually
  • Make table query
  • Delete query
  • Update query
  • Append query
  • Create a subform from control wizard
  • Modify the subform
  • Datasheet view
  • Subform properties
  • Continuous forms view
  • Calculations on a subform
  • 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
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
from 170 reviews
“Jane was an excellent trainer. She was extremely helpful and made the content relevant to our individual needs.”
Tiarne, Aug 2020
“Kim is a very considerate and adaptable trainer.”
Daniel, Jul 2020
“Very good content.”
Vicki, Jul 2020
Lisa, May 2019