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 ▲

Prerequisites
Experience using Windows
Notes
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

  Sessions  
Tue., Sept. 29
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8427
Register Now
 
Tue., Feb. 23, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$249
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, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Fall 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf