Skip Navigation Links

Course Length:
1 Day
Course Description:
You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Who Should Attend:
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.
Benefits of Attendance:
Upon 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.
Prerequisites:
To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. Microsoft® Office Access® 2010: Level 1 and Microsoft® Office Access® 2010: Level 2 or equivalent knowledge is recommended:
Course Outline:
  • Structuring Existing Data
    1. Restructure the Data in a Table
    2. Create a Junction Table
    3. Improve the Table Structure
  • Writing Advanced Queries
    1. Create SubQueries
    2. Create Unmatched and Duplicate Queries
    3. Group and Summarize Records Using Criteria
    4. Summarize Data Using a Crosstab Query
    5. Create a PivotTable and a PivotChart
  • Simplifying Tasks with Macros
    1. Create a Macro
    2. Attach a Macro
    3. Restrict Records Using a Condition
    4. Validate Data Using a Macro
    5. Automate Data Entry Using a Macro
  • Creating Effective Reports
    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Publish Reports as PDF
  • Maintaining an Access Database
    1. Link Tables to External Data Sources
    2. Manage a Database
    3. Determine Object Dependency
    4. Document a Database
    5. Analyze the Performance of a Database