Top Access Options

Access’ Options dialog box offers options to help you increase database effectiveness, in these categories:

• Current Database. This category (Figure A-6) offers settings for customizing the current database file, including entering an Application Title and selecting an Application icon. You can choose a Display Form, set up Navigation Options, and choose Ribbon and Toolbar Options for the finished database, among other choices.

  Figure A-6. Access’ Current Database options.

  [View full size image]

  

• Datasheet. This category offers formatting settings for any datasheet in Access. You can choose Default Colors for many items, change settings for Gridlines and Cell Effects, and change the Default Font settings.

• Object Designers. This category offers choices for controlling appearance and behavior when you’re using Table Design and Query Design views, as well as the design views for Forms/Reports. For example, you can choose a Default Field Type and Default Text Field Size for the Table Design view, or choose whether to Show Table Names in Query Design view. This category also has settings for controlling Error Checking.

• Proofing. As in the other apps, the settings here adjust AutoCorrect and spelling check.

• Advanced. This category offers a number of settings for Editing in tables, such as whether pressing an arrow key moves to the next field or the next character. You can specify margins for printing, or turn on such features as Open Last Used Database When Access Starts.