1 / 4

Announcements

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

Télécharger la présentation

Announcements

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. Announcements • Homework 1 Due 9/15 • Project: Step 1 Due 9/17 • Reading for Monday • 2.1 – 2.5

  2. Introduction to Access Lecture 2

  3. 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

  4. 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

More Related