Microsoft Office Tutorials and References
In Depth Information
Cases and Places
AC 203
Cases and Places
Apply your creative thinking and problem solving skills to design and implement a solution.
E ASIER
•• M ORE D IFFICULT
• 1: Maintaining the Second-Hand Goods Database
Use the Second-Hand Goods database you created in Cases and Places 1 in Chapter 1 on page AC 71
for this assignment, or see your instructor for information on accessing the fi les required for this topic.
Perform each of the following tasks:
a. The Condition fi eld should be a Lookup fi eld. Only the current values in the database should be
legal values.
b. A better description for the bookcases is 3-Shelf Bookcase.
c. The duvet has been sold.
d. The minimum price of any item is $2.00.
e. It would be easier to fi nd items for sale if the default sort order for the item table were by
description rather than by item number. Also, some of the descriptions are not displayed
completely in Datasheet view.
f. Specify referential integrity. Cascade the update and the delete.
Submit the revised database in the format specifi ed by your instructor.
• 2: Maintaining the BeachCondo Rentals database
Use the BeachCondo Rentals database you created in Cases and Places 2 in Chapter 1 on page AC 71
for this assignment, or see your instructor for information on accessing the fi les required for this topic.
Perform each of the following tasks:
a. Add the fi eld, For Sale to the Condo Unit, to indicate whether a condo unit is for sale. The fi eld is
a Yes/No fi eld and should appear after the weekly rate.
b. All units owned by Alonso Bonita are for sale.
c. The Bedrooms, Bathrooms, and Sleeps fi elds always should contain data.
d. Most common condo units have one bedroom, one bathroom, and sleep two people. All condo
units should have a minimum of one bedroom, one bathroom, and sleep two people.
e. No unit rents for less than $700 or more than $1,500.
f. Management has just received a new listing from Mark Graty. It is unit 300. The unit sleeps 10,
has three bedrooms, has 2.5 bathrooms, and includes linens. The weekly rate is $1,400 and the
owner is interested in selling the unit.
Submit the revised database in the format specifi ed by your instructor.
•• 3: Maintaining the Restaurant Database
Use the restaurant database you created in Cases and Places 3 in Chapter 1 on page AC 71 for this
assignment, or see your instructor for information on accessing the fi les required for this topic. Using
the Plan Ahead guidelines presented in this chapter, determine what changes need to be made to
your database. For example, a multivalued fi eld could be useful to record opening days and times of
a restaurant. Another multivalued fi eld could record restaurant specialties. Use a word processing
program, such as Microsoft Word, to explain the changes you need to make to the database. Then,
make the changes to the database. Submit the Word document and the revised database in the format
specifi ed by your instructor.
Continued >
Search JabSto ::




Custom Search