Benchmark Access 2003
Lesson Blueprints
Text Updates
Student Data Files
Lecture Hall
Student Center
Computer Lab
Library
Testing Center

Contact Us
Company Info
News/Events
Certification Info
 
College Resource Center : Benchmark 2003 : Benchmark Access 2003 : Text Updates

by Nita Rutkosky & Meredith Flynn

Text Updates

Chapter 7, Exercise 9, page S223 (in Benchmark Access 2003 Specialist and Expert, Benchmark Access 2003 Specialist, and Benchmark Office 2003/Access Module)

Change the steps as follows:

Step 4: Close the Linked Policies table. Start Excel and open Excelsac7. Change the number 745 in the Premium column to 850.
Step 5: Add the following new row in the Excel worksheet and then save the worksheet: (same data as shown in existing step):
Step 6: Switch to Access and reopen the Linked Policies table. Notice the table data has updated to reflect the changes made to the Excel worksheet. Print and then close the Linked Policies tble.
Step 7: DELETE.
Step 8: Okay as is.
Step 9: Okay as is.

-----------

Microsoft Corporation made a change in Office 2003 Service Pack 2 and in Office XP, after the Access books were published, that affects the directions in specific exercises. The change concerns the linking of Excel and Access. With linked files, users can no longer update the Access file and expect the revisions to be made automatically to the linked Excel file. The changes must be made in both the Excel file and the Access file. This software revision affects the following activities in Benchmark Access 2003 Specialist and Expert text and the Benchmark Access 2003 Expert text:

Chapter 8, Exercise 4, page E262

------------

Benchmark Access 2003 Specialist and Expert, page E117, page E159 and page
E165
Benchmark Access 2003 Expert, page E117, page E159 and page E165

page E117, Assessment 1: Add a new step 2 (existing steps 2-5 then become
steps 3-6):
2. Open the 03WaterfrontCafe database file and create the following
relationships:
a. A one-to-many relationship between Suppliers (one) and Orders (many).
b. A one-to-many relationship between Suppliers (one) and Products (many).
c. A one-to-many relationship between Orders (one) and Order Details (many).
d. A one-to-many relationship between Employees (one) and Order Details
(many).
e. A one-to-many relationship between Employees (one) and Banquets (many).
f. A one-to-many relationship between Products (one) and Order Details
(many).

page E159, Assessment 1: Add a new step 14 (existing step 14 becomes step
15):

14. Create the following relationships between the tables. For each
relationship, turn on referential integrity and both cascade options.
a. A one-to-many relationship between Attendees (primary table) and
Registration (related table).
b. A one-to-many relationship between Events (primary table) and
Registration (related table).
c. A one-to-many relationship between Event Type (primary table) and
Events
(related table.)

Page E165, Assessment 7: Change the first sentence in step 2 as follows:
Create a new query in Design View based on the Attendees, Registration, and
Events tables.

Add the following sentence to the end of step 7: Sort the report by the
LastName field.


Materials posted on this site are copyrighted by Paradigm Publishing Inc. Permission is granted by the publisher to adopters of the text product that this electronic material accompanies to reproduce portions of these materials, and to adapt them as needed for educational use at a single location.
Printable Version


Powered by: Blue Earth Interactive © 2018 EMC Corporation. All Rights Reserved