Database Design - MS Access
$250-750 USD
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.
Project ID: #1391165
About the project
39 freelancers are bidding on average $360 for this job
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.
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
Hi jjrangelmx, I have 23 years msAccess development experience, and can provide this Payroll project for you. Regards, Gerry
Will be pleased to do this assignment, will ensure you are satisfied with my completed work.
Long-time Access database application developer now in retirement. I believe I can provide exactly what you're looking for in a timely manner.
Dear Hirer, I have gone through the project details and I can start immediately. Please see inbox for details. Thank you.
Hello, I have made many very similar tools in MS Access and I can create a simple and reliable database program for you.
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.