Microsoft Access 2010 Training Course Advanced Milton Keynes

In this course you will learn how to create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

After completing this course you will know how to restructure data into appropriate tables to ensure data dependency and minimize redundancy, write advanced queries to analyze and summarize data, create and revise Microsoft® Office Access® 2010 macros, customize reports by using various Microsoft® Office Access® 2010 features and maintain their databases using Microsoft® Office Access® 2010 tools.

Microsoft Access 2010 Training Course (Advanced) Outline - Milton Keynes

Structuring Existing Data

Restructure the Data in a Table
Create a Junction Table
Improve the 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

Creating Effective Reports

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish Reports as PDF

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

Microsoft-Access-2010-Training-Course-Milton_Keynes-Advanced

Course Duration: 1 Day

Milton Keynes

Fairbourne Drive
Atterbury
Milton Keynes
MK10 9RG
UNITED KINGDOM

Located in a new business park in parkland setting Atterbury Lakes is situated just off Junction 14 on the M1, and is an ideal central UK location with excellent access to the rest of the UK motorway network. The West Coast main line from London Euston runs through Milton Keynes; approximately 100 trains a day run between Milton Keynes and Euston (40 minutes) and there is a direct service to Gatwick Airport. The centre is highly visible from Childs Way, which is the primary route into Milton Keynes. Just right for your Advanced Microsoft Access 2010 Training Course.

Alternatively if you live in and around Milton Keynes and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

Maybe you would prefer your training at an alternative venue.

To see more details as to our Training Venues click one of the links below: