×
  • This field is for validation purposes and should be left unchanged.

Microsoft Access Level II

If your job calls for you to expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications and customize reports – this course is for you. Extend your knowledge of Microsoft Access 2013 for a more robust, functional database for your users.

This class is taught in Microsoft Office 2013. The UW-Milwaukee School of Continuing Education’s computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

Instructors

Hannah Goodman

Hannah Goodman

Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more

Scott Lovy

Scott Lovy

Scott Lovy has been a resident of the Milwaukee area his whole life. He received his B.S. in electrical engineering from UW-Platteville in 1988. He is currently employed at a benefit management solutions company, where he is able to utilize ... read more

Who Should Attend

This course is designed for students wishing to gain intermediate-level skills and individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Course Outline/Topics

Course Content Microsoft Access Level II

Lesson 1: Designing a Relational Database

Relational Database Design
Create a Table
Create Table Relationships

Lesson 2: Joining Tables

Create Query Joins
Join Tables That Have No Common Fields
Relate Data Within a Table
Work with Subdatasheets
Create Subqueries

Lesson 3: Organizing a Database for Efficiency

Data Normalization
Create a Junction Table
Improve Table Structure

Lesson 4: Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

Lesson 5: Advanced Reporting

Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

Prerequisites

Access 2010/2013 – Level I (or equivalent experience)

Notes

Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you will learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at nellenp@uwm.edu or 414-227-3208

Testimonials

"Hannah has a wealth of experience to share and she uses that to assist in the real-world situations that were discussed in class."  —  Participant, 2015

"Hannah is very knowledgeable and really allowed us time to ask our very specific questions."  —  Participant, 2015

All sessions are Face-to-Face unless otherwise noted.

Wed., Oct. 25

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Scott Lovy

Fee:

$249 if you register by Wed., Oct. 11.
$274 if you register after Wed., Oct. 11.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-10170

Registration Deadline: Wed., Oct. 25

Register Now