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 ProgramsFaculty & Staff

Microsoft Access Level II


Get up to date on the more advanced features of Access 2010. Learn how to maintain data consistency, customize database components and share Access data with other applications. This course provides more in-depth knowledge on modifying field properties of a database, data integrity, working with joins, creating flexible queries and modifying data, customizing reports, and sharing data across applications.

Course Outline/Topics

Course Content Microsoft Access Level II

Lesson 1: Controlling Data Entry

Constrain Data Entry Using Field Properties

Establish Data Entry Formats for Entering Field Values

Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins

Join Tables with No Common Fields

Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set the Select Query Properties

Retrieve Records Based on Input Criteria

Create Action Queries

Lesson 4: Improving Forms

Restrict Data Entry in Forms

Organize Information with Tab Pages

Add a Command Button to a Form

Create a Subform

Change the Display of Data Conditionally

Lesson 5: Customizing Reports

Organize Report Information

Control Report Pagination

Summarize Report Information

Close ▲

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

"Great course! Hannah was very knowledgeable. I am looking forward to taking Access III."
student, 2014

Dates and locations to be announced.
Fee: $224
CEUs: 0.7
  Related Courses  
Microsoft Access Level IV
Microsoft Access Level III
Email us with your interest, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Comments on this Program
"Great instructor and content of program"

Sue Duerlinger
P&H Mining Equipment
Milwaukee, WI