Access Database Project
$250-750 USD
Πληρώθηκε κατά την παράδοση
We need to create some queries in Access that pulls data, similar to a VLookup in Excel. We have four Excel spreadsheets that need to be converted to Access database:
1) Database with Zip Codes and Metro Areas
2) Database with Household values connected to different Groups (Group A, Group B, etc) in their respective zip codes.
3) Database with the behaviors associated with each group.
4) Database with Groups and their associated Demographics.
Database 1 Columns = Metro, Zip
Database 2 Columns = Zip, Group #, Group Household Value A, Group Household Value B, Group Household Value C
Database 3 Columns = Group #, Group Behavior
Database 4 Columns = Group #, Age Range, Income, etc.
Objectives:
1) Our primary objective is to be able to enter in a list of zip codes/metro areas and group specifications (e.g. 84889, 44492, 29922; Group D, Group Z) and return the Household values for those groups in those zip codes.
2) Additionally, we would like to be able to query the Group behaviors associated with their Household values.
3) We would also like to be able to input demographic filters (e.g. Age: 25-35, Income: $25K +) and return the Groups that have those demographics.
Conclusion:
This should be a relatively quick project, a 2-5 hours at most, since we have all of the Excel spreadsheet ready to roll.
Ταυτότητα Εργασίας: #1192926
Σχετικά με την εργασία
53 freelancers κάνουν προσφορές κατά μέσο όρο $283 για αυτή τη δουλειά
Hello I am a very experienced MS Access developer with more than 17 years of daily experience and can create a very nice MS Access application for the analysis of your demographic data. The Data Analysis area wo Περισσότερα
Hi, I am ready to start work on this project. Using high speed internet connection. Interested to work with you long term. Very good command on access DB programming.
Hi I have spent many years analysing Excel data using Access and have 15 years experience in Excel and Access programming and design. Please see my attachment in my private message for my bid details. Thanks.
Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly Περισσότερα
Hello I am working with MS-Access for the past 10 years. I am ready to start your project right now. Have completed a good no. of MS-Access projects through freelancer.com. I can provide you copy of some of my previ Περισσότερα
Hi, I'm an experienced, US based Access/Excel developer and would love to help you with this! Please check your PM for further details.
Hi, We have expertise in databases specially MS Access. We can do this project. Please provide your excel files. Regards!