Microsoft Office Tutorials and References
In Depth Information
Additional Microsoft Office Programs
To Create an Access Database
Unlike the other Ofi ce programs, Access saves a database when you i rst create it. When working in Access,
you will add data to an Access database. As you add data to a database, Access automatically saves your changes rather
than waiting until you manually save the database or quit Access. Recall that in Word and Excel, you entered the data
i rst and then saved it.
Because Access automatically saves the database as you add and change data, you do not have to always click
the Save button. In fact, the Save button in Access is used for saving the objects (including tables, queries, forms,
reports, and other database objects) a database contains. You can use either the Blank Database option or a template
to create a new database. If you already know the organization of your database, you would use the Blank Database
option. If not, you can use a template. Templates can guide you by suggesting some commonly used database
The following steps use the Blank Database option to create a database named Charmed Excursions in the
Access folder in the class folder (CIS 101, in this case) on a USB l ash drive.
If necessary, click the Blank database
button in the New gallery (shown
in Figure 74 on page OFF 53) in
the Backstage view to select the
in File Name
Browse for a
location to put
Click the File Name text box to select
the default database name.
in the File Name text box to enter
the new i le name. Do not press the
ENTER key after typing the i le name
because you do not want to create
the database at this time (Figure 76).
Why is the Backstage view automatically open when you start Access?
Unlike other Ofi ce programs, you i rst must save a database before adding any data. For this reason, the Backstage view
opens automatically when you start Access.
File New Database
Click the ‘Browse for a location to
put your database’ button to display
the File New Database dialog box.
Navigate to the location for the
database, that is, the USB l ash
drive, then to the folder identifying
your class (CIS 101, in this case), and
then to the Access folder (Figure 77).
For detailed steps about navigating,
see Steps 3a – 3c on pages OFF 28
and OFF 29.
i le name
displayed in File
name text box
Why does the ‘Save as type’ box say
Microsoft Access 2007 Databases?
Microsoft Access database formats
change with some new versions of
Microsoft Access. The most recent
format is the Microsoft Access
2007 Databases format, which was
released with Access 2007.