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
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
2. Open the 03WaterfrontCafe database file and create the following
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
e. A one-to-many relationship between Employees (one) and Banquets (many).
f. A one-to-many relationship between Products (one) and Order Details
page E159, Assessment 1: Add a new step 14 (existing step 14 becomes step
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
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
Add the following sentence to the end of step 7: Sort the report by the
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.