Flylib.com

Books Software

 
 
 

Selecting a Database File Type

Team-Fly    

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

Selecting a Database File Type

One thing to discuss before you look at creating a new database is the database file format. By default, new databases created in Access 2002 are created in the Access 2000 file format. This makes your database files compatible with earlier versions of Access, such as Access 2000 and Access 97.

Saving the database in the Access 2000 file format does not negate you from using any of the tools or features available in Access 2002. If you use your database files only in Access 2002 and share the databases with co-workers who also use Access 2002, you can set the default file format for new databases to Access 2002. Select the Tools menu, and then select Options. The Options dialog box opens.

Select the Advanced tab on the Options dialog box. Click the Default File Format drop-down box and select Access 2002. Now take a look at creating new databases.


Team-Fly    
Top
 
Team-Fly    

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

Creating a Blank Database

Creating a blank database is very straightforward. As mentioned previously, you are just creating the container file that holds all the objects that actually make up the database. To create a blan database, follow these steps:

  1. Open the Access window (click Start, Programs, Access ).

  2. Select Blank Database in the task paneor click the New button on the Database toolbar. The File New Database dialog box appears (see Figure 3.1).

    Figure 3.1. Provide a location and a name for the new database file.

  3. Use the Save In drop-down box to locate the folder in which you want to save the new database. Type a name for the new file into the File Name text box.

  4. When you are ready to create the database file, click Create. The new database window appears in the Access workspace (see Figure 3.2).

Figure 3.2. A new database window opens in Access.

The database window provides you with a set of icons that allows you to select a particular object type. For example, the Tables icon is selected by default after you create the new database (which makes sense, because you need to create at least one table before you can create any of the other object types such as a form or a report).

Shortcuts for different methods of creating tables are provided at the top of the Object pane on the right side of the database window. After you create a new table for the database, it is listed in this pane. In Lesson 4, "Creating a Table with the Table Wizard," and Lesson 5, "Creating a Table from Scratch," you take a look at creating tables.

The database window enables you to view the different objects that you've created for a particular database (or those that have been created when you use the Database Wizard). When you want to switch the database window's focus to a different Access object, all you have to do is click the appropriate icon in the Objects list.

Tip

Different Ways to View the Database Windows The toolbar on the database window provides buttons for opening or creating a particular database object, such as a table or a form. The toolbar also provides buttons that can be used to change the view in the Object pane: Large Icons, Small Icons, List (the default view) and Details (which provides information such as when the object was last modified).



Team-Fly    
Top