Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
In the Lab continued
Instructions Part 2: The data for the Services Offered ﬁ eld shown in Figure 3–82 must be added to the
database. The address for Elegante is incorrect. It should be 180 Broadway. Le Beauty has changed its
name to Le Beauty Day Spa. Nancy’s Place has gone out of business. A new salon, PamperMe Day Spa,
just opened. The address for the salon is 2125 Lawrence and the phone number is 555-2401. The spa
provides all services except hair styling and tanning.
Management wants to use PA10 as the customer number and Terry Sinson is the sales rep. The
new spa has purchased $750 worth of supplies but has not paid for them. Format the datasheet to best
ﬁ t the data.
Instructions Part 3: Because the sales reps work on commission, management wants to make sure that
customers are not assigned to a sales rep who is not in the database. It also wants the ability to change a
sales rep number in the Sales Rep table and have the change applied to the Customer table. Create the
appropriate relationship that would satisfy management’s needs.