• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 your database. Now you can group your tables, reports, and forms that are related to the same or similar category. Even though a field is a category, this is a category of a broader scope. Just as a field is a category of common values, an Access group is a category of common objects. For example, you can have all the reports related to invoices in one group, or all the tables related to projects in another group. You can mix and match tables, reports, forms, and modules into a group. You determine the commonality of the objects.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint