McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Access 2002
Office XP Access 2002, 2/e
Timothy O'Leary, Arizona State University

Modifying a Table and Creating a Form

Concepts

The following concepts will be introduced in this lab:

  1. Format Property: You can use the Format property to create custom formats that change the way numbers, dates, times, and text display and print.
  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. Validity Check: Access automatically performs certain checks, called validity checks, on values entered in a field to make sure that the values are valid for the field type.
  4. Find and Replace: The Find and Replace feature helps you quickly find specific information and automatically replace it with new information.
  5. Sort: You can quickly rearrange a table’s records by sorting the table data in a different order.
  6. 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.