Cpsc 203 introduction to computers
Download
1 / 15

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 94 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