Access Database Design and Programming, Second Edition

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