Mrs. Traino - Room 341

Home > BIM > Unit 3 - Access > Lesson 2 - Creating, Modifying, and Relating Tables

Lesson 2 - Creating, Modifying, and Relating Tables

Objective:

  • Create tables
  • Modify table design
  • Create an input mask
  • Import, export, and link Access data
  • Define relationships and enforce referential integrity
  • Create a Lookup Field

TEKS: 120.23.5

 Assignments:

  1. Key Terms (pg. 338) - Define Key Terms on a spreadsheet, have student ready to transfer Key Terms on to a database by lesson 3
  2. Step Through It Exercises 1-6 (ALL)
  3. Guided Activities 1- 2
  4. Do It Yourself Activities
    • Import and Modify a Table 
    • Create a Table and Establish Relationships
    • Modify Field Properties and Enter Data
    </LI>
Author: Esperanza Traino
Last modified: 4/23/2012 9:27 AM (EST)