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
Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.

"This course was very helpful. I plan to return for Access II and III. I could draw parallels to my role and work in ACCESS."
student, 2014

"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

Tue., Feb. 10
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
Enrollment Limit: 20
Program No. 5070-7389
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 Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf

In Partnership with
American Marketing Association