In Progress

Microsoft Access Database with Report Generation

I need the attached Excel file to link into an Access Database. Lets have the excel file saved on the desktop so that when Access Database is sent to me, I can simply save the excel file on my desktop so the linking is in place. As you can see, there are 7 tables in excel that should each link into Access as a table.

From there, I need a report created ONLY for the city of Austin with the following filters. Once Austin is done, I can simply make a copy of the report and link it to the other city tables.

Zip Code – Select one or multiple

County – Select one or multiple

Submarket – Select one or multiple

Type – Select one or multiple

Asset Class – Select one or multiple

Units – Select Range - =<, =>, or between a set range (e.g. 100 to 200)

Avg. – Select Range - =<, =>, or between a set range (e.g. 650 to 900)

YOC – Select Range - =<, =>, or between a set range (e.g. 1980 to 1989)

Sale Date – Select Range - between a set range (1/1/2016 to 6/30/2016)

Sale Price – Select Range - =<, =>, or between a set range (e.g. $1,000,000 to $5,000,000)

/Unit – Select Range - =<, =>, or between a set range (e.g. $75,000 to $100,000)

/SF – Select Range - =<, =>, or between a set range (e.g. $45 to $100)

Would like to be able to drill down by selecting more than one criteria (e.g. Asset Class and Sale Price).

Once this filter is setup, I would like to choose fields to show in a report. The report would look like the attached PDF file without any pictures of the property or the map. It will show every field in the excel file. I want the report to look very similar to the attached as many fields are the same.

Skills: Excel, Microsoft Access

See more: i need an access database, city of austin, asset link, lawyer database access microsoft, database invoice microsoft excel access, database shop microsoft access, sample php script report generation mysql database, census database access microsoft, chemical inventory database access microsoft, access microsoft money 2004 database, design recycling database system microsoft access, asp form microsoft database access, simple database student microsoft access, image database access students report size, chemicals database access microsoft access, database access report, report generation mysql database freeware, database projects microsoft access doc

About the Employer:
( 40 reviews ) Chicago, United States

Project ID: #11077316

Awarded to:

arranmercer

Hello, I am a certified Microsoft Office Specialist who works full time as a data analyst, specialising in Access and Excel. I have created many reports and databases, with search forms which operate in the same More

$111 USD in 1 day
(0 Reviews)
0.0

14 freelancers are bidding on average $122 for this job

$100 USD in 3 days
(168 Reviews)
6.8
beltran0404

Hello, I would like to help you in this task. I can work with excel and microsoft access. Please contact me by chat and then we could discuss better your project. Looking forward to hear from you soon! Kind regards More

$100 USD in 5 days
(23 Reviews)
3.8
jennalynferanil

Hello there, how are you? I am very interested in doing this project and can start working on it after being awarded. Hoping to hear from you and may you have a great day ahead. Thank you :)

$200 USD in 5 days
(12 Reviews)
3.8
istiyaqueahmed

# I have lots of experience in this sector. # I have worked for many Clients before on other platforms. # I am there with an uninterrupted Internet connection. . let’s start right now.

$88 USD in 4 days
(9 Reviews)
3.3
timnorton74

Good afternoon. I am an advanced Access/Excel developer who would be more than pleased to deliver the solution that you require. I have all kinds of experience creating systems that are interactive between different More

$155 USD in 3 days
(6 Reviews)
3.0
masud4096

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Excel Access PowerPoint Data Processing Data Collecting (Using Macro) MS Office C++ HTML VBA Macro Automa More

$125 USD in 3 days
(4 Reviews)
2.7
faysalmehmood

hi consider me please, i am expert in ms access and able to do your [url removed, login to view] let me do.................

$100 USD in 1 day
(0 Reviews)
0.0
AleenaIlyas

Hello, I have understood your requirements very well. I propose to complete your project with perfection right on time. Review and use the available description and resources in order to complete this project. I ca More

$155 USD in 3 days
(0 Reviews)
0.0
ivettej83

I am a highly-trained working virtual assistant. I am aware that business owners such as you already have a full plate, so I am here at your service to take care of admin and repetitive tasks for you. This way, you can More

$222 USD in 3 days
(0 Reviews)
0.0
zubairikram248

i am a expert in Data entry and excel work .so please contact me for more details..thank you so much

$30 USD in 3 days
(1 Review)
0.0
CloudLogics

Hi I am expert in Linking Excel and Access. And creating reports for the required filters. Ready to start. s k y p e [url removed, login to view] Thanks

$55 USD in 3 days
(0 Reviews)
0.0
GraphicsKing16

Hello I have got your job post. For your kind information I want to let you know that I have been working with these types of works for more than 8 years. I am working with the design team of GraphicsKing. For the pa More

$30 USD in 1 day
(0 Reviews)
0.0
UsamaNazar

I have great experience in access. First I will show you my past work then we can [url removed, login to view]

$111 USD in 1 day
(0 Reviews)
0.0
$250 USD in 3 days
(0 Reviews)
0.0