Course Details close

Course Details

(inc GST)
$ 990
Duration:2 days
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Access Essentials 2013 Course

   (4.79 out of 5)
284 Access essentials student evaluations

Quick links

Access Essentials 2013 Course

Course Overview

This course is for students with no prior knowledge of Microsoft Access or relational databases. This course is designed to teach you the concepts of relational database architecture and knowledge for building an Access database. During this 2 day course you will learn how to build tables to store data in related tables, create forms for data entry, create and execute queries to analyse data and produce printable reports. If you have inherited an Access database that you have to learn how to manage and maintain or simply just need to know how to work with an Access database, then this course is for you.

Some working knowledge of Excel would be advantageous for this course.

At the completion of this course students will gain a solid understanding of the relational database concepts and terminology used throughout Microsoft Access. Students will also be able to build a simple database, manipulate data via forms and create a basic queries and reports.

Course Prerequisites

Basic keyboard and computer skills

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

Access 2013 Environment

  • Understanding Microsoft Access 2013
  • Starting Access in Windows 8
  • Understanding the Start Screen
  • Creating a New Blank Database
  • Understanding the Backstage View
  • Opening an Existing Database File
  • Understanding the Access 2013 Screen
  • Using the Ribbon
  • Working With the Navigation Pane
  • Adding Commands to the QAT
  • Working with Touch Mode
  • Working with a Table
  • Working With Other Database Objects
  • Closing a Database File
  • Exiting From Access 2013

Designing a Relational Database

  • Understanding How Access Stores Data
  • Understanding Access 2013 Data Types
  • Scoping Your New Database
  • Identifying Table Problems
  • Refining Table Structures
  • Finalising the Design

Creating a Database

  • Creating a New Relational Database
  • Creating a Table (Parent)
  • Defining the Primary Key Field
  • Saving and Closing a Table
  • Creating the Transaction Table (Child)
  • Understanding Table Relationships
  • Joining Tables
  • Viewing Table Relationships (Schema)

Modifying Table Properties

  • Opening an Existing Table
  • Adding Fields to a Table
  • Setting Field Properties
  • Changing Field Size Property
  • Updating Field Names
  • Set Decimal Places
  • Changing Date Formats
  • Indexing Table Fields
  • Deleting Table Fields
  • Copying a Table
  • Deleting a Table

Adding Records

  • Typing Records via a Table
  • Create an Basic Form
  • Adding Records via a Form
  • Saving a Form
  • Adding Records via an Existing Form
  • Adding Additional Records
  • Importing Data From Microsoft Excel

Adding Transactional Records

  • Typing Transactional Records
  • Adding Transactional Records via a Form
  • Adding Additional Transactional Records
  • Adding Records via a Subdatasheet
  • Inserting and Removing a Subdatasheet

Table Data Validation

  • Assigning Default Values to a Field
  • Setting Validation Rules and Text
  • Validating Numbers
  • Setting Required Fields in a Table
  • Working with Other Data Validations

Working with Table Records

  • Navigating Through Records in a Table
  • Going a Specific Record
  • Editing an Existing Record
  • Deleting a Record
  • Undo a Record Update
  • Deleting a Record
  • Deleting Multiple Records
  • Searching for Data in a Table
  • Searching in a Field
  • Finding and Replacing Data
  • Printing Table Records
  • Compacting and Repairing a Database

Formatting Tables

  • Changing Column Widths
  • Formatting Tables
  • Changing Table Fonts
  • Moving Columns in a Table
  • Freezing Table Columns
  • Hiding Table Columns
  • Un-hiding Table Columns

Sorting and Filtering

  • Simple Sorting
  • Sorting On Multiple Fields
  • Simple Table Filtering
  • Working with Table Filters
  • Filtering Date Ranges

Creating Queries

  • Understanding Access Queries
  • Creating a Query
  • Working with a Query
  • Changing a Query Design
  • Applying Record Filter Criteria
  • Clearing Selection Filter Criteria
  • Saving a Database Query
  • Running Queries Directly from the Navigation Pane
  • Deleting a Query
  • Creating More Queries

Query Techniques

  • Modifying an Existing Query
  • Utilising AND Criteria in Queries
  • Utilising OR Criteria in Queries
  • Querying Numeric Fields
  • Querying Date Fields
  • Using Range Expressions
  • Querying for Opposite Values
  • Moving Fields in a Query
  • Sorting Data in a Query
  • Removing Fields from a Query
  • Wildcards in Queries
  • Working with Problem Characters
  • Querying With a Related Tables
  • Sorting Data Numerically
  • Displaying NULL Values
  • Querying For Uniqueness

Creating Reports in Access

  • Understanding Reporting In Access
  • Creating a Basic Report
  • Editing Existing Reports
  • Previewing a Report
  • Printing a Report
  • Changing the Report Layout
  • Build a Report Using the Report Wizard
  • Grouping Data in a Report
  • Statistical Reports
  • Managing Grouped Reports

Creating and Using Access Forms

  • Understanding Form Structure
  • Creating a Basic Main Form
  • Creating a Split Form
  • Binding a Form to a Query
  • Build a Form Using the Form Wizard
  • Editing Existing Forms
  • Updating Records via a Form
  • Deleting Records via a Form
  • Deleting a Form

Student Comments

  • Access Essentials training course
    Craig is a great presenter, very patient, and really tailored the course to our needs. I'd definitely recommend his company to colleagues and to my wider business network.
    - Tracey
  • Access Essentials training course
    This is hands down the best Microsoft application course that I have ever attended. Thank you.
    - Melissa
  • Access Essentials training course
    Very well organised. Practical applications.
    - Ella
  • Access Essentials training course
    Enjoyed the course and felt I got a lot out of it - Sean is a fantastic trainer!!!!!
    - Sascha
  • Access Essentials Training Course
    Enjoyed the course and felt I got a lot out of it - Sean is a fantastic trainer!!!!!
    - Sascha
  • Access Essentials training course
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    Informative - a lot of information to take in but the course flowed in a way that allowed for everything taught to make sense.
    - Keirin
  • Access Essentials Training Course
    Craig was excellent and passed the training to my level and assisted where I needed additional information.
    - Greg
  • Access Essentials training course
    The trainer really knows his stuff and presented the material very well and made a difficult subject quite understandable.
    - Stephen
  • Access Essentials training course
    Excellent trainer. Approachable and not boring. Imparts knowledge well. Overall a good learning experience. Thank you.
    - Monica
  • Access Essentials training course
    Yes, I now have the secrets of the Gods so bow down before me mere non-Access minions.
    - Ron
  • Access Essentials training course
    This is hands down the best Microsoft application course that I have ever attended. Thank you.
    - Melissa
  • Access Essentials training course
    Sean is a great and inspirational teacher and clearly very skilled & knowledgeable in this software - I will be back! (is that a trekky comment?) again, funny......
    - Chris
  • Access Essentials Training Course
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    Thanks and well done.
    - Aaron
  • Access Essentials Training Course
    Excellent trainer. Approachable and not boring. Imparts knowledge well. Overall a good learning experience. Thank you.
    - Monica

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us