1 / 14

CPSC 203 Introduction to Computers

CPSC 203 Introduction to Computers. Lab 39, 40 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 database? Keep consistent information altogether

Download Presentation

CPSC 203 Introduction to Computers

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CPSC 203Introduction to Computers Lab 39, 40 By Jie (Jeff) Gao

  2. Introduction to Database • What is a database? • A database is a collection of information related to a particular subject or purpose. • Why database? • Keep consistent information altogether • Easy to manage and find useful information • Easy to manage related information CPSC 203 Labs by Jie Gao

  3. An Example CPSC 203 Labs by Jie Gao

  4. Terminology (1) Field Table Record CPSC 203 Labs by Jie Gao

  5. Terminology (2) • DBMS • Database Management System • Database Objects in Access • Table • Query • Form • Report • Pages …… CPSC 203 Labs by Jie Gao

  6. Plan for the Lab • First part • Basic operation in Access: create table, alter table, input data, append or insert data, sort records, forms, … • Second part • Advanced operation in Access: queries, reports, … • Assignment requirements CPSC 203 Labs by Jie Gao

  7. 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 Labs by Jie Gao

  8. 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 Labs by Jie Gao

  9. Edit Data • Input data in datasheet view • The format should conform to the mask • Move insert point among records using the navigator at the bottom of the datasheet view CPSC 203 Labs by Jie Gao

  10. A Little More Work • Sort • By a field • Ascending or descending CPSC 203 Labs by Jie Gao

  11. Forms in Access • A form in Access is used to provide a friendly interface to the user • 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 Labs by Jie Gao

  12. Create a Form • Two methods: Wizard or Design View • Form Wizard is easy to use. You can create a form for a table on the fly! • Design View can provide you more power. You can implement advanced features! CPSC 203 Labs by Jie Gao

  13. Form Wizard • Select • Which fields will appear in the formYou can select fields from multiple tables • Form type • Background • Name • You can click “Finish” when you accept the defaults for the following steps. CPSC 203 Labs by Jie Gao

  14. 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 Labs by Jie Gao

More Related