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
This course is taught using Microsoft Office 2010. If you are interested in using Microsoft Office 2013, please contact us for more information.

"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  
Thu., Nov. 19
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8423
Register Now
 
Wed., May 11, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8422
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