This preview shows page 1. Sign up to view the full content.
Unformatted text preview: cter position of a field to be a letter or numeral. 3. Automatic conversion of typed characters to upper-or lower-case. For 16.12,
this feature may be used with the STATE field. Hence, the system will accept
“mh”, “Mh”, "mH" or "MH" for the state code of Maharashtra, and will
automatically convert the entry to "MH”. This feature can greatly ease data entry
and ensure the uniformity of data.
4. Automatic formatting of certain fields. For example, in the form of Figure
16.12, this feature can be used with the TELEPHONE NO. field to automatically
display the value of this field in the specified format (with the parentheses, space,
and hyphen). That is, to enter the telephone number "(020) 5680-489", the user
only needs to type "0205680489", and the system automatically causes the form to
display "(020) 5680-489".
After the forms have been designed, the database is ready for entry of data. Data is
entered one record at a time. To enter the data, the user issues a command that
calls up and displays the appropriate form with blank fields. The user then keys in
the data for each field in the appropriate spaces. In this manner, the user enters the
data for the first record, then for the second record, and so on. In most database
systems, the records are automatically assigned a number as they are entered.
While entering data into the fields, the tab key or enter key is usually used to move
to the next field. Pressing enter or tab key in the last field on the form saves the
record in the database and moves to a new, blank form the next record to be
entered. In addition to using the tab or enter key to move forward through fields,
one can directly go to any field on the form at any time by clicking on it with the
Viewing, Modifying, Deleting and Adding Records
All database systems .provide commands to view, modify, delete, or add the
records of an already established database. The command for viewin...
View Full Document
- Spring '14