Access Chapter 05

Access Chapter 05 - MS Access Chapter 5 Chapter 5...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
S Access Chapter 5 arlotta Eaton Committed to Shaping the Next Generation of IT Experts. Chapter 5 One-to-Many Relationships: Subforms and Multiple-Table Queries Exploring Office 2003 - Grauer and Barber 2 Objectives z Distinguish between primary and foreign keys z Define referential integrity z Use the Relationships Window to create a one-to- many relationship z Explain how AutoNumber simplifies data entry z Distinguish between a main form and a subform z Create a report based on a multi-table query z Create a main form with linked subforms Exploring Office 2003 - Grauer and Barber 3 Case Study: Evergreen Flying Club z The case requires students to create a database that includes: z Three tables: airports, members, and hangars z Two one-to-many relationships z A switchboard, an About form and a relationship diagram Exploring Office 2003 - Grauer and Barber 4 Relationships Window CustomerID is foreign key in Loans table CustomerID is primary key in Customers table Relationships line Enforce Referential Integrity
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
S Access Chapter 5 arlotta Eaton Exploring Office 2003 - Grauer and Barber 5 Referential Integrity z Access automatically implements a form of data validation during data entry z Can enter a record in the “one” table, but not in the “many” table if record contains an invalid value for
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/15/2011 for the course BCIS 3610 taught by Professor Koh during the Spring '08 term at North Texas.

Page1 / 6

Access Chapter 05 - MS Access Chapter 5 Chapter 5...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online