We
have designed this Instructor’s Manual to supplement and enhance your teaching
experience through classroom activities and a cohesive chapter summary.
This
document is organized chronologically, using the same heading in red
that you see in the textbook. Under each heading you will find (in order):
Lecture Notes that summarize the section, Figures and Boxes found in the
section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay
special attention to teaching tips, and activities geared towards quizzing your
students, enhancing their critical thinking skills, and encouraging
experimentation within the software.
In
addition to this Instructor’s Manual, our Instructor’s Resources CD also
contains PowerPoint Presentations, Test Banks, and other supplements to aid in
your teaching experience.
For your students:
Our latest online feature, CourseCasts, is a
library of weekly podcasts designed to keep your students up to date with the
latest in technology news. Direct your students to http://coursecasts.course.com, where
they can download the most recent CourseCast onto their mp3 player. Ken
Baldauf, host of CourseCasts, is a faculty member of the Florida State
University Computer Science Department where he is responsible for teaching
technology classes to thousands of FSU students each year. Ken is an expert in
the latest technology and sorts through and aggregates the most pertinent news
and information for CourseCasts so your students can spend their time enjoying
technology, rather than trying to figure it out. Open or close your lecture
with a discussion based on the latest CourseCast.
Table of Contents
Students
will have mastered the material in Chapter Five when they can:
l Use Yes/No, Date, Memo,
OLE, Object, Attachment, and Hyperlink fields
l Use the Input Mask
Wizard
l Update fields and enter
data
l Change row and column
size
l Create a form with a
subform in Design view
l Modify a subform and
form design
l Enhance the form title
l Change tab stops and tab
order
l Use the form to view
data and attachments
l Use Date, Memo, and
Yes/No fields in a query
l View object dependencies
LECTURE
NOTES
·
Discuss
the one-to-many relationship between the Recruiter and Client tables
Use
this introduction to review the concept of referential integrity (discussed in
Chapter 3) with students.
AC
298: Project – Multi-Table
Forms
LECTURE
NOTES
·
Use
Figure 5-1 to illustrate a multi-table form that includes several new fields
·
Review
the tasks that will be covered in this chapter
o
Adding
fields with Yes/No, Date, and Memo data types
o
Adding
the Phone Number field and creating an appropriate input mask
o
Creating
the Recruiter Master Form and adding fields from the Recruiter table
o
Adding
a subform containing fields from the Client table
o
Enhancing
the form with colors and various special effects
o
Creating
and running queries that involve Yes/No, Date, and Memo data types
FIGURES
and TABLES: Figure — 5-1
TEACHER TIPS
This chapter
illustrates the advantages of a graphical user interface (GUI) such as Windows
to create forms. Students should be encouraged to explore different options for
the form they will create.
As students work through the tasks in this
chapter, encourage them to save their work after each task. Also, forms with
pictures can increase substantially the size of the database. Remind students
that they can compact their database by clicking the Office Button and then
pointing to Manage on the Office Button menu. Clicking Compact and Repair
Database on the Manage submenu will compact (reduce the size of) the database.
AC
299: Plan Ahead (Critical Thinking): Report and Form Design
Guidelines
·
When
new fields are needed, determine the purpose of those fields to see if they
need special data types
·
When
a form is required, determine whether the form requires data from more that one
table
·
If
the form requires data from more than one table, determine the relationship
between the tables
·
If
the form requires data from more than one table, determine on which of the
tables the form is to be based
·
Determine
the fields from each table that need to be on the form
TEACHER TIPS
These guidelines are intended to help students
with their critical thinking skills. Students should understand the reasons for
creating adding fields and creating multi-table forms. Spend a significant
amount of class time reviewing each of these guidelines and use example
databases, such as a student database or a database of credit card information
to which students can relate. These points are emphasized at appropriate
locations in the chapter. Also, Cases and Places 3, 4, and 5 challenge students
to apply these guidelines to creating multi-table forms for a database.
LECTURE
NOTES
·
For
figures that match those in the book, change screen resolution to 1024 x 768
·
Review
the steps to start Access
·
Review
the steps to open a database
You can use the Lecture Success
System for Access in conjunction with the Figures in the Book. To do this,
start Access and open the database from the appropriate folder. Then, start
your slide show containing the figures for the project. You can switch back and
forth between the slide show and Access by using the alt+tab key
combination. You can use the Figures in the Book to show the steps students should
follow. If students need additional reinforcement or ask questions about the
task, you can switch to Access to do a live demonstration.
AC
301: Plan Ahead (Critical Thinking); Determine the Purpose of New
Fields to See if They Need Special Data Types
·
Determine
whether an input mask is appropriate
·
Determine
whether the Yes/No data type is appropriate
·
Determine
whether the Date data type is appropriate
·
Determine
whether the Memo data type is appropriate
·
Determine
whether the OLE Object data type is appropriate
·
Determine
whether the Attachment data type is appropriate
·
Determine
whether the Hyperlink data type is appropriate
TEACHER TIPS
Spend some time reviewing these guidelines with
students. It is important they understand the different data types and when
these data types are appropriate. Yes/No fields also are called Boolean fields
because they can accept only one of two values that evaluate to either true or
false. The ability to subtract one date from another is very important in a
business environment. The Memo data type gives users the flexibility to add
comments or notes in their own words. The OLE data type allows users to insert
pictures, photographs, and drawings in a database. The Attachment data type is
new in Access 2007 and is useful for attaching external files related to a
particular record. The Hyperlink data type allows users to add a Web page
reference.
CLASSROOM ACTIVITIES
1. Class Discussion: Ask students what types of data JSP Recruiters could store in Date
fields, Yes/No fields, Memo fields, and Attachment fields.
2. Critical Thinking: Why is it important to be
able to subtract one date from another?
3. Assign a Project: Require students to
research OLE.
4. Quick Quiz:
1)
Which data type would you use to store
links to Office documents? (Answer: Hyperlink data type)
2)
Which data type would you use to store
text that is variable in length? (Answer: Memo data type)
LECTURE
NOTES
·
Define
input mask and review the Yes/No, Date, Memo, OLE, and Attachment data types
·
Discuss
the reasons for using the OLE data type rather than the Attachment data type
for a picture
·
Use
Figures 5-2 through 5-4 to illustrate adding fields to a table
·
Use
Figures 5-5 through 5-8 to describe using an input mask
FIGURES
and TABLES: Figures — 5-2, 5-3, 5-4, 5-5, 5-6, 5-7, 5-8
BOXES:
1.
BTW: Input Mask Characters. Explain
the purpose of the literal values Access adds to an input mask.
TEACHER TIPS
Point out that Date,
Memo, OLE, and Hyperlink data types do not have field sizes.
An input mask makes data entry easier and
controls the values users can enter in a field. Use Figure 5-7 to explain that
storing data without the symbols takes up less space. If a format also has been
specified for the field, the format takes precedence over the input mask. The
format property affects only how the value is displayed not how it is stored.
The format mask that students create may vary slightly from the format mask
shown in Figure 5-8.
CLASSROOM ACTIVITIES
1. Class Discussion: Ask students what other fields in the Recruiter table could use an
input mask.
AC 306: Updating the New Fields
LECTURE NOTES
·
Use
Figures 5-9 through 5-11 to illustrate entering data using an input mask
·
Use
Figure 5-12 to illustrate entering data in a Yes/No field
·
Use
Figure 5-13 to describe entering data in Date fields
·
Use
Figures 5-14 and 5-15 to describe entering data in Memo fields
·
Define
field selector and row selector
·
Use
Figures 5-16 and 5-17 to illustrate changing the row and column size
·
Use
Figures 5-18 through 5-20 to describe entering data in OLE fields
·
Explain
why entries in the Picture initially may be Pbrush
·
Use
Figures 5-21 through 5-24 to illustrate entering data in Attachment fields
·
Review
the steps to enter data in Hyperlink fields
·
Review
the steps to save the properties and close the table
·
Explain
how to view pictures and attachments in Datasheet view
FIGURES
and TABLES: Figures — 5-9, 5-10, 5-11, 5-12, 5-13, 5-14, 5-15, 5-16, 5-17,
5-18, 5-19, 5-20, 5-21, 5-22, 5-23, 5-24
BOXES:
1.
BTW: OLE Fields. Review the procedure
for converting a Bitmap Image to Picture (Device Independent Bitmap).
2. Other Ways: Encourage your students to explore other
ways of changing the row and column size.
TEACHER TIPS
The steps in this
section update the new fields in Datasheet view. You also can update the fields
in Form view. When
data is entered in a field that has an input mask, the cursor should be
positioned at the beginning of the field. The short date style of MM/dd/yyyy is
taken from the Windows Vista Regional Settings Section Short Date setting.
Access 2007 automatically treats all two-digit years before 30 as 2000 through
2029. Other dates are treated as 1930 through 1999. For example, the date
If students see the word Package instead of
Bitmap image after they insert the picture and move to another record, there is
a problem either with the graphics filter or with the file associations for BMP
files. Students should follow the directions at the bottom of page AC 311 to
correct the problem.
CLASSROOM
ACTIVITIES
1.
Critical Thinking: Many different types of data can be entered into database
fields. But, what types of data should be entered? In this project, pictures of
recruiters are entered into the database. Some people may feel that pictures of
the recruiters is irrelevant, or inappropriate. Should pictures of the
recruiters be a part of the database? Why or why not? How much input should a
database designer have on what fields are, and are not, included in the
database? Why?
LAB
ACTIVITIES
1.
Have students use the Calendar to enter dates. Have them try to enter an
incorrect date to see what happens.
2.
Have students view the attachments. Also asked them to delete the attachments
and then re-add them.
AC 314: Multi-Table Form
Techniques
LECTURE NOTES
·
Review
the one-to-many relationship
between the Recruiter and the Client tables; remind students of the referential
integrity rule created previously
·
Explain
the difference between a subform and a main form
·
Use
Figures 5-25 and 5-26 to describe creating a form in Design view
·
Use
Figures 5-27 and 5-28 to illustrate adding a control for a field to the form design
·
Review
the steps to save the form
·
Use
Figure 5-29 to illustrate adding controls for additional fields
·
Use
Figures 5-30 and 5-31 to describe aligning controls
·
Use
Figure 5-32 to illustrate moving the field list
·
Use
Figures 5-33 through 5-36 to describe adding controls for the remaining fields
·
Use
Figures 5-37 and 5-38 to illustrate using a shortcut menu to change the
fill/back color
·
Use
Figure 5-39 to illustrate adding a title
·
Use
Figures 5-40 through 5-46 to describe placing a subform
·
Point
out the steps to close and save a form
·
Use
Figures 5-47 through 5-49 to illustrate modifying a subform
·
Explain
size mode including: Clip, Stretch, and Zoom
·
Review
the steps to change the size mode
·
Use
Figures 5-50 through 5-55 to illustrate changing special effects and colors
·
Use
Figures 5-56 through 5-58 to describe enhancing a form title
·
Use
Figure 5-59 to illustrate changing a tab stop
·
Use
Figure 5-60 to illustrate changing the tab order
·
Review
the steps to anchor controls
·
Use
Figures 5-61 through 5-64 to describe using the form
·
Discuss
the various actions you can take within a form
·
Use
Figure 5-65 to illustrate viewing object dependencies
FIGURES
and TABLES: Figures — 5-25, 5-26, 5-27, 5-28, 5-29, 5-30, 5-31, 5-32, 5-33,
5-34, 5-35, 5-36, 5-37, 5-38, 5-39, 5-40, 5-41, 5-42, 5-43, 5-44, 5-45, 5-46,
5-47, 5-48, 5-49, 5-50, 5-51, 5-52, 5-53, 5-54, 5-55, 5-56, 5-57, 5-58, 5-59,
5-60, 5-61, 5-62, 5-63, 5-64, 5-65
TEACHER TIPS
Encourage students to
save after each task.
Emphasize that the main form and the subform are two different objects within
the database.
Viewing a list of
objects that use a specific object helps in the maintenance of a database and
avoids errors when changes are made to the objects involved in the dependency.
The Etched special
effect may not show on some computers. You can have students select one of the
other choices, such as Solid with a Border Width of 3.
CLASSROOM
ACTIVITIES
1. Critical Thinking: Ergonomics is the study of
workplace design and the physical and psychological impact
it has on workers. How does a well-designed form improve working conditions and
efficiency?
2. Quick Quiz:
1)
Which size mode does the best job of
fitting a picture to the allocated space without changing the look of the
picture? (Answer: Zoom)
2)
Which tool do you use to place a subform
on a form? (Answer: Subform/Subreport tool on the Design tab)
LAB
ACTIVITIES
1.
Have the students experiment with the different size modes and record their
reactions to the results.
AC 315: Plan Ahead (Critical
Thinking): Determine on which of the Tables the Form Is to be Based
·
Determine
the main table the form is intended to view and/or update
·
Determine
how the additional table should fit into the form
AC 315: Plan Ahead (Critical
Thinking): Determine the Fields from Each Table to be Included in the Form
·
Determine
the fields from the main table that should be included on the form
·
Determine
the fields from the additional table that should be included on the form
AC 340: Date, Memo, and Yes/No Fields in Queries
LECTURE
NOTES
·
Use
Figures 5-66 through 5-71 to illustrate using Date, Memo, and Yes/No fields in
a query
FIGURES
and TABLES: Figures — 5-66, 5-67, 5-68, 5-69, 5-70, 5-71
BOXES:
1.
BTW: Searching Memo Fields. Remind
students that comments are free-form.
2.
BTW: Date Fields in Queries. Have
students read the information on using date fields in queries.
LAB
ACTIVITIES
1.
Have students create and run other queries that use Date, Memo, and Yes/No
fields.
LECTURE
NOTES
·
Use
Figure 5-72 to describe a simple form with a datasheet
·
Review
the steps to create a simple form with a datasheet
·
Use
Figures 5-73 through 5-75 to discuss how to create a form with a datasheet in
Layout view
·
Review
the steps to create a form with a datasheet in Layout view
FIGURES
and TABLES: Figures — 5-72, 5-73, 5-74, 5-75
AC 346: Creating a Multi-Table
Form Based on the “Many” Table
LECTURE
NOTES
·
Use
Figure 5-76 to describe a form based on the many table in a one-to-many
relationship
·
Review
the steps to create a multi-table form based on the “many” table
BOXES:
1.
BTW: Certification. For more
information on the MCAS program see Appendix G or visit the Access 2007
Certification Web page.
2.
BTW: Quick Reference. Point out the
location of the Quick Reference Summary and the Access 2007 Quick Reference Web
page.
§ Learn It Online is a
series of online student exercises that test your knowledge of chapter content
and key terms.
§ Apply Your Knowledge is
a student assignment that helps you to reinforce the skills and apply the
concepts you learned in this chapter.
§ Extend Your Knowledge is
a student assignment that challenges you to extend the skills you learned in
this chapter and to experiment with new skills. You may need to use Help to
complete the assignment.
§ Make It Right is a
student assignment that requires you to analyze a presentation and correct all
errors and/or improve the design.
§ In the Lab (Lab): In the
Lab is a series of student assignments that ask you to design and/or create a
presentation using the guidelines, concepts, and skills presented in this
chapter. The assignments are listed in order of increasing difficulty.
§ Cases and Places is a
series of student assignments where you apply your creative thinking and
problem solving skills to design and implement a solution.
·
field
selector (AC 309)
·
input
mask (AC 302, AC 304)
·
main
form (AC 315)
·
OLE
(Object Linking and Embedding (AC 301)
·
one-to-many
relationship (AC 314)
·
record
selector (AC 309)
·
size
mode (AC 329)
·
subform
(AC 315)