MS Access - Lesson 2: Customize Access

TipsMake.com - Access 2007 provides a wide range of customizable options that allow you to work with Access better . To access these options:

- Click Office Button

- Select Access Options

MS Access - Lesson 2: Customize Access Picture 1 Figure 1: Select Access Options

Popular

These features allow you to define the working environment with the use of ScreenTips, the location and file format for databases, and usernames.

MS Access - Lesson 2: Customize Access Picture 2 Figure 2: Setting Popular features

Current Database

This feature allows you to set options for Application, Navigation, Ribbon and Toolbars, AutoCorrect, and Filters.

MS Access - Lesson 2: Customize Access Picture 3 Figure 3: Setting the Current Database feature

Datasheet

This feature allows you to specify individual options in datasheet mode, including Default colors, Gridlines and cell effects and Default font.

MS Access - Lesson 2: Customize Access Picture 4 Figure 4: Setting up the Datasheet feature

Object Designers

This feature allows you to customize options for creating and editing database objects in Access including Table Design, Query Design, Forms / Reports, and Error Checking.

MS Access - Lesson 2: Customize Access Picture 5 Figure 5: Setting up the Object Designers feature

Proofing

This feature allows you to change how Access automatically adjusts and formats the contents of the database and how it detects errors.

MS Access - Lesson 2: Customize Access Picture 6 Figure 6: Set up Proofing feature

Advanced

This feature allows you to customize advanced levels in Access, including Editing, Display, Printing and other advanced options.

MS Access - Lesson 2: Customize Access Picture 7 Figure 7: Setting up the Advanced feature

Customize

Customize allows you to add features to the Quick Access Toolbar. If there is a tool that allows you to use it regularly, you may want to add them to the Quick Access Toolbar.

MS Access - Lesson 2: Customize Access Picture 8 Figure 8: Customize feature settings