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

"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  
Dates and locations to be announced.
Fee: $224
CEUs: 0.7
  Related Courses  
Microsoft Access Level IV
Microsoft Access Level III
Microsoft Access Level II
 
Email us with your interest, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf