Microsoft Access 2010 Advanced
Sponsored links
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.
| Delivery: |
|
| Category: | |
| Duration: |
|
| Qualification: |
|
Further Details
Microsoft Access 2010 Training Course (Advanced) Outline -
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
This Training Course is offered "in house" at the following locations:
Cambridge
Colchester
Ipswich
Leicester
Norwich
Peterborough
Birmingham
Northampton
London N
London NW
London SE
London SW
London W
London WC
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
