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 ProgramsFaculty & Staff

Microsoft Access Level I


Microsoft Access is one of the most efficient and powerful ways to manage data. Information can be stored, linked and managed using a single relational database application and powerful reporting tools for accessing the information. Examine the basic database concepts, and create and modify databases using the Microsoft relational database application.

Course Outline/Topics

Course Content Microsoft Access Level I

Lesson 1: Getting Started with Access Databases

Identify the Elements of the Access 2010 Interface

Identify the Components of a Database

Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database

Create a New Database

Create a Table Using the Design View

Manage Tables

Establish Table Relationships

Lesson 3: Managing Data in a Table

Sort and Filter Records

Work with Subdatasheets

Lesson 4: Querying a Database

Create a Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

Create a Form

Modify the Design of a Form

Lesson 6: Generating Reports

Create a Report

Add a Control to a Report

Format the Controls in a Report

Prepare a Report for Print

Close ▲

Experience using Windows
This course is taught using Microsoft Office 2010. If you are interested in training using Microsoft Office 2013, please contact us for more information.

"I really liked the class and thought it was very useful. It got me off to a good start in being able to create databases."
student, 2014

"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
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8427
Register Now
Tue., Feb. 23, 2016
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8426
Register Now
  Related Courses  
Microsoft Access Level IV
Microsoft Access Level III
Microsoft Access Level II
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Marketing & Technology Fall 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf