Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Apply your creative thinking and problem solving skills to design and implement a solution.
• E ASIER •• M ORE D IFFICULT
• 1: Design and Create an E-Commerce Database
Students often have very little money to furnish dorm rooms and apartments. You and two of your
friends have decided to use the skills you learned in your e-Commerce class to create a Web site
speciﬁ cally for college students to buy and sell used household furnishings.
Design and create a database to store the data that you need to manage this new business. Then
create the necessary tables and enter the data from the Case 1-1 Second-Hand Goods document. See
the inside back cover of this topic for instructions for downloading the Data Files for Students, or see
your instructor for information on accessing the ﬁ les required in this topic. Submit your assignment in
the format speciﬁ ed by your instructor.
• 2: Design and Create a Rental Database
You are a part-time employee of BeachCondo Rentals. BeachCondo Rentals provides a rental service
for condo owners who want to rent their units. The company rents units by the week. Currently, the
company keeps information about its rentals in an Excel workbook.
Design and create a database to store the rental data. Then create the necessary tables and enter
the data from the Case 1-2 BeachCondo Rentals workbook. See the inside back cover of this topic for
instructions for downloading the Data Files for Students, or see your instructor for information on
accessing the ﬁ les required in this topic. Create an Available Rentals Report that lists the unit number,
weekly rate, and owner number. Submit your assignment in the format speciﬁ ed by your instructor.
•• 3: Design and Create a Restaurant Database
Your school is sponsoring a conference that will draw participants from a wide geographical area. The
conference director has asked for your help in preparing a database of restaurants that might be of
interest to the participants. At a minimum, she needs to know the following: the type of restaurant
(vegetarian, fast-food, ﬁ ne dining, and so on), street address, telephone number, and opening and
closing times and days. Because most of the participants will stay on campus, she also would like to
know the approximate distance from campus. Additionally, she would like to know about any unique or
special features the restaurants may have.
Design and create a database to meet the conference director’s needs. Create the necessary tables,
determine the necessary ﬁ elds, enter some sample data, and prepare a sample report to show the
director. Submit your assignment in the format speciﬁ ed by your instructor.
•• 4: Design and Create a Database to Help You Find a Job
Make It Personal
Conducting a job search requires careful preparation. In addition to preparing a resume and cover
letter, you will need to research the companies for which you are interested in working and contact
these companies to let them know of your interest and qualiﬁ cations.
Microsoft Access includes a Contacts table template that can create a table that will help you
keep track of your job contacts. Create a database to keep track of the companies that are of interest to
you. Submit your assignment in the format speciﬁ ed by your instructor.