Change Access 2007 database options for your application

by Mary Ann Richardson | Jun 26, 2007 12:00:00 AM

Tags: Mary Ann Richardson, Microsoft Office, Microsoft Access, databases, desktops, Office Suites, Software, Enterprise Software, Data Management

Takeaway: Make your Access 2007 databases more descriptive with custom titles in the title bar. Here's how to change database options in Access 2007.

Before putting your Access 2007 application into production, you should make some changes to what appears in the Access window. For example, instead of displaying PersonnelDB in the title bar, you may want to change it to Employee Records. Also, you may want the correct form to display when users open the application. If users only work with this one form, you may want to hide the navigation pane, which will prevent them from making any changes to the forms design or layout. Follow these steps:

1. Click the Office button.
2. Click the Access Options button.
3. In the left pane, click Current Database.
4. Click in the Application Title text box and enter Employee Records.
5. Click the Display Form drop-down list and select the form you want to display on startup.
6. Clear the Enable Layout View for this database check box.
7. Clear Enable Design Changes for tables in Datasheet View for this database) check box.
8. Clear the Display Navigation Pane check box.
9. Click OK.

You will need to close and reopen the database for the changes to take effect.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Print/View all Posts Comments on this article

OK So now, how do I undo thistrschaefer@...  | 03/20/08