Home > Training > Professional Technical Education > Classes Offered

Access 2010: Beginners

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools.  In this course, you will be introduced to the concept of the relational database by using the Microsoft Office Access 2010 relational database application and its information management tools.

Course Outline

Exploring the Microsoft Office Access 2010 Environment
Examine Database Concepts
Explore the User Interface
Use an Existing Access Database
Customize the Access Environment
Obtain Help

Designing a Database
Consider the Relational Database Design Process
Normalization of Data
Primary and Foreign Keys
Table Relationship Properties

Building a Database
Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version

Managing Data in a Table
Modify Table Data
Sort Records
Work with Subdatasheets

Querying a Database
Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Designing Forms
View Data Using an Access Form
Create a Form
Modify the Design of a Form

Generating Reports
View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat Style to a Report
Prepare a Report for Print