Access Chapter 2 – Relational database and Multi-Table Queries

Table of Contents

Lesson Plan...... 2

Solution for Ch 2 Homework (Hands-On Exercises in Chapter).... 4

Capstone Exercise for Ch 2 (End of Chapter Capstone Exercise).. 7

Solution for Capstone Exercise...... 8

Homework Handout for next class period (Ch 3)...... 11

1

Access Chapter 2 – Relational Databases and Multi-Table Queries

Materials Needed

Description of Document / Name of Document / Location of Files
Solution to Homework Hands-on Exercises for Access Chapter 2 / chap2_ho1_safebank_solution_backup.accdb
chap2_ho2_safebank_solution_backup.accdb
chap2_ho1-3_safebank_solution.accdb / Exploring Access2007
Chapter 2 Folder on
Instructor Resource Disk
or

Capstone Exercisefor Access Chapter 2 / ExplOffice2007_AccessCh2CE.docx
Solution for
Capstone Exercise for Access Chapter 2 / AccessCh2CE_solution.accdb
AccessCh2CE1_backup_solution.accdb
Homework Handout for Access Chapter 3 / ExplOffice2007_AccessCh3HW.docx
Answer Key for MyITLab Access Chap 2 / AnswerKey_MyITLab_Access_Chap_2

Class Run-Down

  1. Have students turn in Homework assignments.
  2. Talk about chapter using discussion questions listed below.
  3. Demonstrate Access 2007.
  4. Direct students to the MyITLab site to complete the following:
  5. Access Chapter 2Pre-Test
  6. Study Plan
  7. Access Chapter 2Post-Test
  8. Have students complete Capstone Exercise for Access Chapter 2.
  9. Give students Homework Handout for next class period.

Learning Objectives

At the end of this lesson students should be able to:

▪Design data.

▪Create tables.

▪Understand table relationships.

▪Share data with Excel.

▪Establish table relationships.

▪Create a query.

▪Specify criteria for different data types.

▪Copy and run a query.

▪Use the Query Wizard.

▪Understand large database differences.

Discussion Questions

▪What are some examples of good database design? Why is it important to have good database design?

▪When designing a database we have to take into considerations many factors. What are some of those factors?

▪Why is it important to understand table relationships? How do we establish table relationships?

▪What is a Primary Key? What is a Secondary Key? What is a Foreign Key? Why are they important?

▪What are the various data types and why are they important?

Additional Web Resources

From Microsoft Office Online for Access 2007:

  • Database design basics
  • Create, edit or delete a relationship
  • Queries

Demonstrate how to:

▪Design data.

▪Create tables.

▪Share data with Excel.

▪Create a query.

▪Copy and run a query.

▪Use the Query Wizard.

1

Access Chapter 2 – Relational Databases and Multi-Table Queries

chap2_ho1_safebank_solution_backup.accdb

chap2_ho2_safebank_solution_backup.accdb

No printouts required for this exercise

chap2_ho1-3_safebank_solution.accdb

No printouts required for this exercise

1

Exploring Office 2007 Access Chapter 2 Capstone Exercise

Student Name: ______Section: ______
Due Date: ______00 Points PossiblePoints Earned:______

Objectives

  • Use the Import Wizard to import an Excel spreadsheet into Access and then create a database relationship and create, add criteria to, and sort a query.

Preparation Helpful Information

Read Chapter 2 – “Relational Databases and Multi-Table Queries” located in the Microsoft Office 2007 Professional book.

Check each step before continuing; it is easy to skip one when you hurry.

If you are not familiar with Access, allow yourself extra time for the exercises.

Read this assignment sheet first before you complete any assignments. Many times there will be additional instructions not included in your book.

Instructions

Designate one disk for your Access assignments, as these files take up a lot of space.

TASK 1: Read Access Chapter 2, pages 000-000.

TASK 2: Complete Capstone Exercise: JC Raulston Arboretum on page 00.

TASK 3: Print the relationship window in Step D under Create Relationship.

TASK 4: Print the results from Step E under Create, Add Criteria to, and Sort a Query.

TASK 5: Save your file to a disk.

When you complete your assignment, do the following:

Turn in your assignment to your instructor.

1

Access Chapter 2 – Relational Databases and Multi-Table Queries

AccessCh2CE_solution.accdb

Connoisseur Table

Relationship Window

1

Access Chapter 2 – Relational Databases and Multi-Table Queries

Your Name Gala NO, Conn plant Yes query

1

Exploring Office 2007Access Chapter 3HOMEWORK

Student Name: ______Section: ______
Due Date: ______00 Points PossiblePoints Earned:______

Learning Objectives

At the end of this lesson students should be able to:

▪Understand the order of precedence.

▪Create a calculated field in a query.

▪Create expressions with the Expression Builder.

▪Create and edit Access functions.

▪Perform date arithmetic.

▪Create and work with data aggregates.

Assignment

  • Read Chapter 3 – “Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions” pages 000-000.
  • Complete the three Hands-on Exercises in the chapter.

When your assignment is complete, do the following:

Turn in the following filesto your instructor:

□“chap3_ho1-3_realestate_solution.accdb” file.

□“chap3_ho1_realestate_solution.accdb” file.

□“chap3_ho2_realestate_solution.accdb”file.

1