Mrs. Traino - Room 341

Home > BIM > Unit 3 - Access > Lesson 3 - Working With Datasheets and Queries

Lesson 3 - Working With Datasheets and Queries

Objective:

  • Sort records in a datasheet
  • Search for data in a datasheet
  • Filter records in a datasheet
  • Create and modify select queries
  • Create and special queries using wizards
  • Format a datasheet

TEKS 120.23.5

Assignments:

  1. Key Terms - 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
    • Use Sort and Filter Techniques to Retrieve Data 
    • Create a Find Duplicates Query 
    • Create and Modify a Select Query
    </LI>
Author: Esperanza Traino
Last modified: 4/23/2012 9:27 AM (EST)