Microsoft Access

Slide 2

Lesson #1 The Basics of Access

What is Access?

How Can Access Help?

Vocabulary to Know

The Database Window

Describing the Various Objects

Describing the Various Objects

Tables: The Design View

A View of the Design View

Tables: The Database View

A View of the Database View

Quiz: Question 1

Quiz: Question 1 Answer

Description of Access
Symbols and Terms

Opening a Database

How to Add a New Record

How to Exit Access

Quiz: Question 2

Quiz: Question 2 Answer

New Lesson!!!

Lesson #2 Forms, Queries, and Reports

Forms Revisited

Queries Revisited

Reports Revisited

Using the Find Command

More on the Find Command

Slide 29

Quiz: Question 1

Quiz: Question 1 Answer

The Replace Command

The Undo Command

The Delete Command

Quiz: Question 2

Quiz: Question 2 Answer

Data Validation

Making a Report

Office Assistant

Quiz: Question 3

Quiz: Question 3 Answer

New Lesson!!!

Lesson #3 Filters and Sorting

What are Filters and Sorts?

How do they Help?

Filtering by Selection

Filtering by Selection Continued

Filtering by Form

Quiz: Question 1

Quiz: Question 1 Answer

Sorts

Sort Ascending

Sort Descending

Quiz: Question 2

Quiz: Question 2 Answer

Remove Filter Button

New Lesson!!!

Lesson #4 Relational Databases

What is a relational database?

How Do Relational Databases Help?

Slide 61

How is it Used?

Quiz: Question 1

Quiz: Question 1 Answer

An Overview

Drawing a Relation

How to Create Relationships

Setting the Relationships

Editing Relationships

Establishing the Relationships

More on Relationships

More on relationships

Referential Integrity

Referential Integrity

Quiz: Question 2

Quiz: Question 2 Answer

Slide 77

Credits