Beauty To Go : Activity A1

Sue Miller, an owner of a nail and hair salon in Orlando, Florida, regularly checks in on her grandmother, who resides in a retirement community. On some of her visits, Sue does her grand- mothers hair and nails. Her grandmother recently asked if Sue would also be willing to do the hair and nails of some of her friends in her retirement community and other surrounding communities. She said that these friends would happily pay for her services. Sue thinks this is an excellent way to expand her current business and serve the needs of the retirement community at the same time. In discussing the opportunity with some of the members of the retirement community, she found that the ladies would very much like to pay Sue in advance for her services and have them scheduled on a regular basis; however, the frequency and types of the services vary from person to person. Sue decides to come up with different options that would serve the needs of the ladies in the retirement community. Sue wants to use Access to maintain information about the customers and the types of options offered. She needs your help in creating this database. Complete the following:

1. Create a new, blank database named Beauty and save it in the folder where you are storing your files, as specified by your instructor.
2. In Datasheet view for the Table1 table, rename the default primary key ID field to OptionID. Change the data type of the OptionID field to Short Text.
3. Add the following three fields to the new table in the order shown: OptionDescription (a Short Text field), OptionCost (a Currency field), and FeeWaived (a Yes/No field). Save the table as Option.
4. Enter the records shown in Figure 1-32 in the Option table. Hint: When entering the OptionCost field values, you do not have to type the dollar signs, commas, or decimal places; they will be entered automatically.

Figure 1-32

Option table records

OptionID OptionDescription OptionCost FeeWaived

136 Wash/cut bi-weekly for 6 months $500.00 Yes

101 Manicure weekly for 1 month $125.00 No

124 Manicure/pedicure weekly for 3 months $700.00 Yes

142 Wash/cut/color monthly for 6 months 117 $ 600.00 Yes

117 Pedicure bi-weekly for 3 months $190.00 No

5. Sue created a database named BeautyToGo that contains a MoreOptions table with plan data. The Option table you created has the same design as the MoreOptions table. Copy all the records from the MoreOptions table in the BeautyToGo database (located in the Access1 > Case1 folder provided with your Data Files), and then paste them at the end of the Option table in the Beauty database.
6. Resize all datasheet columns to their best fit, and then save the Option table. 7. Close the Option table, and then use the Navigation Pane to reopen it. Note that the records are

displayed in primary key order by the values in the OptionID field.

7. Close the Option table, and then use the Navigation Pane to reopen it. Note that the records are

displayed in primary key order by the values in the OptionID field.

8. Use the Simple Query Wizard to create a query that includes the OptionID, OptionDescription, and OptionCost fields from the Option table. In the second Simple Query Wizard dialog box, select the Detail option if necessary. (This option appears because the query includes a Currency field.) Save the query as OptionData, and then close the query.
9. Use the Form tool to create a form for the Option table. Save the form as OptionInfo, and then close it.
10. Use the Report tool to create a report based on the Option table. In Layout view, resize the OptionID field so it is slightly wider than the longest entry, which is the field name in this case. Resize the OptionDescription field so there are no entries with multiple lines. Also, resize the box containing the total amount that appears below the OptionCost column by clicking the box and then dragging its bottom border down so that the amount is fully displayed. (The Report Tool calculated this total automatically.) Display the report in Print Preview; then verify that all the fields are within the page area and all field values are fully displayed. Save the report as OptionList, print the report (only if asked by your instructor to do so), and then close it.
11. Close the Option table, and then compact and repair the Beauty database. 12. Close the Beauty database.