Our Microsoft Access training comprises three courses lasting approximately four days in all:

• the one-day introductory course, for first-time users of Access, covers database concepts, forms, queries and reports;
• the one-day intermediate course considers database maintenance & security and higher level forms, queries & reporting functions;
• the two-day advanced course cover functions, relationship, graphs, macros, and command bars.

All delegates must be confident computer users with Word and Excel experience.

Click here for a printable version of Access Introduction Course Outlines

Click here for a printable version of Access Intermediate Course Outlines

Click here for a printable version of Access Advanced Course Outlines

Access introductory course contents are as follows.

Database Concepts

• Database concepts and terminology
• Exploring the Access environment
• Planning and designing databases
• Getting help
• Closing a database and Access

Access basics

• Exploring tables and forms
• Examining Queries
• Exploring reports

Creating databases

• Creating a database
• Using the Table Wizard
• Working in Design View

Working with fields and records

• Changing the design of a table
• Adding and deleting records
• Finding and editing records
• Sorting and filtering records

Querying tables

• Creating and using queries
• Modifying query results and queries
• Using calculations in queries

Creating and using forms

• Creating forms by using AutoForm
• Using the Form Wizard
• Using Design view
• Finding, Sorting, and filtering records

Creating and using reports

• Using the Report Wizard and queries
• Creating, modifying, and printing reports

Importing, exporting, and linking objects

• Importing Access objects
• Exporting Access objects
• Exporting and importing XML documents
• Linking Access objects

Access intermediate course contents are as follows.

Advanced Forms and Reports

• Using Properties
• Sub Forms and Sub Reports
• Calculated Fields in Forms and Reports
• Tabbed Forms
• Graphics in Forms and Reports
• Programming with Command Buttons
• Using Active-X Controls

Queries

• What are Queries?
• Query Types
• Designing a simple Select query using the QBE grid
• Calculated Fields
• View Totals and Subtotalling
• Parameter Queries
• Setting Parameters
• Running the Query
• Conditional Branching -the IF function
• Action Queries
• Make Table Query
• Update, Append and Delete Queries
• Programming

Database Maintenance

• Compacting and Repairing a Database
• Backing Up
• Upsizing to a MS SQL Server Database
• Analysing the Database

Database Security

• Password Protecting the Database
• Removing a Password
• Encryption
• Setting User-Level Security with the Wizard

User and Group Accounts

• Predefined Accounts

Permissions

• What are Permissions
• Assigning Permissions
• Access and MS Office
• Access and the Web

Access advanced course contents are as follows.

Creating Queries that Relate to Open Forms

Using Functions in Forms

• Date and Formatting Functions
• Text Processing Functions
• Conditional Functions

Outer Join Query Types and Exception Reporting

• SQL Query statements and ANSI SQL
• Select Queries
• Distinct and Distinct Row variations
• Union Queries
• Data Processing Queries

Creating Relationships and Enforcing Referential Integrity

Creating and Customising Reports and Groups

Graphics and Graphs in Reports

• Sub Reports
• Running Reports from Open Forms

Extending Form Usage

• Custom Data Entry Forms
• Sub Forms and Graphs in Forms
• Using UnBound forms and Controls
• Using Aggregate Dfunctions() in Forms and reports
• Using Advanced Functions in Forms
• Reports and Queries
• Using Controls and Control Properties

Setting Access Default Properties

Introduction To Macros

• Using and Building Macros
• Adding Buttons to Forms
• Introduction to the Macro Windows
• Building Basic Macros
• Chaining Macros and Conditional Macros
• File Processing Macros
• Macros that perform menu Actions
• Opening and Closing Forms
• Modifying Fields with Macros
• Macros to Filter Data
• Macros to transfer data
• Activating Dialogue Boxes
• Running and Printing Reports from Macros
• Conditional Actions in Macros
• Running External Applications
• Using The SENDKEYS to Transfer Data Instructions
• Transfer and Attach database options
• Mail-Merge and Excel and Word
• Custom Menu Design
• Customising the Toolbar and ACCESS 2.0
• Removing the Toolbars from Use
• AUTOEXEC Macros
• Using Switchboard Forms for Dialogue
• Using Dialogue Boxes for simple interrogation
• Creating User Dialogue Boxes with UnBound Forms and Controls
• Form and Control Events

Building Command Bars & Menus Security in Access

• Database v User Level Security
• Enabling Access Security
• Using the Security Wizard
• Creating Administrator Accounts
• New Users and Groups
• Changes to database Ownership
• ODBC etc
• *ODBC Links
• *Direct & Parse through Queries
• *Depends upon availability of server/network links