Databases Reference
In-Depth Information
AuName
Text
A
uPhone
Text
There is only a single property that you need to set, as shown in Table D-5.
Table D-5. Single p
r
operty to be set in the AUTHORS table
Field Name:
AuID
Property:
Indexed
V
alue:
Y
es (No Duplicates)
When you've finished creating the fields and assigning their attributes, define AuID as
the table's primary key. Then save the table, assigning it the name AUTHORS.
Next, enter the author data into the table; it is shown in Table D-6.
Table D-6. Data for the AU
T
HORS table
AuID
AuName
AuPhone
1
Austen
1
11-111-1111
1
2
Grumpy
3
21-321-0000
3
Homer
3
33-333-3333
1
0
Jones
1
23-333-3333
6
Joyce
6
66-666-6666
2
Meville
2
22-222-2222
8
Mill
8
88-888-8888
4
Roman
4
44-444-4444
5
Shakespeare
5
55-555-5555
1
3
Sleepy
3
21-321-1111
9
Smith
1
23-222-2222
1
1
Snoopy
3
21-321-2222
7
Spenser
7
77-777-7777
D.4 Creating the PUBLISHERS Table
Once again, follow the same basic steps listed in Section D.2 to create the PUBLISHERS
table. Field definitions for the PUBLISHERS table are shown in Table D-7.
Table D-7. Fields of the
PUBLISHERS table
Field Name
Data Type
PubID
Text
P
ubName
Text
P
ubPhone
Text
Once again, there is only a single property that you need to set, as shown in Table D-8.
