Intermediate Microsoft Access

Course Objectives

Delegates will learn some more techniques to use with Microsoft Access. These include Linking Tables, Update Queries and simple Macros.

Prerequisites

Some previous experience in using Microsoft Access is recommended.

Course Duration

1 day

Course Content

  • Revision
    • Review of Introduction day
    • Revision Exercise
  • More about Datasheets
    • Finding Information in a Datasheet
    • Replacing Information
    • Sorting in a Datasheet
    • Filtering for Ad-hoc enquiries
  • Relationships between Tables
    • The Northwind Sample Database
    • Understanding Links
    • Multi-Table Queries
    • Creating the Relationships
  • Custom Forms
    • Starting from Scratch
    • Control Properties
    • Using List / Combo Boxes
    • Check Boxes / Option Buttons
    • Calculations on a Form
  • Custom Reports
    • Starting from Scratch
    • Sorting and Grouping
    • The Control Types to be Used
  • Action Queries
    • Make Table Queries
    • Append Queries
    • Delete Queries
    • Update Queries
  • Macro Design
    • Creating a Macro
    • The Macro Design Window
    • Saving and Running the Macro

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk