A Query is a tool that retrieves data from a single table or multiple tables; it is the most powerful tool to analyze your data in Microsoft Access ... Below the field row is the Table row.

A table in Access is a subject-based list of rows and columns. Each row in a table is called a record while every column is called a field. There can be no two fields having the same name.