Microsoft Access Intermediate (2007, 2010 & 2013)

MODULE 1: Advanced File Tasks

Learning outcomes:

A look at some important administrative features necessary for managing an Access Database file.

Topics covered:

• Using Windows Explorer within Access
• Database Management
• Saving Your Files
• Exporting Files
• Linking Files

MODULE 2: Working with Tables

Learning outcomes:

Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.

Topics covered:

• Customising Tables
• Table Properties: Formatting
• More Table Properties
• Data Validation and Lookup Wizard

MODULE 3: Working with Forms

Learning outcomes:

Building professional forms to enhance the user experience and improve effective use.

Topics covered:

• Basic Form Controls
• Advanced Form Controls
• Formatting Your Form
• Formatting Controls
• Using Themes

MODULE 4: Working with Reports

Learning outcomes:

Organise and format your reports professionally and common report tasks you may need to perform.

Topics covered:

• Organizing Report Data
• Formatting Reports
• Common Report Tasks

MODULE 5: Working with Queries

Learning outcomes:

Creating a range of different queries from very basic queries through to management queries with advanced functionality.

Topics covered:

• Basic Queries
• Doing More with Queries
• Creating Advanced Queries
• Creating Management (Action) Queries