Access Database Creation from Excel Spreadsheet

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.

Skills: Excel, Microsoft Access

See more: database creation excel access links, we excel, top query, southern proper, microsoft excel spreadsheet, link list in data structure, linked list in data structure, linked list data structure, i need an access database, excel sites, data structure topics, data structure link list, data structure linked list, covering letter example, basic of data structure, access database creation, microsoft links, how to microsoft excel, how to master excel, master excel, two letter, table creation, spreadsheet microsoft excel, san francisco, query creation

About the Employer:
( 6 reviews ) Austin, United States

Project ID: #580955

33 freelancers are bidding on average $98 for this job


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
(31 Reviews)

Hi, please view my PM, thanks.

$200 USD in 4 days
(48 Reviews)

At your service. Kindly check PMB for details.

$135 USD in 7 days
(20 Reviews)

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD in 0 days
(27 Reviews)

Good Evening, Please check your PMB. Thank you for the consideration. Best Regards.

$100 USD in 2 days
(14 Reviews)

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
(13 Reviews)

please see the PMB

$200 USD in 14 days
(2 Reviews)

It can be done with very high quality of work. refer to PM.

$30 USD in 0 days
(4 Reviews)

Hi Sir, Please allow me to take this project. Please check my PM for more details. Regards Varun Sharma

$100 USD in 3 days
(4 Reviews)

Ready here...! Expert..Let's Start.....!

$50 USD in 1 day
(8 Reviews)

hi, My bid is less than 30 but I can not enter 30 in the amount. So I can do one more job for same project

$30 USD in 2 days
(2 Reviews)

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.. More

$100 USD in 5 days
(1 Review)

i can do it, please see my pm

$30 USD in 10 days
(2 Reviews)

I would like to take up the project

$30 USD in 2 days
(2 Reviews)

Ok. The FrontEnd is Microsoft Excell, and the DB MSAccess.

$150 USD in 5 days
(0 Reviews)

have done several projects in access, will get it done to ur specifications!

$200 USD in 15 days
(0 Reviews)

Greetings! Please see my entry on the Project Clarification Board. Thanks, Randy

$250 USD in 7 days
(0 Reviews)

Respected Sir, With reference to the your website I am Ready to do the online work Sir I am having computer with Broad Band Internet connection I have completed Diploma in computer Science and Engineeri More

$91 USD in 3 days
(0 Reviews)

pls chak p

$30 USD in 1 day
(0 Reviews)

I have been doing this for 10 years. I can turn it around fast and accurate. I'm reliable and experience. It's very important to setup the table structure correctly to ease the future maintenance issues.

$85 USD in 0 days
(0 Reviews)