Microsoft Office Tutorials and References
In Depth Information
Creating a Simple Table
Getting Started with
Your First Database
Creating a Simple Table
When you first create a database, it’s almost empty. But in order to get you started,
Access creates your first database object—a table named Table1. The problem is, this
table begins life completely blank, with no defined fields (and no data).
If you followed the steps to create a new database described earlier, you’re already at
the Datasheet view (Figure 25-4), which is where you enter data into a table. All you
need to do is customize this table so that it meets your needs.
There are two ways to customize a table:
• Design view lets you precisely define all aspects of a table before you start using
it. Almost all database pros prefer Design view, and you’ll start using it in the
• Datasheet view is where you enter data into a table. Datasheet view also lets you
build a table on the fly as you insert new information. You’ll use this approach
in this chapter.
The following steps show you how to turn a blank new table (like Table1) into the
Dolls table using the Datasheet view:
In this case, that means choosing a bobblehead doll to add to the list. For this
example, you’ll use a nifty Homer Simpson replica.
Note: It doesn’t matter which doll you enter first. Access tables are unsorted, which means they have no
underlying order. However, you can sort them any way you want when you need to retrieve information
Up to speed
Putting Big Values in Narrow Columns
A single field can hold entire paragraphs of information.
But if you have lengthy values, you may find yourself
running out of viewing space while you’re typing them into a
narrow column. And although you’re free to scroll forward
and backward through your field, this gets annoying fast.
Most people prefer to see the entire contents of a column
a column named Field1, move your mouse to the right
edge of the Field1 box.) Then, drag the column to the right
to resize it as big as you want.
If you’re just a bit impatient, there’s a shortcut. Move the
mouse over the right edge of the column, so that it turns
into a two-way arrow. Then, double-click the column edge.
This resizes the column to fit its largest piece of information
(provided this doesn’t stretch the column beyond the edge
of the Access window).
Fortunately, you don’t need to suffer in silence with
cramped columns. To expand a column, just position your
mouse at the right edge of the column header. (To expand