Microsoft Office Tutorials and References
In Depth Information
With Elsa’s design in place, you’re ready to create the new Northeast database and the
Creating a New Database
Access provides different ways for you to create a new database: you can use a Database
Wizard, create a blank database, copy an existing database file, or use one of the database
templates available on the Microsoft Web site. When you use a Database Wizard , the wizard
guides you through the database creation process and provides the necessary tables, forms,
and reports for the type of database you choose—all in one operation. Using a Database
Wizard is an easy way to start creating a database, but only if your data requirements closely
match one of the supplied templates. When you choose to create a blank database, you need
to add all the tables, forms, reports, and other objects after you create the database file.
Creating a blank database provides the most flexibility, allowing you to define objects in the
way that you want, but it does require that you define each object separately. Whichever
method you choose, you can always modify or add to your database after you create it.
The following steps outline the process for creating a new database using a
1. If necessary, click the New button on the Database toolbar to display the New File
2. In the Templates section of the task pane, click the “On my computer” option. The
Templates dialog box opens.
3. Click the Databases tab, and then choose the Database Wizard that most closely
matches the type of database you want to create. Click the OK button.
4. In the File New Database dialog box, choose the location in which to save the new
database, specify its name, and then click the Create button.
5. Complete each of the wizard dialog boxes, clicking the Next button to move through
them after making your selections.
6. Click the Finish button when you have completed all the wizard dialog boxes.
None of the Database Wizards matches the requirements of the new Northeast data-
base, so you’ll use the Blank Database option to create it.
To create the Northeast database:
1. Start Access, and make sure your Data Files are in the proper location.
2. In the Open section of the Getting Started task pane, click Create a new file . The New File
task pane is displayed.
3. Click Blank database . The File New Database dialog box opens. This dialog box is similar
to the Open dialog box.
4. Click the Save in list arrow, and then click the drive that contains your Data Files.
5. Navigate to the Brief\Tutorial folder, and then click the Open button.
6. In the File name text box, double-click the text db1 to select it, and then type Northeast .
Trouble? If your File name text box contains an entry other than “db1,” select whatever
text is in this text box, and continue with the steps.
7. Click the Create button. Access creates the Northeast database in the Brief\Tutorial folder
included with your Data Files, and then displays the Database window for the new database
with the Tables object selected.