Exp19_Access_Ch01_Cap - Loan Lending Management 1.1

Blake_Exp19_Access_Ch01_Cap_Loan_Lending_Management.accdb

Home >Computer Science homework help >Exp19_Access_Ch01_Cap - Loan Lending Management 1.1

OfficerID	FirstName	LastName	EmailAddress	PhoneExtension	Title

LoanID	OfficerID	MemberID	LoanAmount	Term	InterestRate	Payment	Grade	IssueDate	LoanStatus
42	2	19	¤ 15,000.00	36 months	0.1122	¤ 492.65	B	2018-12-15	Current
43	1	11	¤ 6,475.00	36 months	0.1989	¤ 240.28	E	2018-12-15	Fully Paid
44	1	18	¤ 10,000.00	36 months	0.0999	¤ 322.63	B	2018-10-15	In Grace Period
45	2	20	¤ 20,400.00	60 months	0.0789	¤ 412.57	A	2018-11-15	Current
46	3	13	¤ 8,000.00	36 months	0.1825	¤ 290.23	E	2018-10-15	Current
47	2	16	¤ 10,000.00	60 months	0.1899	¤ 259.36	E	2018-12-15	Current
48	4	13	¤ 13,000.00	60 months	0.0789	¤ 262.91	A	2018-11-15	Current
49	4	12	¤ 6,800.00	36 months	0.0624	¤ 207.61	A	2018-10-15	Current
50	2	16	¤ 18,000.00	60 months	0.1999	¤ 476.79	E	2018-11-15	Current
51	4	17	¤ 3,425.00	36 months	0.1849	¤ 124.67	E	2018-12-15	Current
52	4	11	¤ 17,000.00	60 months	0.1433	¤ 398.48	C	2018-11-15	Current
53	1	14	¤ 1,500.00	36 months	0.1561	¤ 52.45	D	2018-11-15	Current
54	6	18	¤ 5,600.00	36 months	0.1318	¤ 189.18	C	2018-11-15	Fully Paid
55	6	20	¤ 30,000.00	36 months	0.1229	¤ 1,000.59	C	2018-10-15	Current
56	6	16	¤ 24,000.00	60 months	0.1367	¤ 554.35	C	2018-12-15	Current
57	3	19	¤ 19,800.00	36 months	0.1288	¤ 666.00	C	2018-12-15	Fully Paid
58	2	14	¤ 9,000.00	36 months	0.1153	¤ 296.92	B	2018-10-15	Current
59	5	17	¤ 27,200.00	60 months	0.0818	¤ 553.87	B	2018-10-15	Current
60	5	12	¤ 6,000.00	36 months	0.1122	¤ 197.06	B	2018-12-15	Fully Paid

MemberID	FirstName	LastName	EmailAddress	PhoneNumber	StreetAddress	City	State	Zip	Age	CreditScore
11	Cameron	Bailey	[email protected]	(104) 600-4765	599 S. Bellevue Street	Wakefield	MA	01880	71	643
12	Mel	Lane	[email protected]	(302) 186-7040	8990 Fordham St.	Tuckerton	NJ	08087	45	837
13	Brynn	Anderson	[email protected]	(142) 580-7170	78 Pumpkin Hill Street	Fayetteville	NC	28303	56	615
14	Lane	Williams	[email protected]	(402) 815-8112	167 South Indian Spring Lane	Enfield	CT	06082	70	641
15	Will	Ward	[email protected]	(906) 344-4740	7731 Thatcher Ave.	Marshalltown	IA	50158	57	762
16	Tyler	Fletcher	[email protected]	(496) 739-2502	8270 Cambridge Street	Cottage Grove	MN	55016	23	846
17	Ashley	Armstrong	[email protected]	(880) 601-5444	212 Poplar Ave.	Temple Hills	MD	20748	57	664
18	Taylor	Shepard	[email protected]	(663) 625-8716	329 Hartford St.	Media	PA	19063	30	633
19	Reggie	Graham	[email protected]	(102) 899-3364	8304 Valley View Dr.	Encino	CA	91316	23	877
20	Rowan	Huber	[email protected]	(860) 779-3066	350 Lake View Street	Crown Point	IN	46307	57	631

ID	mSysRowId
1	9IXvQZNs29QgIJSOmgNWrLu5kCsQEEBpb8fj8ZdeHsM=-~Il9R3m/Z8shUrz5QZzqeCQ==

PARAMETERS __MemberID Value; SELECT DISTINCTROW * FROM Loans AS [Maintain Members] WHERE ([__MemberID] = MemberID);

SELECT DISTINCTROW * FROM Loans;

SELECT DISTINCTROW * FROM Members;

SELECT Loans.LoanID, [Loan Officers]![FirstName] & " " & [Loan Officers]![LastName] AS LoanOfficer, [Members]![FirstName] & " " & [Members]![LastName] AS MemberName, Loans.LoanAmount, Loans.LoanStatus FROM ([Loan Officers] INNER JOIN Loans ON [Loan Officers].OfficerID = Loans.OfficerID) INNER JOIN Members ON Loans.MemberID = Members.MemberID;