Microsoft Access Introduction

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches the basic skills needed to create a relational database, define tables, create data-entry forms, add and edit records, create queries to extract information, and design basic reports in Microsoft Access.

Prerequisites

This course is designed for users that are new to Microsoft Access or are self-taught. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Windows course or have equivalent knowledge. You should feel comfortable using a mouse and have a working knowledge of the Windows environment.

Understanding the Basics of an Access Database

What is a Database?

Opening and Reviewing a Database

Reviewing Important Screen Elements

Understanding the Main Database Objects

Steps to Designing a Database

Creating an Access Database

Creating a New Database

Creating New Tables and Defining Fields

Opening a Table

Modifying a Table's Structure

Relating and Linking Tables

Entering Data and Working With Tables in Access

Adding New Records

Using Data Entry Shortcuts

Editing Information and Undoing Changes

Customizing the Datasheet

Closing a Table

Entering Related Data into a Child Table

Deleting Records

Creating Forms to Help Enter Data in Access

Creating a Form Using the Form Wizard

Opening, Closing, and Customizing Forms

Understanding Form Sections

Navigating Between Records on a Form

Adding and Deleting Records

Printing Information on a Form

Finding, Sorting, and Filtering Access Records

Navigating Through a Table

Finding a Specific Record

Sorting Records

Filtering Records

Creating Queries to Extract Information in Access

Reviewing Data Types and Criteria Examples

Building a Query

Specifying the Fields

Writing Criteria in Yes/No Fields

Viewing or Running the Query

Saving and Closing a Query

Opening or Modifying a Query

Sorting Query Results

Printing Results of a Query

Specifying Criteria in a Text Field

Using Wildcards When Specifying Criteria

Writing Criteria in a Numeric Field

Writing Criteria in a Date/Time Field

Using the "OR" Criteria

Creating Basic Access Reports

Creating a Report Based on a Query

Modifying and Customizing Reports

Understanding Report Sections

Modifying Page Setup Options

Changing the Title of a Report

Inserting Additional Fields

Saving, Closing, Opening, and Printing a Report

Creating Mailing Labels

Is this the right level for you? Take our free assessment! Please contact our office at 202.682.4500 if you have any questions.