McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center


Advantage Series MS Office XP Access 2002
Advantage Series: Microsoft® Access 2002
Sarah Hutchinson-Clifford
Glen Coulthard
Creating Advanced Queries

Short Answer



1

Write the SQL code that retrieves all fields from a table named tblOrders for customer number (CustNo) 124, sorted by date.
2

Define Entity Integrity. Define Referential Integrity.
3

How do you define a many-to-many relationship between two tables?
4

What are the advantages of using a naming convention, when naming objects in an Access database?
5

Why is a parameter query useful as the basis for forms and reports?




McGraw-Hill/Irwin




Copyright2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.