Find Jobs
Hire Freelancers

Access Database Creation from Excel Spreadsheet

$30-250 USD

Cancelled
Posted over 14 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 580955

About the project

33 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $98 USD for this job
User Avatar
hi, i m the best DB expert. I will provide u a very dynamic tables structure and friendly GUI Hussien Sharaf
$180 USD in 4 days
5.0 (31 reviews)
6.0
6.0
User Avatar
Hi, please view my PM, thanks.
$200 USD in 4 days
4.4 (48 reviews)
5.4
5.4
User Avatar
At your service. Kindly check PMB for details.
$135 USD in 7 days
5.0 (20 reviews)
4.7
4.7
User Avatar
Hello Ready to start right now. Please see your PMB for details. Thanks
$30 USD in 0 day
4.8 (27 reviews)
4.5
4.5
User Avatar
Good Evening, Please check your PMB. Thank you for the consideration. Best Regards.
$100 USD in 2 days
5.0 (14 reviews)
4.2
4.2
User Avatar
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 in 1 day
4.9 (13 reviews)
4.0
4.0
User Avatar
please see the PMB
$200 USD in 14 days
4.2 (2 reviews)
3.9
3.9
User Avatar
It can be done with very high quality of work. refer to PM.
$30 USD in 0 day
5.0 (4 reviews)
2.6
2.6
User Avatar
Hi Sir, Please allow me to take this project. Please check my PM for more details. Regards Varun Sharma
$100 USD in 3 days
5.0 (4 reviews)
2.4
2.4
User Avatar
Ready here...! Expert..Let's Start.....!
$50 USD in 1 day
5.0 (8 reviews)
2.1
2.1
User Avatar
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 in 2 days
5.0 (2 reviews)
2.0
2.0
User Avatar
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 in 5 days
5.0 (1 review)
1.8
1.8
User Avatar
i can do it, please see my pm
$30 USD in 10 days
5.0 (2 reviews)
1.8
1.8
User Avatar
I would like to take up the project
$30 USD in 2 days
5.0 (2 reviews)
1.0
1.0
User Avatar
im ready for that please count me in
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am confident of doing your project.
$150 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Respected Sir, I can do this work very easily so please give me a chance for prove to me.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
It will be my pleasure to have this project
$70 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i will complete the project within 25 days for 60 US $
$60 USD in 25 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Austin, United States
5.0
6
Member since Dec 31, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.