Query vs Report

  • Thread starter Thread starter Kris D
  • Start date Start date
K

Kris D

I am new to using Access 2007. I don't understand the difference between a
query and a report? Don't both a query and report pull information? When
would you need to create a query?

Thank you
 
A query retrieves data and can filter the data that is retreived.

A report (or a form) uses a query (or a table) as the source for its data.

Simplified explanation:
Tables: store data

Queries: select records and specific fields (and can combine data from
multiple tables)

Forms: display data using queries as a source and allow you to modify
the data and enter new records

Reports: print data using queries to select the information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
I am new to using Access 2007. I don't understand the difference between a
query and a report? Don't both a query and report pull information? When
would you need to create a query?

Thank you
Click to expand...

A Query looks, acts, and feels like a table: it pulls data from a table, lets
you select which fields and which records to include, and sorts it.

A Report (which will usually be based on a query, though it can be based on a
table) is a tool which arranges data on a page (or a virtual page onscreen) to
be printed. It does much more than a query (you can't have headers, titles,
footers, page numbers, labels, etc. etc. in a query). A Report is much more
like a Form than a query, the difference being that Forms are designed for
onscreen use and are "two way", both displaying data and accepting input, and
Reports are (up to 2007, and still in the main) "output only" tools.
 
Back
Top