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
 

Microsoft Access 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 liked that we started the class with examples of problems that people deal with every day. It was very useful to me that people encountered other problems I also had, and Hannah went through those first before going into the manual."
Student, 2014

"Hannah is an expert in her field! Lucky to have her teaching these Continuing Ed courses. Thank you!"
Student, 2014

  Sessions  
Wed., May 6, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$224
Enrollment Limit: 20
Program No. 5070-7379
Register Now
 
  Related Courses  
Microsoft Access Level IV
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

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