Test 6 Study Guide

Test 6 Study Guide - Test #6 Study Guide: Tutorials 9-10:...

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

View Full Document Right Arrow Icon
Test #6 Study Guide: Tutorials 9-10: 1. What is an action query? Answer: is a query that adds, changes, or deletes multiple table records at a time. 2. Types of action queries. Answer: Make-table query Append Query History Table Delete query Update query 3. M:N Relationships Answer: Many to many relationship – exits between two tables when each record in the first table matches many records in the second table. 4. How to “create” a M:N relationship. Answer: you must create a third table and form one-to-many relationships between the two original primary tables and the new related table 5. 1:1 Relationships Answer: One-to-one relationship = exits between two tables when each record in the first table matches at most one record in the second table. 6. What is an Index? Answer: is a list that relates field values to the records that contain those field values. 7. What are some of the tradeoffs of Using Indexes?
Background image of page 1

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

View Full DocumentRight Arrow Icon
Answer: The increased speed advantage of using an index must be weighed against
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 05/20/2008 for the course IT 260 taught by Professor Mr.stone during the Spring '08 term at Harding.

Page1 / 4

Test 6 Study Guide - Test #6 Study Guide: Tutorials 9-10:...

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