In Progress

Moving from Excel/Word to Access DB

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!

Skills: Microsoft Access

See more: what is a computer programmer, what are databases and what are they used for, seasonal work, need of excel programmer, me excel, how to contact a programmer, how to be a computer programmer, excel to application, computer programmer work, computer programmer training, computer programmer information, computer programmer info, computer programmer application, a computer programmer, moving from, is into one word, which word, payroll process in excel, payroll how to, payroll business, how to payroll, business payroll, word to, seasonal, save to excel

About the Employer:
( 1 review ) Monticello, United States

Project ID: #1147986

Awarded to:

florinserban

Hi, please check PM for details. Thanks!

$120 USD in 5 days
(14 Reviews)
4.3

36 freelancers are bidding on average $181 for this job

torajiv

VBA expert with the exact expertise you are looking for at your service. More detailed offer in PM Thanks

$150 USD in 7 days
(89 Reviews)
6.2
kulhanekd

I have 15 years exp in access design. I would like to bid on your project. Thanks Donna PS There are 0 attachments.

$200 USD in 10 days
(34 Reviews)
5.8
jeanek

Hello. I have a BSc. Computing degree from the United Kingdom and over eight years of professional (IT) work experience where I developed databases with various versions of Microsoft Access and extensively used MS Exce More

$200 USD in 20 days
(5 Reviews)
4.9
Krusche

Hello. This is a very challenging VBA project for us. Please notice that we have strong background in this field and can provide German quality both in terms of technical and time frame issues. For more examples check More

$240 USD in 4 days
(7 Reviews)
4.9
instech

12 years of Access/VBA development experience. Bid details, suggestions and sample in the PM.

$220 USD in 3 days
(7 Reviews)
4.8
MattThrower

I have over 8 years of experience of MS access development and have completed similar projects.

$150 USD in 10 days
(9 Reviews)
4.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

$110 USD in 7 days
(26 Reviews)
4.6
braghunath

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]

$540 USD in 30 days
(3 Reviews)
4.1
ExactSystems

Please see a robust solution on PMB. regards

$250 USD in 20 days
(2 Reviews)
4.1
ifaisal

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

$200 USD in 7 days
(6 Reviews)
3.7
MichalBayer

Offer details in private message.

$200 USD in 7 days
(4 Reviews)
3.5
gerrymwalsh

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.

$225 USD in 15 days
(1 Review)
2.4
DenBorg

I am very interested in your project, and I am highly qualified. With over 22 years experience in database and application development experience, 20+ years of which is with MS Access, I can deliver a great program More

$250 USD in 20 days
(1 Review)
2.2
simplicityq88

Dear provider, I am a English native developer, living and working in Sweden. As you can see from some of my past projects I have worked with both Excel and Access and I think Access would do the job perfectly. I would More

$250 USD in 10 days
(3 Reviews)
2.0
noelmartin

Hi, I can migrate all your data for you.

$30 USD in 3 days
(1 Review)
1.3
primasoft

Dear Sir, Please refer to my PM for further detail. Thank You Primasoft

$200 USD in 5 days
(1 Review)
1.0
GlobalTalent

Please see PMB for details. Thanks.

$100 USD in 4 days
(0 Reviews)
0.0
mwilliamson8

Thanks for your consideration.

$200 USD in 3 days
(0 Reviews)
0.0
adanpradan

We have done many projects in Access and we are bidding for $150 to be completed in 15 Days.

$150 USD in 15 days
(0 Reviews)
0.0
nelson1812002

I have over 28 years' as a technical writer, developer, and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. I would like to be More

$200 USD in 7 days
(0 Reviews)
0.0