Database reference - Nwind_new

Nwind_new -  views

View overview

name created modified columns code length dependents depends on comment
~sq_cCategories~sq_cProduct List 8/16/2008 9:43:31 PM 8/16/2008 9:43:31 PM 10 126 0 2 Product names, suppliers, prices, and units in stock. 
~sq_cCustomer Labels Dialog~sq_cSelectCountry 8/16/2008 9:43:31 PM 8/16/2008 9:43:31 PM 1 85 0 1 Customers' names, addresses, and phone numbers. 
~sq_cCustomer Orders~sq_cCustomer Orders Subform1 8/12/2008 10:02:16 PM 8/12/2008 10:02:16 PM 14 131 0 1 Customer name, order date, and freight charge for each order. 
~sq_cCustomer Orders~sq_cCustomer Orders Subform2 8/12/2008 10:02:16 PM 8/12/2008 10:02:16 PM 7 202 0 3 Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. 
~sq_cCustomers~sq_cCountry 8/12/2008 10:02:30 PM 8/12/2008 10:02:30 PM 1 57 0 1 Customers' names, addresses, and phone numbers. 
~sq_cEmployees (page break)~sq_cReportsTo 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 2 159 0 1 Employees' names, titles, and personal information. 
~sq_cEmployees~sq_cReportsTo 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 2 159 0 1 Employees' names, titles, and personal information. 
~sq_cOrders~sq_cCustomerID 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 2 124 0 1 Customers' names, addresses, and phone numbers. 
~sq_cOrders~sq_cEmployeeID 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 2 171 0 1 Employees' names, titles, and personal information. 
~sq_cOrders~sq_cOrders Subform 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 7 129 0 3 Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. 
~sq_cProducts~sq_cCategoryID 11/22/2006 8:19:43 PM 11/22/2006 8:19:43 PM 2 140 0 1 Categories of Northwind products. 
~sq_cProducts~sq_cSupplierID 11/22/2006 8:19:43 PM 11/22/2006 8:19:43 PM 2 136 0 1 Suppliers' names, addresses, phone numbers, and hyperlinks to home pages. 
~sq_cQuarterly Orders~sq_cQuarterly Orders Subform 11/22/2006 8:19:47 PM 11/22/2006 8:19:47 PM 7 155 0 3 (Crosstab) Record source for Quarterly Orders Subform. 
~sq_cSales Reports Dialog~sq_cSelectCategory 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 1 101 0 1 Categories of Northwind products. 
~sq_dSales by Category~sq_dSales by Category Subreport 8/16/2008 9:43:31 PM 8/16/2008 9:43:31 PM 4 152 0 1 Record source for Sales by Category report. 
~sq_dSales by Year~sq_dSales by Year Subreport 11/23/2006 10:03:05 PM 11/23/2006 10:03:05 PM 0 120 0 1  
~sq_fCategories 8/16/2008 9:43:31 PM 8/16/2008 9:43:31 PM 4 45 0 1 Categories of Northwind products. 
~sq_fCustomer Orders 8/12/2008 10:02:16 PM 8/12/2008 10:02:16 PM 11 44 0 1 Customers' names, addresses, and phone numbers. 
~sq_fCustomer Orders Subform1 8/16/2008 9:50:02 PM 8/16/2008 9:50:02 PM 14 41 0 1 Customer name, order date, and freight charge for each order. 
~sq_fCustomer Phone List 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 11 44 0 1 Customers' names, addresses, and phone numbers. 
~sq_fCustomers 8/12/2008 10:02:30 PM 8/12/2008 10:02:30 PM 11 44 0 1 Customers' names, addresses, and phone numbers. 
~sq_fEmployees 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 17 44 0 1 Employees' names, titles, and personal information. 
~sq_fEmployees (page break) 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 17 44 0 1 Employees' names, titles, and personal information. 
~sq_fProducts 11/22/2006 8:19:43 PM 11/22/2006 8:19:43 PM 10 43 0 1 Product names, suppliers, prices, and units in stock. 
~sq_fSuppliers 8/16/2008 9:43:30 PM 8/16/2008 9:43:30 PM 12 44 0 1 Suppliers' names, addresses, phone numbers, and hyperlinks to home pages. 
~sq_rCustomer Labels 8/16/2008 9:43:32 PM 8/16/2008 9:43:32 PM 11 44 0 1 Customers' names, addresses, and phone numbers. 
Alphabetical List of Products 6/21/1996 6:18:30 PM 8/16/2008 9:43:32 PM 11 196 0 2 Underlying query for Alphabetical List of Products report. 
Catalog 6/21/1996 6:19:56 PM 8/16/2008 9:43:32 PM 7 346 0 2 Underlying query for the Catalog report. 
Category Sales for 1995 9/13/1995 10:51:43 AM 8/16/2008 9:43:29 PM 2 210 0 1 Totals product sales by category based on values returned by the Product Sales for 1995 query. 
Current Product List 9/13/1995 10:51:43 AM 8/16/2008 9:43:29 PM 2 187 0 1 Filters records in Products table; query returns only products that are not discontinued. 
Customers and Suppliers by City 9/13/1995 10:51:43 AM 8/16/2008 9:43:29 PM 4 242 0 2 (Union) Returns list of suppliers and customers in each city. 
Employee Sales by Country 9/13/1995 10:51:44 AM 8/16/2008 9:43:29 PM 6 500 0 2 (Parameter) Record source for Employee Sales by Country report. Prompts for beginning and ending dates. 
Invoices 9/13/1995 10:51:44 AM 8/16/2008 9:43:29 PM 26 1,170 1 3 (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. 
Invoices Filter 9/13/1995 10:51:44 AM 8/16/2008 9:43:29 PM 26 103 0 1 Filters records in Invoice report. Referred to in the Click event of the Print button on the Orders form. 
Order Details Extended 9/13/1995 10:51:45 AM 8/16/2008 9:43:30 PM 7 428 3 2 Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. 
Order Subtotals 9/13/1995 10:51:45 AM 8/16/2008 9:43:29 PM 2 182 5 1 Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order. 
Orders Qry 6/21/1996 6:14:06 PM 8/16/2008 9:43:30 PM 20 601 0 2 Underlying query for the Orders form. 
Product Sales for 1995 9/13/1995 10:51:45 AM 8/16/2008 9:43:30 PM 3 541 1 2 Record source for Category Sales for 1995 query. Uses Sum and CCur functions. 
Products Above Average Price 9/13/1995 10:51:45 AM 8/16/2008 9:43:30 PM 2 194 0 1 (Subquery) Returns products that have a unit price higher than the average. 
Products by Category 6/21/1996 6:22:44 PM 8/16/2008 9:43:31 PM 5 360 0 2 Underlying query for the Products by Category report. 
Quarterly Orders 9/13/1995 10:51:45 AM 8/16/2008 9:43:30 PM 4 270 1 2 Record source for Quarterly Orders form. Lists only customers who had orders in 1995. 
Quarterly Orders by Product 9/13/1995 10:51:46 AM 8/16/2008 9:43:30 PM 7 627 1 2 (Crosstab) Record source for Quarterly Orders Subform. 
query_MSysObjects 8/16/2008 9:41:00 PM 8/16/2008 10:24:08 PM 2 76 0 0  
Sales by Category 9/13/1995 10:51:46 AM 8/16/2008 9:43:31 PM 4 628 1 3 Record source for Sales by Category report. 
Sales by Year 9/13/1995 10:51:46 AM 8/16/2008 9:43:30 PM 0 552 1 2 (Parameter) Record source for Sales by Year report and its subreport. Refers to controls on Sales by Year Dialog for parameter values. Uses Format function to return the year value of a shipped date. 
Sales Totals by Amount 6/21/1996 6:24:36 PM 8/16/2008 9:43:31 PM 4 415 0 2 Underlying query for the Sales Totals by Amount report. 
Summary of Sales by Quarter 6/21/1996 6:25:53 PM 8/16/2008 9:43:31 PM 3 268 0 2 Underlying query for the Summary of Sales by Quarter report. 
Summary of Sales by Year 6/21/1996 6:27:04 PM 8/16/2008 9:43:31 PM 3 268 0 2 Underlying query for the Summary of Sales by Year report. 
Ten Most Expensive Products 9/13/1995 10:51:47 AM 8/16/2008 9:43:30 PM 2 157 0 1 (Top Values) Returns 10 most expensive products. Specifies the number of highest values to return using the Top Values box on the toolbar. 
ULCustomerQuery 8/16/2008 9:11:07 PM 8/16/2008 9:43:30 PM 2 155 0 1  


Largest views by code length



Documentation generated by SqlSpec