I need part 3 of the attached project completed involves ms access and ms excel
iamnickok
CIS480_ProjectCase_DataFile.xlsxCustomer
| CID | Last Name | First Name | Street Address | City | State | Zip | Phone |
| 1 | George | Lamont | 2005 Copper Rock | Dallas | TX | 99943 | (999)212-7358 |
| 2 | Peters | Carry | 3721 Winter Hill Way | Brooksville | TX | 99999 | (999)348-1086 |
| 3 | Matchtolff | Allean | 2022 Washington Way | Luther | OK | 88889 | (999)751-4444 |
| 4 | Macnai | Leigh Ann | 1206 Lincoln Blvd | Tulsa | OK | 88877 | (999)307-5629 |
| 5 | Mensik | Ronald | 13004 Bryant | Claremore | CO | 33333 | (999)111-4797 |
| 6 | Thompson | Samuel | 2540 Hunter Cliff | Phoenix | AZ | 22222 | (999)804-2881 |
| 7 | Westvang | Harry | 3817 Stone Ridge Mt. | Dallas | TX | 99943 | (999)331-0774 |
| 8 | Goertzen | Keith | 1833 Pepperdine | Brooksville | TX | 99999 | (999)517-9988 |
| 9 | Darr | Kevin | 28 West Paris | Anchorage | AK | 44444 | (999)685-7974 |
| 10 | Brunhoeber | Robert | 123 Downing Street | Dallas | TX | 99943 | (999)478-4852 |
| 11 | Pierce | Franklin | 2748 Alleghney | Brooksville | TX | 99999 | (999)341-8733 |
| 12 | Dastolfo | Marcus | 229 Redwood Drive | Brooksville | TX | 99999 | (999)890-2784 |
| 13 | Javorsky | Edith | 1720 Iowa Street | Bentonville | TX | 99999 | (999)285-1286 |
| 14 | Roller | Alenjandro | 916 Ridgecrest | Bentonville | TX | 99999 | (999)844-4021 |
| 15 | Keck | Joseph | 4116 Pinnacle Square | Lancelot | OK | 88888 | (555)715-1988 |
| 16 | Madere | Alva | 2209 Western Avenue | Fort Smith | AR | 77777 | (444)330-1837 |
| 17 | Spruill | Stareta | 2411 Horshoe | Colleyville | AR | 77763 | (444)289-7892 |
| 18 | Tang | Yosheto | 612 Irvine Way | Duncan | OK | 99977 | (999)721-3330 |
| 19 | Milenkovic | Yuri | 17613 Spring Creek | Grapevine | TX | 99924 | (999)715-9888 |
| 20 | Khan | Felix | 7132 Fox Run | Los Angeles | CA | 11112 | (999)528-6033 |
Rate
| RateCode | RateDescription | Percentage |
| D | Daily | 1 |
| HP | Half Price | 0.5 |
| SD | Special Discount | 0.25 |
| SM | Six Months | 0.85 |
| W | Weekend | 0.9 |
| Y | 12 Months | 0.8 |
Property
| PID | RentalPrice | Description | Category |
| C0001 | 150 | Lakefront, Lot 1 | CB |
| C0002 | 150 | Lakefront, Lot 2 | CB |
| C0003 | 150 | Lakefront, Lot 3 | CB |
| C0004 | 125 | Wooded Area, Lot 1 | CB |
| C0005 | 125 | Wooded Area, Lot 2 | CB |
| C0006 | 100 | Wooded Area, Lot 3 | CB |
| F0001 | 150 | 16' Fishing Boat; Green | FB |
| F0002 | 150 | 16' Fishing Boat; Blue | FB |
| F0003 | 150 | 16' Fishing Boat; Red | FB |
| J0001 | 360 | 3 Passenger; Red Stripes | JS |
| J0002 | 360 | 3 Passenger; Blue Stripes | JS |
| J0003 | 360 | 3 Passenger; White Stripes | JS |
| J0004 | 360 | 3 Passenger; Green Stripes | JS |
| J0005 | 360 | 3 Passenger; Purple Stripes | JS |
| J0006 | 150 | 1 Passenger; Blue | JS |
| J0007 | 200 | 2 Passenger; Aqua | JS |
| J0008 | 400 | 4 Passenger; Mint | JS |
| P0001 | 250 | 26' Blue Powerboat | PB |
| P0002 | 250 | 26' Red Powerboat | PB |
| S0001 | 25 | 25' Slip | SL |
| S0002 | 25 | 25' Slip | SL |
| S0003 | 25 | 25' Slip | SL |
| S0004 | 25 | 25' Slip | SL |
| S0005 | 20 | 22' Slip | SL |
| S0006 | 20 | 22' Slip | SL |
| S0007 | 20 | 22' Slip | SL |
| S0008 | 17 | 20' Slip | SL |
| S0009 | 17 | 20' Slip | SL |
| S0010 | 17 | 20' Slip | SL |
| C0007 | 250 | Lakefront, Lot 4 | CB |
| C0008 | 275 | Lakefront, Lot 5 | CB |
Payment
| Payment ID | CID | PaymentDate | PaymentAmount | Deposit | Comment |
| 1 | 1 | 11-Apr-08 | $250.00 | Y | Deposit |
| 2 | 1 | 01-Jun-08 | $187.50 | N | |
| 4 | 6 | 08-Jun-08 | $450.00 | Y | Initial Deposit |
| 5 | 2 | 11-Apr-08 | $400.00 | Y | Deposit |
| 6 | 3 | 26-May-08 | $750.00 | Y | Deposit |
| 7 | 4 | 16-May-08 | $200.00 | Y | Deposit |
| 8 | 5 | 24-May-08 | $750.00 | Y | Initial Deposit |
| 9 | 7 | 01-Jun-08 | $400.00 | Y | Deposit |
| 10 | 8 | 09-Jun-08 | $300.00 | Y | Deposit |
| 11 | 9 | 01-May-08 | $600.00 | N | |
| 12 | 10 | 20-May-08 | $750.00 | Y | Deposit |
| 13 | 11 | 11-Apr-08 | $600.00 | N | Paid full amount. |
| 14 | 12 | 05-Jun-08 | $500.00 | N | Paid initial deposit. |
| 15 | 2 | 30-Apr-08 | $400.00 | N | |
| 16 | 2 | 06-Jun-08 | $2,120.00 | N | |
| 17 | 4 | 24-May-08 | $150.00 | N | |
| 18 | 4 | 06-Jun-08 | $360.00 | N | |
| 19 | 4 | 08-Jun-08 | $1,100.00 | N | |
| 20 | 4 | 22-Jun-08 | $40.00 | N | |
| 21 | 5 | 01-Jul-08 | $750.00 | N | |
| 22 | 5 | 01-Sep-08 | $1,500.00 | N | |
| 23 | 5 | 01-Oct-08 | $910.00 | N | |
| 24 | 6 | 10-Jun-08 | $360.00 | N | |
| 25 | 7 | 15-Jun-08 | $250.00 | N | |
| 26 | 7 | 22-Jun-08 | $306.25 | N | |
| 27 | 12 | 04-Jul-08 | $650.00 | N | |
| 28 | 13 | 13-Jun-08 | $450.00 | N | Paid full amount |
| 29 | 14 | 14-Jun-08 | $150.00 | N | Paid full amount |
| 30 | 15 | 03-Jul-08 | $500.00 | Y | Deposit |
| 31 | 15 | 04-Jul-08 | $520.00 | N | |
| 32 | 16 | 05-Jul-08 | $450.00 | N | |
| 33 | 17 | 06-Jul-08 | $485.00 | N | |
| 34 | 18 | 07-Jul-08 | $750.00 | Y | Deposit |
| 35 | 19 | 13-Jul-08 | $150.00 | N | Paid full amount. |
| 36 | 20 | 20-Jul-08 | $360.00 | Y | Deposit |
| 37 | 20 | 21-Jul-08 | $500.00 | N | |
| 38 | 20 | 22-Jul-08 | $580.00 | N | |
| 39 | 1 | 23-Jul-08 | $360.00 | N | Paid full amount |
| 40 | 3 | 24-Jul-08 | $360.00 | N | |
| 41 | 3 | 25-Jul-08 | $360.00 | N | |
| 43 | 3 | 03-Jun-08 | $262.50 | N | |
| 44 | 8 | 27-Jul-08 | $550.00 | N | |
| 45 | 2 | 02-Jun-08 | $345.00 | N | Paid in full |
| 46 | 5 | 04-Jun-08 | $500.00 | N | Paid in full. |
| 47 | 6 | 07-Jun-08 | $150.00 | N | |
| 48 | 7 | 06-Jun-08 | $397.50 | N |
Reservation
| ResID | CID | BookingDate | ResDate | EndDate | PickUp Time | RateCode | PID |
| R001 | 1 | 01-Apr-08 | 01-Jun-08 | 10-Jun-08 | 1:00:00 PM | SD | C0001 |
| R002 | 1 | 01-Apr-08 | 01-Jun-08 | 10-Jun-08 | 2:00:00 PM | SD | S0001 |
| R003 | 2 | 04-Apr-08 | 05-Apr-08 | 06-Apr-08 | 10:00:00 AM | SD | S0007 |
| R004 | 2 | 04-Apr-08 | 06-Apr-08 | 08-Apr-08 | 10:00:00 AM | D | J0002 |
| R005 | 9 | 01-May-08 | 01-Jul-08 | 02-Jul-08 | 8:00:00 AM | D | J0003 |
| R006 | 9 | 01-May-08 | 01-Jul-08 | 05-Jul-08 | W | C0001 | |
| R007 | 9 | 01-May-08 | 01-Jul-08 | 05-Jul-08 | D | J0005 | |
| R008 | 9 | 01-May-08 | 01-Jul-08 | 05-Jul-08 | D | S0010 | |
| R009 | 4 | 13-May-08 | 07-Jun-08 | 14-Jun-08 | W | C0006 | |
| R010 | 8 | 16-May-08 | 09-Jun-08 | 10-Jun-08 | 8:00:00 AM | D | C0005 |
| R011 | 8 | 16-May-08 | 09-Jun-08 | 10-Jun-08 | HP | F0002 | |
| R012 | 4 | 20-May-08 | 07-Jun-08 | 07-Jun-08 | D | P0001 | |
| R013 | 10 | 20-May-08 | 06-Jul-08 | 06-Jul-08 | 8:00:00 AM | SD | S0010 |
| R014 | 3 | 22-May-08 | 07-Apr-08 | 14-Jun-08 | 8:00:00 AM | HP | S0002 |
| R015 | 5 | 22-May-08 | 15-Jun-08 | 15-Dec-08 | SM | S0002 | |
| R016 | 7 | 01-Jun-08 | 01-Jun-08 | 01-Jun-08 | SD | S0003 | |
| R017 | 6 | 01-Jun-08 | 08-Jun-08 | 11-Jun-08 | W | C0004 | |
| R018 | 7 | 01-Jun-08 | 15-Jun-08 | 17-Jun-08 | D | P0002 | |
| R019 | 7 | 01-Jun-08 | 15-Jun-08 | 22-Jun-08 | SD | C0006 | |
| R020 | 11 | 01-Jun-08 | 04-Jul-08 | 05-Jul-08 | D | C0002 | |
| R021 | 11 | 01-Jun-08 | 06-Jul-08 | 07-Jul-08 | D | C0001 | |
| R022 | 2 | 02-Jun-08 | 02-Jun-08 | 02-Jun-08 | D | J0003 | |
| R023 | 2 | 02-Jun-08 | 03-Jun-08 | 03-Jun-08 | D | F0001 | |
| R024 | 12 | 02-Jun-08 | 03-Jul-08 | 06-Jul-08 | D | C0005 | |
| R025 | 12 | 02-Jun-08 | 04-Jul-08 | 07-Jul-08 | D | C0004 | |
| R026 | 3 | 03-Jun-08 | 03-Jun-08 | 03-Jun-08 | D | F0003 | |
| R027 | 1 | 04-Jun-08 | 04-Jun-08 | 04-Jun-08 | D | J0001 | |
| R028 | 8 | 04-Jun-08 | 04-Jun-08 | 04-Jun-08 | D | F0002 | |
| R029 | 5 | 04-Jun-08 | 04-Jun-08 | 07-Jun-08 | D | C0005 | |
| R030 | 7 | 06-Jun-08 | 06-Jun-08 | 06-Jun-08 | D | J0005 | |
| R031 | 6 | 07-Jun-08 | 07-Jun-08 | 07-Jun-08 | D | F0002 | |
| R032 | 6 | 08-Jun-08 | 08-Jun-08 | 08-Jun-08 | D | J0005 | |
| R033 | 4 | 09-Jun-08 | 09-Jun-08 | 09-Jun-08 | D | P0001 | |
| R034 | 13 | 13-Jun-08 | 13-Jun-08 | 15-Jun-08 | D | C0002 | |
| R035 | 14 | 14-Jun-08 | 14-Jun-08 | 14-Jun-08 | HP | F0002 | |
| R036 | 15 | 03-Jul-08 | 03-Jul-08 | 04-Jul-08 | D | F0001 | |
| R037 | 15 | 03-Jul-08 | 03-Jul-08 | 04-Jul-08 | D | J0003 | |
| R038 | 17 | 04-Jul-08 | 01-Jul-08 | 02-Jul-08 | D | C0005 | |
| R039 | 12 | 04-Jul-08 | 04-Jul-08 | 04-Jul-08 | D | F0003 | |
| R040 | 16 | 05-Jul-08 | 05-Jul-08 | 09-Jul-08 | W | C0006 | |
| R041 | 17 | 06-Jul-08 | 06-Jul-08 | 06-Jul-08 | D | J0001 | |
| R042 | 18 | 07-Jul-08 | 07-Jul-08 | 07-Jul-08 | SM | S0009 | |
| R043 | 19 | 13-Jul-08 | 20-Jul-08 | 20-Jul-08 | D | F0002 | |
| R044 | 20 | 20-Jul-08 | 21-Jul-08 | 22-Jul-08 | D | J0005 | |
| R045 | 20 | 21-Jul-08 | 21-Jul-08 | 22-Jul-08 | D | J0004 | |
| R046 | 6 | 23-Jul-08 | 28-Jul-08 | 29-Jul-08 | D | F0001 | |
| R047 | 3 | 24-Jul-08 | 28-Jul-08 | 29-Jul-08 | D | J0005 | |
| R048 | 3 | 25-Jul-08 | 29-Jul-08 | 30-Jul-08 | D | J0004 | |
| R049 | 7 | 26-Jul-08 | 30-Jul-08 | 31-Jul-08 | SD | F0002 | |
| R050 | 8 | 27-Jul-08 | 02-Aug-08 | 04-Aug-08 | D | F0001 |
