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.

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. The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

Instructor

Scott Lovy

Scott Lovy

Scott Lovy is a life-long resident of the Milwaukee area. 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 all of his ... read more

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

"I really enjoyed the instructor. He was very engaging and you could tell that he knew the material very well."  —  Physician Compensation Analyst, 2018

"This course was very helpful to go through the different scenarios. Much of what I learned I currently use with my systems at work. I was not aware how similar the two were."  —  Operations Manager, 2018

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

Date: Tue., Sept 25

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Scott Lovy

Fee:

$249 by Tue., Sept. 11.
$274 after Tue., Sept. 11.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-11020

Registration Deadline: Tue., Sept. 25

Register Now

Date: Thu., Jan 24, 2019

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Scott Lovy

Fee:

$249 by Thu., Jan. 10, 2019.
$274 after Thu., Jan. 10, 2019.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-11407

Registration Deadline: Thu., Jan. 24, 2019

Register Now

Share