Question: Activity 2: make and maintain customer profiles Your task. In this activity, you are required to make a customer profile database to store information about

Activity 2: make and maintain customer profiles

Your task.

In this activity, you are required to make a customer profile database to store information about your customers. The database will help you in the identification of special customers, including but not limited to

  • Frequent customers
  • Special customers who possess special customer cards
  • Customers were visiting your restaurants on their special occasions such as birthdays or wedding anniversaries.

Based on thisinformation, you can provide special services to the client, including

  • Giving a 10% discount to special customer cardholders when they spend more than $35 in the restaurant.
  • Organising free birthday or anniversary cake

In this task, you arerequired to do the following:

  • make a customer profile database to capture customer information that can be used in the future to provide tailored products and services.
  • Save the information of the clients in MS Excel File
  • Include the following information about the clients in the database:

1. CustomerInformation, including

  • Customer Id
  • Customer name
  • Date of birth
  • Special service needs
  • Additional comments by client

2. Most recentcustomer transaction

  • Customer Id (taken from customer info table)
  • Transaction date
  • Items ordered
  • Billed amount
  • Discount provided
  • Net bill amount
You will be required to complete. Your Trainer will observe you during the activity and complete the following performance checklist.

Customer information
ID Name DOB Special service needs Additional comments

Recent transaction details
Customer id Transaction date Items ordered Billed amount Discount provided Net bill

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!