Microsoft Access: Advanced

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, please click here.

Microsoft Access: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • put existing data into correctly designed tables and compact your database.
  • use a variety of techniques to summarize data.
  • create and revise basic Access macros.
  • create macros that require data entry in certain fields and automatic data entry in others.
  • use advanced features to enhance forms.
  • use advanced features to enhance reports and distribute a report to non-Access users.
  • use Office Links to use Access data in other Office programs.

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Use the Table Analyzer Wizard for Help

Topic 1B: Decide on Your Own Design

Topic 1C: Create a Junction Table

Topic 1D: Modify the Original Tables and Complete the Design

Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data

Topic 2A: Group and Summarize Records in Different Ways

Topic 2B: Summarize with a Crosstab Query

Topic 2C: Pivot Query Results

Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable

Topic 5A: Change the Display of Data Under Certain Conditions

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart

Topic 6C: Arrange Data in Columns

Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

Topic 7A: Merge Access Data with a Word Document

Topic 7B: Publish Access Data as a Word Document

Topic 7C: Analyze Access Data in Excel