Find Jobs
Hire Freelancers

Creation of new functionality for existing MS Access Database

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
I have an existing MS Access Database which is mostly functioning well. I wish to add functionality to allow each month the payroll run to be generated by appending records into a new table. The full project description is in the attached PDF document. I have an existing MS Access Database which is mostly functioning well. It is a database of our members of staff, and information about them. We are a relatively small organisation. There is one main table (Staff) with approximately 75 records and approximately 40 fields (job title, address, phone number etc). Of those 75 records, approximately 30 relate to our “Current” staff, and the rest are mostly for “Former” staff who have now left. This should be a straightforward project for someone highly skilled in MS Access, including VBA. I wish to run our payroll monthly by appending records to a new table (Payroll), the fields for which I have already created. Each month records will be appended which show the monthly gross pay for each member of staff, as well as some of the deductions. This information will subsequently be sent elsewhere to actually create the individual payslip records and work out the tax and national insurance etc. So this project has nothing to do with payroll or tax legislation or calculation – it is purely drawing on existing information within the database. Information will need to be drawn from the Staff table in order to populate the Payroll table. After the payroll run, I would like to have a form in tabular view to look at the newly created records. And I would like this form to allow me to generate a report so that I can save as PDF and send to external providers.
Project ID: 5261368

About the project

9 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
[login to view URL] I have gone through your project requirements and the pdf file.. I will do all the things you have mentioned regarding the payroll development. I will append the records for the month and year selected but will not override if already done. I will do them for the current employees only. I will also add the functionality to add for the current running month also, i.e. those employees who have become "Former" during the current month. I am ready to do communication via skype and I do speak good English. My ratings are sufficient for you to have confidence in me. I will do the project within 3 days of the award and payment of milestone amount. I will keep the things confidential. I will discuss the fields #9 and 10 in your pdf file.. Thanks for your time Regards Prashant
$155 USD in 3 days
5.0 (463 reviews)
6.9
6.9
9 freelancers are bidding on average $140 USD for this job
User Avatar
I'm an expert Access/VBA developer and can do the job for you, including creating the report. If you have Access 2010 or higher then the report can directly be saved as PDF. Thanks for considering my bid. Bests, Larry
$84 USD in 3 days
5.0 (15 reviews)
4.8
4.8
User Avatar
Dear Sir, I'm interesting on you project and i know that you data is confidential,so i wonder if you can send me a black copy from your database and the olf database that you have mentioned on your pdf file?? Kind Regards, NourElDeen
$111 USD in 7 days
5.0 (27 reviews)
4.5
4.5
User Avatar
I have 15 years exp in access database design. I have created well over 150 databses in this time frame. I would like to upgrade your databse to what you need. Donna
$155 USD in 7 days
5.0 (1 review)
2.1
2.1
User Avatar
I can help you with this job. I have big experience with VBA in MS Office and I have interested in this type of work.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello SoBAnalysis, From the pdf attached what I understand is there is an Access database of Staff and you need to append the rows in the table each tim when payroll is run and to have a form to generate a report. I need to discuss few points on this. I am intrested in working for this system. Can we have a (s k y p e) call to discuss on this further. I can provide you with the basic wireframe of the system by today. Await your reply,
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. Very skilled in Access and Excel, including VBA. Please let me know if you need additional information regarding this work. Regards.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$80 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
4.9
9
Payment method verified
Member since Mar 24, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.