cpsc 203 introduction to computers
Download
Skip this Video
Download Presentation
CPSC 203 Introduction to Computers

Loading in 2 Seconds...

play fullscreen
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