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

Access 2007/2010 - 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 thought this class was most valuable. I am looking forward to level 4."

"As always, Hannah did an amazing job!"
student, 2013

Tue., Apr. 29
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
Fee: $224
CEUs: 0.7
Program No. 5070-6266
Register Now
  Related Courses  
Access 2007/2010 - Level IV
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Spring 2014 Business Programs Catalog

Or download the pdf

Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>