• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Opening a Database

You have already taken a look at how to close a database; next, you walk through the process of opening a database file. The next time you start Access or after you finish working with another database, you need to know how to open your other database files.

One of the easiest ways to open a database you've recently used is to select it from the File menu. Follow these steps:

  1. Open the File menu. You'll see up to four databases that you've recently used listed at the bottom of the menu.

  2. If the database you need is listed there, click it.


Want to See More Files? To increase the number of files displayed in this list, open the Tools menu and select Options. Then, from the General tab of the Options dialog box, select a number from 1 to 9 (the default is 4) in the Recently Used Files drop-down list.

A list of recently used databases also appears on the tip of the Access task pane. You can open any of the files by clicking the filename (to open the task pane, select View, Toolbars, Task Pane).

If a file you want to open is not listed either on the File menu or the task pane, you can open it using the Open command. Follow these steps:

  1. Select File, Open, or click the toolbar's Open button. The Open dialog box appears (see Figure 3.7).

    Figure 3.7. Use the Open dialog box to locate a database file you want to open.

  2. If the file isn't in the currently displayed folder, use the Look In drop-down list to access the correct drive, and then double- click folders displayed in the dialog box to locate the file.

  3. When you have located the database file, double-click the file to open it.

In this lesson, you learned how to create a database from scratch and how to create a database from a template. You also learned how to close and open a database. In the next lesson, you learn how to create a table using the Table Wizard.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint