Tables — a complete multi-table database

Summary

The basic structure of the book database is now complete; the tables have been built and the joins are in place between them. All it lacks is some data. Being the amiable types we are, you’ll find a file called chap16end.mdb containing a database of an identical structure to the one described in this chapter and, what’s more, it contains data. When you look at the table view of this data, you’ll see that expand buttons appear alongside records in the Category, Publisher and Author tables, placed there automatically by Access.