Index | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23

Database

A Database is a collection of information stored in a way that makes it easy to retrieve, modify and search. A database can be stored in a single file with all the information stored together in a single table which is referred to as a flat database or stored in multiple tables with some common access information referred to as a relational database.

Each person or item in a database has it's own Record. Each piece of information about that person or record are stored in Fields. All the information in all the records makes up the Data Base.

Each Field can have information typed into it. Use the Tab key to move forward through the Field and the Shift-Tab to move backwards. Many databases also allow users to use the arrow keys to move around as well.

Though many fields only allow a single line of input some allow multiple lines. When the cursor reaches the bottom of a field with multiple lines the text will scroll upwards to show any information that is below the line of sight. If there is more text in the field than there is room on the screen use the arrow keys to move the cursor through the text.

It is possible to mask individual fields to make data entry easier. For instance the field for phone numbers can be formatted to only allow numbers to be entered.

There are many different ways to use information in a database. In order to use it you can search for or display information using various filters to allow or disallow certain records to display. This is referred to as a query.

The data can be arranged to create reports and print the information in a specific format.

It is crucial that the information typed into a Data Base or information updated be saved before leaving the program. Many data errors can be traced back to power-failures or accidental computer shut downs.

The data can also be used by other programs for things like invoicing and form letters. The data from a database can be merged with forms created in other programs for a wide range of uses.

Index | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23