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.

In Microsoft Access, a Query can answer a simple question, merge data from different tables, perform calculations, add, change, and delete data from the database.