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