Resize all datasheet columns to their best fit, and then save the Option 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.Ħ. The Option table you created has the same design as the MoreOptions table. Sue created a database named BeautyToGo that contains a MoreOptions table with plan data. 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.ĥ. Enter the records shown in Figure 1-32 in the Option table. 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). Change the data type of the OptionID field to Short Text.ģ. In Datasheet view for the Table1 table, rename the default primary key ID field to OptionID. Create a new, blank database named Beauty and save it in the folder where you are storing your files, as specified by your instructor.Ģ. She needs your help in creating this database. Sue wants to use Access to maintain information about the customers and the types of options offered. Sue decides to come up with different options that would serve the needs of the ladies in the retirement community. 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 thinks this is an excellent way to expand her current business and serve the needs of the retirement community at the same time. She said that these friends would happily pay for her services. 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. On some of her visits, Sue does her grandmother’s hair and nails. Data File needed for this Case Problem: BeautyToGo.accdbīeauty To Go 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.
0 kommentar(er)
