Cpsc 203 introduction to computers
Download
1 / 4

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

CPSC 203 Introduction to Computers. Lab 39, 40 By Jie (Jeff) Gao. Midterm Exam. Date and time: March 3, Wednesday 6:00 PM Location: Science Theatre 140 & 148 Duration: 1 hour Type: Multiple choice Please prepare pencils and erasers No electronic devices allowed. Table Design.

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


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


Midterm exam
Midterm Exam

  • Date and time:

    • March 3, Wednesday

    • 6:00 PM

  • Location: Science Theatre 140 & 148

  • Duration: 1 hour

  • Type: Multiple choice

  • Please prepare pencils and erasers

  • No electronic devices allowed

CPSC Labs by Jie Gao


Table design
Table Design

  • Data type options

    • Field size

    • Format

    • Decimal places

    • Required

  • Some data types in detail

    • AutoNumber

    • Number

    • Date/Time

CPSC Labs by Jie Gao


Primary key
Primary Key

  • A field in a table

  • Its value can uniquely identify each record, i.e. no two records have the same value in this field

  • It is often the field like “ID”

  • We can define a primary key in the design view

  • Access can automatically add a primary key in AutoNumber type

CPSC Labs by Jie Gao


ad