Microsoft Office Tutorials and References
In Depth Information
Undo and Redo
You also can undo
multiple actions. To see
a list of recent actions
that you can undo, click
the down arrow next to
the Undo button on the
Quick Access Toolbar.
To redo the most recent
action, click the Redo
button on the Quick
Access Toolbar. You also
can redo multiple actions
by clicking the down
arrow next to the button.
Making Changes to the Data
Check your entries carefully to ensure they are correct. If you make a mistake and
discover it before you press the TAB key, correct it by pressing the BACKSPACE key until the
incorrect characters are removed and then typing the correct characters. If you do not
discover a mistake until later, you can use the following techniques to make the necessary
corrections to the data:
• To undo your most recent change, click the Undo button on the Quick Access
Toolbar. If there is nothing that Access can undo, this button will be dim, and
clicking it will have no effect.
• To add a record, click the New (blank) record button, shown in Figure 1–46 on the
previous page, and then add the record. Do not worry about it being in the correct
position in the table. Access will reposition the record based on the primary key, in this
case, the Client Number.
• To delete a record, click the Record selector, shown in Figure 1–46, for the record to
be deleted. Then press the DELETE key to delete the record, and click the Yes button
when Access asks you to verify that you do indeed wish to delete the record.
• To change the contents of one or more ﬁ elds in a record, the record must be on the
screen. If it is not, use any appropriate technique, such as the UP ARROW and DOWN
ARROW keys or the vertical scroll bar, to move to it. If the field you want to correct is
not visible on the screen, use the horizontal scroll bar along the bottom of the screen
to shift all the ﬁ elds until the one you want appears. If the value in the ﬁ eld is
currently highlighted, you can simply type the new value. If you would rather edit the existing
value, you must have an insertion point in the ﬁ eld. You can place the insertion point
by clicking in the ﬁ eld or by pressing F 2 . Once you have produced an insertion point,
you can use the arrow keys, the DELETE key, and the BACKSPACE key in making the
correction. You also can use the INSERT key to switch between Insert and Overtype mode.
When you have made the change, press the TAB key to move to the next ﬁ eld.
If you cannot determine how to correct the data, you may ﬁ nd that you are “stuck”
on the record. Access neither allows you to move to any other record until you have made
the correction, nor allows you to close the table. If you encounter this situation, simply
press the ESC key. Pressing the ESC key will remove from the screen the record you are
trying to add. You then can move to any other record, close the table, or take any other
action you desire.
Using the Ofﬁ ce
you can create entries
that will replace
spelled-out names and
For example, you can
create the abbreviated
entry dbms for database
management system .
Whenever you type dbms
followed by a space or
punctuation mark, Access
dbms with database
management system. To
specify AutoCorrect rules
and exceptions to the
rules, click Access Options
on the Ofﬁ ce Button
menu and then click
Prooﬁ ng in the Access
Options dialog box.
Not visible in the Access window, the AutoCorrect feature of Access works
behind the scenes, correcting common mistakes when you complete a text entry in a cell.
AutoCorrect makes three types of corrections for you:
1. Corrects two initial capital letters by changing the second letter to lowercase.
2. Capitalizes the ﬁ rst letter in the names of days.
3. Replaces commonly misspelled words with their correct spelling. For example,
it changes the misspelled word recieve to receive when you complete the entry.
AutoCorrect will correct the spelling automatically of more than 400 commonly