Note that while a filter is set to user cannot access

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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". Entering Data 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 mouse. 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

Ask a homework question - tutors are online