| 05/10 | Microsoft Access Expert 5
This is the fifth Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 4 left off.
This class is 1 hour, 17 minutes long and focuses on creating a letter report that you can print, export, or email to your customers directly from your database. You'll also learn how to edit embedded macros, customize the Ribbon, and lots more. Topics include:
- Print a [more...] |
| 04/29 | Microsoft Access Expert 4
This is the fourth Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 3 left off.
This class is 1 hour, 48 minutes long and focuses primarily on new types of form controls including option groups, toggle buttons, the image control, and more. We'll also learn about one-to-one relationships, and practice more with one-to-many relationships. You will learn:
- Additional Form [more...] |
| 04/05 | Access 2010 Expert 3
This is the third Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 2 left off.
This class is 1 hour, 26 minutes long and teaches you the basics of SQL (the language behind all of the queries in your database), form footer totals, subforms, and lots more You will learn...
- SQL Basics
- Future Callbacks for Customers
- Default Value to Tomorrow at 9 AM
- Creating [more...] |
| 03/31 | Access Loan Amortization Seminar
This was only supposed to be a quick 30-minute tutorial, and it ballooned up into almost 6 hours, but it covers a lot of great material. If you want to learn how to manage loans in Access, this is the seminar for you.
This seminar will teach you how to calculate a complete Loan Amortization Schedule in Microsoft Access.
1. Learn how to calculate loan payments
2. Create a complete amortization schedule
3. Work with flexible loan terms
4. Manage multiple [more...] |
| 03/20 | Access X2, Fiscal Handbooks Available
The handbooks for Access 2010 Expert Level 2 and the Access Fiscal Year Seminar are now available.
If you have already purchased these handbooks, you can download them now or get them in the Theater. If you are on the Waiting List [more...] |
| 03/10 | Access 2010 Expert 2
This is the second Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 1 left off.
This class is 1 hour, 25 minutes long and covers database table normalization, defining explicit relationships, referential integrity, cascade updates and deletes, setting values across different forms, and lots more. You will learn:
- Database Table Normalization
- Global Relationships
- [more...] |
| 02/22 | Access Fiscal Year Seminar
Well, I wasn't planning on making this a seminar, but at least three different customers asked me about this over the past two weeks, and one of them really needed to learn how to do it, and he submitted it as a PAID TechHelp question. So... I decided to turn it into a short seminar.
This Fiscal Year Seminar will teach you how to perform [more...] |
| 02/12 | Two New Handbooks Available
The handbooks for Access 2010 Expert Level 1 and Windows 8 Beginner Level 1 are now available.
If you have already purchased these handbooks, you can download them now or get them in the Theater. If you are on the Waiting List for [more...] |
| 02/05 | Access 2010 Expert 1
This is the first Microsoft Access video tutorial in the Expert series. It picks up where Beginner Level 9 left off. This class covers fixing the contact history table that we started in the last class. I intentionally showed you the wrong way to build it last time. Now we'll build it correctly. You will learn:
��- Relational Database Concepts
��- Primary & Foreign Key Fields
��- Types of [more...] |
| 01/25 | Windows 8 Beginner 1
Do you need to learn Windows 8? Whether you've recently purchased a new PC with Windows 8 on it, or you have a little experience with older versions of Windows, or you just want to see what the new features of Windows 8 are, this class is for you.
- History & Versions of Windows
- What's New in Windows 8
- The New Start Menu
- Windows Modern Interface
- Apps & Programs
- Configuring Windows 8
- [more...] |
