1 / 10

CPSC 203 Introduction to Computers

Learn how to create queries and reports in Microsoft Access using Query Design View and Report Design View. Discover the power of designing custom queries and reports to present data effectively. Assignment instructions included.

calla
Télécharger la présentation

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 Lab 39, 40 By Jie (Jeff) Gao

  2. Queries in Access • A query in Access is used to filter records and fields • Only the fields and records which match the query are returned • The data in a query’s view is from some table CPSC 203 Labs by Jie Gao

  3. Create a Query • Two ways: Wizard or Design View • Query Wizard can only create simple queries such as select part of the fields to display • Query Design View provides you the powerful interface to create various queries CPSC 203 Labs by Jie Gao

  4. Query Design View • Select tables which your query is from • Select fields or define new fields to display in the query • Set criteria • Use the expression builder • =, >, <, … • and, or, … CPSC 203 Labs by Jie Gao

  5. 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 Labs by Jie Gao

  6. 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 Labs by Jie Gao

  7. Using the Report Wizard • Select • Fields to appear in the report • How to group the records if you have multiple fields selected • How to order the records and summaries • Layout • Style • Name CPSC 203 Labs by Jie Gao

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

  9. 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 Labs by Jie Gao

  10. Assignment 3 • Create a blank table in suitable structure • Create a columnar form and enter data in it (given on the course website) • Create three reports • You may need to create some queries first to get the data which will appear in the reports • Use different fonts, size and underline to make your report better • Deliverable: the three reports • Remember your cover page CPSC 203 Labs by Jie Gao

More Related