Course Outline
Microsoft Access - Advanced
Hands-on training in an instructor-led environment. One workstation per delegate
and exercises to consolidate learning
Training Method:
A working knowledge of Microsoft Access, or having attended our 2 day Introduction
to Access course.
Two days
To enhance database designs by using the principles of table relationships. Delegates will learn how to
query multiple tables for data that is then used in customised forms and reports. They will further learn
how to perform more complex queries and create more efficient forms and reports.
Experienced users of Microsoft Access or as a follow on from our 2 day Introduction.
Designed for:
Module 1: Working with Queries
A Quick Review
Understanding the Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions & Expression Builder
Using an IIF Function
Summarizing Groups of Records
Display Top or Bottom Values, Parameter Queries
Finding Duplicate Records & Unmatched Records
Crosstab Queries,Delete Queries,Append Queries
MakeTable Queries, Update Queries
Module 2: Working with Forms
Creating a Form with AutoForm, Modifying a Form
Adding and Deleting Fields
Moving and Sizing Controls, Changing the Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form and Report Property Reference
Working with Multiple Controls
Adding, Cutting, Copying, and Pasting Controls
Changing a Controlís Data Source
Creating a Calculated Control
Changing a Controlís Default Value
Using the Control Wizard, Creating a Subform
Modifying and Working with Subforms
Module 3: Working with Reports
Creating a Report with AutoReport
Modifying a Report, Adding and Deleting Fields
Moving and Sizing Controls
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Understanding Report Sections
Grouping and Sorting Records
Creating Calculated Controls
Working with Section Properties
Creating Charts with the Chart Wizard
Module 4: Formatting Forms & Reports
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment, Using AutoFormat
Changing Colours, Applying Special Effects
Using the Format Painter, Adding Pictures & Lines
Aligning Controls with One Another
Changing a Controlís Formatting Properties
Module 5: Working with Macros
Creating and Running a Macro, Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Module 6: Advanced Topics
Importing Information, Exporting Information
Importing Objects from Another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields, Using OLE Object Fields
Displaying Database Object Dependencies
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287