×

Microsoft Access Level II

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

This class is taught in Microsoft Office 2013.

Who should attend:

This course is designed for students wishing to gain intermediate-level skills or 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

Great course! Hannah was very knowledgeable. I am looking forward to taking Access III.

— student, 2014

Hannah is very knowledgeable and really allowed us time to ask our very specific questions.

— Student, 2015

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

Thu., Oct. 29

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8424

Registration Deadline: Wed., Oct. 28

Register Now

Thu., Apr. 7, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8425

Registration Deadline: Wed., Apr. 6, 2016

Register Now

FacebookTwitterGoogle+Share