Microsoft® Access 2013 Level I Introduction

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


Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Course Information
  • Course ID:Beginner
  • Credit:PDUs: 6.5

Related Courses