Houston | The Woodlands
(832) 693-9785
Excel Training Houston on Facebook Houston Excel Training on LinkedIn Excel Training Houston on Twitter Houston VBA Training on Google+ Excel VBA Houston Email
  • Microsoft Access: Level 3 - Advanced

  • Course length:

    1.0 day

    Course Objective:

    You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

    Target Student:

    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.

    Certification:

    This course is one of a series of courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft Excel-Add-In.

    Course Objectives:

    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 macros
    • customize reports by using various Access features
    • maintain your database using Access tools.
  • Course Content

    Lesson 1: Structuring Existing Data

    1. Restructure the Data in a Table
    2. Create a Junction Table
    3. Improve the Table Structure

    Lesson 2: Writing Advanced Queries

    1. Create Subqueries
    2. Create Unmatched and Duplicate Queries
    3. Filter Records Using Criteria
    4. Summarize Data Using a Crosstab Query
    5. Create a PivotTable and a PivotChart

    Lesson 3: 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

    Lesson 4: Creating Effective Reports

    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Publish a Report as a PDF

    Lesson 5: 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

    Appendix A: Microsoft Office Access 2010 Exam 77–885