Play Around Toys Inc. wants to lure back customers who have not purchased any of
ID: 442468 • Letter: P
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 46268Explanation / 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.