1 / 17

IEOR 115 Industrial and Commercial Data Systems

Learn database creation and management using MS Access. Understand relational databases and their implementation in Access. Lab sessions cover tables, queries, forms, and reports. Deadline for quizzes is on Friday, September 13th.

eloisel
Download Presentation

IEOR 115 Industrial and Commercial Data Systems

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. IEOR 115Industrial and Commercial Data Systems Fall 2013, Lab 1 Animesh Garg PhD Student, IEOR

  2. Intro to MS Access • Database creation and management program • We will learn • Relational Databases • Implementation in MS Access

  3. Access to MS Access • Install on Personal Laptops • WindowsGet from UC Berkeley Software Centralhttp://ist.berkeley.edu/MS-DL-instructions • Mac / *nixBootcamp / Parallels / VM • Use Lab Machines- Guest AccountsUserID: !ieor-e10-15, Pwd: zxc!@#123 • Still Facing problems? Meet me in OH

  4. What are Databases • Collection of Correlated Lists/Tables

  5. What are Databases

  6. Why Database? Why not Excel? • Excel: Good for numerical analysis • No way of capturing Correlation • DB Maintenance is a problem? • Hence we need, Relational Databaseto create, maintain,search and analyzedata in multiple tablesat once

  7. Main Features of Access • Tables • Queries • Forms • Reports

  8. Tables

  9. Tables • Data is stored as Rows and Columns

  10. Tables • Columns = FieldsFields organizes data by Type • Rows = RecordsRecord is Unit of information: Tuple

  11. Forms

  12. Queries • Analyze data

  13. Reports • Present data

  14. Case Study: Library Management

  15. Terminology Relationship View is NOT the same as ER Diagram from lectures

  16. Quiz • Lab Notes and Quiz postedhttp://www.ieor.berkeley.edu/~ieor115/labs.html • Deadline: Friday, 13 Sept. • Reminder: Contact Report Due 9, Sept.Template Posted, please download and use it

  17. How to submit HW/Quizzes • Pandagrader.com • You will receive a invite, Sign up! • Download HW template from Class Website (pdf/word) • Fill out answers in Assigned Spaceswithout changing Template • Submit as pdf on Pandagrader.com • Make Pdf using: Save as PDF,Scanner or Photo Scanner Apps (e.g. CamScanner)

More Related