×

Microsoft Access Level I

Most of us work with data every day.  It is part of our daily lives in the workplace and our personal lives.  We are awash in data including prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.  And, because data is everywhere, most jobs today involve some form of data management.  A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data.

In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

This class is taught in Microsoft Office 2013.

Course Outline/Topics

Course Content Microsoft Access Level I

Lesson 1: Getting Started with Access

Orientation to Microsoft Access

Create a Simple Access Database

Get Help in Microsoft Access

Lesson 2: Working with Table Data

Modify Table Data

Sort and Filter Records

Create Lookups

Lesson 3: Querying a Database

Join Data from Different Tables in a Query

Sort and Filter Data in a Query

Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Create Parameter Queries

Create Action Queries

Create Unmatched and Duplicate Queries

Summarize Data

Lesson 5: Generating Reports

Create a Report

Add Controls to a Report

Enhance the Appearance of a Report

Prepare a Report for Print

Lesson 6: Customizing the Access Environment

The Access Options Dialog Box

 

Prerequisites

Experience using Windows

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

Hannah is an excellent instructor. I appreciate that she encouraged questions and really took the time to answer them thoroughly. I came to class with almost no knowledge of databases and am leaving with a foundational understanding of their components and how they work. Thank you!

— Student, 2015

Fantastic overview of Access. The instructor is very knowledgeable and provided some wisdom from her experience. Gave very good insight and advice.

— Student, 2015

Tue., Sept. 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-8427

Registration Deadline: Mon., Sept. 28

Register Now

Tue., Feb. 23, 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-8426

Registration Deadline: Mon., Feb. 22, 2016

Register Now

FacebookTwitterGoogle+Share