Microsoft Office Tutorials and References
In Depth Information
Creating a Simple Table
Getting Started with
Your First Database
Based on the simple analysis you performed earlier (see the box on page 693),
you know that you need to enter four fields of information for every doll. For
the Homer Simpson doll, this information is “Homer Simpson” (the name),
“Fictional Industries” (the manufacturer), “$7.99” (the price), and today’s date
(the purchase date). Although you could start with any field, it makes sense to
begin with the name, which is clearly an identifying detail.
Start entering info here. . .
. . .then enter the next piece of info here
To fill in your first
record, start by
in the first field of
information (like the
doll name “Homer
press Tab to jump to
the second column,
and enter the second
piece of information.
Ignore the ID column
for now—Access adds
that to every table to
identify your rows.
Repeat steps 2 and 3 until you’ve added every field you need, being careful to
put each separate piece of information into a different column.
If you want to get a little fancier, include the currency symbol ($) when you
enter the price, and make sure you put the date in a recognized date format (like
January 1, 2010 or 01-01-2010 ). These clues tell Access what type of
information you’re putting in the column. (In the next chapter, you’ll learn how to take
complete control of the type of data in each column and how to avoid possible
misunderstandings.) Figure 25-6 shows the finalized record.
Note: If you press Tab without entering any information, you’ll move to the next row and start inserting a
new record. If you make a mistake, you can backtrack using the arrow keys.
4. It’s time to fixyourcolumnnames.Double-click the firstcolumn title (like
The field name switches into Edit mode.