Database Design - MS Access

Closed Posted Jan 16, 2012 Paid on delivery
Closed Paid on delivery

I need a database to run a few queries and create a report based on two tables. I would like to automate the production with macros that run off menus. There would be one main menu that opens when the file opens, with buttons asking to Import Data, Export Data, Run Reports. I would like to compare the file from one year to the file from another year.

I am working with some very large payroll files, thus I am somewhat concerned about size. I do have a SQL server that I can use but I need the controls to run through Access. I would want to be able to use copies of the access file to run/export payroll for separate states and compare separate years.

I have prepared prior years data manually, but I am hoping to automate certain processes. The data comes to me in multiple text files (between 1 and 4 files, each up to 800MB) that are separated by a degree (°) symbol. I need to combine all of these test files into one file, add a few columns bases on formulas, and summarize the data into a new table. I want to compare the summarized table to the prior year's summary the reports.

The queries are relatively simple - one to add a few columns to the base table based off formulas, and another to summarize the base table.

The reports I am looking for are also relatively simple - one would compare totals from the file from one year to total from the file from the other year. The other would compare certain columns of matching records from each year.

I would appreciate any ideas experienced designers have concerning the design of this program.

Microsoft Access MySQL SQL Visual Basic

Project ID: #1391165

About the project

39 proposals Remote project Active Mar 1, 2012

39 freelancers are bidding on average $360 for this job

rhomeu

MS Access expert here. Please check my profile thanks!

$250 USD in 2 days
(62 Reviews)
7.0
kulhanekd

I have 15 years exp in access design. I can do this project for you. Thanks Donna

$500 USD in 15 days
(36 Reviews)
5.9
Krusche

Working with th MS Access reports,queries based on the design background is what we are good at. Please check some of our examples in your inbox.

$480 USD in 8 days
(27 Reviews)
5.6
winghei

Hi, I see your needs and I want to help. Please see pmb for attachments. Regards, Sherwin

$250 USD in 2 days
(30 Reviews)
5.4
jeanek

Good Day. I would like to express my interest in designing your MS Access Database. I have over eight years of professional (IT) work experience, where I have worked with various versions of Microsoft Access. Please re More

$350 USD in 15 days
(5 Reviews)
4.9
VBAWhizz

I have 20 years Access and SQL exerience, Please see PMB.

$500 USD in 10 days
(9 Reviews)
4.9
MichalBayer

This looks like a fairly simple project. Also very quick to complete. I can prepare comparison of the two data sets in a very flexible way so user will be able to learn exactly of is needed in an analysis. Using SQL More

$250 USD in 2 days
(11 Reviews)
4.6
Kingpin1962

Kindly check PMB for details. Thanks...

$250 USD in 7 days
(3 Reviews)
3.8
Jacob2i

Hello, I have over 17 years of experience coding in Microsoft Access. I also have extensive experience with SQL Server, ORACLE, and MySQL databases. I have many years of programming in Visual Basic, VBA, C#, VB.Net, AS More

$250 USD in 5 days
(2 Reviews)
3.2
gerrymwalsh

Hi jjrangelmx, I have 23 years msAccess development experience, and can provide this Payroll project for you. Regards, Gerry

$650 USD in 15 days
(1 Review)
2.4
vw991322vw

Will be pleased to do this assignment, will ensure you are satisfied with my completed work.

$250 USD in 7 days
(1 Review)
2.2
iosifrn

Hello, I have over 15 years of programming experience in MS Access, SQL Server, ORACLE, C#, Visual Basic, VBA, ASP.NET, Web Development and others. I can help you with this project and any other projects you may have. More

$300 USD in 14 days
(1 Review)
1.0
KennySamo

Can do this

$450 USD in 5 days
(0 Reviews)
0.0
gwinok

I am a software programmer and fluent with microsoft Access databases, Sql Server and other programming languages. I can provide quick and expert solution for your databases project. I have several years of programing More

$650 USD in 7 days
(0 Reviews)
0.0
GlobalTalent

Please see PMB for details. Thanks.

$250 USD in 10 days
(0 Reviews)
0.0
anyAccessDev

Long-time Access database application developer now in retirement. I believe I can provide exactly what you're looking for in a timely manner.

$250 USD in 4 days
(0 Reviews)
0.0
indiadigital

Dear Hirer, I have gone through the project details and I can start immediately. Please see inbox for details. Thank you.

$265 USD in 5 days
(0 Reviews)
0.0
chaniPL

Hello, I have made many very similar tools in MS Access and I can create a simple and reliable database program for you.

$250 USD in 4 days
(0 Reviews)
0.0
katrinaef

Hi, i am an access expert. In the past i did really complex applications similar to what you want, that handled huge ammount of data, did clever search and reporting. I can easily do your project.

$500 USD in 5 days
(0 Reviews)
0.0
hussamahmed

i'll do it for u :)

$250 USD in 2 days
(0 Reviews)
0.0