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 recordNAVIGATING A LARGE TABLE
Using the Keyboard
First record, same field
Previous record, same field
Next record, same field
Last record, same field
New (blank) recordNAVIGATING A LARGE TABLE
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