Using Design View, Data Validation, and Relationships
Using Design View, Data Validation, and Relationships
After completing this chapter, you will be able to:
SLO 2.1
Create a table in Design view; add new fields; define a primary key; delete fields; save, close and open a table; and switch between Datasheet and Design views.
SLO 2.2
Set field properties including Field Size, Format, Caption, Default Value, and Required (p. A2-79).
SLO 2.3
Explain data integrity and data validation concepts and options.
SLO 2.4
Create field and record level validation rules, test rules, create validation text, create lookup fields, and define an input mask.
SLO 2.5
Change field properties after records are added into a table.
SLO 2.6
Explain relational database principles, understand the steps that must be taken to design a database, create relationships between tables, implement referential integrity, and delete and edit relationships.
SLO 2.7
Import data records from Excel.
SLO 2.8
Preview and print the contents of a table.
SLO 2.9
Manage a database using Compact & Repair (p. A2-121).
"Check For Understanding" quizzes available in the drop-down menu.
To learn more about the book this website supports, please visit its Information Center.