Microsoft Access 2007 Advanced

Sponsored links

You already have a good working knowledge of Access, working with various Access objects, such as tables, queries, forms, and reports. In this course, you will explore some of the more specialist and advanced aspects of Access, including writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Delivery:
  • In house
Category:
Duration:
  • 1 Day
Qualification:
  • Certificate upon completion

Further Details

Microsoft Access 2007 Training Course (Advanced) Outline -

Structuring Existing Data
Analyze Tables
Create a Junction Table
Improve Table Structure

Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

Making Effective Use of Forms
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Making Reports More Effective
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot

Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

This Training Course is offered "in house" at the following locations:
Cambridge
Colchester
Ipswich
Leicester
Norwich
Peterborough
Birmingham
London N
London NW
London SE
London SW
London W
London WC

Guide Price: Get in contact for more details