Keeping a good track of inventory is vital to any sales business and many chose to hire professionals to create an inventory database for them. MS Access, however. Basic MS Access Business templates contain everything from employee information and schedule to client information and orders. Especially targeted. Just note here that a 'PO system' is a very broad term, and can encompass (or exclude) many things. (Orders, Quotations, Billing, Commissions, discounts, Inventory management, Shipping, CRM.etc) So you may have to 'sit up' and provide a few more specifics.;-) Remember that you might also want to look into an off-the-shelf product. A fully functional PO system is a challenging proposition to create, even if starting with a template. So unless you needs are now (and forever will be) simple, you may want to just buy something and avoid all the headaches associated with developing this on your own. Creating this for the web is even more complicated. If this is your ultimate need, then you should really consider making the move to SQL/.Net.or some other similar technology. Access no question. This is a natural for a relational database and Excel is not a relational database. Access has an order entry template that would make a good starting point. Hope this helps, Scott P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries Hope this helps, Scott Blog: Microsoft Access MVP since 2007. I am wondering the best way to do this: I am an office manager and do order entry for the business. I want to be able to input all the SKUs, description and prices into a program. Then when I am in the order form (an Excel sheet) I would like to be able to pull up the Sku and all the coordinating info quickly and input it into the order form. Is this doable? What would be the best way to do this? Put the data into Access or Excel? Db´¯`.¸>-)))º> ´¯`.¸>-)))º> share the nirvana mann Status - Off line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |