Microsoft Office Tutorials and References
In Depth Information
Getting Started with Your First Database
Getting Started with
Your First Database
Figure 25-2:
The File New
Database dialog box lets
you choose where
you’ll store a new
Access database file. It
also gives you the
option to create your
database in the format
used by older versions
of Access (.mdb),
instead of the more
modern format used
by Access 2010 and
Access 2007 (.accdb).
To do so, you need
to choose either the
2000 or 2002-2003
format options from
the “Save as type” list,
as shown here.
Up to speed
Templates: One Size Fits Some
The example in this section shows you how to create a
blank database. However, you’ve probably noticed a
number of other options in the Available Templates section in
the middle of the File➝New page. These options let you
browse dozens of prebuilt databases, which are known as
templates. Templates aim to save you the work of creating
a new database and let you jump straight to the fine-tuning
and data-entry stage.
of information you want to track, you might find that the
predefined structure isn’t quite right. For example, if you
choose to use the Home Inventory template to track all
the stuff in your basement, you might find that it’s
missing some information you want to use (like the projected
resale value of your stuff on eBay) and includes other
details you don’t care about (like the date you acquired each
item). To make this template work, you’ll need to change
the design of your table, which involves the same Access
know-how as creating one.
As you might expect, there’s a price to be paid for this
convenience. Even if you find a template that stores the type
Once you create or open a database, the Access window changes quite a bit. An
impressive-looking toolbar (the ribbon ) appears at the top of your screen, and a
navigation pane shows up on the left. You’re now in the control center where you’ll perform
all your database tasks (as shown in Figure 25-3).
Search JabSto ::

Custom Search