Microsoft Office Tutorials and References
In Depth Information
Creating a Database
In this case, the templates provided do not match Oren’s needs for the Belmont
Landscapes database, so you need to create a new, blank database from scratch.
To create the new Belmont database:
1. Make sure you have created your copy of the Access starting Data Files, and that
your computer can access them.
Trouble? If you don’t have the starting Data Files, you need to get them before
you can proceed. Your instructor will either give you the Data Files or ask you to
obtain them from a specified location (such as a network drive). In either case,
make a backup copy of the Data Files before you start so that you will have
the original files available in case you need to start over. If you have any
questions about the Data Files, see your instructor or technical support person for
2. Make sure the New tab is selected in the navigation bar, and that the Blank
database option is selected (see Figure1-4).
3. In the File Name box on the right side of the screen, select the default name
provided by Access, and then type Belmont . Next you need to specify the location for
Be sure to type Belmont
or you’ll create a database
4. Click the Browse button
to the right of the File Name box. The File New
Database dialog box opens.
5. Navigate to the drive that contains your Data Files.
Trouble? If you do not know where your Data Files are located, consult with your
instructor about where to save your Data Files.
6. Navigate to the Access1\Tutorial folder. This is the folder in which you will store
the database file you create.
7. Make sure the “Save as type” box displays “Microsoft Access 2007 Databases.”
Trouble? If your computer is set up to show filename extensions, you will see the
Access filename extension “.accdb” in the Save as type box.
8. Click the OK button. You return to Backstage view, and the File Name box now
shows the name Belmont.accdb. The filename extension “.accdb” identifies the
file as an Access 2007 database.
If you don’t type the
filename extension, Access
adds it automatically.
9. Click the Create button. Access creates the new database, saves it to the
specified drive, and then opens an empty table named Table1.
Understanding the Database File Type
Access 2010 uses the .accdb file extension, which is the same file extension used for
databases created with Microsoft Access 2007. To ensure compatibility between
databases created with Access 2007 and Access 2010, new databases created using Access
2010 have the same file extension and file format as Access 2007 databases. This is why
the File New Database dialog box provides the Microsoft Access 2007 Databases option
in the “Save as type” box. In addition, the notation “(Access 2007)” appears in the title
bar next to the name of an open database in Access 2010.