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: #1379097
About the project
Awarded to:
40 freelancers are bidding on average $362 for this job
I have over 15yrs programming experience mostly in VBA and MS Access. Am giving more details in PM - thanks in advance
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
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.
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
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
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.
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
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.
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
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