New Perspectives Excel 2019 | Excel Module 10 SAM Textbook project    Cup and Platter          Author     Date     Purpose    To retrieve short-term and long-term financial data for select group of Cup and Platter products from a variety of data sources Cup and Platter         Data Sources                  Support_EX_10_History.csv         Field    Data Type    Notes Year    integer    Calendar year from 1999 to 2021 Business Year    integer    Year of Cup and Platter business operation, starting with Year 1 Revenue ($mil)    decimal    Annual revenue in millions of dollars Units Sold    integer    Annual units sold of all items Notes    text    Descriptive information about the year's events          Support_EX_10_TwoYear.csv         Field    Data Type    Notes Date    date    Date range from 1/1/2020 to 12/31/2021 Daily Revenue    integer    Sales revenue collected daily at Cup and Platter          Support_EX_10_Data.accdb         Customers Table         Field    Data Type    Notes Cust ID    text    Customer ID number City    text    Customer's city of residence State    text    Customer's state of residence (all customers are from the United States) Postal Code    text    Customer's postal code          Orders Table         Field    Data Type    Notes Order ID    text    Order ID number Order Date    date    Date on which the order was placed Store ID    text    Store ID number Cust ID    text    Customer ID number Items    integer    Quantity of items in the order Cost    currency    Cost of the quantity of items ordered Tax    currency    Sales tax on the items ordered Shipping    currency    Shipping charge for items ordered, if necessary Total Charge    currency    Total chart to the customer for the items ordered          Product Orders Table         Field    Data Type    Notes Order ID    text    Order ID number Product ID    text    Product ID number Quantity    integer    Quantity of the product ordered Revenue    currency    Revenue generated from the ordered products          Products Table         Field    Data Type    Notes Product ID    text    Product ID number Category    text    General product category Subcategory    text    Subcategory of the product category Description    text    Short summary description of the product          Stores Table         Field    Data Type    Notes Store ID    text    Store ID number Type    list    Type of store (Website or Brick-and-Mortar) Store Name    list    Name of store (Website, Brooklyn, Philadelphia, Washington DC, Chicago, Indianapolis) Address    text    Web address or street address of store City    text    City location of the brick store State    text    State location of the brick store Postal Code    text    Postal code of the brick store Phone    text    Phone number of the brick store Manager    text    Website manager or store manager Established    integer    Year in which the store was established