What's Covered
The Loan Form is the main feature
of this database. Here you can select a client, a loan provider, enter
the terms of the loan, calculate the payments, generate a complete
amortization schedule, and track client payments. We'll spend most of
our time building this complex form.

Exploring the other features of this
database, we'll learn how to create a Main Menu form:

We will create a Client List and a
Client Detail form. You'll see a list of Loans per Client.

You can print a report showing the
status of all loans per client.

You can see all of the same items for
Loan Providers as well (list form, details, report):

To create a new loan, just select
a client and a provider. Enter a description, the loan amound, the
interest rate, and the start date. Select a frequency (monthly, weekly,
etc.)

Enter in the number of payments (or type
in the number of Years and the database will calculate the number of
payments for you). The click on the Calculate Monthly Payment
button and Access will tell you what the payment should be.

Now you're ready to generate the complete
Amortization Schedule. Again, one click and Access does all the
heavy lifting for you.

You can enter the client's payments
as they come in. Access will assign them to "regular" payment amount and
"extra" payment amount, if you wish to allow the client to pay down his
balance early.

You can print this complete report
out for the client.

There are a couple of additional reports
as well. You can generate a list of all active loans for all providers,
a list of all current loan values (payoff amounts), and you can generate
an aged accounts receivable, showing as much or as little detail
as you want.

For example, this report shows the
providers, clients, and loan info, but not all of the payment schedule
details:

This is the perfect seminar for anyone
who needs to learn how to calculate loan payments and track amortization
schedules with payment histories in Microsoft Access. Of
course, if you have any questions about whether or not this seminar is
for you, please feel free to
contact me. I'd
be happy to answer any questions you might have.
NOTE: If you're looking for
something less involved, there is a simpler database available that
performs basic loan amortizations in the
Templates section.

Access Loan Amortization Seminar Outline
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

|