1 / 8

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

kiml
Download Presentation

Reports: Getting started

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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 Reports: Getting started

  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… it’s 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.) • Can’t do subreports • Feel free to experiment!

More Related