fbpx

Microsoft Access Introduction

Course Description

The Microsoft Access Introduction course aims to provide participants with the required knowledge to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries within a database using Microsoft Access.

Learning Outcomes

At the completion of Microsoft Access Introduction you should be able to:

  • understand how Access is used and how to navigate around it
  • design a database with lookup tables
  • create a database structure using Access 2016
  • modify the structure of an existing table
  • add records to a new table
  • add transactional records to a lookup database
  • work with the records in a database table
  • sort and filter records in a database table
  • create simple and effective queries
  • create meaningful reports from tables
  • create and use forms

Prerequisites

Microsoft Access Introduction assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.

Course Duration

The Microsoft Access Introduction course is run over one-day but can be customised to suit your needs.

Course Overview

  • Understanding Access
  • Starting Access from multiple locations
  • Create a new blank database
  • Open an existing database file
  • Understand Backstage View
  • Customising the Access environment
  • Working with a table
  • Understand how Access stores data
  • Scoping your new database
  • Identifying table problems
  • Refining table structures
  • Finalising the design
  • Create a new database file
  • Create a lookup table
  • Defining the primary key
  • Save and close a table
  • Creating a transaction table
  • Understanding lookup table relationships
  • Viewing table relationships
  • Open an existing table
  • Add fields to an existing table
  • Understand field properties
  • Changing field size or names
  • Changing other field properties
  • Indexing fields
  • Delete fields
  • Copy and delete a table
  • Typing records in a table
  • Adding records using a form
  • Saving a form layout for reuse
  • Adding records using an existing form
  • Importing from Microsoft Excel
  • Typing Transactional Records
  • Add Transactional Records using a form
  • Adding records using a Subdatasheet
  • Removing a Subdatasheet
  • Inserting a Subdatasheet
  • Table Navigation
  • Navigating to a specific Record
  • Edit and delete records
  • Searching in a table or field
  • Find and replace data
  • Print records from a table
  • Compact a database
  • Simple sorting
  • Sorting on several fields
  • Simple filtering
  • Working with filters
  • Filtering between dates
  • Understanding Queries
  • Create a Query Design
  • Working with a Query
  • Changing a Query Design
  • Applying Record Criteria
  • Saving a Query
  • Running Queries from the Navigation Pane
  • Delete a Query
  • Create a Basic Report
  • Working with Existing Reports
  • Previewing and Printing a Report
  • Changing the Report Layout
  • Using the Report Wizard
  • Creating a Grouped or Statistical Report
  • Creating a Basic Form
  • Creating a Split Form
  • Binding a Form to a Query
  • Using the Form Wizard
  • Working with Existing Forms
  • Deleting Records using a Form

Course Includes

Skills Analysis

Certificate

We come to you

Hands-on training

Email Support

Real-world examples

Course Pricing

Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.

Number of participants Investment (per day)
1-on-1 Training $500.00
2-3 participants $650.00
4-6 participants $800.00
7-8 participants $950.00
9-10 participants $1,200.00

Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.

View other course outlines

Microsoft Access Computer Training Courses

Access Intermediate

- 1 day course duration

Call Now Button