Setting Special Options in Access

When you work in Access, you spend a lot of time in the Datasheet view, adding and manipulating records in a database table. Although forms can be used to handle some of the data entry and editing chores (as discussed in the Access section of this book [Part VI]), you still will work a great deal with table datasheets . Therefore, you might want to customize the Datasheet view to make it easier to work with and provide an environment that is a little easier on your eyes.

Follow these steps to customize Access options:

1. In Access, select Tools and then select Options . The Options dialog box opens.

2. Click the Datasheet tab on the Options dialog box (see Figure 6.7).

   Figure 6.7. You can edit the datasheet colors and other settings on the Datasheet tab.

   

3. Use the Font drop-down box to select a color for the font used in the Datasheet view.

4. The Background and Gridlines drop-down boxes can be used to adjust the colors of these items to complement the Font color you select.

5. If you want to change the Default Cell Effect, select either the Raised or Sunken option buttons .

6. You can also specify a wider default column width for your datasheets in the Default Column Width box.

7. When you have finished making your changes, click OK (or Cancel to discard any changes made).