Creating and Using Stored Tables

Why Use Tables

You create stored tables so you can store, retrieve, and process information. The information may be of concern only to yourself, or it may be used by many people in the corporation.

Before creating stored tables, you must decide what information you need and how you want to use that information.

An Example

For example, Fran Snell, personnel director of Acme Insurance, wants to keep a record of all the positions in the company, both filled and unfilled. Fran also wants to store information about applicants for positions at Acme Insurance. Fran would like to use the job and applicant information stored in the database to help personnel fill open positions at Acme.

In this section, you will outline an application that meets Fran's data processing needs and create the stored tables that make up the application. This section covers the following topics:

Outlining a relational application
Defining a stored table
Using a table to store and retrieve data
Stored table summary

This section contains the following topics:

Outlining an Application

Defining a Stored Table

Using a Data Table

Stored Table Summary