Microsoft Access Introduction

This course has been developed for people wanting to create a simple database to enter and extract data, and create reports. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

2 days course
4.56  (242 reviews)
What you will learn:
  • Create a new database
  • Define and edit tables
  • Add, edit and search for data
  • Query the data in related tables
  • Use criteria to customise a query and create a calculated field
  • Create professional reports and data input forms
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Post Course Support
Course prerequisites

Experience using Windows and other Microsoft Office programs (e.g. Excel), including the ability to open and save files.

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
  • Database components
  • Understand database design
  • Plan the database
  • Define tables
  • Define fields
  • Determine relationships
  • Create a database shell
  • Name conventions
  • Database file formats (.mdb, .accdb)
  • Design view
  • Create fields
  • Field data types
  • Primary key
  • Save a table
  • Table views
  • Field size property
  • Format property
  • Decimal places property
  • Caption property
  • Default value property
  • Required property
  • Indexed property
  • Move columns
  • Rename a field
  • Freeze columns
  • Add a field
  • Filtering
  • Sorting
  • Delete records
  • Modify a record
  • Find and replace text
  • Import a spreadsheet into table
  • Create a lookup field
  • Link to an existing table
  • Create a value list
  • View subdatasheets
  • Create an AutoForm
  • Create a Wizard form
  • Add fields to form
  • Add records on form
  • Form layout view
  • Modify form fonts
  • Modify form colours
  • Control padding
  • Control anchoring
  • Setting basic form and control properties
  • Modify form element placement
  • Tabbed interface
  • Navigation forms
  • Create a simple query
  • Add a table
  • Add fields
  • Sort results
  • View query result
  • Save a query
  • Modify a query
  • Use query wizard
  • Typing criteria
  • Use like
  • Use wildcards
  • Use operators
  • Between operator
  • Multiple criteria
  • Hiding fields
  • Add a simple expression
  • Export query results to Excel
  • Print query results
  • Create an AutoReport
  • Preview report results
  • Report layout view
  • Modify report fonts
  • Modify report colours
  • Modify report placement
  • Create wizard report
  • Report design view
  • Report header/footer
  • Print reports to PDF
  • How to add records
  • How to create table relationships
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
4.56
4.56
from 242 reviews
5/5
“Kim is an excellent trainer, who communicates well and flexible with her training approach to ensure her participants get the most of the course. Really enjoyed the course.”
Li Peng, Aug 2020
5/5
“Kim was fantastic, accommodated our needs and provided guidance.”
Carolyn, Aug 2020
5/5
“Fantastic (and knowledgeable) presenter, made content interesting, relevant and easy to learn.”
Paul, Jul 2020
4/5
“I feel confident navigating Access.”
Rebecca, Jul 2020