Microsoft Access 2010 Training Course Advanced Peterborough

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

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

Course Duration: 1 Day

Peterborough

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

This business centre is a strategically located headquarters office building in central Peterborough, in the heart of the business district. It is within walking distance of the bus and railway stations and close to all shopping facilities, including Marks & Spencer and the Queensgate Shopping Centre where tenants include John Lewis, Waitrose and Boots. It is within a quater mile of junction 5 of the Peterborough Ring Road. Convenient for your Advanced Microsoft Access 2010 Training Course.

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