I run a seasonal entertainment business in the summer and I'm looking to change the process of how I manage the information to move it all to Access databases with a front end menu to greatly decrease the amount of work I need to put into it.
Here are some details of what I'm envisioning. I am open to suggestion; these details are based on how I currently go about entering data into various Excel and Word documents.
Main menu with button options to add player contact info, event info (date, time, location, etc), assign players to events, generate pay stubs. Application needs to track player contact information, event information, which players performed at which events, how much they were paid per event, and how much they earn for the season. Pay stubs are generated from this information - listing the events performed within the pay period, how much was earned for each event, and the total they made for that period.
I have all of this information spread across several Excel and Word documents and am looking to streamline the whole thing so everything is in one place, plus I can save myself a lot of work when doing payroll. I can send these files along with a few more details. I am not particular about how many databases are used or how the info is stored or linked. For that matter, it doesn't even have to be Access; it just seemed to make the most sense to me. I'm also perfectly ok with reusing some of these files (such as the invoice file) if there is a way for the data to be sent directly to the invoice and calculated without having to enter it manually.
Attached are all the files I use, except File Explanations, which goes into detail on the rest of the files as to how I use them and how they're related.
I don't have any formal training in Access or Excel but I'm a computer programmer so I understand the logic and I do know enough about Excel to at least understand how to make changes. I also understand relational DBs pretty well.
Thanks for your consideration!
Apologies - I'm not sure why it's not letting me upload the sample files. Thank you for all the responses - I'm currently reviewing and will be awarding the project soon!
36 freelancers are bidding on average $181 for this job
Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]
Hello I can do this for you. I am an expert in MS Access and has developed many application on this platform. Please see my Private message for more details. Regards Faisal
Hi, This looks like an interesting project. I have over 20 years development experience, and have developed a wide range of systems using Access. I would be happy to convert the sytem to access for you.