School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted

Connect With Us

HomeCourses & ProgramsCertificate ProgramsCustomized TrainingFaculty & Staff

Microsoft Access Level III


This course is for non-programmers wishing to learn the basic objects in a database file. Learn to find, edit and generate reports using Microsoft Access.

Course Outline/Topics

Course Content Microsoft Access Level III

Lesson 1: Structuring Existing Data

Restructure the Data in a Table

Create a Junction Table

Improve the Table Structure

Lesson 2: Writing Advanced Queries

Create SubQueries

Create Unmatched and Duplicate Queries

Group and Summarize Records Using Criteria

Summarize Data Using a Crosstab Query

Lesson 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

Lesson 4: Creating Effective Reports

Include a Chart in a Report

Print Data in Columns

Cancel Printing of a Blank Report

Publish Reports as PDF

Lesson 5: Maintaining an Access Database

Link Tables to External Data Sources

Manage a Database

Close ▲

Access 2007/2010 - Level II (or equivalent experience)
Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.

"I liked that we started the class with examples of problems that people deal with every day. It was very useful to me that people encountered other problems I also had, and Hannah went through those first before going into the manual."
Student, 2014

"Hannah is an expert in her field! Lucky to have her teaching these Continuing Ed courses. Thank you!"
Student, 2014

Wed., May 6
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
Enrollment Limit: 20
Program No. 5070-7379
Register Now
  Related Courses  
Microsoft Access Level IV
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Spring 2015 Business Programs Catalog

Or download the pdf