Reduce mouse clicks with these two Access options

If you write macros or in general work a lot in Access, Mary Ann Richardson has tips for you to reduce your efforts clicking the mouse while completing everyday tasks.

If you are a heavy Access user, you probably find yourself doing an inordinate amount of mouse clicking as you navigate through the Word 2002/2003 database window. You can save yourself some time by activating the single-click database window option. Follow these steps:

  1. Go to Tools | Options.
  2. Click the Advanced tab.
  3. In the View section, click to select the Single-Click Open check box, then click OK.

All objects in the database window are now underlined, indicating that you only need to click them once to open them.

For those of you who write many macros, Access provides another timesaving option. In order to display the Names and Conditions columns in the Macro window, you first have to click the Names And Conditions button in the Macro toolbar. You can save time by having those columns display when the window opens. Follow these steps:

  1. Go to Tools | Options.
  2. In the View section, click to select the Names And Conditions column in the Macro check box, then click OK.
Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.