Access Payables Seminar Coming
By Richard Rost
10/28/2010 3:05:32 AM
I'm almost finished with the next new Access seminar. This seminar will cover accounts payable (paying your bills) for small business and personal use.
It will show you how to track multiple payees (vendors, people you pay money to), each having multiple bills (or invoices). You can place payees into categories (rent, utilities, advertising, etc.). You can enter single or recurring bills and have the database remind you when they need to be added.
You can track multiple payments on each of those bills (to know when the bills are paid). And of course, you can print checks right from the database, or at least generate a report of what payments to make online (since I personally use online BillPay for everything). And, no payables database would be complete without an aged accounts payable report, and a chart to show expenses by category by period.
There are a TON of customizations, enhancements, and other tidbits I've thrown into this. You'll learn many tricks like making dynamic SQL listbox forms with customizable sorted columns and criteria filters... and much more.
I've got some options in mind, but I'm not sure how many people are interested in these things, so I may or may not add them. Some of these topics include emailing "you've been paid" notices to vendors, calculating discounts on terms (such as 2%NET10), and so on. If anyone feels strongly about these topics (or can think of anything else I missed) please feel free to reply here.
So far I've got 24 lessons recorded (about 4 hours of video). I've probably got another hour or two of material to record, and then package it up. Full screen shots, a database walkthru, and a sample copy of the database will follow. This is just to let you know what I've been working on. I hope to have it ready for release by this weekend.