Microsoft® Access 2013 Level I

Open Enrollment Course Dates:  TBA

Click here to pre-register for this course now!

Course Length: 1 day
PDUs: 6.5
PMI Activity ID# 000329
Prerequisites: None
Course Level: Beginner
Course Fee: $345
Course Hours: 8:30-4:15

Course Description: This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Course Objectives:

  • identify the basic components of an Access database
  • build the structure of a database
  • manage data in tables
  • query a database
  • design forms
  • generate reports

Course Content:

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
Modify Table Data
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
View and Edit Data Using an Access Form

Lesson 6: Generating Reports
Create a Report
Add a Control to a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print