Find Jobs
Hire Freelancers

Access Database Creation from a Census Excel Spreadsheet

$30-250 USD

Completed
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 2007 Database. A sample spreadsheet with two columns is attached. Please review before placing a bid. 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. I will not select anybody bidding more than $100.
Project ID: 584369

About the project

23 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
Awarded to:
User Avatar
Good Afternoon. I can get started right away. Please check your PMB. Thank you for the consideration. Best Regards.
$100 USD in 3 days
5.0 (14 reviews)
4.2
4.2
23 freelancers are bidding on average $77 USD for this job
User Avatar
Please refer PM for details.
$100 USD in 3 days
5.0 (52 reviews)
6.0
6.0
User Avatar
I can deliver the dump if chosen
$60 USD in 2 days
5.0 (10 reviews)
5.2
5.2
User Avatar
Hello, Please check PM
$80 USD in 2 days
4.9 (20 reviews)
4.8
4.8
User Avatar
Hello Ready to start right now. Please see your PMB for details. Thanks
$75 USD in 3 days
4.8 (29 reviews)
4.7
4.7
User Avatar
Respected Sir, Please see PMB for details. Regards, Farrukh Rehman.
$100 USD in 3 days
4.7 (18 reviews)
4.5
4.5
User Avatar
Dear Sir, I would like to do this task for you. Check PMB for negotiation. Waiting your reply. Thanks for your time
$100 USD in 2 days
5.0 (7 reviews)
3.2
3.2
User Avatar
I can provide the interface in Ms Access to import the data to MS Access. I've done data import before. Thanks, John
$80 USD in 4 days
5.0 (1 review)
2.7
2.7
User Avatar
Hi, Check PM. Thanks, Sumeet.
$60 USD in 0 day
5.0 (1 review)
1.0
1.0
User Avatar
Please check PMB
$70 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please check PMB . Thanks..
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I'm ready for this job.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I am bidding with sincelry & honestly for purpose of working and earning for my family. I assure you that if you will give a chance to work that it will be the best choice of your to make long terms relations. Thanking & Regards. Asif Majeed
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is lot of work and can't be done for $100. Please select me if you can give $200
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already worked on this kind of small project in mnc. Thanks.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do your project chandrakumara
$40 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
ATENTION THIS PERSON DONT PAY HE OR SHE ASK ME TO PUT ALL THIS DATA IN AN EXCEL FILE VERSION 2000 AND DON'T PAY I'LL STILL WAITING FOR MY MONEY SIR OR LADY!!!! I HAVE A BABY AND I REALLY NEED THAT MONEY SO DON'T FUCK OFF HONESTY PEOPLE
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Please let me know when we have to start working on this project
$30 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hello, I can definitely do this job; I work full-time as a database analyst using Access and Excel, so this should not be an issue at all. Let me know if you have any questions. Thanks.
$80 USD in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
It's easy job. I am working in this field for a long time.
$70 USD in 7 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.