Cpsc 203 introduction to computers
Download
1 / 10

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 81 Views
  • Uploaded on

CPSC 203 Introduction to Computers. Lab 39, 40 By Jie (Jeff) Gao. 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. Create a Query.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' CPSC 203 Introduction to Computers' - calla


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Cpsc 203 introduction to computers

CPSC 203Introduction to Computers

Lab 39, 40

By Jie (Jeff) Gao


Queries in access
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


Create a query
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


Query design view
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


Reports in access
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


Create a report
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


Using the report wizard
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


Using the report design view
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


Create a good report
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


Assignment 3
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


ad