Skip Navigation LinksHome > Training > Technology Training > Class Catalog

Access 2010: Beginners

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways to store and work with this data is the relational database. In this course, students will use the Microsoft Office Access 2010 application and its various information management tools to structure, develop, and manage relational databases in a practical, accessible, and hands-on way.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