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

	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 ▲
	Prerequisites Access 2007/2010 - Level II (or equivalent experience)
	Notes 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." "This is very helpful for my job and for future job advancement opportunities." -- students, Access-III, 2012



	Tue., June 18 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Hannah Goodman Fee: $224 Program No. 5070-0008 Add To Registration Form Check Registration Form

	Tue., Apr. 29, 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-6266 Add To Registration Form Check Registration Form


	Access 2007/2010 - Level IV

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

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