Play Around Toys Inc. wants to lure back customers who have not purchased any of

Question

Play Around Toys Inc. wants to lure back customers who have not purchased any of its products for a while. Click here to download the database with customer demographic information and transaction data.

Tasks:

Perform a Join operation on the tables tbl Customers and tbl Orders.

Develop a query to generate a report on customer transaction data.

Provide an analysis on customer behavior.

Provide a strategy to get customers back to the local Play Around Toys store.

Submit your answers, in minimum of 250 words, in an MS Word document.

Submit a copy of the updated database

Ok I need some help here, I have never used Microsoft Acess before. I really don't know what I am doing, if someone can please help me.

tbl Customers Customer ID Last Name First Name Address City State Zip 1000 Finley Jane 1 Main Street Indianapolis IN 46239 1001 Smith Scott 2 Main Street Greenwood IN 46140 1002 Thompson Dave 3 Main Street Indianapolis IN 46214 1003 Scott Ken 4 Main Street Carmel IN 46032 1004 Davidson Mike 5 Main Street Indianapolis IN 46250 1005 Jones Dana 6 Main Street Indianapolis IN 46278 1006 Davis Gina 7 Main Street Carmel IN 46032 1007 Foley Sue 8 Main Street Indianapolis IN 46227 1008 David Rose 9 Main Street Carmel IN 46032 1009 Rush Sara 10 Main Street Indianapolis IN 46268

Explanation / Answer

i think you need to prepare a statment based on expendituer wise. with the given information we can not proceed. we need some more information. you may missed anything, please check once comletely.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.