
Since none of the fields we need for our Automobile database are
contained in any of the wizard tables, we will create a simple table
using the wizard that has nothing to do with our database. This section
is an exercise in explaining how the Wizard works.
The Wizard permits the fields of the table to come from more than one
suggested table. We will create a table with fields from three different
suggested tables in the Wizard.
Click
Use Wizard to Create Table
. This opens the Table Wizard.
Note
A field in a table is one bit of information. For example, in a
price list table, there might be one field for item name, one for
the description and a third for the price. More fields may be
added as needed.
Step 1: Select fields.
You have a choice of two categories of suggested tables: Business and
Personal. Each category contains its own suggested tables from which
to choose. Each table has a list of available fields. We will use the
CD-
Collection
Sample table in the Personal category to select the fields we
need.
1)
Category
:
Select
Personal
. The
Sample Tables
drop down list
changes to a list of personal sample tables.
2)
Sample Tables
: Select
CD-Collection
. The
Available
fields window
changes to a list of available fields for this table.
3)
Selected Fields
: Using the > button, move these fields from the
Available fields
window to the
Selected fields
window in this
order:
CollectionID, AlbumTitle, Artist, DatePurchased, Format,
Notes,
and
NumberofTracks.
4)
Selected Fields from another sample
table. Click Business as the
Category. Select
Employees
from the dropdown list of sample
tables. Use the > button to move the
Photo
field from the
Available fields
window to the
Selected fields
window. It will be at
the bottom of the list directly below the
NumberofTracks
field.
5) If a mistake is made in the order as listed above, click on the field
name that is in the wrong order to highlight it. Use the Up or
Down arrow on the right side of the
Selected Fields
list (see
Figure 177) to move the field name to the correct position. Click
Next.
Chapter 8 Getting Started with Base 243
Comentarios a estos manuales