Microsoft PowerPoint Presentation

4/3/00


Click here to start


Table of Contents

PPT Slide

PPT Slide

PPT Slide

There are 5 general query types

Select

Crosstab

Parameter

Action query

SQL

Working with more than one table

Related tables

Joining Tables

Joining Tables

Three types of relationships

One-to-many

Many-to-many

Example of a many-to-many using a third linking table

One-to-one

Defining

PPT Slide

Design Query

The Results

Calculated Field

Create

Creating

Creating Summary Queries

Select a calculation option

First and Last

Questions

Author: Dolores Zage

Email: dmz@cs.bsu.edu

Home Page: http://www.cs.bsu.edu/homepages/dmz/cs104/