Hello, I'm new to these forums and please excuse me if I am not posting in the right area, but I have a few questions about access and whether it would be effective to use it for what I need.
I work for a business that wants to create a database to track quotes and purchases from customers. We offer a variety of machinery, and I want to keep track of the multiple quotes and invoices we've made.
I can't tell if it would be better to use Access or Excel for this. I want to be able to list all of the companies who we sell to, and be able to click on a given company and see our quotes with them and our invoices with them in two different columns. Some companies have more invoices or quotes than others, and i'm not sure if I can create multiple lines or organize the companies in a way where it's easy to see the multiple quotes and invoices we have with them. I would also like to individually date the quotes/invoices, and i'd like to find a way to sum up the dollar amount of the quotes/invoices for every company.
Perhaps this program isn't the best choice, and again I am very sorry if this is a bad place to post this, I just really don't know where the best place to turn is. ANY advice or guidance is GREATLY appreciated.