Seminars are lessons that cover a specific topic, or have a singular goal, such as learning how to search for information in your database, or work with SQL. They do not necessarily fall into line with the regular sequential courses. Check the specific Seminar page for more information on what's covered, and if there are any pre-requisites.
The Check Register Seminar is over 5 hours long and covers everything you need to know to build a database in Microsoft Access to manage and maintain your checking, credit card, and other accounts. Also available as just a template.
Do you want to share your Microsoft Access database online with other users? In this seminar, I will teach you how to set up a SharePoint database, publish your tables to it, distribute your database to other users, and lots more.
Add mailing labels to your database. Enter individual labels manually, add directly from your customer form, insert blank labels on top of the sheet, delete all labels with one click, duplicate labels, print all active customers selected to get your mailing list. More!
Everything the absolute beginner needs to know to get up and running with Microsoft Access in about 30 minutes. Build basic tables, queries, forms, and reports.
Easy Access POS Seminar
An easy to use and fully customizable Point of Sale system built completely in Microsoft Access. Currently in development with the Access Developer students. You can participate in building this database by enrolling in Access Developer 14.
Learn just about everything there is to know about searching, sorting, and filtering in your Access databases. We'll cover everything from basic find & replace to advanced query parameters, working with NULL values, custom SQL forms, and lots more.
Learn just about everything there is to know about relationships in Microsoft Access. We will build eight (8) different database projects so you can see how to set up good relationships between your tables.
Although the title of this course says "Work Order Seminar," it's much more than that. You will learn everything you need to design a database to run a service-oriented business. Learn everything from work orders and scheduling to invoicing, job costing, and more.
Learn how to set up a database with multiple back-end files: one that every database user can access, and another for sensitive information, such as financial data, that only a small, select group of users can access.
Lock down the data in your tables so that nobody can see your private information. Scramble & encrypt sensitive data to keep it from prying eyes. This is a good solution for securing data without the need for an expensive database server platform. Works great with the techniques taught in our Access Security Seminar.
Supercharge your Access databases with the full power of SQL. This seminar will focus primarily on action queries to manipulate the data in your tables, but lots of other topics are covered as well. Learn the one type of query you need to use SQL for: UNION queries. Tons of examples.
This seminar is all about manipulating the structure of your Access database - building and modifying tables and queries with SQL commands. The techniques in this seminar are especially useful for the administrator or developer who has to support remote database files. You can now update them (add a table, change a field, etc.) with simple SQL commands.
Learn how to protect your Access database so you can give or sell it to others, and they will be required to register their copy of the database with you. This prevents theft and piracy, and protects your intellectual property.
Learn how to build a database to manage your assets. You will learn how to create grouped assets (with unlimited grouping levels), track locations, owners, values, and keep a complete log of changes to the asset's history.
Learn how to count the number of work days between two dates, determine if a date is a week day or a weekend day, calculate holidays, time stamp edited records, use event timers in your database to create popup notifications for reminders, generate recurring appointments, and calculate the number of a particular weekday (Friday) in any period (January). Lots more.
Learn how to work with images and other objects (OLE, pictures, etc.) in your Access datbases. Learn how to work with images and other objects in your Access databases. Learn how to use images without having to store them in your database.
You know, Russ, one of my YouTube Gold members just asked me a couple days ago if I could show how to reconcile a check book, so I was going to do a simple check register as a TechHelp video, and then for the Extended Cut show how to print checks.
I cover how to do a simple check register in Access Expert 29. I cover how to print checks in Developer 5. But a lot of people want to learn how to do these things and don't necessarily want ALL of the rest of the material in those classes, so I can make a quick, short how-to TechHelp video that covers the basics.
I've been thinking about a full seminar on the subject too. I would include things like tracking multiple accounts, downloading and importing your bank statements, putting expenses in categories, etc. If you can think of any other features you'd like to see, post them here.
As far as WHEN? I don't know. The quick TechHelp videos, very soon. It's a Gold Member so he's on top of the list. The seminar? Not sure. I've got a few other things on my plate first.
Alex just reminded me that I already recorded 3 hours of a Bank Seminar that I never released back in 2019. That covers mostly downloading and importing transactions from your bank. I'm going to review it soon and perhaps publish what I've got so far.
I really just want to know that "if statement" for a credit of deposit so i can have the 2 fields then the running balance. I wish you would have included it in Expert 29 class I would think that would have qualified for the expert level.
There's two ways you can do it. In Expert 29 I show you how to use a single AMOUNT field and enter debits as negative numbers. The other way to do it is to use two fields: one for debits and one for credits. A lot of banks and accounting software use the 2nd method, which I think I'm going to do in the TechHelp video just to show a different way to do it. Is that what you're asking about? If so, stay tuned for that.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.