Access Database Design and Programming, Second Edition

Creating the BOOK/AUTHOR Table

The BOOK/AUTHOR table is the final table needed for our examples. Once again, create it following the same basic steps described earlier in Section 4.2. It consists of only two fields, as shown in Table 4.8. Once you’ve entered the field names and data types into the table definition, change the two properties listed in Table 4.9 and save the table as BOOK/AUTHOR. When you save the table, Access will open the dialog shown in Figure 4.4. The table in fact does not have a primary key, so click on the No button; Access will save the table without designating a primary key.

Table D-8. Fields of the BOOK/AUTHOR Table

Field Name	Data Type
ISBN	text
AuID	text

Table D-9. Nondefault Properties of the BOOK/AUTHOR Table

Field Name	Property	Value
ISBN	Indexed	Yes (Duplicates OK)
AuID	Indexed	Yes (Duplicates OK)

Figure D-4. The “no primary key” warning dialog

Once you’ve created the BOOK/AUTHOR table, you can enter the data shown in Table 4.10 into it.

Table D-10. Data for the BOOK/AUTHOR Table

ISBN	AuID
0-103-45678-9	3
0-11-345678-9	2
0-12-333433-3	8
0-12-345678-9	1
0-123-45678-0	6
0-321-32132-1	11
0-321-32132-1	12
0-321-32132-1	13
0-55-123456-9	9
0-55-123456-9	10
0-555-55555-9	5
0-91-045678-5	5
0-91-335678-7	7
0-99-777777-7	5
0-99-999999-9	1
1-1111-1111-1	4
1-22-233700-0	4

Once you’ve finished this data entry, you’ll ...