Lab 2. Modifying a Table and Creating a Form. Objectives. Navigate a large table. Change field format properties. Set default field values. Insert a field. Add validity checks. Hide and redisplay fields. Find and replace data. Use Undo. Sort records.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Modifying a Table and Creating a Form
[Page Down]Down one page
[Page Up]Up one page
[Ctrl] + [Page Up]Left one window
[Ctrl] + [Page Down]Right one window
[End]Last field in record
[Home]First field in record
[Ctrl] + [End]Last field of last record
[Ctrl] + [Home]First field of first record
[Ctrl] + [up arrow]Current field of first record
[Ctrl] + [down arrow]Current field of last record
Using the Keyboard
First record, same field
Previous record, same field
Next record, same field
Last record, same field
New (blank) record
Using the Navigation Buttons
Text and Memo Data Types
Identifiers and Expressions
Entered in the Validation Rule field of the field's property.
Dialog Box Options