Cpsc 203 introduction to computers
Download
1 / 9

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 79 Views
  • Uploaded on

CPSC 203 Introduction to Computers. T43, T46 & T68 By Jie (Jeff) Gao. What We Did in Week 1. Basic concept of database Tables, Fields, Records Microsoft Access Skills Tables (Create, Data types, Change, Enter data, …) Forms (Form Wizard) Queries (Query Design View, Complex criteria)

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' - stevie


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

T43, T46 & T68

By Jie (Jeff) Gao


What we did in week 1
What We Did in Week 1

  • Basic concept of database

    • Tables, Fields, Records

  • Microsoft Access Skills

    • Tables (Create, Data types, Change, Enter data, …)

    • Forms (Form Wizard)

    • Queries (Query Design View, Complex criteria)

    • Reports (Report Wizard)

CPSC 203 Tutorials by Jie Gao


Problems of report wizard
Problems of Report Wizard

  • Sometimes the fields in a report overlap

  • Cannot input period (“.”) into the title

  • What if I want to change the title/header/footer after running the wizard

  • The above can not be done by the wizard, but can be done in the design view

CPSC 203 Tutorials by Jie Gao


Report design view
Report Design View

  • Split into several parts

    • Report header/footer: appear once for the whole report

    • Page header/footer: appear once for each page

    • (Possibly) Group header/footer: appear once for each group (they corresponds to the grouping levels in the Wizard)

    • Detail: appear once for each record

  • The sizes of those areas affect the report appearance

CPSC 203 Tutorials by Jie Gao


Elements in the design view
Elements in the Design View

  • Labels: Static text on the report, e.g. the title, the headers

    • Click to change the text. Use format toolbar to change format (font, colour, …)

  • Textboxes: Dynamic text, e.g. the field content, formulas (sum, average, …)

  • Lines, pictures, …

  • Background

CPSC 203 Tutorials by Jie Gao


Tools in design view
Tools in Design View

  • Toolbox: Add new controls from toolbox

    • E.g. a new label for more text

  • Properties window: Adjust settings of controls

    • E.g. Currency style for a textbox

  • Sorting and Grouping: Change the way your report is sorted

CPSC 203 Tutorials 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 Tutorials by Jie Gao


Change of due time
Change of Due Time

  • From Assignment 3 and on, the due time is changed to 2:00 p.m. on due days

CPSC 203 Tutorials by Jie Gao


In assignment 3
In Assignment 3

  • You need apply various formatting options to your reports

  • Give good titles to your reports

    • Titles like “Report 1” are NOT good

  • You only need print reports to hand in

    • You do not need table and form print outs

CPSC 203 Tutorials by Jie Gao


ad