From the course: Access: Building a Sales Database
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Product price list - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Product price list
- [Instructor] A product price list is a really handy report to have on hand. It's also something that you can customize for individual customers to send them a price list just for the things they want to buy, so you can use this in many other ways, so having built the base report is a good step to take. Now, you can include cost information in the main version that you use. Obviously, you won't include that when you customize this for a customer. But you can include the cost and retail price information, because you can also insert calculations that determine your net on your products, by subtracting your cost from your price. This isn't a real profit analysis, because there are more factors involved in calculating that, but it does give you the margin you're taking per item in your inventory. Alright, so we're gonna base this on the products table, and because we're only pulling from one table, and we want a simple layout, again, we can use the Report Wizard. A lotta people think…