4/9/2013 10:14:35 PM
Four New Access Tip Videos
By Richard Rost
I just published four new Access Tip Videos.
1. Create a Database in Microsoft Access 2013. This is a quick run-through of how to set up a database in about 15 minutes. If you've watched my Access Beginner 1 course then there's nothing new in this video.
2. Referential Integrity. Learn about the benefits of referential integrity to prevent orphaned records in your tables. This topic is covered in Access Expert 2.
3. Calculating Loan Payments. This video will show you how to calculate the monthly payment for a loan or mortgage based on the amount of the loan, the interest rate, and the number of payments using the PMT function. I cover this in much more detail in my Loan Amortization Seminar.
4. Access SQL Basics introduces you to the basics of Access SQL - Structured Query Language - which is behind every query in your database. Learning this will take your development to the next level. Learn more SQL in my Access Expert 3 or SQL Seminar classes.
Keywords: access tips sql amortization loan payments referential integrity