40 likes | 209 Views
Announcements. Homework 1 Due 9/15 Project: Step 1 Due 9/17 Reading for Monday 2.1 – 2.5. Introduction to Access. Lecture 2. A Sample Database. Simple University database Need to keep information about Students Classes Professors Enrollment-links students to their classes
E N D
Announcements • Homework 1 Due 9/15 • Project: Step 1 Due 9/17 • Reading for Monday • 2.1 – 2.5
Introduction to Access Lecture 2
A Sample Database • Simple University database • Need to keep information about • Students • Classes • Professors • Enrollment-links students to their classes • Example uses Microsoft Access • Data represented as tables • Each row of Student table represents one student • Each row of Class table represents one class • Each row of Enroll represents relationship between one student and one class See Figure 1.1
Lab 1.1 • Examine existing tables, relationships, queries, and reports • Design new queries • Design and run a new report • Design and use a form • Update tables