Access Level 3

Course Description
Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar. This course meets the Microsoft Proficiency Guidelines for Microsoft Access at the Expert level.

Prerequisites
Access Level 1 and Access Level 2 or equivalent knowledge

Study Method:
Flexible Learning:  Group Training

What Next?
Access Level 4

Course Content

Lesson 1: Parameter and Action Queries

Creating Parameter Queries

Creating Action Queries

Lesson 2: Query Joins and Crosstab Queries

Joining Tables and Working with Join Properties

Creating Crosstab Queries

Editing Limitations in Query Datasheets

Lesson 3: Using Advanced Form Techniques

Organizing Field Placement

Using Functions to Control Data Entry

Adding an Option Group to a Form

Using a Form as the User Interface

Creating a Form that Contains a Subform

Lesson 4: Creating Basic Macros to Automate Forms

Macro Basics

Attaching a Macro to a Command Button

Revising a Macro

Lesson 5: Using Macros to Provide User Interaction and Automate Tasks

Using a Macro to Provide User Interaction

Using a Macro to Automate Tasks

AutoKeys and AutoExec Macros

Lesson 6: Using Advanced Report Techniques

Customizing the Appearance and Functionality of a Report

Lesson 7: Web Capabilities and Data Integration

Using Hyperlinks

Data Integration

[ Home ] [ Computer Skills ] [ Office Skills ] [ Professional IT courses ] [ Business Courses ] [ Contact ] [ Group Training ] [ Flexible Learning ] [ Distance Learning ] [ Certification | Training West Midlands/Microsoft West Midlands/Sage West Midlands/Bookkeeping West Midlands ]