Find Jobs
Hire Freelancers

Access Database Creation from Excel Spreadsheet

$30-250 USD

已取消
已发布超过 14 年前

$30-250 USD

货到付款
I have an excel spreadsheet with US Census data for approximately 900 metropolitan areas, and I need the information converted to a Microsoft Access Database. The spreadsheet is attached. The spreadsheet has the city information as columns instead of rows, and each contain several datasets. For example, each city has datasets, labeled in the lighter green, covering numerous topics such as populations and employment data. This data will be used later on to link with a variety of content, to link content with a variety of information on different geographic regions. I need an Access DB that can house this information. The main tables will be to establish structure, and provide the linking functionality. A table to the States, a two column table with the proper name and the two letter abbreviation. A table of cities, located in the dark green, at the top of the excel document. This table will include the city name, the state, and the Census classification. There will also be three optional fields for “subcities.” There are a few city areas that will have two states selected, these cities will need to come up under searches for both states. I will be importing lots of data, and I need some tables to manage how everything links up. For example, some sites might list San Francisco as San Fran., San Francisco Bay, SF, etc., and we need some tables to manage that. I need a table for the alternative names for the states to add in variations, so all of the records will match up under state regardless of source. I need a cities table with the same purpose. Each of the variations tables needs to allow links to multiple selections, so several entries could be created under “Southern Califonia” for example, so that record would link to all of the cities. I need data tables created as well. The datatables are included in the document and colored light green. I need a table created for each one of the headings (Basic Variables, Age: Total, etc.). The tables need to include the city and state, and have them linked to the appropriate master table. Finally, I need a query set up to identify any records that are not linked to a city or state. I am looking for someone that can get started quickly.
项目 ID: 580955

关于此项目

33提案
远程项目
活跃14 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
33威客以平均价$98 USD来参与此工作竞价
用户头像
hi, i m the best DB expert. I will provide u a very dynamic tables structure and friendly GUI Hussien Sharaf
$180 USD 在4天之内
5.0 (31条评论)
6.0
6.0
用户头像
Hi, please view my PM, thanks.
$200 USD 在4天之内
4.4 (48条评论)
5.4
5.4
用户头像
At your service. Kindly check PMB for details.
$135 USD 在7天之内
5.0 (20条评论)
4.7
4.7
用户头像
Hello Ready to start right now. Please see your PMB for details. Thanks
$30 USD 在0天之内
4.8 (27条评论)
4.5
4.5
用户头像
Good Evening, Please check your PMB. Thank you for the consideration. Best Regards.
$100 USD 在2天之内
5.0 (14条评论)
4.2
4.2
用户头像
I am Ms-Access expert developer. I have very good experience with Ms-Access 2000/2003/2007. I have completed many projects on GAF in Ms-Access & Excel skill. I will provide quick & professional service.
$40 USD 在1天之内
4.9 (13条评论)
4.0
4.0
用户头像
please see the PMB
$200 USD 在14天之内
4.2 (2条评论)
3.9
3.9
用户头像
It can be done with very high quality of work. refer to PM.
$30 USD 在0天之内
5.0 (4条评论)
2.6
2.6
用户头像
Hi Sir, Please allow me to take this project. Please check my PM for more details. Regards Varun Sharma
$100 USD 在3天之内
5.0 (4条评论)
2.4
2.4
用户头像
Ready here...! Expert..Let's Start.....!
$50 USD 在1天之内
5.0 (8条评论)
2.1
2.1
用户头像
hi, My bid is less than 30 but I can not enter 30 in the amount. So I can do one more job for you...in same project
$30 USD 在2天之内
5.0 (2条评论)
2.0
2.0
用户头像
Hi There, I am good in MS Access. I can complete you the project. I have worked on Access 2000, 2003 and 2007 as well, with a software development background. I can get the database developed with the way you want...Can start immediately.
$100 USD 在5天之内
5.0 (1条评论)
1.8
1.8
用户头像
i can do it, please see my pm
$30 USD 在10天之内
5.0 (2条评论)
1.8
1.8
用户头像
I would like to take up the project
$30 USD 在2天之内
5.0 (2条评论)
1.0
1.0
用户头像
im ready for that please count me in
$100 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am confident of doing your project.
$150 USD 在4天之内
0.0 (0条评论)
0.0
0.0
用户头像
My advice for you is php/mysql is best combination for you. And it is help ful you to for webpages. If you want then contact me
$200 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Respected Sir, I can do this work very easily so please give me a chance for prove to me.
$30 USD 在0天之内
0.0 (0条评论)
0.0
0.0
用户头像
It will be my pleasure to have this project
$70 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
i will complete the project within 25 days for 60 US $
$60 USD 在25天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Austin, United States
5.0
6
会员自12月 31, 2009起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。