Study Guide Grauer

Study Guide Grauer - Relationship Line: When a relationship...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Grauer – Access 5 One-To-Many Relationship: When one category in access relates to many others. Ex. One customer can have many loans, but a specific loan is associated with only one customer. Primary Key: A field (or combination of fields) that makes every record in the table unique. AutoNumber field: A field that will generate the primary key. (Move onto the next number automatically with customers, etc.) Format Property: The display of the C or L in front of Customer ID or Loan ID (Ex. L0001, L0002 for loans or C0001, C0002 for customer ID) Referential Integrity: A tool that guarantees that the tables within a database are consistent with one another. Relationship window: is used to create the one-to-many relationship between customers and loans. Foreign key : the primary key of another table. Ex. The CustomerID is the primary key in the Customers table, where its values are unique, but it is a foreign key in the Loans table, where its values are not unique.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Relationship Line: When a relationship has been established, this is the line that connects the tables, indicating the one and many sides of a relationship. Subdatasheet : The display of the related records for a customer. You can click on the plus sign to the left of their name to see them. Subform: a form within a form Main Form (also known as primary form): based on the primary table Form View: Where the main form is displayed Datasheet View: Where the subform is displayed. Multiple-Table query: A form the puts information together from multiple tables. Table Row: indicates the table where the field originates (is only necessary in multiple-table inquiries). Join line: The line between the two field lists. The one Jeremy likes to play around with. Structured Query Language (SQL) : The universal way to access a relational database, meaning that the information provided by any database is obtained through SQL queries....
View Full Document

This note was uploaded on 04/07/2008 for the course DSC 199 taught by Professor Daley during the Fall '06 term at Oregon.

Ask a homework question - tutors are online