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). |
|