Updating database of manual pages
For more information about input masks, see Control data entry formats with input masks.
Lists help maintain data integrity and are easy to use.
Finally, you can delete a record when it is no longer relevant and to save space.
For more information on setting up a database for data entry, see Design considerations for updating data. Data entry forms can provide an easier, faster, and more accurate way to enter data.
Value lists display a set of items that you enter manually.
Lookup lists use a query to retrieve their data from one or more table result sets open in datasheet view.
You can use lists in forms, and in tables and queries.
Access has three types of lists — value lists, lookup fields and multivalued lists.
For example, you might to want to track customer support issues and assign multiple people the same issue in one field.
The deletion process is fairly simple, except when the record is related to other data and resides on the "one" side of a one-to-many relationship.
To maintain data integrity, by default, Access does not let you to delete related data.
The record number is counted sequentially, from the beginning of the form or datasheet — it does not correspond to any field value. The first matching value is highlighted in real time as you enter each character.
Filter The filter indicator button shows whether a filter has been applied. The Find and Replace dialog box provides another way to change small amounts of data in less time and with less effort.