The Table Is the Center

Returning to our original proposition, why is the table the heart of the database? Simply put, the table is the center of everything in the database. Queries, forms, reports, macros, and modules all revolve around the table. Just as a table should be about one subject, a database should be about one theme. For example, within a client database, you might have an Employees table that shows you which employees work with which clients. But you might also include a Projects table. The theme is clients, but there might be many aspects of that theme. Or you can look at it as the database being about one main topic and the tables contained therein being about subtopics.

Access has added another tool to help you further delineate ...

Get Access 2002 Programming by Example 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.