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
Working With Tables

Learning Objectives

After completing this chapter, you will be able to:

1.

Understand the fundamentals of relational database design, including normalization and referential integrity

2.

Establish table relationships for the purpose of reducing data redundancy and optimizing data storage

3.

Customize the appearance and behavior of fields by setting properties in table Design view

4.

Ensure data integrity by specifying required fields, input masks, validation lists, and lookup tables

5.

Import and export data in a variety of different formats, including Excel worksheets, HTML Web pages, and XML documents.




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.