Database Design - MS Access

In Progress Posted Jan 9, 2012 Paid on delivery
In Progress 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 SQL Visual Basic

Project ID: #1379097

About the project

40 proposals Remote project Active Jan 17, 2012

Awarded to:

BenjiKRo

Hello, I’m ready to do this job for you

$250 USD in 10 days
(0 Reviews)
0.0

40 freelancers are bidding on average $362 for this job

torajiv

I have over 15yrs programming experience mostly in VBA and MS Access. Am giving more details in PM - thanks in advance

$300 USD in 5 days
(159 Reviews)
6.8
jhaynes75

Professional software developer with over 12 years experience. Please see PM.

$450 USD in 5 days
(31 Reviews)
6.1
fedalal2

Hi, I have more 10 years experience in MS Access and SQL Server, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$400 USD in 5 days
(34 Reviews)
5.5
Krusche

Working with MS Access Database queries and macro's is one of our core specialties. Our solution offering includes user-friendly and well organized reliable application. Please check your PMB for more examples.

$360 USD in 7 days
(27 Reviews)
5.5
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

$700 USD in 30 days
(5 Reviews)
4.9
kulhanekd

I have 15 yeras experience in access design I would like to bid. Donna

$400 USD in 15 days
(36 Reviews)
5.8
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c More

$250 USD in 7 days
(35 Reviews)
4.9
VBAWhizz

Hi,I am a professional database developer using SQL Server and Microsoft Access (all versions). Please see PMB for an attachment with futher details of my bid. Many thanks Melanie

$400 USD in 7 days
(9 Reviews)
4.8
rbenfield

Hi there, I'm a UK-Based Professional Microsoft Access Developer and Microsoft Certified systems Engineer. I've been building bespoke Access database solutions for over 15 years. I have built similar systems i More

$380 USD in 7 days
(10 Reviews)
4.6
PerfectSquare

Hi I am database designer with experience in sqlserver and ms access I have lot of experience in similar work I can design the database and the report you required.

$250 USD in 1 day
(28 Reviews)
4.2
ifaisal

Hello I can do this for you. I have expertise in MS Access and SQL Server and has done many similar projects. Last project I did was to a client in USA who had stock trading data and data was imported into the sy More

$250 USD in 7 days
(7 Reviews)
3.8
waleedobeidat

i have 21+ years exoerience developing databases.

$750 USD in 21 days
(1 Review)
3.0
gutenmorgen11

Hi. I'm ready to start. Please check Pm.

$250 USD in 5 days
(3 Reviews)
1.0
stalker2011

I am 4+ experiences software developer and can do it for you

$250 USD in 3 days
(1 Review)
1.0
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

$400 USD in 14 days
(1 Review)
1.0
LeedsITSolutions

An Access application (frontend) running against SQL Server database (backend) is a fairly common configuration for business users. I am also familar with your requirement as I have completed some similar work for a pa More

$500 USD in 7 days
(1 Review)
1.0
essevren

I can do that for you.

$250 USD in 1 day
(0 Reviews)
0.0
Hansulet

The project is very simple for me. I am usually working with pdf, word and excel. I made many documents and databases that are frequently used in may daily work by me and my team. I respect all my deadlines.

$250 USD in 1 day
(0 Reviews)
0.0
takitsolutions

Hi there, I am a London based professional db developer and ms access gur and am absolutely sure I can deliver you the task in a very short time and am looking forward hearing from you. Regards

$375 USD in 1 day
(0 Reviews)
0.0
briansteffens

Usually it's best to keep all of your data in the same database, as it makes management and reporting much simpler. If designed correctly, an Access database can handle a surprising amount of data at once. I'd be inter More

$600 USD in 6 days
(0 Reviews)
0.0