Microsoft Office Tutorials and References
In Depth Information
Creating a New Database
Creating a New Database
As you’ve seen in the previous section,
you can use one of the Access template
databases. If it meets your needs, you can
simply start entering your records. You can also
customize the database if you find there is a field
you need that isn’t in there or perhaps a number
of fields you don’t want. Chapter 19, “Modifying an
Access Database,” will show you how to modify a
database, whether it’s one you’ve opened from a
template, or one you created yourself.
And now that you’ve seen what a database looks
like, it’s time to create your own. Follow these steps:
Figure 18-8
A new blank database.
Open Access. If you have Access already
open, click the File tab and choose New.
Creating a Table
The first thing you must decide when you create a
database is what kind of information you want to
track. Are you creating a database of your DVDs? If
so, you’ll want fields such as Movie Name, Date,
Genre, and perhaps Rating. If you are creating an
address list, you’ll probably want at least a Name,
Address, City, State, Zip, and several Phone Number
fields. And if you’re creating a database of items in
your home, you might want a Description,
Location, Purchase Date, Purchase Price, and
maybe even a Photo field.
2. From the Available Templates category, click
Blank Database.
3. On the right side of the screen, enter a name
for your database. If you don’t give it a name,
Access automatically creates it with the name
Database1, Database2, and so forth.
4. Click the Create button. The Navigation Pane
and a blank datasheet table appears. See
Figure 18-8.
When you’re planning which fields you want to
include, here are a few guidelines to assist you:
Search JabSto ::

Custom Search