1 / 8

CPSC 203 Introduction to Computers

This tutorial provides an overview of database concepts essential for CPSC 203, focusing on the structure of databases and Microsoft Access functionalities. Learn about tables, fields, and records, and understand the importance of defining data types explicitly. Explore how to create and manage tables, set primary keys, and establish relationships between data to maintain consistency. Important tips for safely handling Access databases from WebDisk and best practices for data management are also highlighted.

alaric
Télécharger la présentation

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 Tutorial 03 & 29 By Jie (Jeff) Gao

  2. Database Concept • A collection of information related to a particular subject or purpose • Database structure: • Database • Tables • Fields • Fields have data types • Should be explicitly defined, not like Excel CPSC 203 Tutorials by Jie Gao

  3. Records • Information in databases are stored as records • A “row” in a table • Containing values for each field • Databases store records without considering their orders • The unit of many operations CPSC 203 Tutorials by Jie Gao

  4. DBMS • Database Management System • Microsoft Access is a DBMS in Office CPSC 203 Tutorials by Jie Gao

  5. Access – Introduction • A component in Office • You need to save an Access database first (unlike other Office documents) • Objects in an Access database • Tables • Forms • Queries • Reports • … CPSC 203 Tutorials by Jie Gao

  6. ATTENTION – WebDisk and Access • DO NOT open an Access database directly from WebDisk • Otherwise you will probably lose your data • Once this happens, you have no way to get data back. No kidding! • ALWAYS copy Access databases from WebDisk to the Desktop or “My Documents”, then open it • Remember to copy the updated database back to the WebDisk CPSC 203 Tutorials by Jie Gao

  7. Access – Creating Tables • Use the table design view to define tables • Give names to each field, and define data types for them • Field options • Required / Index / Size / … • Primary Key • The unique identifier for a record • Save and give a table name CPSC 203 Tutorials by Jie Gao

  8. Access – Relationships • Relationships help keep the data consistent • Different types of relationships • One-to-One • One-to-Many • Many-to-Many • Creating a relationship • Menu Tools  Relationships CPSC 203 Tutorials by Jie Gao

More Related