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:

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 Inclusions

Skills Analysis

Take advantage of our free online skills analysis prior to your training to ensure you’re enrolled in the right course.

Certificate

After completing the course you’ll receive a certificate to show off your new-found Microsoft Outlook knowledge.

We come to you

To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.

Hands-on training

We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.

Email Support

Access unlimited support following your training course to build on your learning and ask any burning questions.

Real-world examples

There’s nothing better than working through real-world examples to reinforce learning and increase your confidence.

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 Scroll to Top