Duration: 2 Days
Overview:
In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Target Audience:
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Pre-requisites:
- Access 2010 basic skills
At Course Completion:
Upon successful completion of this course, students will be able 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
- Maintain their databases using Microsoft® Office Access® 2010 tools
Outline:
Module 1: Structuring Existing Data
- Restructure the Data in a Table
- Create a Junction Table
- Improve the Table Structure
Module 2: 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
Module 3: 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
Module 4: Creating Effective Reports
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Publish Reports as PDF
Module 5: 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
