Access Database Project

已关闭 已发布的 Sep 2, 2011 货到付款
已关闭 货到付款

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.

Excel 微软Access

项目ID: #1192926

关于项目

53个方案 远程项目 活跃的Oct 7, 2011

有53名威客正在参与此工作的竞标,均价$283/小时

rhomeu

MS Access expert here. Please check my profile. Thanks!

$250 USD 在0天内
(40条评论)
6.5
svet63

Excel/Access developer since 1997. Can do. Regards, Svet.

$450 USD 在3天内
(48条评论)
6.2
jhaynes75

Professional software developer with over 11 years experience. Please see PM.

$375 USD 在3天内
(29条评论)
6.1
HussienSharaf

Hi, I m the best Access Expert. Plz check demos of my work in the PM Hussien Sharaf

$250 USD 在2天内
(31条评论)
6.0
kulhanekd

I can do this for you. 15 years experience with access. Thanks Donna

$450 USD 在15天内
(37条评论)
5.8
Krusche

Access and Excel professionals here. Please check the PMB for the details.

$250USD 在1天里
(26条评论)
5.6
tootwotrue

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 更多

$300 USD 在5天内
(6条评论)
5.4
spawar

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.

$300 USD 在3天内
(13条评论)
5.3
VBAWhizz

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.

$350USD 在1天里
(8条评论)
4.9
srinichal

I can deliver the Code for the same in .net

$275 USD 在5天内
(3条评论)
4.6
simplicityq88

Dear friend please refer to your PM for more details.

$250 USD 在4天内
(28条评论)
4.4
frehmanpk

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 更多

$250 USD 在0天内
(18条评论)
4.5
KellogITSolution

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 更多

$250USD 在1天里
(25条评论)
4.5
TCar

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.

$275 USD 在5天内
(6条评论)
4.2
eperfections

Hi, We have expertise in databases specially MS Access. We can do this project. Please provide your excel files. Regards!

$250 USD 在2天内
(13条评论)
4.1
abbie3290

I am expert in database. I can do this work as per your time constraint.

$250USD 在1天里
(16条评论)
3.9
PerfectSquare

Simplest, get right now no need to waste time Thanks

$250 USD 在0天内
(24条评论)
3.9
mb01a

see pm please

$400 USD 在5天内
(1条评论)
3.4
jyotiranjanca

Can be done perfectly. Please check PM for details.

$250USD 在1天里
(5条评论)
3.0
counterpuncher

For your consideration... Thanks.

$300USD 在1天里
(4条评论)
3.0