|
A database is an
accumulation of custom data that you can enter and display.
Actually, a database
is more of a complete data system. It includes the data
itself, methods for you to enter data, customized reports,
customized letters and documents, data filters, mailing
labels, and so on.
The data:
Basically, all of the data is held in one or more tables. You
can picture a table as being like a checker board, which
is divided into columns and rows. The rows are called records.
The columns are called fields. The square, where a particular
column and row intersect, is called a cell. Each cell contains
some data for that record, like an employee's street address,
or a lawnmower part number.
Forms for entering
data: The entry forms are where the user meets
the data. A simple form is displayed on the computer screen. The
majority of the form is made up of labels and text boxes.
Labels are simply words that define the adjoining text box,
for example "Last Name" or "Part Number". The text boxes are where you type the
data. They may also be filled in ahead of time from existing
data, or they can
have a drop down menu with predetermined choices. A well
designed form will allow a person, with minimal training, to
properly enter, manipulate, and display important data.
Customized
reports: The data can be filtered and sorted in any
reasonable way. As a simple example, you may want to have a
printed report, or generate mailing labels, of everyone on your Christmas list, from a
certain ZIP code, or area code. You may need a report of all
part numbers stored in a particular location, sorted in
alphabetical order. You could even print a list of all
employees with "A" as the third letter of their last name. The
possibilities, and the practical uses, are almost endless.
Labels:
A custom label, with specific data, can be printed for each record you specify.
These labels are not limited to envelopes. Perhaps you need to
identify parts or containers. Once again, the possibilities,
and the practical uses, are almost endless.
Databases on the
Internet: Your database can be placed on the Internet.
Imagine any authorized person being able to make data entries,
and read or print reports, from anywhere in the world. Persons
authorized to access the data will have their user name and
password stored in the database. After they enter the proper
personal information, they will obtain permission to access
and manipulate the data. Managers can control and monitor
these activities through the use of administrative forms and
data displays.
|