MS-Office-logoAll 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.

pdf download

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

pdf download

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

Delegate Pre-Requisites

Attendance on the Access The Basics course is recommended together with the experience of building an Access Database.

Course Duration

This is a One 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