fbpx

Microsoft Access Intermediate

Course Description

The Microsoft Access Intermediate course aims to build on the skills covered in the Introduction level course. Participants will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and will cover an introduction to some basic automation techniques involving macros.

Learning Outcomes

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

  • use various data validation features in Access to protect data
  • format the data in a table
  • perform more advanced queries using a variety of querying techniques
  • create and use parameter queries
  • create calculated queries
  • modify and adapt an existing form according to specific needs
  • create a navigation form for a database in Access 2016
  • create forms using a combination of wizards and manual techniques
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
  • create and manage custom categories and groups in the Navigation Pane

Prerequisites

Microsoft Access Intermediate assumes the participant has the knowledge required to create a table and basic query plus design a simple form.

Course Duration

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

Course Overview

  • Assign Default Values
  • Validation Rules and Text
  • Set Required Fields
  • Work with Validations
  • Change Column Widths
  • Format Cells in a Table
  • Move and freeze columns in a Table
  • Hide and Unhide Columns in a Table
  • Modify a Saved Query
  • Create an AND and OR Queries
  • Query Numeric Data or Dates
  • Using a Range Expression
  • Query Opposite Values
  • Sort Query Data
  • Query Using Wildcards
  • Query with a Lookup Table
  • Sort Query Data Numerically
  • Display NULL Values
  • Create a Parameter Query
  • Use Parameters to Display a Range
  • Use Parameters in Expressions
  • Use Parameters with Wildcards
  • Create a Calculated Field
  • Summarise Data Using a Query
  • Calculate with Dates
  • Use Criteria in Calculations
  • Concatenating String Fields
  • Work with a Control Stack
  • Change Control Widths
  • Move and Align Controls on a Form
  • Add an Unbound Control
  • Add a Control Source
  • Change the Tab Order
  • Insert the Date into the Form Header
  • Create a Simple Navigation Form
  • Create a Complex Navigation Form
  • Create Subsidiary Pages
  • Apply a Theme
  • Modify Properties
  • Automatically Start the Navigation Form
  • Create a Multiple Item Form
  • Adjust the Layout of a Form
  • Disable Fields
  • Add an Easy Lookup Field
  • Add Buttons to a Form
  • Adjust Form Properties
  • Create a Macro
  • Run a Macro
  • Modify an Existing Macro
  • Interact with the User
  • Create a Print Macro
  • Create a Sequence of Conditions
  • Use the MsgBox Function
  • Reconfigure a Message Box
  • Use the InputBox Function
  • Create Navigation Macros
  • Create Unassigned Buttons
  • Run or Modify an Event Macro
  • Set Echo Off
  • Add a Close Button
  • Create and run a Search Macro
  • Understand the Navigation Pane
  • Create Custom Categories
  • Create Custom Groups
  • Add Objects to a Group
  • Hide Groups and Objects
  • Show Hidden Groups and Objects

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 Introduction

- 1 day course duration

Call Now Button