Question: what is the difference between table and query in ms access?
Answer: 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.