{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Test 6 Study Guide

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

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 Document Right Arrow Icon
Answer: The increased speed advantage of using an index must be weighed against two disadvantages:
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.

{[ snackBarMessage ]}