what is the difference between queries and tables?
Here a summary of the differences between queries and tables… Data is not physically stored in a query whereas a table is the physical data archive. ... In a query, you can bring fields from more than one table together for a query linking them into a relationship and therefore create more flexible reports.