Microsoft Access Intermediate

Overview:

This one-day training session will expand on participants existing knowledge of Microsoft Access. During the session participants will receive hands-on training on a variety of uses of Access in the workplace.

The training session is designed for those who have a good grounding in Microsoft Access, for example, following attendance at an Introduction workshop. Each participant will be given a comprehensive reference manual to take away with them.

Objectives:

By the end of the day delegates will be able to:

• Use planning and designing tools.
• Work with relationships.
• Use tables.
• Work with queries.
• Learn more about forms.
• Learn more about reports.

Topics covered:

Planning and Designing

• Determine the Requirements
• Determine the Tables
• Determine the Fields
• Determine the Relationships

Relationships

• Overview of Relationships
• Creating
• Editing
• Removing
• Working with Related Tables

Working with Tables

• Lookup Lists
• Default Values
• Input Masks

Queries

• Select Queries
• Parameter Queries
• Multiple Table Queries
• Calculations withing a Query

More on Forms

• Forms to display related tables
• Linked Forms

More on Reports

• Grouped Reports
• Reports with Subtotals

Duration: 1 Day
Maximum Places: 6
Price: £85 +VAT per delegate

For more information
please contact us on
029 20 491 491

View Print Friendly Page