Microsoft Office Tutorials and References
In Depth Information
To modify the PEJuly1Positions query and use the multiple undo feature:
1. Open the PEJuly1Positions query in Design view.
2. Select the StartDate Criteria value, #7/1/2006# , and then press the Delete key. The
StartDate Criteria text box is now empty.
3. Press the Tab key four times to move to and select "PE" , the StateProv Criteria value, and
then press the Delete key.
4. Run the query. Notice that the results display all records for the fields specified in the
query design grid.
5. Click the View button for Design view
on the Query Datasheet toolbar to switch back to
Now you will use multiple undo to reverse the edits you made and reinsert the two conditions.
6. Click the list arrow for the Undo button on the Query Design toolbar. A menu appears
listing the actions you can undo. See Figure 3-29.
Using multiple undo
list of actions
you can undo
Two items, both named “Cell Edit,” are listed in the Undo list box. These items represent
the two changes you made to the query design—first deleting the StartDate condition and
then deleting the StateProv condition. If you select an action that is below other items in the
list, you will undo all the actions above the one you select, in addition to the one you select.
Currently no actions are selected, so the list box indicates “Undo 0 actions.”
7. Position the pointer over the second occurrence of Cell Edit in the list. Notice that both
undo actions are highlighted, and the list box indicates that you can undo two actions.
8. Click the second occurrence of Cell Edit . Both actions are “undone,” and the two condi-
tions are redisplayed in the query design grid. The multiple undo feature makes it easy for
you to test different criteria for a query and, when necessary, to undo your actions based
on the query results.
Notice that the Redo button and list arrow are now available. You can redo the actions
you’ve just undone.
9. Click the list arrow for the Redo button on the Query Design toolbar. The Redo list
box indicates that you can redo the two cell edits.
10. Click the list arrow for the Redo button
again to close the Redo list box without
selecting any option.
11. Close the query. Click the No button in the message box that opens, asking if you want to
save your changes. You return to the Database window.