How to create Tables with Table Designer in Access You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns.

Tables: Access stores its data in tables. You can build a single database that includes all the data for the entire project — this is often called a "flat" database.

Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.