All versions of Microsoft Access are supported – if you require a Course Outline for specific version, please contact our Sales Team – see our Contact Page for more information

Access 2003
Access 2007
Access 2010
Access 2013
Access 2016

Access The Basics

Target Audience

This course is designed for delegates who wish to gain a basic understanding of the principles of creating a database using Microsoft Access. Access is a very powerful tool which allows the user to create tables, queries and reports with ease.

DOWNLOAD

The Content

Access Workplace

The Workplace
Customising The Quick Access Toolbar
Customising the New Status Bar

The Basics

Terminology and Concepts
What is a Database?
The Database Structure

Opening a Database & Security Issues

Creating a Database

Creating Tables
Using Datasheet View
Using Design View

Table Modification & Navigation

Adding Fields
Data Types
Formatting Data in Tables
Navigation Pane
Field Properties
Input Mask
Validation Rules
Field Properties – Guides Table

Manipulating Records & Tables

Primary Keys & Indexing

Defining a Primary Key
Indexing
Manipulating Single & Multiple Field Indexes

Filtering & Sorting

Text Filters
Single & Multiple Filters
Sorting

Access Forms

Forms Overview
Creating / Modifying Forms
Form View
Modifying Records

Relationships

Table Relationships
One-to-Many Relationship
Many-to-Many Relationship
One-to-One Relationship
Relationships between Tables
Referential Integrity
Cascade Options

Using Queries

What are Queries?
Creating simple Queries
Adding Criteria to a Query
Running a Query
Editing Criteria in a Query
Creating a Two Table Query and Sorting the Results
Saving a Query

Access Reports

What are Reports?
Using the Report Wizard
Modifying the Layout of a Report
Adding & Modifying Field Names within a Report
Adding Logos to a Report
Using Autoformat

Printing Options

Considerations before Printing
Printing Tables, Query, Reports or Forms
Print Preview

Delegate Pre-Requisites

No prior knowledge of Access is required.

Course Duration

This is a Two Day Course

Course Details

Courses commence at 9:30 a.m. through to 4:30 p.m.

A laptop computer is provided for each delegate attending on this packed programme to try out the tips and techniques demonstrated

All delegates will receive comprehensive Training Courseware to refer to during the course, together with a Course Attendance Certificate

Access Advanced

Target Audience

This course is designed for delegates using Access and have already set up a database within Access and wish to learn the more Advanced features of the product

DOWNLOAD

The Content

Form Customisation

Linking a Form to a Table
Manipulating Controls on the Form
Special Effects
Placing a Bound Control on a Form
Explanation of the Types of Forms
Popup Forms
Modal Forms
Split Forms
Limiting User Access
Exporting Form to XML

Reports

Creating an AutoFormat Template
Applying an AutoFormat to a Report
Applying an AutoFormat to an existing Report
Conditional Formatting
Sub-Reports
Formatting Reports

Access SwitchBoards

What is a Switchboard?
Creating a Switchboard
Deleting a Switchboard
Adding Items to a Switchboard
Editing a Switchboard
Deleting Items within a Switchboard
Editing Items within a Switchboard
Making a Switchboard the default Switchboard
Displaying Switchboards automatically when opening a database

Customising Access

Access Customisation Options
Current Database Options
Datasheet Options
Object Designers Options
Proofing Options
Add-Ins Options