Access Essentials

by Corporate Training Solutions Australia Claim Listing

This practical hands-on course will enable you to understand the main concepts of databases and help you develop a database application. Training available on Microsoft Access 365, 2019, 2016 and 2013.  Select your version when making a booking.

$440

Contact the Institutes

Fill this form

Advertisement

Corporate Training Solutions Australia Logo

img Duration

1 Day

Course Details

This practical hands-on course will enable you to understand the main concepts of databases and help you develop a database application. Training available on Microsoft Access 365, 2019, 2016 and 2013.  Select your version when making a booking.

  • Design a multiple table database

  • Create tables and add fields and set data types

  • Add records

  • Create forms for data entry

  • Sort and filter data in tables and forms

  • Create simple queries

  • Create reports based on tables and queries.

 

 

Audience:

Students who need to learn basic database techniques and skills required to modify an existing database or create a new database.

 

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques. 

 

Inclusions

  • Training Manual with step by step instructions

  • Practice files relevant to the training material

  • Training Completed files you are free to take away any completed files for review

  • Unlimited online support as training does not stop when you walk out our door

 

Course Content

Getting Started

  • What is Microsoft Access?

  • Basic Terminology - Tables, Records, Forms, Queries and Reports

  • Understanding a relational database

  • Opening Microsoft Access

  • Interface Overview

  • Ribbon and commands

  • Quick Access Toolbar

  • Closing Microsoft Access

 

Working With Tables

  • Opening Tables

  • Table Views

  • Datasheet View

  • Navigating Records in a Datasheet

  • Adding and Editing records in a datasheet

  • Managing Column widths and row heights

  • Moving a Column

  • Hiding / Unhiding Columns

  • Freezing / Unfreezing Columns

 

Working With Data Through Forms

  • Understanding forms and their relationship to tables

  • Moving a round a form

  • Understanding form controls

  • Find records through a form

  • Filtering data

    • using a data sheet

    • on a split form

    • by date

    • by selection

  • Sorting Data

  • Printing records

  • Export to PDF

  • Export to Excel

  • Deleting a record

 

Working With Reports

  • Running a Report

  • Understanding the relationship of the report data

  • Veiwing the Report structure

  • Printing the report

 

Creating A table

  • Planning a new Table

  • Creating a Table

  • Setting Field properties and data types

  • Using a Lookup field

  • Setting a Primary Key

  • Setting Indexes

  • Entering Data into a Table

 

Creating Forms To View and Edit Data

  • What is a Form?

  • Bound vs. Unbound Controls

  • Creating a Form with the Wizard

  • Using Design View to Modify Your Form

 

Creating A New Database

  • Planning a Database

  • Creating a Database from a Template

  • Creating a Blank Database

  • Using Database Objects

  • Setting Navigation Options

 

Creating Queries To Select Records

  • What is a Query?

  • Creating a Query with the Wizard

  • Using Design View to Modify a Query

  • Using Queries

 

Creating Reports

  • What is a Report?

  • Creating a Report with the Wizard

  • Using Design View to Modify a Report

  • Using Reports

  • Brisbane CBD Branch

    Level 19, Waterfront Place, 1 Eagle Street, Brisbane CBD, Brisbane

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy