|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Payables Seminar Lessons Welcome to Access Payables. Total running time is 10 Hours 55 min. Lessons
Resources
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
IntroIn this lesson, you will learn how to build an accounts payable database with Microsoft Access to manage your bills and payments, track vendors, handle invoices including recurring expenses, process payments, and generate key reports like aged payables and expense charts. We will cover working with tables, forms, queries, and reports, and touch on some Visual Basic programming. The seminar is designed for users with experience from the beginner, intermediate, and advanced Access levels, and the techniques shown are applicable to most modern versions of Microsoft Access.TranscriptWelcome to the Microsoft Access Payables Seminar brought to you by AccessLearningZone.com. I am your instructor Richard Rost.The purpose of this seminar is to teach you how to build a database using Microsoft Access to manage your accounts payable, whether for your personal finances or for your small, commit-size company. Most of my seminars and Access classes to date have been focused on the receivables end of the database, which is getting money from your customers and billing. In this seminar, we'll cover paying your vendors and paying your bills. This seminar will focus primarily on tracking vendors or payees, monitoring your invoices and entering your bills, including recurring bills that can repeat at any schedule you set forth, processing payments for those bills, whether it's just printing out a list of bills you have to pay or actually printing checks from the database, and generating various reports such as an aged accounts payable, expenses between dates, and a chart showing expenses by category. If you'd like to know more about exactly what's covered in each lesson and what the database does before starting the seminar, skip ahead and watch lessons 57 and 58. Lesson 57 is a lesson summary that will tell you exactly what's covered in each video. Lesson 58 will give you a step-by-step walkthrough of exactly what the finished database will do. I put these optional lessons at the end of the seminar because not everyone's going to want to watch them, and this way they won't interfere with the normal lesson numbering system 1, 2, 3, and so on. While this seminar does stand alone, and I will cover all the concepts in detail, it is strongly recommended that you have a solid background building databases with Microsoft Access before taking this seminar. You should definitely know everything covered in my beginner 100-level lessons, such as building tables, queries, forms, and so on. I also strongly recommend that you have completed my 200-level lessons covering all the intermediate topics. There will also be some Visual Basic programming in this seminar, so it will be very helpful for you to have taken my 300-level classes as well. This is a fast-paced seminar, and while I will go over everything in detail, the more you know up front, the better off you'll be. In the seminar, I will be using Microsoft Access 2010. If you're using 2007, you should find the majority of the information is exactly the same. There are some minor differences in some of the screens, but you shouldn't have any problems following along. Most of everything that I'm doing will be valid for all versions of Access going back to about Access 2000. Yes, the screens will be different and where you click on some things on the ribbon will be different, but if you know how to access build events and create forms and add combo boxes and all the basic Access stuff, you should be able to follow along regardless of what version of Access you're using. The sample database files will be found on my website at accesslearningzone.com/Pables Seminar. If you're watching this course online in my theater or using my special video player software, you will see the student interaction forms appear in a small window next to the videos. If you have any questions about the topics covered in each lesson, please post them in the student forums. If you have any questions, please leave a comment. If you have any questions, please post them in the comments below. If you have any questions, please post them in the comments below. If you have any questions, please post them in the comments below. QuizQ1. What is the primary focus of the Microsoft Access Payables Seminar?A. Managing accounts receivable B. Designing websites for vendors C. Managing accounts payable D. Creating marketing reports Q2. Which of the following tasks is NOT specifically mentioned as a topic in this seminar? A. Tracking vendors or payees B. Processing payments for bills C. Generating aged accounts payable reports D. Handling payroll management Q3. What version of Microsoft Access is primarily used in the seminar? A. Microsoft Access 2000 B. Microsoft Access 2007 C. Microsoft Access 2010 D. Microsoft Access 2016 Q4. What prior knowledge is strongly recommended before starting this seminar? A. Advanced SQL server management B. Web development in HTML and CSS C. Solid background with Access beginner and intermediate lessons D. No prior knowledge is needed Q5. Why are lessons 57 and 58 placed at the end of the seminar? A. To hide them from most students B. To avoid interfering with normal lesson numbering C. Because they are not important D. Due to technical limitations Q6. What additional skill will be helpful for students attending this seminar? A. Experience with Visual Basic programming B. Knowledge of PowerPoint presentations C. Experience in database marketing D. Skill in using Photoshop Q7. If you are using Access 2007, what should you expect according to the seminar introduction? A. You will not be able to follow the seminar B. Most information will be the same with minor screen differences C. No compatibility with the course materials D. Full compatibility only with Access 2000 Q8. Where can you find the sample database files mentioned in the seminar? A. In the Microsoft Store B. On Rich Text Format files C. On accesslearningzone.com Payables Seminar section D. Embedded within the seminar videos Q9. According to the introduction, how should students ask questions about the seminar content? A. Send them via postal mail B. Only ask during live webinars C. Post them in the student forums or video comments D. Email Microsoft support Answers: 1-C; 2-D; 3-C; 4-C; 5-B; 6-A; 7-B; 8-C; 9-C DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from the Access Learning Zone is the Microsoft Access Payables Seminar. My goal in this seminar is to teach you how to build an effective database in Microsoft Access to manage accounts payable, which you can use for tracking your personal finances or for handling the payables in a small or medium-sized business.Most of my previous seminars and classes on Access have dealt with the receivables side, focusing on billing customers and collecting payments. This seminar switches gears to the other side of accounting: paying your vendors and managing your expenses. You will learn how to keep track of your vendors or payees, monitor their invoices, and enter bills into the system. We'll also discuss how to handle recurring bills that need to be scheduled at custom intervals, and how to record payments for those expenses. Whether you want to print a list of bills that need to be paid or actually create checks from the database, I'll show you how to get it done. Also included are lessons on generating critical reports like an aged accounts payable report, reports showing expenses between specific dates, and charts that break down expenses by category. If you want more details about the contents and structure of the seminar before you start, you can check out lessons 57 and 58. Lesson 57 contains a summary of what is covered in each part of the seminar. Lesson 58 walks you through exactly what the finished database looks like and how it works. I placed these optional lessons at the end so they would not interrupt the flow of the primary lessons. While this seminar is designed to stand alone and I will explain all concepts as we go, it is highly recommended that you have experience building Microsoft Access databases before beginning. Ideally, you should be familiar with all the material from my beginner lessons, including working with tables, queries, and forms. I also strongly suggest completing my intermediate tutorials at the 200-level. Since we will be writing some Visual Basic code, prior experience with my 300-level lessons will be helpful as well. This seminar moves at a quick pace and we will cover a lot of ground. The more prior experience you bring, the easier it will be to keep up. Throughout the seminar, I will be demonstrating everything in Microsoft Access 2010, but the concepts and techniques will be almost exactly the same if you are using Access 2007. There are just a few minor differences in interface and screen layout. If you are using anything from Access 2000 onward, you should be able to follow along just fine. The main thing is to be comfortable with basic Access features like creating forms, adding controls, and editing events. The sample files that I use in the seminar can be downloaded from my website at AccessLearningZone.com under Payables Seminar. If you are watching this seminar through my online theater or with my video player software, interactive forms for student feedback will appear next to the videos. For questions about any lesson or topic we cover, please use the student forums or post your questions in the comments. I'll do my best to respond and help you work through any issues. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListThis is an introductory overview for a Microsoft Access Payables Seminar video, describing the course and what students can expect to learn. |
||||||||||||||||||
|
| |||
| Keywords: Access Payables Seminar PermaLink How To Build an Accounts Payable Database With Vendors, Bills, Payments, and Reports in Microsoft Access |
