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 ▲

Prerequisites
Access 2007/2010 - Level I (or equivalent experience)
Notes
This course is taught using Microsoft Office 2010. If you are interested in using Microsoft Office 2013, please contact us for more information.

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

"Very helpful class, and Hannah was wonderful about addressing student questions. Thank you!"
Student, 2015

"Hannah is very knowledgeable and really allowed us time to ask our very specific questions."
Student, 2015

  Sessions  
Thu., Oct. 29
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8424
Register Now
 
Thu., Apr. 7, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8425
Register Now
 
  Related Courses  
Microsoft Access Level IV
Microsoft Access Level III
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

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

Sue Duerlinger
P&H Mining Equipment
Milwaukee, WI