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
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

  Sessions  
Thu., July 24
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
Fee: $224
CEUs: 0.7
Program No. 5070-6327
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


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>>