Access 2000

Access Basics

• 1

  Introduction to Databases

  

  • Introduction

  • Organizing Our World

  • Organizing Our World (continued)

  • What is a relational database?

  • What is a relational database? (continued)

  • Real world examples of database applications

  • Real world examples of database applications (continued)

  • Challenge!

• 2

  Database Terms

  

  • Introduction

  • What is a Database?

  • Database Terms

  • Database Terms - Tables, Records, Fields

  • The Great Lake Elementary School Database - Tables, Records, Fields

  • Database Terms - Queries, Forms

  • Database Terms

  • Challenge!

• 3

  Starting Access

  

  • Introduction

  • Installing Access 2000

  • The Access Environment

  • Opening an Existing Database

  • Opening Files in Access

  • Challenge!

• 4

  Database Tables

  

  • Introduction

  • Datasheet basics

  • Field Properties

  • Understanding Table Relationships

  • Primary Keys

  • Challenge!

Working with Tables and Forms

• 5

  Adding Table Records

  

  • Introduction

  • Opening an Existing Table

  • Navigating the Table

  • Using the Keyboard to Navigate Table Records

  • Enter/Add a Table Record in Datasheet View

  • The Record Selector

  • Working with Records

  • Challenge!

• 6

  Editing Table Records

  

  • Introduction

  • Editing Data in a Table

  • Using the Undo Feature in Access 2000

  • Moving or Copying Data

  • Check the Spelling of Data

  • Challenge!

• 7

  Deleting Table Records

  

  • Introduction

  • Deleting Table Records

  • Deleting Multiple Records

  • Important to Remember:

  • Challenge!

• 8

  Adding Form Records

  

  • Introduction

  • Opening a Form

  • Navigating a Form

  • Adding Records in a Form

  • Challenge!

• 9

  Editing Form Records

  

  • Introduction

  • Editing Form Records

  • Editing Form Records - Continued

  • Challenge!

• 10

  Deleting Form Records

  

  • Introduction

  • Deleting Form Records

  • The Delete Confirmation Message

  • Challenge!

Finding Records and Creating Reports

• 11

  Sorting Records

  

  • Introduction

  • Review: Table and Form Concepts

  • Sort Records to Find Information

  • Working in Datasheet View

  • Sorting Records

  • Challenge!

• 12

  Sorting Multiple Records

  

  • Introduction

  • Multi-field Sorting

  • Multiple Sorting Example

  • Multi-Field Sorting Example

  • Challenge!

• 13

  Finding Records

  

  • Introduction

  • The Find and Replace Dialog Box

  • The Find and Replace Dialog Box's Additional Features

  • Using Wildcards

  • Challenge!

• 14

  Filtering Records

  

  • Introduction

  • Filtering Records

  • Removing a Filter

  • Filter Excluding Selection

  • Filter By Form

  • Challenge!

• 15

  Queries

  

  • Introduction

  • What is a Query?

  • Run an Existing Query

  • Creating a Simple Query

  • Sorting, Finding, and Filtering Query Results

  • Challenge!

• 16

  Creating a Report

  

  • Introduction

  • Reports

  • AutoReport

  • The Report Wizard

  • Using the Report Wizard

  • Challenge!

• 17

  Printing a Report

  

  • Introduction

  • Open an Existing Report

  • Print Preview

  • Printing a Report

  • Challenge!

Extras

• Quiz

Learn More

• Access 2013

• OneDrive and Office Online

• Tech Savvy Tips and Tricks

• Office 2000 Basics