Views
| Name | Description |
|---|---|
 Alphabetical list of products |
Underlying query for Alphabetical List of Products report. |
| Category Sales for 1997 |
Totals product sales by category based on values returned by the Product Sales for 1995 query. |
| Current Product List |
Filters records in Products table; query returns only products that are not discontinued. |
| Customer and Suppliers by City |
|
| Invoices |
(Criteria) Record source for Invoice report. Based on six tables. Includes expressions that concatenate first and last employee name and that use the CCur function to calculate extended price. |
| Order Details Extended |
Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. |
| Order Subtotals |
Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order. |
| Orders Qry |
Underlying query for the Orders form. |
| Product Sales for 1997 |
Record source for Category Sales for 1995 query. Uses Sum and CCur functions. |
| Products Above Average Price |
(Subquery) Returns products that have a unit price higher than the average. |
| Products by Category |
Underlying query for the Products by Category report. |
| Quarterly Orders |
Record source for Quarterly Orders form. Lists only customers who had orders in 1995. |
| Sales by Category |
Record source for Sales by Category report. |
| Sales Totals by Amount |
|
| Summary of Sales by Quarter |
|
| Summary of Sales by Year |