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 Access Databases

What is a Database?

Opening and Reviewing Databases

Reviewing Important Screen Elements

Understanding the Main Database Objects

Steps for Designing Databases

Creating Access Databases

Creating New Databases

Creating New Tables and Defining Fields

Opening and Closing Tables

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 View

Entering Data into Related Tables

Deleting Records

Creating Forms to Help Enter Data in Access

Creating Form Using the Wizard

Opening, Closing, and Customizing Forms

Understanding Form Sections

Navigating Between Records on Forms

Adding and Deleting Records

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

Creating Queries

Specifying Query Fields

Writing Criteria in Yes/No Fields

Viewing or Running the Query

Saving and Closing Queries

Opening or Modifying Queries

Sorting Query Results

Printing Query Results

Specifying Criteria in Text Fields

Using Wildcards When Specifying Criteria

Writing Criteria in a Numeric Field

Writing Criteria in a Date/Time Field

Using the "AND" and "OR Criteria

Creating Basic Access Reports

Creating Reports Using the Wizard

Modifying and Customizing Reports

Understanding Report Sections

Modifying Page Setup Options

Changing Report Titles

Inserting Additional Fields

Saving, Closing, Opening, and Printing Reports

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.

Other Helpful Links

Access - Introduction Agenda

Access - Intermediate Agenda

Access - Advanced Agenda

Access - VBA Programming Agenda

Database Design

Top of Page