Newcomer to forum and access, have a question

[kmccann84]

Hello all,


I am new to this forum as of today, and I am just starting to work with Access. I am here because I working for a trucking company. I am their service manager. Currently they have no digital system for parts or inventory and really have no idea where anything is. I was searching about and came across Access. I am not fully familar with it's capabilities. I am planning on self teaching my self. Now one thing we would like to be able to do is to track the cost of purchasing parts. Specifically we want to be able to track when an item was last purchased and at how much. So say we buy a part 3 times over the course of 6 months. We would like to be able to see when it was purchased and how much it was purchased for each time. Is this something that you can do in Access? Also if it is something that could be done could you give me a quick rundown of how the table, or tables would look like?

Thank you for your help in advance and I appreciate any input received.

[davmec93]

Hi, welcome to the site and to Access.
I think that your scenario would be a great candidate for Access. My suggestion would be for you to go through the templates and see if there is something that would be a great start for your project. Access has several templates that are great to use and then modify them for your own use. There is a template called Desktop Product Inventory Database and think it would be a good place for you to start. Check it out and let us know what you think.

[ItsMe]

If you want to know the history of a part, you might want to know info about where it was purchased from too. Inventory systems are not simple. Since you will likely want to track relative vendor info with your part, I would probably start with a Vendor database. This way, you can start to track your parts from the time of purchase via a purchase order. PO's make it easier to add stuff to an inventory system. I would build the inventory part last or at least after I had a vendor DB.

You will want to start by creating a model
http://www.youtube.com/watch?v=-fQ-bRllhXc

Here are other tutorials
https://www.accessforums.net/tutoria...ase-45451.html

[SSgtBarry]

Welcome and good luck with the Trucking Company! I worked in a small trucking company for about 9 years. I have made many modules in access (databases). Most all of my experience was in MS Access 2003. I am now learning the 2010. The data base you are inquiring about would be very simple. You would want to insure there is a "Vendor Company Name" field, a "Vendor Contact" field, a "Contact Phone" field, a "date purchased" field, a "Nomenclature" field, and "Cost" field, just to name a few. I have been out of the database scene for about 4 years but with the help of these nice forum folks, it is slowly coming back. Gook luck~