Reports: Getting started

1
Reports Getting started

• Reports in MS Access are a lot like forms
• Usually build a report on a query that selects
  and sorts your data
• Reports often have sub-reports (so that repeating
  data from related tables can be included)
• Basic interface for designing forms and reports
  is identical
• controls
• properties
• Autoreports and report wizards are useful

2
Reports and subreports

• Same general strategy as forms
• First draw the overall report on paper
• what data should be included and where will it
  go?
• Make the Parent report (probably in design mode)
• make the sub-report (if any)
• Edit the parent report to include the subreport
• Link them with the Field linker
• Adjust until you are satisfied
• Switch to preview constantly until you like the
  result

3
First make the main report
Does this look familiar? It should its just
like the interface for new forms.
4
Base the report on a query!
Here is the list of fields available in the
query
5
Need more fields? Redo the query!
I wanted to add title to my report
6
Create the subreport
produces
7
Link report and sub-report

• Note that I needed to edit the query to include
  the PersonID field -- otherwise this subform
  cannot work

8
Report Wizards

• A very useful tool
• Especially good for grouping data and presenting
  simple numerical summary statistics (sub-totals,
  average, etc.)
• Cant do subreports
• Feel free to experiment!