Microsoft Access 2010 Training Course Advanced Leicester

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 - Leicester

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-Leicester-Advanced

Course Duration: 1 Day

Leicester Grove Park

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Advanced Microsoft Access 2010 Training Course.

Alternatively if you live in and around Leicester 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: