Hello everyone! I'm new here but I figured I came to the right place. I do have some basic coding experience using Visual Basic but I am not familiar with any other programs.
I have a friend that does various motorcycle repairs/upgrades/builds and he asked me to help him out. When I went to his place, I realized that he was doing everything on paper. When creating a new invoice and needing the correct part numbers and prices, he pulled out an old invoice that had the same service performed on it, and I had to copy all of that information down on the new invoice. This is very time consuming and I imagine that it would be a more effective and efficient use of time if the information was stored and could be pulled up with the click of a button.
I'm thinking about creating a database and a program that would allow me to enter customers information into the system for the date(s) their bike has been serviced and each part that may have been used during that service and create an invoice for the current service. In the program, I would like to create a couple common service options that I could pull up and edit as needed, because some particular jobs call for 10+ parts to be used for that job (seals, gaskets, screws, etc.). If I could select and option from a drop-down list that would bring up all of the needed parts for that job on the invoice that would be ideal...and then I could edit/delete an individual part if needed to eliminate redundancy.
Hopefully I didn't ramble too much. I was just trying to give you an idea as to what my goal is. I have access to MS Visual Basic and MS Access. I would like to create a program that could keep all of the information as well as create an invoice. If there are any particular programs, software, applications that you think would be helpful, it would be very much appreciated.
Thanks in advance.