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

	Access 2007/2010 - Level I

	Microsoft Access is one of the most efficient and powerful ways of managing data. Information can be stored, linked and managed using a single relational database application and powerful reporting tools for accessing the information. Examine the basic database concepts, and create and modify databases using the Microsoft® Office Access relational database application.
Course Outline/Topics ▼ Course Content Microsoft Access Level I Lesson 1: Getting Started with Access Databases Identify the Elements of the Access 2010 Interface Identify the Components of a Database Examine the Relational Database Design Process Lesson 2: Building the Structure of a Database Create a New Database Create a Table Using the Design View Manage Tables Establish Table Relationships Lesson 3: Managing Data in a Table Sort and Filter Records Work with Subdatasheets Lesson 4: Querying a Database Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping Lesson 5: Designing Forms Create a Form Modify the Design of a Form Lesson 6: Generating Reports Create a Report Add a Control to a Report Format the Controls in a Report Prepare a Report for Print Close ▲
	Prerequisites Experience using Windows
	Notes Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.
	"I have never used Access before and this class is a great starting point. I will be trying out our examples on the job tomorrow." -- student, Access I, 2012



	Wed., Sept. 25 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. 7781-6210 Add To Registration Form Check Registration Form

	Wed., Feb. 19, 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-6264 Add To Registration Form Check Registration Form

	Wed., June 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-6268 Add To Registration Form Check Registration Form


	Access 2007/2010 - Level II 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

IT Certificate Programs Brochure

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