Microsoft (MCAS) Access 2007 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

Two day intensive course mapped against the MCAS (Microsoft Certified Application Specialist) qualification. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

Topics include

Introducing Access
What is a Database?
Looking at the Screen
Planning a Database
Creating a Database Using a Template
Moving Around a Database
Creating a Blank Database
Organizing Files

Creating and Modifying Tables
Creating Tables using Datasheet View
Moving Around a Table
Inserting, Deleting and Modifying Data in a Table
Creating Tables using Table Templates
Creating Tables Based on Existing Tables
Creating a Table in Design View
Modifying Data Types
Modifying Field Properties
Adding and Removing Primary Keys
Adding and Removing Multiple Primary Keys

Manipulating a Table
Restructuring Tables
Formatting Tables
Modifying Tables
Printing and Distributing Tables

Data Manipulations
Inserting and Deleting Records
Importing and Exporting Data
Finding and Replacing Data

Sorting and Filtering
Sorting Records
Filtering Records

Select Queries
What is a Query?
Creating a Query using the Wizard
Creating a Query in Design View
Saving, Closing and Running Queries
Adjusting Queries
Sorting Fields
Showing and Hiding Fields
Applying Criteria
Using Wildcard Characters
Functions and Calculated Fields
Changing Field Properties
Working with Aliases
Filtering Query Data

Relating Multiple Tables
Establishing Table Relationships
Enforced Referential Integrity
Print Relationships
Using the Table Analyzer

Maintaining Databases
Database Maintenance
Opening Databases
Modify Database Options
Modifying Database Properties
Using the Database Documenter
Saving a Database to a Previous Version
Saving a Database with a Password
Splitting Databases

Working with Forms
What is a Form?
Creating a Form
Using Forms
Creating and Modifying a Form in Layout View
Creating and Modifying a Form in Design View
Creating Datasheet Forms
Creating Multiple Item Forms
Creating Split Forms
Creating PivotTable Forms

Working with Reports
What is a Report?
Creating a Report using the Report Tool
Creating a Report using the Report Wizard
Creating and Modifying Reports in Layout View Creating and Modifying Reports in Design View
Print Preview and Print Reports
Exporting as PDF or XPS Format
Creating Mailing Labels

Advanced Table Design
11 Buttons
Advanced Field Properties
Using Lookup Fields
Linking Tables

Advanced Queries
Select Queries from Multiple Tables
Adding and Removing Tables from Queries
Inner and Outer Joins
Specialized Select Queries
Summary Queries
Action Queries
Create Sub-Queries
Queries from Filters

Advanced Forms and Reports
Features of Forms and Reports
Customizing Forms and Reports
Working with Properties
Using Unbound and Bound Controls
Applying Images
Using List Boxes and Combo Boxes
Using Check Boxes
Using Option Groups

Using Subforms and Subreports
Creating Subforms and Subreports
Exporting to HTML