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.

"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

  Sessions  
Tue., Feb. 10, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$224
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, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf

In Partnership with
American Marketing Association


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>