Create a simple excel spreadsheet with data to update the database. 

profileitaiab
info262_rmessman_week7.accdb
Home>Computer Science homework help>Create a simple excel spreadsheet with data to update the database. 
ID BorrowerLastName BorrowerFirstName
1 Gibson Joseph
2 Martin William
3 Lucia Anna
4 Ambrosini John
5 Scruton Patricia
Item ID TItle Type Genre Borrowed Date Returned Date Date due Borrower ID
1 Grease DVD Musical 8/2/16 8/8/16 8/12/16 2
2 Black Star CD Rock 9/1/16 9/12/16 9/13/16 4
3 Rio CD Pop 8/13/16 8/23/16 8/23/16 4
4 The Departed DVD Drama 9/3/16 9/23/16 9/23/16 3
5 Neighbors DVD Comedy 10/5/16 10/13/16 10/15/16 2
6 Pinups CD Rock 10/11/16 10/20/16 10/21/16 1
7 The Wedding Album CD Pop 11/7/16 11/15/16 11/17/16 5
8 Bad Santa DVD Comedy 8/15/16 8/24/16 8/25/16 1
9 Nightmare on Elm Street DVD Horror 9/16/16 9/26/16 9/26/16 4
10 Head on the Door CD Alertnative 10/6/16 10/25/16 10/26/16 1
ID Caption ReportToRun
1 Borrowers RptBorrower
2 Media RptMediaList
3 Past Due RptPastDue
SELECT [Borrower].[ID], [Borrower].[BorrowerLastName], [Borrower].[BorrowerFirstName], [Inventory].[Item ID], [Inventory].[TItle], [Inventory].[Type], [Inventory].[Genre], [Inventory].[Borrowed Date], [Inventory].[Returned Date], [Inventory].[Date due], [Inventory].[Borrower ID] FROM Borrower INNER JOIN Inventory ON [Borrower].[ID] =[Inventory].[Borrower ID];
SELECT DISTINCTROW * FROM Inventory;