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 ProgramsCustomized TrainingFaculty & Staff
 

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

"As always, Hannah did an amazing job!"
student, 2013

  Sessions  
Tue., Apr. 29
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-6266
Register Now
 
  Related Courses  
Access 2007/2010 - Level IV
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Spring 2014 Business Programs Catalog

Or download the pdf


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