0. Introduction (10:17)

1. Lesson 01 (22:49)
Initial setup
Making the Tables
Loan Form

2. Lesson 02 (21:04)
NumberOfPayments Calculator
Tab Order
PMT Function
Creating the Schecule Form

3. Lesson 03 (22:05)
Delete any previous Schedules
Create a new Schedule
DateAdd

4. Lesson 04 (24:44)
Summary Totals
Adding a Subform
Check for changes
Add a Payment
Recalculate other figures

5. Lesson 05 (22:46)
Recalculating Payments
Adding the Payments SubForm
Master/Child Fields

6. Lesson 06 (22:14)
Adding a Payment
Loan Status Values

7. Lesson 07 (18:18)
ClientF, ProviderF
Main Menu
ClientListF
Listbox of Loans
Default Values

8. Lesson 08 (22:34)
Fixing a Requery Problem on new Loan
Echo to stop Screen updating
Delete a Record
Stop Warnings

9. Lesson 09 (24:27)
Repeat for the ProviderListF
DoubleClick Events to open Forms
Active Loans

10. Lesson 10 (21:11)
Reports
CanGrow/CanShrink
Format Painter
Size/Align to Grid
Force New Page
Master/Child Fields

11. Lesson 11 (29:05)
Report Headers
Totals
Payments SubReport
Relationships 101
Sorting and Grouping

12. Lesson 12 (27:26)
Accounts Receivable

13. Lesson 13 (31:12)
Accounts Receivable Reports
Hiding Report Sections

14. Lesson 14 (25:13)
Current Loan Value Report