Where are you????

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Databases

Data bases are used to manage various types of data such as a list of customers names, phone numbers, numbers, etc. Data is stored in electric files called data bases.

Many organizations use databases to mange lots of information, including airlines, hospitals, and other corporations.

 

Examples of Database programs - Microsoft Access - File Maker - SQL - dbase - Oracle

The columns are referred to as fields and rows are called records. Records are a collection of fields and fields store the same info.

Here is an example:

Name
Phone #
address
jeff scott 590-6789 23 address lane
bob jim 123-cool 123 main street
jack fred 123-help 456-7890
mr prezident pres-ident white house

 

There are two types of databases:

Flat databases and Relational databases

Flat databases

An older and simpler database. They aren't as complex as relational databases. A spreadsheet is an example of a flat database.

 

Relational databases

Data is stored in different modules (tables) that are linked together by a common field, called they key field For example, you can choose to display just the customers address or just what they ordered.

 

Query

Used to retrieve wanted data from a database. An encoded message that asks the database to pull out specific fields from different tables into one table.

 

Report

Presents data in a clear way with a heading and fields.

 

Forms

Makes data entry easier and faster. It has several fields from different tables, that the user can easily enter data into the database.

   

Back Top Forward

Home

Copyright © Zachary Colby 2007
All rights reserved