Creating the PUBLISHERS Table
Once again, follow the same basic steps listed in the earlier section Section 4.2 to create the PUBLISHERS table. Field definitions for the PUBLISHERS table are shown in Table 4.6.
Table D-6. Fields of the PUBLISHERS Table
|
Field Name |
Data Type |
|---|---|
|
PubID |
Text |
|
PubName |
Text |
|
PubPhone |
Text |
Once again, there is only a single property that you need to set:
|
Field Name: |
PubID |
|---|---|
|
Property: |
Indexed |
|
Value: |
Yes (No Duplicates) |
Designate PubID as the primary key, and save the table as PUBLISHERS.
Once you’ve finished creating the PUBLISHERS table, you can enter data into it. The PUBLISHERS table contains records for only three publishers; these are shown in Table 4.7.
Table D-7. Data for the PUBLISHERS Table
|
PubID |
PubName |
PubPhone |
|---|---|---|
|
1 |
Big House |
123-456-7890 |
|
2 |
Alpha Press |
999-999-9999 |
|
3 |
Small House |
714-000-0000 |
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.
