Access 2007/2010 - Level II - School of Continuing Education, University Of Wisconsin

	Access 2007/2010 - 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.
SHARE THIS PROGRAM Connect with Information Technology

	Thu., Oct. 31 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-6220 Add To Registration Form Check Registration Form

	Tue., Mar. 25, 2014 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructors: Lynne Miller Hannah Goodman Fee: $224 CEUs: 0.7 Program No. 5070-6265 Add To Registration Form Check Registration Form

	Thu., July 24, 2014 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructors: Lynne Miller Hannah Goodman Fee: $224 CEUs: 0.7 Program No. 5070-6327 Add To Registration Form Check Registration Form


	Access 2007/2010 - Level IV Access 2007/2010 - Level III

	For more information, contact:
		Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208

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