What can a Database Program do?

Sorting and Selecting
A database program can sort a file of records of alphabetical and numeric values, in descending (A-Z) or ascending (Z-A) order. You can apply this to any field containing this sort of data. If you want to re-sort a file and keep the new configuration you will have to save it in another name.

Query
A query is an operation, which will allow you to extract information from a table (or tables) given particular criteria. For example, you could search through a list for a stock item within a certain price range, or a person in a certain town.

Data Entry
Data entry forms let us add records to our file with the minimum of training. To add a record to a file when empty fields appear on the screen, you can move about the screen by using the tab key or arrows. A blank form with default formatting is illustrated below.

Contents: Databases

Skill Check: Databases