Access
DeTazz
acc_2_bank_database_example.zipACC_2_Bank_Database_Example.accdb
| LoanID | LoanType | LoanRate | LoanMin |
|---|---|---|---|
| 1 | 15 Year Mortgage | 0.045 | ¤ 50,000.00 |
| 2 | 30 Year Mortgage | 0.055 | ¤ 75,000.00 |
| 3 | Auto Loan 36-Month | 0.085 | ¤ 5,000.00 |
| 4 | Auto Loan 48-Month | 0.095 | ¤ 7,500.00 |
| 5 | Auto Loan 60-Month | 0.105 | ¤ 10,000.00 |
| 6 | Student | 0.05 | ¤ 2,000.00 |
SELECT DISTINCTROW *
FROM loans;
