Computrain IT Training

Microsoft Access Advanced

Objectives and Overview

This intensive course is designed to give existing Microsoft Access users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This 'hands on' course will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports.

Who should attend?

Existing users of Access who want to get grips with some of the more advanced features of this package as quickly as possible.

Course prerequisites

A basic knowledge of Access gained through use of the product or by attending an "Access Foundation" course.

Customising Tables

Creating an Index • Normalising a Table • Setting a Default Entry Value • Creating and Modifying an Input Mask • Defining a Data Validation Rule • Creating and Modifying a Lookup Field • Creating a Relationship

Creating Custom Queries

Specifying Criteria in Multiple Fields • Modifying Query Properties • Applying Filters to a Query • Specifying Criteria in a Totals Query • Creating an Action Query • Creating a Parameter Query • Creating a Crosstab Query • Creating a PivotTable • Joining Tables to Create a Query • Creating Many-to-Many Relationship

Customising Forms

Creating a Form in Design View • Adding a List to a Form • Customising Form Sections • Inserting a Graphic in a Form • Modifying Control Properties • Creating a Subform • Creating a Switchboard

Customising Reports

Creating and Modifying a Report in Design View • Adding Sections to a Report • Sorting and Grouping Report Data • Modifying Report Properties • Adding and Modifying Report Controls • Creating a Subreport • Synchronising Report Data

Using Databases and the Internet

Creating a Hyperlink • Exporting a Form to HTML • Creating a Data Access Page Using AutoPage • Creating a Data Access Page using the Page Wizard • Grouping and Sorting Data on a Data Access Page

Automating Tasks

Creating an W Macro • Using Controls to Run a Macro • Assigning a Macro to an Event • Assigning a Macro to a Condition • Testing and Debugging a Macro

Using Database Tools

Setting a Database Password • Modifying and Deleting a Database Password • Encrypting and Decrypting a Database • Replicating a Database • Splitting a Database • Converting a Database to Access 97 File Format

Integrating Access with Other Office Applications

Creating a Graph • Exporting Data to Excel • Dragging Tables and Queries to an Excel Worksheet • Creating a Link