CS224 Chapter 7 Notes: Reports and Labels

• ❑ Creating a Report: Some Preliminary Activities
  • ❑ Before you create a report, you must know what its output is expected to look like. So, you need to first define the output format.
  • ❑ Your format can be sketched out with pencil and paper.
  • ❑ The Query behind the Report
    • ❑ First make sure the query for our report exists.
    • ❑ Query structure in Fig. 7.2, pg. 275
    • ❑ (Create this query before proceeding)
    • ❑ Create the new Report - pgs. 275-276
  • ❑ Modifying the Report Structure
    • ❑ First note what changes need to be made before beginning the modification process. (Your design notes will help here.)
    • ❑ Make the changes - pgs. 277-279
  • ❑ Creating Detail Line Headers (Subheaders) - pgs. 279-280
• ❑ Creating a Report with Subtotals and Totals
  • ❑ One advantage of reports is that they can provide activity summaries.
  • ❑ Creating a sales report - pgs. 281-282
  • ❑ Creating the Basic Report Structure with the Report Wizard - pgs. 282-288
• ❑ Reports Based on Crosstab Queries
  • ❑ Crosstab queries provide useful summary results. But you're limited in what results you can show if you just use the query.
  • ❑ A report can overcome this by using the crosstab query as the data source.
  • ❑ Create Crosstab query report - pgs. 289-291
• ❑ Using Report Graphics
  • ❑ Access makes it easy to add graphics like charts to a report. All you need is a data source and the Access Chart Wizard.
  • ❑ The Chart Wizard works best with a Select query.
  • ❑ Creating the report chart - pgs. 291-296
  • ❑ Editing the Report Graphics
    • ❑ You can return the report to its design view to drag the chart object's limits to line them up with the rest of the report output. You can also edit the chart object by clicking on it and then clicking on the right mouse button to select Chart Object to produce the Edit menu.
    • ❑ Edit the Chart object - pgs. 296-298
• ❑ Mailing Labels
  • ❑ Mailing labels are very handy and taken for granted but many business activities require frequent use of mailing labels.
  • ❑ Access has a special wizard for mailing labels. It's contained within the Report segment of the Access database application development software.
  • ❑ Create the mailing label report - pgs. 298-301
  • ❑ Modifying the Label Output Format
    • ❑ Before you modify the mailing label report, think about how you want the fields to be spaced.
    • ❑ Begin by sketching the layout of a sample label that meets your requirements.
    • ❑ Modify the label report - pgs. 302-304
• ❑ Form Letters - pgs. 305-308