One of your co-workers wants to confirm if the details she got from a customer matches the database. She writes down the details and hands it to you.A Policy # GW9462B173 Premium: $554.27 Excess: $27.52B Name: Mr. Jimmy Johnstone Phone 503 - 555 - 2337C Address: 218 30th St., Portland Oregon, 94201D Customer Since: Jan 11, 2007 Renewal Date: Jan 16, 2015
Question
One of your co-workers wants to confirm if the details she got from a customer matches the database. She writes down the details and hands it to you.A Policy # GW9462B173 Premium: 27.52B Name: Mr. Jimmy Johnstone Phone 503 - 555 - 2337C Address: 218 30th St., Portland Oregon, 94201D Customer Since: Jan 11, 2007 Renewal Date: Jan 16, 2015
Solution
To confirm if the details match the database, follow these steps:
-
Open the database system that your company uses to store customer information.
-
In the search bar, type in the policy number provided, which is GW9462B173, and press enter.
-
The system should bring up the details of the customer associated with that policy number.
-
Compare the details provided by your co-worker with the details on the system.
-
Check the premium amount. It should be $554.27.
-
Check the excess. It should be $27.52.
-
Check the name. It should be Mr. Jimmy Johnstone.
-
Check the phone number. It should be 503 - 555 - 2337.
-
Check the address. It should be 218 30th St., Portland Oregon, 94201.
-
Check the date the customer has been with the company. It should be since Jan 11, 2007.
-
Check the renewal date. It should be Jan 16, 2015.
-
-
If all the details match, then the information your co-worker got from the customer is correct. If there are any discrepancies, then there might have been a mistake or a change that hasn't been updated in the system.
Similar Questions
One of your co-workers wants to confirm if the details she got from a customer matches the database. She writes down the details and hands it to you.A Policy # GW9462B173 Premium: $554.27 Excess: $27.52B Name: Mr. Jimmy Johnstone Phone 503 - 555 - 2337C Address: 218 30th St., Portland Oregon, 94201D Customer Since: Jan 11, 2007 Renewal Date: Jan 16, 2015 Which of the rows in the second table matches the details on the piece of paper?
One of your co-workers wants to confirm if the details she got from a customer matches the database. She writes down the details and hands it to you.A Policy # GW9462B173 Premium: $554.27 Excess: $27.52B Name: Mr. Jimmy Johnstone Phone 503 - 555 - 2337C Address: 218 30th St., Portland Oregon, 94201D Customer Since: Jan 11, 2007 Renewal Date: Jan 16, 2015
in a database, information is accessible from
The whole office now knows that you're good at double checking details on slips of paper. Another one of your co-workers in sales asks you to check if the details she got were correct.
ne of your co-workers hands you a scrap of paper with the correct details of a client in your database. Find the incorrect entry in the table.A Policy # GW94262b173 Premium: $554.27 Excess: $27.52B Name: Mr. Jimmy Johnstone Phone 503 - 555 - 2337C Address: 218 30th St., Portland Oragon, 94210D Customer Since: Jan 1, 2007 Renewal Date: Jan 16, 2015
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.