|
|
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 - 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:
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. Copyright © Zachary Colby 2007 |