GCFLearnFree.org

I love your videos. Everything is so precise and to the point.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003

Access 2003

thumbnail view list view video view
Access 2003 is the database software in the Microsoft 2003 Office suite. Learn how to order, manage, search, and run reports on large amounts of information in a relational database.

Microsoft Access Overview

  • 1

    Introduction to Databases

    lesson contents
    • Introduction

    • Organizing our world

    • Organizing our world

    • What is a relational database?

    • What is a relational database?

    • Real-world examples of database applications

    • Real-world examples of database applications

    • Challenge!

  • 2

    Database Concepts

    lesson contents
    • Introduction

    • What is a database?

    • What is a table?

    • What is a query?

    • What is a form?

    • What is a report?

    • Challenge!

  • 3

    Identifying the Basic Parts of the Access Window

    lesson contents
    • Introduction

    • Launching Microsoft Access from the Windows desktop

    • The main Access window

    • The main Access window

    • The database window

    • Challenge!

  • 4

    Database Tables

    lesson contents
    • Introduction

    • Datasheet basics

    • Field properties

    • Understanding table relationships

    • Primary keys

    • Challenge!

  • 5

    Getting to know the Contact Management Database

    lesson contents
    • Introduction

    • Download the Contact Management database

    • Open the Contact Management database

    • Reviewing the contact management tables

    • Reviewing the contact management forms

    • Reviewing the contact management reports

    • Challenge!

  • 6

    Using a Wizard to Create the Contact Management Database

    lesson contents
    • Introduction

    • Launching the Database Wizard

    • Verifying the intent of the Contact Management database

    • Selecting tables and fields for the Contact Management database

    • Defining the format of the screen display

    • Defining the format of the report display

    • Naming the database

    • Finishing the wizard

    • Challenge!

Entering, Viewing and Working with Data

  • 7

    Opening a Table and Learning to Navigate Records

    lesson contents
    • Introduction

    • Opening an existing table in Datasheet view

    • Using the status area to navigate through records in a table

    • Displaying records by scrolling through the table

    • Using the keyboard to navigate table records

    • The Record Selector

    • Challenge!

  • 8

    Viewing and Adding Table Records

    lesson contents
    • Introduction

    • Enter or add a table record in Datasheet view

    • Resizing table columns

    • Resizing table columns

    • Adjusting row height

    • Challenge!

  • 9

    Editing and Deleting Table Records

    lesson contents
    • Introduction

    • Editing a table record in Datasheet view

    • Cutting, copying, and pasting table records

    • Cutting, copying, and pasting table records

    • Using the Undo feature

    • Check the spelling of data

    • Deleting table records

    • Deleting table records

    • Challenge!

  • 10

    Adding Form Records

    lesson contents
    • Introduction

    • Opening forms in the Contact Management database

    • Using the Contact Management Main Switchboard

    • Contacts Table: Adding records using the enter/view contacts form

    • Calls Table: Adding records using the Calls form

    • Adding records using the enter/view Contact Types form

    • Adding records using the enter/view Contact Types form

    • Challenge!

  • 11

    Editing Form Records

    lesson contents
    • Introduction

    • Using the status area to navigate records in a form:

    • Editing form records

    • Challenge!

Turning Data into Meaningful Information

  • 12

    Sorting Records

    lesson contents
    • Introduction

    • Sorting records to find information

    • Performing a multi-field sort

    • Removing a sort

    • Saving a sort

    • Challenge!

  • 13

    Finding Records

    lesson contents
    • Introduction

    • Performing a simple find

    • Performing a simple find

    • Using wild cards to find records

    • Challenge!

  • 14

    Filtering Records

    lesson contents
    • Introduction

    • Performing a Filter By Selection

    • Removing a filter

    • Saving a filter

    • Performing a Filter Excluding Selection

    • Performing a Filter By Form

    • Challenge!

  • 15

    Running Database Queries

    lesson contents
    • Introduction

    • Run an existing query

    • Creating a single-table query

    • Creating a single-table query

    • Creating a multiple-table query

    • Creating a multiple-table query

    • Sorting, finding, and filtering query results

    • Challenge!

  • 16

    Running and Printing Database Reports

    lesson contents
    • Introduction

    • Running Contact Management reports

    • Running Contact Management reports

    • Creating a report using AutoReport

    • Creating a report using the Report Wizard

    • Creating a report using the Report Wizard

    • Creating a report using the Report Wizard

    • Creating a report using the Report Wizard

    • Using Print Preview

    • Printing a report

    • Challenge!

Extras

  • Quiz

ampersand

Learn More

  • Access 2013

  • OneDrive and Office Online

  • Tech Savvy Tips and Tricks

  • Office 2003 Basics

Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.