Entering Data

This is an important part of the operation of the database program, as a good deal of information could be entered only to find that it would have to be re-entered.

To avoid errors, we can format the fields so that only information typed in a certain way will be accepted. Dates can be formatted as dd/mm/yy. Abbreviations such as St. and Rd. could be used for Street and Road.

It is advisable to decide what information you will want to extract from your database while you are designing the field contents so that sorting and searching will bring up the required information.

Contents: Databases

Skill Check: Databases