Access 365/2019 Capstone Level 3 Working With A Sales Database
AC2019-Capstone-Level3-resources/NewSalesData.xlsx
NewSales
| ID | SaleDate | Quantity | ItemID | TotalSale |
| 501 | 7/30/19 | 7 | OLDB005 | 38.50 |
| 502 | 7/30/19 | 4 | OLDB005 | 22.00 |
| 503 | 7/30/19 | 4 | OLDB005 | 22.00 |
| 504 | 7/30/19 | 7 | OLDB005 | 38.50 |
| 505 | 7/31/19 | 4 | OLDB005 | 22.00 |
| 506 | 7/31/19 | 6 | OLDB005 | 33.00 |
| 507 | 7/31/19 | 8 | OLDB005 | 44.00 |
| 508 | 7/31/19 | 1 | OLDB005 | 5.50 |
| 509 | 7/31/19 | 11 | OLDB005 | 60.50 |
| 510 | 8/1/19 | 5 | OLDB005 | 27.50 |
| 511 | 8/1/19 | 3 | OLDB005 | 16.50 |
| 512 | 8/1/19 | 3 | OLDB005 | 16.50 |
| 513 | 8/1/19 | 1 | OLDB005 | 5.50 |
| 514 | 8/1/19 | 3 | OLDB005 | 16.50 |
| 515 | 8/2/19 | 2 | OLDB005 | 11.00 |
| 516 | 8/2/19 | 19 | OLDB005 | 104.50 |
| 517 | 8/2/19 | 5 | OLDB005 | 27.50 |
| 518 | 8/3/19 | 10 | OLDB005 | 55.00 |
| 519 | 8/3/19 | 5 | OLDB005 | 27.50 |
| 520 | 8/4/19 | 9 | OLDB005 | 49.50 |
| 521 | 8/4/19 | 6 | OLDB005 | 33.00 |
| 522 | 8/4/19 | 19 | OLDB005 | 104.50 |
| 523 | 8/4/19 | 2 | OLDB005 | 11.00 |
| 524 | 8/4/19 | 4 | OLDB005 | 22.00 |
| 525 | 8/4/19 | 8 | OLDB005 | 44.00 |
| 526 | 8/4/19 | 6 | OLDB005 | 33.00 |
| 527 | 8/4/19 | 4 | OLDB005 | 22.00 |
| 528 | 8/4/19 | 10 | OLDB005 | 55.00 |
| 529 | 8/5/19 | 2 | OLDB005 | 11.00 |
| 530 | 8/5/19 | 9 | OLDB005 | 49.50 |
| 531 | 8/5/19 | 20 | OLDB005 | 110.00 |
| 532 | 8/5/19 | 6 | OLDB005 | 33.00 |
| 533 | 8/5/19 | 6 | OLDB005 | 33.00 |
| 534 | 7/30/19 | 11 | ORIG001 | 60.00 |
| 535 | 7/30/19 | 1 | ORIG001 | 20.00 |
| 536 | 7/30/19 | 11 | ORIG001 | 10.00 |
| 537 | 7/30/19 | 6 | ORIG001 | 50.00 |
| 538 | 7/30/19 | 3 | ORIG001 | 10.00 |
| 539 | 7/31/19 | 1 | ORIG001 | 50.00 |
| 540 | 7/31/19 | 10 | ORIG001 | 10.00 |
| 541 | 7/31/19 | 3 | ORIG001 | 20.00 |
| 542 | 7/31/19 | 1 | ORIG001 | 50.00 |
| 543 | 7/31/19 | 10 | ORIG001 | 30.00 |
| 544 | 8/1/19 | 5 | ORIG001 | 10.00 |
| 545 | 8/1/19 | 2 | ORIG001 | 20.00 |
| 546 | 8/1/19 | 2 | ORIG001 | 70.00 |
| 547 | 8/1/19 | 6 | ORIG001 | 60.00 |
| 548 | 8/1/19 | 6 | ORIG001 | 60.00 |
| 549 | 8/1/19 | 4 | ORIG001 | 50.00 |
| 550 | 8/1/19 | 8 | ORIG001 | 20.00 |
| 551 | 8/1/19 | 2 | ORIG001 | 20.00 |
| 552 | 8/2/19 | 2 | ORIG001 | 20.00 |
| 553 | 8/2/19 | 5 | ORIG001 | 20.00 |
| 554 | 8/3/19 | 2 | ORIG001 | 30.00 |
| 555 | 8/3/19 | 11 | ORIG001 | 40.00 |
| 556 | 8/3/19 | 5 | ORIG001 | 20.00 |
| 557 | 8/4/19 | 2 | ORIG001 | 30.00 |
| 558 | 8/4/19 | 4 | ORIG001 | 10.00 |
| 559 | 8/4/19 | 8 | ORIG001 | 10.00 |
| 560 | 8/4/19 | 5 | ORIG001 | 30.00 |
| 561 | 8/4/19 | 5 | ORIG001 | 10.00 |
| 562 | 8/4/19 | 1 | ORIG001 | 20.00 |
| 563 | 8/4/19 | 3 | ORIG001 | 30.00 |
| 564 | 8/4/19 | 7 | ORIG001 | 20.00 |
| 565 | 8/5/19 | 10 | ORIG001 | 20.00 |
| 566 | 8/5/19 | 5 | ORIG001 | 10.00 |
| 567 | 8/5/19 | 7 | ORIG001 | 10.00 |
| 568 | 8/5/19 | 18 | ORIG001 | 60.00 |
| 569 | 7/30/19 | 19 | CARA002 | 114.00 |
| 570 | 7/30/19 | 2 | CARA002 | 12.00 |
| 571 | 7/30/19 | 8 | CARA002 | 48.00 |
| 572 | 7/30/19 | 3 | CARA002 | 18.00 |
| 573 | 7/30/19 | 8 | CARA002 | 48.00 |
| 574 | 7/31/19 | 5 | CARA002 | 30.00 |
| 575 | 7/31/19 | 4 | CARA002 | 24.00 |
| 576 | 7/31/19 | 2 | CARA002 | 12.00 |
| 577 | 7/31/19 | 11 | CARA002 | 66.00 |
| 578 | 7/31/19 | 17 | CARA002 | 102.00 |
| 579 | 8/1/19 | 4 | CARA002 | 24.00 |
| 580 | 8/1/19 | 9 | CARA002 | 54.00 |
| 581 | 8/1/19 | 17 | CARA002 | 102.00 |
| 582 | 8/1/19 | 18 | CARA002 | 108.00 |
| 583 | 8/2/19 | 17 | CARA002 | 102.00 |
| 584 | 8/2/19 | 17 | CARA002 | 102.00 |
| 585 | 8/3/19 | 9 | CARA002 | 54.00 |
| 586 | 8/3/19 | 7 | CARA002 | 42.00 |
| 587 | 8/3/19 | 9 | CARA002 | 54.00 |
| 588 | 8/4/19 | 17 | CARA002 | 102.00 |
| 589 | 8/4/19 | 1 | CARA002 | 6.00 |
| 590 | 8/4/19 | 9 | CARA002 | 54.00 |
| 591 | 8/4/19 | 5 | CARA002 | 30.00 |
| 592 | 8/5/19 | 8 | CARA002 | 48.00 |
| 593 | 8/5/19 | 1 | CARA002 | 6.00 |
| 594 | 8/5/19 | 20 | CARA002 | 120.00 |
| 595 | 8/5/19 | 5 | CARA002 | 30.00 |
| 596 | 8/5/19 | 16 | CARA002 | 96.00 |
| 597 | 8/5/19 | 19 | CARA002 | 114.00 |
| 598 | 7/30/19 | 2 | TRUF003 | 13.00 |
| 599 | 7/30/19 | 1 | TRUF003 | 6.50 |
| 600 | 7/30/19 | 18 | TRUF003 | 117.00 |
| 601 | 7/31/19 | 5 | TRUF003 | 32.50 |
| 602 | 7/31/19 | 1 | TRUF003 | 6.50 |
| 603 | 7/31/19 | 18 | TRUF003 | 117.00 |
| 604 | 8/1/19 | 19 | TRUF003 | 123.50 |
| 605 | 8/1/19 | 6 | TRUF003 | 39.00 |
| 606 | 8/1/19 | 8 | TRUF003 | 52.00 |
| 607 | 8/1/19 | 11 | TRUF003 | 71.50 |
| 608 | 8/2/19 | 8 | TRUF003 | 52.00 |
| 609 | 8/2/19 | 3 | TRUF003 | 19.50 |
| 610 | 8/3/19 | 10 | TRUF003 | 65.00 |
| 611 | 8/4/19 | 1 | TRUF003 | 6.50 |
| 612 | 8/4/19 | 8 | TRUF003 | 52.00 |
| 613 | 8/4/19 | 11 | TRUF003 | 71.50 |
| 614 | 8/4/19 | 1 | TRUF003 | 6.50 |
| 615 | 8/5/19 | 5 | TRUF003 | 32.50 |
| 616 | 8/5/19 | 5 | TRUF003 | 32.50 |
| 617 | 8/5/19 | 8 | TRUF003 | 52.00 |
| 618 | 8/5/19 | 6 | TRUF003 | 39.00 |
| 619 | 8/5/19 | 4 | TRUF003 | 26.00 |
| 620 | 8/5/19 | 3 | TRUF003 | 19.50 |
| 621 | 8/5/19 | 6 | TRUF003 | 39.00 |
| 622 | 8/5/19 | 10 | TRUF003 | 65.00 |
| 623 | 8/5/19 | 5 | TRUF003 | 32.50 |
AC2019-Capstone-Level3-resources/SalesArchive.accdb
| ID | SaleDate | Quantity | ItemID | Total | TotalSal |
|---|---|---|---|---|---|
| 1.0 | 2019-06-30 | 6.0 | OLDB | 33.0 | |
| 2.0 | 2019-06-30 | 4.0 | OLDB | 22.0 | |
| 3.0 | 2019-06-30 | 4.0 | OLDB | 22.0 | |
| 4.0 | 2019-06-30 | 2.0 | OLDB | 11.0 | |
| 5.0 | 2019-07-01 | 2.0 | OLDB | 11.0 | |
| 6.0 | 2019-07-01 | 5.0 | OLDB | 27.5 | |
| 7.0 | 2019-07-01 | 2.0 | OLDB | 11.0 | |
| 8.0 | 2019-07-01 | 4.0 | OLDB | 22.0 | |
| 9.0 | 2019-07-01 | 8.0 | OLDB | 44.0 | |
| 10.0 | 2019-07-02 | 2.0 | OLDB | 11.0 | |
| 11.0 | 2019-07-02 | 4.0 | OLDB | 22.0 | |
| 12.0 | 2019-07-02 | 2.0 | OLDB | 11.0 | |
| 13.0 | 2019-07-02 | 4.0 | OLDB | 22.0 | |
| 14.0 | 2019-07-02 | 2.0 | OLDB | 11.0 | |
| 15.0 | 2019-07-03 | 2.0 | OLDB | 11.0 | |
| 16.0 | 2019-07-03 | 4.0 | OLDB | 22.0 | |
| 17.0 | 2019-07-03 | 6.0 | OLDB | 33.0 | |
| 18.0 | 2019-07-04 | 2.0 | OLDB | 11.0 | |
| 19.0 | 2019-07-04 | 4.0 | OLDB | 22.0 | |
| 20.0 | 2019-07-05 | 2.0 | OLDB | 11.0 | |
| 21.0 | 2019-07-05 | 2.0 | OLDB | 11.0 | |
| 22.0 | 2019-07-05 | 6.0 | OLDB | 33.0 | |
| 23.0 | 2019-07-05 | 2.0 | OLDB | 11.0 | |
| 24.0 | 2019-07-05 | 4.0 | OLDB | 22.0 | |
| 25.0 | 2019-07-05 | 2.0 | OLDB | 11.0 | |
| 26.0 | 2019-07-05 | 4.0 | OLDB | 22.0 | |
| 27.0 | 2019-07-05 | 2.0 | OLDB | 11.0 | |
| 28.0 | 2019-07-06 | 2.0 | OLDB | 11.0 | |
| 29.0 | 2019-07-06 | 8.0 | OLDB | 44.0 | |
| 30.0 | 2019-07-06 | 10.0 | OLDB | 55.0 | |
| 31.0 | 2019-07-06 | 2.0 | OLDB | 11.0 | |
| 32.0 | 2019-07-06 | 4.0 | OLDB | 22.0 | |
| 33.0 | 2019-06-30 | 12.0 | ORIG001 | 60.0 | |
| 34.0 | 2019-06-30 | 4.0 | ORIG001 | 20.0 | |
| 35.0 | 2019-06-30 | 2.0 | ORIG001 | 10.0 | |
| 36.0 | 2019-06-30 | 10.0 | ORIG001 | 50.0 | |
| 37.0 | 2019-06-30 | 2.0 | ORIG001 | 10.0 | |
| 38.0 | 2019-07-01 | 10.0 | ORIG001 | 50.0 | |
| 39.0 | 2019-07-01 | 2.0 | ORIG001 | 10.0 | |
| 40.0 | 2019-07-01 | 4.0 | ORIG001 | 20.0 | |
| 41.0 | 2019-07-01 | 10.0 | ORIG001 | 50.0 | |
| 42.0 | 2019-07-01 | 6.0 | ORIG001 | 30.0 | |
| 43.0 | 2019-07-02 | 2.0 | ORIG001 | 10.0 | |
| 44.0 | 2019-07-02 | 4.0 | ORIG001 | 20.0 | |
| 45.0 | 2019-07-02 | 14.0 | ORIG001 | 70.0 | |
| 46.0 | 2019-07-02 | 12.0 | ORIG001 | 60.0 | |
| 47.0 | 2019-07-02 | 10.0 | ORIG001 | 50.0 | |
| 48.0 | 2019-07-02 | 4.0 | ORIG001 | 20.0 | |
| 49.0 | 2019-07-02 | 4.0 | ORIG001 | 20.0 | |
| 50.0 | 2019-07-03 | 4.0 | ORIG001 | 20.0 | |
| 51.0 | 2019-07-03 | 4.0 | ORIG001 | 20.0 | |
| 52.0 | 2019-07-04 | 6.0 | ORIG001 | 30.0 | |
| 53.0 | 2019-07-04 | 8.0 | ORIG001 | 40.0 | |
| 54.0 | 2019-07-04 | 4.0 | ORIG001 | 20.0 | |
| 55.0 | 2019-07-05 | 6.0 | ORIG001 | 30.0 | |
| 56.0 | 2019-07-05 | 2.0 | ORIG001 | 10.0 | |
| 57.0 | 2019-07-05 | 2.0 | ORIG001 | 10.0 | |
| 58.0 | 2019-07-05 | 6.0 | ORIG001 | 30.0 | |
| 59.0 | 2019-07-05 | 2.0 | ORIG001 | 10.0 | |
| 60.0 | 2019-07-05 | 4.0 | ORIG001 | 20.0 | |
| 61.0 | 2019-07-05 | 6.0 | ORIG001 | 30.0 | |
| 62.0 | 2019-07-05 | 4.0 | ORIG001 | 20.0 | |
| 63.0 | 2019-07-06 | 4.0 | ORIG001 | 20.0 | |
| 64.0 | 2019-07-06 | 2.0 | ORIG001 | 10.0 | |
| 65.0 | 2019-07-06 | 2.0 | ORIG001 | 10.0 | |
| 66.0 | 2019-07-06 | 12.0 | ORIG001 | 60.0 | |
| 67.0 | 2019-06-30 | 8.0 | CARA002 | 48.0 | |
| 68.0 | 2019-06-30 | 5.0 | CARA002 | 30.0 | |
| 69.0 | 2019-06-30 | 8.0 | CARA002 | 48.0 | |
| 70.0 | 2019-06-30 | 4.0 | CARA002 | 24.0 | |
| 71.0 | 2019-07-01 | 2.0 | CARA002 | 12.0 | |
| 72.0 | 2019-07-01 | 2.0 | CARA002 | 12.0 | |
| 73.0 | 2019-07-01 | 6.0 | CARA002 | 36.0 | |
| 74.0 | 2019-07-01 | 4.0 | CARA002 | 24.0 | |
| 75.0 | 2019-07-01 | 2.0 | CARA002 | 12.0 | |
| 76.0 | 2019-07-02 | 6.0 | CARA002 | 36.0 | |
| 77.0 | 2019-07-02 | 10.0 | CARA002 | 60.0 | |
| 78.0 | 2019-07-02 | 2.0 | CARA002 | 12.0 | |
| 79.0 | 2019-07-02 | 2.0 | CARA002 | 12.0 | |
| 80.0 | 2019-07-03 | 2.0 | CARA002 | 12.0 | |
| 81.0 | 2019-07-03 | 6.0 | CARA002 | 36.0 | |
| 82.0 | 2019-07-04 | 2.0 | CARA002 | 12.0 | |
| 83.0 | 2019-07-04 | 12.0 | CARA002 | 72.0 | |
| 84.0 | 2019-07-04 | 2.0 | CARA002 | 12.0 | |
| 85.0 | 2019-07-05 | 4.0 | CARA002 | 24.0 | |
| 86.0 | 2019-07-05 | 2.0 | CARA002 | 12.0 | |
| 87.0 | 2019-07-05 | 6.0 | CARA002 | 36.0 | |
| 88.0 | 2019-07-05 | 2.0 | CARA002 | 12.0 | |
| 89.0 | 2019-07-06 | 6.0 | CARA002 | 36.0 | |
| 90.0 | 2019-07-06 | 4.0 | CARA002 | 24.0 | |
| 91.0 | 2019-07-06 | 2.0 | CARA002 | 12.0 | |
| 92.0 | 2019-07-06 | 4.0 | CARA002 | 24.0 | |
| 93.0 | 2019-07-06 | 2.0 | CARA002 | 12.0 | |
| 94.0 | 2019-07-06 | 10.0 | CARA002 | 60.0 | |
| 95.0 | 2019-06-30 | 8.0 | TRUF003 | 52.0 | |
| 96.0 | 2019-06-30 | 2.0 | TRUF003 | 13.0 | |
| 97.0 | 2019-06-30 | 14.0 | TRUF003 | 91.0 | |
| 98.0 | 2019-07-01 | 5.0 | TRUF003 | 32.5 | |
| 99.0 | 2019-07-01 | 6.0 | TRUF003 | 39.0 | |
| 100.0 | 2019-07-01 | 12.0 | TRUF003 | 78.0 | |
| 101.0 | 2019-07-02 | 2.0 | TRUF003 | 13.0 | |
| 102.0 | 2019-07-02 | 2.0 | TRUF003 | 13.0 | |
| 103.0 | 2019-07-02 | 2.0 | TRUF003 | 13.0 | |
| 104.0 | 2019-07-03 | 2.0 | TRUF003 | 13.0 | |
| 105.0 | 2019-07-03 | 2.0 | TRUF003 | 13.0 | |
| 106.0 | 2019-07-04 | 8.0 | TRUF003 | 52.0 | |
| 107.0 | 2019-07-05 | 4.0 | TRUF003 | 26.0 | |
| 108.0 | 2019-07-05 | 4.0 | TRUF003 | 26.0 | |
| 109.0 | 2019-07-05 | 8.0 | TRUF003 | 52.0 | |
| 110.0 | 2019-07-05 | 6.0 | TRUF003 | 39.0 | |
| 111.0 | 2019-07-06 | 2.0 | TRUF003 | 13.0 | |
| 112.0 | 2019-07-06 | 2.0 | TRUF003 | 13.0 | |
| 113.0 | 2019-07-06 | 2.0 | TRUF003 | 13.0 | |
| 114.0 | 2019-07-06 | 4.0 | TRUF003 | 26.0 | |
| 115.0 | 2019-07-06 | 10.0 | TRUF003 | 65.0 | |
| 116.0 | 2019-07-06 | 4.0 | TRUF003 | 26.0 | |
| 117.0 | 2019-07-06 | 6.0 | TRUF003 | 39.0 | |
| 500.0 | 1004-12-26 | 100.0 | Popcorn | 1000.0 |