3. A field is a category of fact like the amount of money spent on each air-conditioning system for each house.
4. Structure is simply the way a record is set up. There are three big considerations—the field names, the field width, and the field type. The field name is simply a field’s title. The field width is the number of spaces required for the information in each field. The field type can be one of these categories:
a. A numeric field—just numbers
b. A character field or alphanumeric field—numbers, letters, question marks, miscellaneous symbols like “@,” or spaces between letters or numbers
c. A logical field—one with just two choices, like “Y” for “Yes” and “N” for “No”
5. The EDIT command changes the contents of a data field. You can type in modifications after putting your cursor in the right place.
6. A command to APPEND can add new records to your electronic filing cabinet.
7. Sorting lets you reshuffle records alphabetically, by date or other ways, just as you would index cards.
8. The LIST command tells dBASE II to flash across the screen the records that you specify.
9. .AND. helps you narrow down the information you’re looking for or changing. Consider this hypothetical example: LIST FOR SALE:PERSN = ‘BABBITT’ .AND. LOAN:AMT = ‘$70,000’ would guide you to all houses that a sales rep named Babbitt sold to a customer borrowing exactly $70,000.