Site MapHelpFeedbackModifying a Table and Creating a Form
Modifying a Table and Creating a Form

The following concepts will be introduced in this lab:
  1. Format Property: The Format Property is used to specify the way that numbers, dates, times, and text in a field are displayed and printed.
  2. Default Value Property: The Default Value property is used to specify a value to be automatically entered in a field when a new record is created.
  3. Validation Rule: Validation rules are used to control the data that can be entered in a field by defining the input values that are valid or allowed.
  4. Expression: An expression is a formula consisting of a combination of symbols that will produce a single value.
  5. Find and Replace: The Find and Replace feature helps you quickly find specific information and automatically replace it with new information.
  6. Sort: You can quickly rearrange a table's records by sorting the table data in a different order.
  7. Form: A form is a database object used primarily to display records onscreen to make it easier to enter new records and to make changes to existing records.









The O'Leary Series Office 2003Online Learning Center

Home > Access 1 > Lab 2