Access 2002: Advanced

Course Specifications:

Courseware: Access 2002: Level 3

Software: Microsoft Office XP Professional

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Course Objective:

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.

Target Student:

This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.

Prerequisites:

To ensure the successful completion of Access 2002 Advanced, we recommend completion of one of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2002: Introduction
  2. Access 2002: Intermediate

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Structuring Existing Data

  1. Topic 1A: Use the Table Analyzer Wizard for Help
  2. Topic 1B: Decide on Your Own Design
  3. Topic 1C: Create a Junction Table
  4. Topic 1D: Modify the Original Tables and Complete the Design
  5. Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data

  1. Topic 2A: Group and Summarize Records in Different Ways
  2. Topic 2B: Summarize with a Crosstab Query
  3. Topic 2C: Pivot Query Results
  4. Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

  1. Topic 3A: Create a Macro
  2. Topic 3B: Attach a Macro to a Command Button
  3. Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros

  1. Topic 4A: Require Data Entry with a Macro
  2. Topic 4B: Display a Message Box with a Macro
  3. Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable

  1. Topic 5A: Change the Display of Data Under Certain Conditions
  2. Topic 5B: Display a Calendar on a Form
  3. Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

  1. Topic 6A: Cancel Printing of a Blank Report
  2. Topic 6B: Include a Chart
  3. Topic 6C: Arrange Data in Columns
  4. Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

  1. Topic 7A: Merge Access Data with a Word Document
  2. Topic 7B: Publish Access Data as a Word Document
  3. Topic 7C: Analyze Access Data in Excel