1 / 7

CPSC 203 Introduction to Computers

CPSC 203 Introduction to Computers. T59 & T64 By Jie (Jeff) Gao. Reports in Access. A report is an object in Access used to present data in a printed format Data presented in a report is more understandable than the original data in tables

nantai
Download Presentation

CPSC 203 Introduction to Computers

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. CPSC 203Introduction to Computers T59 & T64 By Jie (Jeff) Gao

  2. Reports in Access • A report is an object in Access used to present data in a printed format • Data presented in a report is more understandable than the original data in tables • You have control over the size and appearance of everything included in a report CPSC 203 Tutorial by Jie Gao

  3. Create a Report • Two ways in Access:Wizard or Design view • It is easy to create a report in wizard, but only some predefined format • Design view is more powerful, you can design the report style by yourself CPSC 203 Tutorial by Jie Gao

  4. Using the Report Wizard • Select • Tables (queries) and their fields to appear in the report • How to group the records if you have multiple fields selected (e.g. put all CPSC courses together) • How to order the records, and summaries for some fields • Layout • Style • Name (also the title in your report) CPSC 203 Tutorial by Jie Gao

  5. Using the Report Design View • Advanced skill • Add fields on it • Decide how to group • Design headers and footers (report, page, group) • Set font and size • Background and colors • …… CPSC 203 Tutorial by Jie Gao

  6. Create a Good Report • Maybe a good way: • First create in wizard • Then modify in design view • Provide sufficient descriptions for the report • Title • Date • Description and comments CPSC 203 Tutorial by Jie Gao

  7. Assignment 3 • The three reports: • All fields and records in a report: you can create this directly from your data table • Employees who started after 01/01/94: you need a query to get the employee records, then create a report from the query • Employees who started after 01/01/94 and have a wage rate of more than 7: similar to 2, you need a query first • Pay attention to the ordering requirements (ascending, descending) • “After” and “More than” mean “>” CPSC 203 Tutorial by Jie Gao

More Related