Secret Shopper! 

Shopping and more shopping!  You have been hired as a "Secret Shopper" for a family members new home that was recently purchased.  Because you are known to have such great taste and style, they have asked for your assistance.  For this task, you will search online for items to help complete various rooms providing them with two alternatives for each item.  They would like to complete final purchases online so that items can be delivered and time is not wasted going to the stores.  Free shipping is a plus!  They are relatively open as far as colors and style goes, so choose what you think might be best!  Thank you and have fun shopping!

To begin, create a table using the information below as a guide.  Feel free to modify these and/or include additional fields that you feel might suit your needs as Secret Shopper.

         Field Name              Data Type Description
  Item Type Text Type of Item:  Bed, Bath, Kitchen, Family Room, Outdoor
  Item Name Text Item Description
  Price Currency Price of Item
  Picture OLE Object              Picture of Item
  Website Hyperlink Website Address
  Free Shipping Yes/No Indicate whether free shipping is available

From the information in the table you created above, design a form that you can use to input the information for possible items to purchase for the new home.  The picture to the left is an example of a simple form, but I know that you can probably do much better than that!  Remember, you would like to impress your family member with your shopping suggestions and Access expertise! 

 

Now you can begin shopping!  Using the form you created, find the items needed for the new home from the table below.  Please provide 2 choices for each item so that they have some options.  Remember as you are selecting items to keep color options in mind.  (For example, if you select a white coffee maker it may be ideal to also select a white toaster.) Here are some examples of things to look for to get you on the right track. For this to work best, try to enter at least 18 different records. 

         Item Type              Item Name Description
  Bedroom Comforter Set King Size
  Den Computer or Laptop with a large screen monitor 
  Den Desk for computer
  Bathroom Bath Towel Set(s) Bath Towel, Hand Towel, Wash Towel
  Family Room Television Large Screen
  Family Room Furniture Couch, Loveseat, Chair...
  Family Room Gaming System any system is fine...
  Outdoor Basketball Hoop free standing or to be set in cement
  Outdoor Patio Furniture  any arrangement 

Show me what you found!

 

Your family is not in town yet and would like to see what their "secret shopper" has found so they can begin to make some decisions.  Use the Query and Report features in Access to show them what you found for the new home!  Include a footer on each report that includes your name, current date, and a brief description of the query/report.  Include the following reports plus one additional report that you feel will help me make my decision.

  • prepare a report that displays all items found for the bedroom
  • prepare a report that diplays all the items found for the family room
  • prepare a report that displays all items that cost $300 or less
  • prepare a report of all items that cost more than $100 that have free shipping
  • prepare a report that displays the bedroom comforter and bathroom towels so that they can see the color coordination
  • one report of your choice to make a final statement! 

Note:  If you are not sure how to create a report, use the Access help feature or search online to learn how this feature works!  I suggest using the Report Wizard as it guides you step-by-step. 

 

  1. Open Word and add a title at the top of the document: (Your Name) – Secret Shopper.
  2. Take a “Screen Shot” of the Form you designed. Paste this into Word and label it as “Secret Shopper Form”
  3. Take "screen shots" of your reports and paste to the Word document:

    ·         Bedroom items

    ·         Family Room items

    ·         Items that cost $300 or less

    ·         Items that cost more than $100 and have free shipping

    ·         Bedroom – comforter and bathroom color coordination

  4. Take a “Screen Shot” of final report you created – your choice! Add to your Secret Shopper Word document.
  5. Save and upload this file to Edmodo.