Jump to Tutorial:
	1	2	3	4	5	6	7	8	9	10

Access 97 Tutorial 3 Internet Assignments

Lopez Lexus Dealerships

Jim Sweeny is the manager of the Lopez Lexus Dealership in Laredo, Texas. Jim wants to determine the cost per pound of each Lexus model so he can use the information as a promotional gimmick in his next advertising campaign. Jim contacts Maria and Hector Lopez and requests the curb weights for each of the models available at the Laredo dealership. First you need to create a query to determine which models are in stock at the Laredo dealership. Next you will use the Internet to find the weight information for each model, and then you will use Access to calculate the cost per pound.

Before beginning this assignment, you must have already completed all Internet Assignments from previous Access tutorials. Please continue to use the file Lexus.mdb from your Internet Assignments disk to complete this assignment.

1. Start Access and then open the Lexus database located in the Cases folder on your Student Disk.
2. Create a query to determine the models that are in stock at the Laredo dealership. Print the query datasheet, save it as Laredo stock, and then close the query.
3. Log on to the Internet and use your Web browser to go to the Course Technology home page. Click the Student Online Companions link, and then click the New Perspectives on Microsoft Office 97 Professional link to open the New Perspectives on Microsoft Office home page. Click the Access 97 link, and then click the Tutorial 3 Internet Assignment link.
4. Click the link to the Lexus home page. The weight specifications that you need are located on the Model Gallery specifications page. (Note: Lexus refers to the SC300 and SC400 models as "coupe.") Print the specifications pages that you will need for Jim, and then close your Web browser.
5. Return to Access and make sure the Lexus database is open. Create a new table named Specifications using the table design shown below.

Field Name	Data Type	Description	Field Size
Model	Text	primary key	50
Weight	Number	curb weight

6. Add the model and curb weight information that you found on the Web to the Specifications table.
7. Create a query that will display the Model, Weight, SellingPrice, and Cost per Pound fields for the automobiles that are located in Laredo. Use the Expression Builder to create the Cost per Pound field, which is calculated by dividing the Selling Price by the Weight. To format the Cost per Pound field to display as currency, right-click the calculated field column in the query design grid, click Properties on the shortcut menu, and then change the Format setting to Currency on the property sheet.
8. Save the query as Cost per Pound, run the query, print the query datasheet, and then close the query. Close Access.
9. Submit your printed datasheet and the printed Web pages to your instructor.

	Jump to Tutorial:
	1	2	3	4	5	5	6	8	9	10

Copyright © 1997 Course Technology