Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

Table of Contents

Lesson Plan...... 2

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

Capstone Exercise for Ch 6 (End of Chapter Capstone Exercise).. 19

Solution for Capstone Exercise...... 20

Homework Handout for next class period (Ch 7)...... 24

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

Materials Needed

Description of Document / Name of Document / Location of Files
Solution to Homework Hands-on Exercises for Access Chapter 6 / chap6_ho1_nationalbank_solution.accdb
chap6_ho2_nationalbank_solution.accdb
chap6_ho1-3_nationalbank_solution.accdb / Exploring Access 2007
Chapter 6 Folder on
Instructor Resource Disk
or

Capstone Exercise for Access Chapter 6 / ExplOffice2007_AccessCh6CE.docx
Solution for
Capstone Exercise for Access Chapter 6 / AccessCh6CE_solution.accdb
AccessCh6CE_solution.docx
Homework Handout for Access Chapter 7 / ExplOffice2007_AccessCh7HW.docx
Answer Key for MyITLab Access Chap 6 / AnswerKey_MyITLab_Access_Chap_6

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 6 Pre-Test
  6. Study Plan
  7. Access Chapter 6 Post-Test
  8. Have students complete Capstone Exercise for Access Chapter 6.
  9. Give students Homework Handout for next class period.

Learning Objectives

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

  • Establish data validity.
  • Create a lookup.
  • Modify a lookup by adding and deleting values.
  • Create and modify a Multivalue lookup field.
  • Work with input masks.
  • Create forms using the formtools.
  • Create custom forms using Design View.
  • Add action buttons and combo box controls.
  • Create Subforms.
  • Fashion functional formats.

Discussion Questions

  • What is data validity? Why is this important?
  • Are there times when using an input mask may hinder productivity?
  • How do forms help limit data entry mistakes?
  • Explain what is meant by Integrity, Validation, and Reliability.

Additional Web Resources

From Microsoft Office Online for Access 2007:

  • Create a form
  • Add or change a lookup column
  • Create a validationrule to validate data in a field
  • Create a form that contains a Subform (a one-to-many form)

Demonstrate how to:

  • Establish required and default field properties.
  • Create and test validation rules and text.
  • Create a lookup field.
  • Modify a lookup field value.
  • Create a multivalue lookup field.
  • Create and edit input banks.
  • Use the form tool and identify form controls.
  • Create a split form.
  • Create a multiple item form.
  • Create a Datasheet form.
  • Create PivotTable and PivotChart forms.
  • Use the blank form tool to create a form.
  • Create a form in Design View.
  • Add action buttons and controls.
  • Create a form with a Subform.
  • Customize a form by moving controls and adding a theme.

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 1k

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 2h

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 3f

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 4f

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 5e

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1_nationalbank_solution.accdb

Step 5e

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho2_nationalbank_solution.accdb

Step 1h

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho2_nationalbank_solution.accdb

Step 2g

chap6_ho2_nationalbank_solution.accdb

Step 3e

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho2_nationalbank_solution.accdb

Step 4o

chap6_ho1-3_nationalbank_solution.accdb

Step 1h

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1-3_nationalbank_solution.accdb

Step 2f

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1-3_nationalbank_solution.accdb

Step 3h

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1-3_nationalbank_solution.accdb

Step 4g

1

Access Chapter 6 – Data Protection: Integrity, Validation, Reliability

chap6_ho1-3_nationalbank_solution.accdb

Step 5n

1

Exploring Office 2007Access Chapter 6 Capstone Exercise

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

Objectives

  • Given a database establish validation rules and create a form that can be used to input new items.

Preparation & Helpful Information

Read Chapter 6 – “Data Protection: Integrity, Validation, Reliability” 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 6, pages 000-000.

TASK 2: Complete Capstone Exercise: Replacements, Ltd on page 00.

TASK 3: Save your file to a disk.

When you complete your assignment, do the following:

Turn in your assignment to your instructor.

1

Exploring Office 2007Access Chapter 6 Capstone Exercise

AccessCh6CE_solution.accdb

Step 1e

1

Exploring Office 2007Access Chapter 6 Capstone Exercise

AccessCh6CE_solution.accdb

Step 2b

1

Exploring Office 2007Access Chapter 6 Capstone Exercise

AccessCh6CE_solution.accdb

Step 3c

1

Exploring Office 2007Access Chapter 6 Capstone Exercise

AccessCh6CE_solution.accdb

Step 5d

1

Exploring Office 2007Access Chapter 7HOMEWORK

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

Learning Objectives

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

  • Maintain a Database
  • Understand Action Queries
  • Create an Update Query
  • Use a Make table Query
  • Create a Delete Query
  • Construct Crosstab Queries
  • Work with Parameter Queries
  • Create Find Unmatched Queries
  • Understand Find Duplicate Queries

Assignment

  • Read Chapter 7 – “Advanced Queries: Using Queries to Change Data” pages 000-000.
  • Complete the two Hands-on Exercises in the chapter.

When your assignment is complete, do the following:

Turn in the following files to your instructor:

□“chap7_ho1-3_replacements _solution.accdb” file.

□“chap7_ho1-3_replacements_solution.docx” files.

□“chap7_ho2_replacements_solution.docx” file.

□“chap7_ho2_replacements_solution.accdb” file.

1