Microsoft Office Tutorials and References
In Depth Information
Understanding Tables
Getting Started with
Your First Database
Figure 25-3:
The navigation pane
on the left lets you
see different items
(or objects) in your
database. You can
use the navigation
pane to jump from
a list of products to
a list of customers
and back again. The
ribbon along the top
groups together every
Access command.
This ribbon is the
control center that lets
you perform various
tasks with your
database. The document
window in the middle
takes up the rest of
the window. This
window is where you’ll
do your work, such as
designing tables and
entering data.
The ribbon
The
navigation
pane
The document window
Now it’s time to consider how you can make use of your brand-new, empty database
by adding a table.
Understanding Tables
Tables are information containers. Every database needs at least one table—without
it, you can’t store any data. In a simple database, like the Bobblehead database, a
single table (which we’ll call Dolls) is enough. But if you find yourself wanting to
store several lists of related information, then you need more than one table. In the
database BigBudgetWedding.accdb, you might want to keep track of the guests that
you invited to your wedding, the gifts that you requested, and the loot that you
actually received. Figure 25-4 shows a sample table.
Before you start designing this table, you need to know some very basic rules:
A table is a group of records A record is a collection of information about .
a single thing. In the Dolls table, for example, each record represents a single
bobblehead doll. In a Family table, each record would represent a single
relative. In a Products table, each record would represent an item that’s for sale. You
get the idea. When you create a new database, Access starts you out with a new
table named Table1, although you can choose a more distinctive name when
you decide to save it.
 
Search JabSto ::




Custom Search