O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Database

There are many ways to create a new database file. You may have noticed the Blank Database button in the upper-left corner of the Office Online area in the main Access screen. This button and the Office Button New choice both reveal the Blank Database area in the right section of the main screen. Clicking either of these buttons transforms the main screen, as shown in Figure 34-3. The Blank Database area replaces the list of recently opened databases on the main screen.

Figure 34-3. Enter the name of the new database in the File Name box in the Blank Database area.

Enter the name of the new database in the File Name box in the Blank Database area. By default, Access creates the new database file in whichever Windows folder you most recently opened from within Access. If you want to use a different folder, use the folder icon to the right of the File Name box to browse to the location you want to use.

Access provides a default name of Database1.accdb for new databases. Be sure to provide a name that you’ll recognize. In Figure 34-4, the new database is named MyAccessAutoAuctions.accdb. (Entering the extension .accdb is optional because Access automatically supplies it if you do not.)

Figure 34-4. The new MyAccessAutoAuctions database is created.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required