Microsoft Access 2010 Training Course Advanced Norwich

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

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

Course Duration: 1 Day

Norwich

Cavell House
Stannard Place
St. Crispins Rd
Norwich
NR3 1YE
UNITED KINGDOM

The centre is located beside the inner ring road, which links directly with all main arterial routes exiting Norfolk. Norwich has train networks nearby that have direct links to London Liverpool Street (2 Hours) and Cambridge (1 Hour). Ideally situated for your Advanced Microsoft Access 2010 Training Course.

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