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
You should read it
- MS Access - Lesson 5: Create a table
- MS Access 2003 - Lesson 7: Enter information for the table
- MS Access 2003 - Lesson 8: Change information in the table
- MS Access 2007 - Lesson 1: Get started with Microsoft Access 2007
- Create Table (Table) in Access 2016
- MS Access 2003 - Lesson 27: Printing information for objects
- MS Access 2007 - Lesson 12: Design Forms
- MS PowerPoint 2007 - Lesson 2: Customize PowerPoint
- MS Word - Lesson 1: Start with Microsoft Word 2007
- Customize keyboard shortcuts in Word 2007
- MS Access 2003 - Lesson 16: Check your presentation
- MS Excel 2007 - Lesson 1: Start Microsoft Excel 2007