Access 2003

Microsoft Access Overview

• 1

  Introduction to Databases

  

  • 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

  

  • 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

  

  • Introduction

  • Launching Microsoft Access from the Windows desktop

  • The main Access window

  • The main Access window

  • The database window

  • Challenge!

• 4

  Database Tables

  

  • Introduction

  • Datasheet basics

  • Field properties

  • Understanding table relationships

  • Primary keys

  • Challenge!

• 5

  Getting to know the Contact Management Database

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • Introduction

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

  • Editing form records

  • Challenge!

Turning Data into Meaningful Information

• 12

  Sorting Records

  

  • Introduction

  • Sorting records to find information

  • Performing a multi-field sort

  • Removing a sort

  • Saving a sort

  • Challenge!

• 13

  Finding Records

  

  • Introduction

  • Performing a simple find

  • Performing a simple find

  • Using wild cards to find records

  • Challenge!

• 14

  Filtering Records

  

  • 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

  

  • 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

  

  • 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

Learn More

• Access 2013

• OneDrive and Office Online

• Tech Savvy Tips and Tricks

• Office 2003 Basics