Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

Access Payables Seminar Coming
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email 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.

Permanent Link

Thank you Comment from Ken @ 11/7/2010
I am new to Access, and I enjoy Learning from all of your Access Seminars!  I am using Access 2010, but seem to be Learning very Much as you have led me through your Seminar Tutorials on Access.

I am anxiously looking forward to the Release of your Accounts Payable Seeminar, as that is what I hav been studying Access to create.

True, a person could use Qui ckn, but Access seems so much Powerful when desiring to Track  everything for the perposes of a Monthly Budget, and Income/Expense Profit/Loss over a long period of time.

Thanks for Creating the Accounts Payable Seminar for us to learn from!!

may you bee richly blessed.

Reply from Richard Rost:

It's almost finished. I've added a LOT more to this seminar than I initially was planning. It will help you do all of the PAYABLE part of what you're looking for... the income portion was all handled by my normal Access 101-329 classes (invoicing, accounts receivable, etc.). So if you merge the two together, you can generate profit/loss statements and such.
Show Just This Thread        Post Reply
Raw Video Comment from Brent @ 11/7/2010
That sounds good, I would love to be part of something like that.
Show Just This Thread        Post Reply
Question Comment from Brent @ 11/6/2010
Do you think you will get this siminar up this weekend, I've been checking everyday hoping to get started.

Reply from Richard Rost:

Sorry, Brent. This seminar has actually taken on a life of its own. I've added SEVERAL more hours to it than I initially planned. It's up over 50 lessons right now, and I've still got 4 or 5 more to add. I'm still working on it.

Moving forward, I was trying to think of a way to allow people to pre-buy courses that I'm currently working on. Every day when I finish recording, I could put the "raw" video up on the server so you could watch it. This way I could also get feedback from students WHILE the course is in progress, and I could address issues and questions in a following video. What do you think of this idea?
Show Just This Thread        Post Reply
Comment from Brent @ 11/4/2010
can't wait, I want to learn alot, but please keep it affordable for us unemployment people trying to maintain our bills we can't pay for. :)

Reply from Richard Rost:

I do my best to keep my courses as affordable as possible.
Show Just This Thread        Post Reply
Comment from Jimmy @ 10/28/2010
i think that it's a good ideo to make an option to send reminders to pay to microsoft outlook calander

Reply from Richard Rost:

Hmmm... I didn't think of that one. Creating calendar events in Outlook is a bit tricky, though. That will probably have to be the topic of another seminar. Checking for duplicates is a pain. EMAILING someone a reminder isn't that hard though.
Show Just This Thread        Post Reply
Access Payables Seminar Comment from Selby Halfpenny @ 10/28/2010
Dear Richard,

I am so pleased that you are working on a new Access seminar. Can you please include all of the topics in the database please. quote "emailing "you've been paid" notices to vendors, calculating discounts on terms (such as 2%NET10)". I cannot understand charts in 2007 Richard.

Your the best. I have learnt so much. I am not to sure but I think your birthday might have been on the 23/10/2010. Happy Birthday Richard. If I am wrong then sorry, must have my dates mixed up.

All the best Selby Halfpenny  

Reply from Richard Rost:

Thanks, Selby. Yes, it was on 23-Oct. I'm old.
Show Just This Thread        Post Reply
Comment from Jimmy @ 10/28/2010
I am very happy to hear those good news, that you come back to access, after a long break.

about the idea to emailing "you've been paid", to tell the truth i dont need that, but i think that it's good idea in a seminor to plant this kind of stuff, to enrich the knowledge of your customrs in access, and even if that ideo will don't come to use now i'm sure that  in the future it's will come to use

at least i (and i'm sure that i'm not alone)  buy all your curses in access not beacuse i need every course specificly, i buy it mainly  beacuse i want to enrich my knowledge in access...

Reply from Richard Rost:

Thanks, Jimmy. I appreciate the feedback and the support.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 1+6:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

4/4/2020Access Concatenation
3/30/2020Access DateDiff Function
3/23/2020Browsing and Selecting Files
3/14/2020New Access Group
3/6/2020NEW Access 2019 for Beginners
8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Richard Rost Microsoft MVP