Microsoft Access Basics

The topics listed under this level of training are a snapshot only of the skills which fall under the Access Introduction category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training for groups the next step after you contact us involves assessing the current skill levels of the students. This helps us to determine exactly which topics you require training in and tells how we can group the students with similar skill levels. After you have completed this level of training, you may want to up-skill to the next level: Microsoft Access Intermediate.

The Office Expert offers Customised Computer Training and Administrative Support in the comfort of your home or office for Cairns in far North QLD.

This level includes:

Navigating around the Access environment

  • Customising & moving the Quick Access toolbar
  • Customising the ribbon
  • Viewing layouts
  • Saving files
  • Finding your saved files
  • The Access Lock file

Object Definitions

  • Records
  • Fields
  • Data
  • Database?
  • Tables Objects
  • Form Objects
  • Report Objects
  • Query Objects

Databases

  • Create a database using the wizard
  • Manually Create a database in Design View
  • Copy/Paste data to Create a database
  • Create a database via template
  • Save a database
  • Open an existing database
  • Exit Access correctly

Tables

  • Create a Table using Wizard
  • Use Design View to Create a Table
  • Create a Table by entering Data
  • Design View
  • Datasheet View
  • Import a Table from Excel (2 ways)
  • Save a Table
  • Adding additional Fields to an existing Table
  • Deleting Fields
  • Renaming Fields
  • Field Properties
  • Primary Keys
  • Foreign Keys

Forms

  • Creating Forms using Wizard
  • Basing Forms on Queries
  • Basing Forms on Tables
  • Forms with linked Sub-Forms
  • Adjusting Form’s Design
  • Bound vs Unbound Fields
  • Headers & Footers
  • Graphics & Formatting

Queries

  • Create Query using Design View
  • Create Query using Wizard
  • Basing Queries on Tables
  • Basing Queries on Queries
  • Sorting a Query
  • Show/hide Fields
  • Adding criteria
  • Select Queries
  • Using dates in Queries
  • Formatting Fields in Queries

Reports

  • Create a Report using the Wizard
  • Create a Report based on Query
  • Report Header & Footer
  • Design / Layout / Report / Print Preview views
  • Formatting Fields
  • Aligning Fields
  • Duplicating Fields
  • Naming Fields
  • Stacking Fields
  • Sorting & grouping
  • Add a Field to an existing Report

Finding Access Help

  • Searching the Help Index
  • Online Help
  • Tutorial Help
  • Customised Help using F1

Printing

  • Selecting your printer
  • Setting a default printer
  • Specifying the amount of copies
  • Setting the print area
  • Printing a Table
  • Printing a Query
  • Scaling pages to fit
  • Orientation
  • Adjusting margins/headers/footers

Database Tools

  • Relationships explained
  • Object Dependencies
  • Compact and Repair

Request for Training

Your Name (required)

Your Email (required)

Your Contact Number (required)

Any prior experience with Access?

Motivation for Training? (upskilling / applying for a job...)

How soon do you need this Access Basics training?

How many people require this training?