In YOUR LAB SECTION, complete the following using the attached file- Mid-Level Exercise: #1 Small Business Loans- Page: 822-823 When you have completed the project, you need to submit 2 files. One file is your main Access database file, and one file is the 201C;Back Up201D; file that you create at the end of the project.Attachmentsa03m1Loans.xlsx
image_4.png.jpeg

image_5.png.jpeg

a03m1loans.xlsx

Unformatted Attachment Preview

LoanID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Date
########
########
########
9/4/2015
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
Amount InterestRateTerm
0.059
29,000.00
0.0525
23,000.00
0.045
24,000.00
0.0399
12,000.00
0.055
60,000.00
0.065
4,000.00
0.055
43,000.00
0.058
37,000.00
0.0475
15,000.00
0.055
8,000.00
0.05
34,000.00
0.0799
13,000.00
0.065
46,000.00
0.0599
56,000.00
0.0625
54,000.00
0.065
39,000.00
0.06
21,000.00
0.055
27,000.00
0.055
44,000.00
0.0625
22,000.00
0.0675
6,000.00
0.065
46,000.00
0.05
25,000.00
0.0555
11,000.00
0.0499
52,000.00
15
5
3
10
30
5
5
30
3
15
3
5
5
15
15
15
30
3
5
4
4
15
15
30
15
LoanClass CustomerID
M
1
C
2
C
3
O
3
M
3
O
2
O
1
M
1
O
1
M
1
C
3
O
3
C
1
M
3
M
3
M
1
M
1
C
3
C
2
C
3
C
3
M
3
M
1
M
1
M
1
2026;
Purchase answer to see full
attachment