We are looking to have a database created that will help track sales by product (about 30 products) as well as compare other imported data. This database should be able to have the following information imported/entered through a user friendly interface. We are looking for someone that has worked on this type of database, and may have suggestions.
Items to be imported/entered into database:
• A user friendly Main Menu as well as other forms/menus. ITEM 1
• Customer tracking - phone calls and showroom visits/day period See Attachment ITEM 2
• inquiries and how did you hear of us/week period - this is to be entered by a staff member through a form. See Attachment ITEM 2
• Sales data from quickbooks imported with customer data? using ODBC connector? this will be imported every week. See Attachment ITEM 3
• Print Campaigns (newspaper ads, kijiji ads, craiglist ads, etc..) that we are running entered on a weekly bases. See Attachment ITEM 4
• Google site analytics imported, such as web site visits, referral sources etc.
• Google adwords information, such click through rates, cost, etc..
• Facebook information such as visits, new likes, etc…
What we're trying to accomplish:
• Seeing how our campaigns are relating to individual product sales and inquiries, and web traffic.
• See what days are the busiest at the showroom per time period example: year over year are Mondays always the busiest?
• All graphs/charts time frame selected from date pickers
• Sales per product compared with showroom visits/inquires/campaigns
• Other various charts/graphs/print-outs to be determined.
Please Review the attachment for examples of data to be tracked and entered. Please give a detailed explanation on the work you propose for the project.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Cincinnati, United States
Freelancer group of developers with a mission to provide Quality IT solutions at affordable price to small and Medium scale enterprises. for more info visit our website www.angulartechnologies.com
SKM Systems Software development since 1996 Providing professional, reliable and efficient software.
I am an expert on programming. ASP.net C#, MS SQL, IIS, MS ACCESS, Pic programming etc.
As a technically proficient Project Manager/Systems Engineer, I am able to envision the end product and how it will be used. This big picture understanding ensures that the end product meets the needs of my client, and exceeds their expectations as well as those of their customers.
Please take a look at below 2 (two) demo, in that we have all requirements fulfilled. You can access this application through Tablets/Smartphones(iPad/iPhones) and obviously with any computer. A Dentist Financial Projection System with Analytics( Graphs and Charts) Username/Password: mi/mi ************************************************ A Order Management System, Maintains Purchase Orders, Items Inventory, Maintains Suppliers, Generate Purchase Orders in PDF format, Send Purchase Orders and many others..... This is Order Management System, please look on Purchase Orders Login for Purchase Order Manager with only Purchase Related Access, please look on Purchase Orders Username/password : purchasemgr1/mi Login for Order Management System Administration with all Access Username/password : omadmin/mi Looking forward to hear from you soon
Experienced application developer using VB6, VB2008, VB2010, VB2013, MS Access, MS SQL, MySQL Databases
I'll stay with you until you're completely satisfied...even after your project is finalized!
am expert vba developer using various office Applications including excel, word, access, powerpoint, etc. also do automation in autocad using vba. Also develop application using Visual Basic. Can be useful for you for all your automation solutions.
Martham, United Kingdom
We pride ourselves with the high quality work we produce. We have taken companies like Mattressman and increased their yearly profits by stream lining the infrastructure.