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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access