Creating the AUTHORS Table
To create the AUTHORS table, follow the same basic steps listed in the previous Section 4.2. The field definitions for the AUTHORS table are shown in Table 4.4.
Table D-4. Fields of the AUTHORS Table
Field Name |
Data Type |
---|---|
AuID |
Text |
AuName |
Text |
AuPhone |
Text |
There is only a single property that you need to set:
Field Name: |
AuID |
---|---|
Property: |
Indexed |
Value: |
Yes (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 4.5.
Table D-5. Data for the AUTHORS Table
AuID |
AuName |
AuPhone |
---|---|---|
1 |
Austen |
111-111-1111 |
12 |
Grumpy |
321-321-0000 |
3 |
Homer |
333-333-3333 |
10 |
Jones |
123-333-3333 |
6 |
Joyce |
666-666-6666 |
2 |
Meville |
222-222-2222 |
8 |
Mill |
888-888-8888 |
4 |
Roman |
444-444-4444 |
5 |
Shakespeare |
555-555-5555 |
13 |
Sleepy |
321-321-1111 |
9 |
Smith |
123-222-2222 |
11 |
Snoopy |
321-321-2222 |
7 |
Spenser |
777-777-7777 |
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.