Select settings for how data is displayed and stored in your database

You can set general options for all future Access databases by selecting options from the General category in the Access Options dialog box. For example, general options can be used to specify how some user interfaces are displayed to users or, which default file format is used, or where database folders are located in the database user's computer.

Note: Setting changes made from the General category may apply not to just to Microsoft Access 2010, but also to other Microsoft Office 2010 programs that you might have installed.

Access Options dialog box displaying the General category  for global setting options

What do you want to do?

Set display options

Set default format and location for new database files

Personalize your copy of Microsoft Office

Set display options

Click Options under Access, and then make your display option changes.

  • When the Enable Live Preview option is selected, you can preview of how a feature affects the document as you hover over different choices.

  • Keep the Always use ClearType selected to have text displayed in a font type that is easy to read. If you clear this option, you must restart Access 2010 for the new setting to take effect.

    Note: The ClearType setting will be applied also to other Office programs that you might have installed.

You can point to a command or option on the ribbon to see a screen tip about the purpose of the button and any available keyboard shortcuts for that option. To hide the screen tips, select a ScreenTip scheme that meets your needs, from the ScreenTip style options:

  • Show feature descriptions in ScreenTips when selected, shows description of the button or option in the ribbon if you hover over the option.

  • Don't show feature descriptions in ScreenTips when this option is selected, you can see the name of the option or feature but not the description.

  • Don't show Screen Tips when selected, does not display the name or description of buttons or options on the ribbon if you hover over the button or option.

  • Color scheme select either the blue, silver, or black color scheme for your Access databases.

Top of Page

Set default format and location for new database files

Once you set the following options any newly created database will follow the default options. Select a version of Access for new databases, a specific location in your hard drive for the new database folders, and a custom sorting order.

  • Use the Default file format to set or change the file format that Access uses whenever you create a new database. If your database is shared by multiple users, consider the version of Access that is available on the other users' computers so that they can access all the features in your database.

    Note: You must close and reopen the current database for the specified option to take effect.

  • To set or change the default folder for storing new databases and files, in the Default database folder text box, type the folder name or click Browse to locate the folder.

  • Select New database sort order to change the default alphabetical sort order. The default option is set to General. To reset the sort order for an existing database, select the language you want to use and then run a compact operation on the database. You must close and reopen the current database for the specified option to take effect.

Top of Page

Personalize your copy of Microsoft Office

  • Type your name, or the name of another user in the User name text box.

  • Type your initials, or the initials of another user in the Initials text box.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×