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

Loading in 2 Seconds...

play fullscreen
1 / 15

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 95 Views
  • Uploaded on

CPSC 203 Introduction to Computers. T43, T46 & T68 By Jie (Jeff) Gao. Introduction to Database. What is a database? A database is a collection of information related to a particular subject or purpose. Why should we use databases? Keep consistent information altogether

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


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

introduction to database
Introduction to Database
  • What is a database?
    • A database is a collection of information related to a particular subject or purpose.
  • Why should we use databases?
    • Keep consistent information altogether
    • Easy to manage and find useful information
    • Easy to manage related information

CPSC 203 Tutorials by Jie Gao

an example
An Example

CPSC 203 Tutorials by Jie Gao

terminology 1
Terminology (1)

Field

Table

Record

CPSC 203 Tutorials by Jie Gao

terminology 2
Terminology (2)
  • DBMS
    • Database Management System
  • Database Objects in Access
    • Table
    • Query
    • Form
    • Report
    • Pages

……

CPSC 203 Tutorials by Jie Gao

plan for the lab
Plan for the Lab
  • Today
    • Basic operation in Access: create table, alter table, input data, append or insert data, sort records, forms, …
  • Thursday
    • Advanced operation in Access: queries, reports, …
    • Assignment requirements

CPSC 203 Tutorials by Jie Gao

creating a table
Creating A Table
  • Design table structure
    • Add fields
    • Select data type for fields
    • Set input mask for fields
  • Set primary key
  • Give the table a name

CPSC 203 Tutorials by Jie Gao

alter a table
Alter A Table
  • Change in design view
    • Everything could be changed
  • If delete a field, the data in that field will be deleted

CPSC 203 Tutorials by Jie Gao

edit data
Edit Data
  • Input data in datasheet view
  • Move your cursor to different records using the navigator at the bottom of the datasheet view
  • Use Tab or Shift+Tab keys to move your cursor to the next or previous field

CPSC 203 Tutorials by Jie Gao

a little more work
A Little More Work
  • Sort
    • By a field
    • Ascending or descending
  • Data in a table is automatically saved; the layout of a table’s data view should be saved manually

CPSC 203 Tutorials by Jie Gao

forms in access
Forms in Access
  • A form in Access is used to provide a friendly interface to the user
    • With labels and input boxes to input and/or view data
  • The user can input data into a table through a form created on that table
  • The user can also navigate data by using the form

CPSC 203 Tutorials by Jie Gao

create a form
Create a Form
  • Two methods: Wizard or Design View
  • Form Wizard is easy to use. You can create a form for a table with simple steps
  • Design View can provide you more power. You can implement advanced features!

CPSC 203 Tutorials by Jie Gao

form wizard
Form Wizard
  • Select
    • Which fields will appear in the formYou can select fields from multiple tables
    • Form type (layout)
    • Style
    • Name
  • You can click “Finish” when you accept the defaults for the following steps.

CPSC 203 Tutorials by Jie Gao

form design view
Form Design View
  • You can
    • Add controls to the form
    • Drag fields into the form
    • Adjust the form layout
    • Add header or footer
    • Even do something like programming

CPSC 203 Tutorials by Jie Gao

assignment 3
Assignment 3
  • Start with a blank database
  • Create a table
  • Create a form on that table
  • Input data
  • Create reports
    • Create queries when necessary
  • Refer to the information on my web site

CPSC 203 Tutorials by Jie Gao

ad