Flylib.com

Books Software

 
 
 

Opening a Database

Team-Fly    

 
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 3.  Creating a New Database

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.

Tip

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.


Team-Fly    
Top
 
Team-Fly    

  
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents


Lesson 4. Creating a Table with the Table Wizard

In this lesson, you learn how to create a table by using the Table Wizard.


Team-Fly    
Top
 

Team-Fly    

 
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 4.  Creating a Table with the Table Wizard

Tables Are Essential

As discussed in Lesson 1, your tables really provide the essential framework for your database. Tables not only hold the data that you enter into the database, but they are designed so that relationships can be established between the various tables in the database. Tables can be created from scratch, as discussed in the next lesson, or they can be created using the Table Wizard.


Team-Fly    
Top