Application: Northwind
Name | Type | Value |
---|---|---|
Name | Memo | C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb |
Connect | Memo | |
Transactions | Yes/No | True |
Updatable | Yes/No | True |
CollatingOrder | Long Integer | 1033 |
QueryTimeout | Long Integer | 60 |
Version | Memo | 3.0 |
RecordsAffected | Single | 0 |
ReplicaID | GUID | |
DesignMasterID | GUID | |
Connection | Empty | |
AccessVersion | String | 07.53 |
Build | Single | 5903 |
StartUpForm | String | (none) |
StartUpShowDBWindow | Yes/No | True |
StartUpShowStatusBar | Yes/No | True |
AllowShortcutMenus | Yes/No | True |
AllowFullMenus | Yes/No | True |
AllowBuiltInToolbars | Yes/No | True |
AllowToolbarChanges | Yes/No | True |
AllowBreakIntoCode | Yes/No | True |
AllowSpecialKeys | Yes/No | True |
StartUpMenuBar | String | NorthwindCustomMenuBar |
Click here to return to the contents list
Name | Created | Last Updated | Record Count | Type | Description |
---|---|---|---|---|---|
Categories | 13/09/1995 10:51:30 | 13/09/1995 10:52:27 | 8 | Normal table | Categories of Northwind products. |
Customers | 13/09/1995 10:51:32 | 20/08/1996 11:27:43 | 91 | Normal table | Customers' names, addresses, and phone numbers. |
Employees | 13/09/1995 10:51:33 | 20/08/1996 15:45:24 | 9 | Normal table | Employees' names, titles, and personal information. |
Order Details | 13/09/1995 10:51:34 | 20/08/1996 19:30:21 | 2155 | Normal table | Details on products, quantities, and prices for each order in the Orders table. |
Orders | 13/09/1995 10:51:38 | 13/09/1995 10:52:28 | 830 | Normal table | Customer name, order date, and freight charge for each order. |
Products | 13/09/1995 10:51:41 | 16/09/1996 18:22:40 | 77 | Normal table | Product names, suppliers, prices, and units in stock. |
Shippers | 13/09/1995 10:51:42 | 13/09/1995 10:52:28 | 3 | Normal table | Shippers' names and phone numbers. |
Suppliers | 13/09/1995 10:51:42 | 25/09/1996 13:45:39 | 29 | Normal table | Suppliers' names, addresses, phone numbers, and hyperlinks to home pages. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
CategoryID | Auto Number | False | True | Number automatically assigned to a new category. | |
CategoryName | Text (15) | True | False | Name of food category. | |
Description | Memo | False | False | ||
Picture | Long Binary (OLE Object) | False | False | A picture representing the food category. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
CustomerID | Text (5) | False | True | Unique five-character code based on customer name. | |
CompanyName | Text (40) | True | False | ||
ContactName | Text (30) | False | False | ||
ContactTitle | Text (30) | False | False | ||
Address | Text (60) | False | False | Street or post-office box. | |
City | Text (15) | False | False | ||
Region | Text (15) | False | False | State or province. | |
PostalCode | Text (10) | False | False | ||
Country | Text (15) | False | False | ||
Phone | Text (24) | False | False | Phone number includes country code or area code. | |
Fax | Text (24) | False | False | Phone number includes country code or area code. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
EmployeeID | Auto Number | False | True | Number automatically assigned to new employee. | |
LastName | Text (20) | True | False | ||
FirstName | Text (10) | True | False | ||
Title | Text (30) | False | False | Employee's title. | |
TitleOfCourtesy | Text (25) | False | False | Title used in salutations. | |
BirthDate | Date / Time | False | False | ||
HireDate | Date / Time | False | False | ||
Address | Text (60) | False | False | Street or post-office box. | |
City | Text (15) | False | False | ||
Region | Text (15) | False | False | State or province. | |
PostalCode | Text (10) | False | False | ||
Country | Text (15) | False | False | ||
HomePhone | Text (24) | False | False | Phone number includes country code or area code. | |
Extension | Text (4) | False | False | Internal telephone extension number. | |
Photo | Long Binary (OLE Object) | False | False | Picture of employee. | |
Notes | Memo | False | False | General information about employee's background. | |
ReportsTo | Long | False | False | Employee's supervisor. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
OrderID | Long | False | True | Same as Order ID in Orders table. | |
ProductID | Long | True | True | Same as Product ID in Products table. | |
UnitPrice | 0 | Currency | True | False | |
Quantity | 1 | Integer | True | False | |
Discount | 0 | Single | True | False |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
OrderID | Auto Number | False | True | Unique order number. | |
CustomerID | Text (5) | False | False | Same entry as in Customers table. | |
EmployeeID | Long | False | False | Same entry as in Employees table. | |
OrderDate | Date / Time | False | False | ||
RequiredDate | Date / Time | False | False | ||
ShippedDate | Date / Time | False | False | ||
ShipVia | Long | False | False | Same as Shipper ID in Shippers table. | |
Freight | 0 | Currency | False | False | |
ShipName | Text (40) | False | False | Name of person or company to receive the shipment. | |
ShipAddress | Text (60) | False | False | Street address only -- no post-office box allowed. | |
ShipCity | Text (15) | False | False | ||
ShipRegion | Text (15) | False | False | State or province. | |
ShipPostalCode | Text (10) | False | False | ||
ShipCountry | Text (15) | False | False |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
ProductID | Auto Number | False | True | Number automatically assigned to new product. | |
ProductName | Text (40) | True | False | ||
SupplierID | Long | False | False | Same entry as in Suppliers table. | |
CategoryID | Long | False | False | Same entry as in Categories table. | |
QuantityPerUnit | Text (20) | False | False | (e.g., 24-count case, 1-liter bottle). | |
UnitPrice | 0 | Currency | False | False | |
UnitsInStock | 0 | Integer | False | False | |
UnitsOnOrder | 0 | Integer | False | False | |
ReorderLevel | 0 | Integer | False | False | Minimum units to maintain in stock. |
Discontinued | =No | Boolean | False | False | Yes means item is no longer available. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
ShipperID | Auto Number | False | True | Number automatically assigned to new shipper. | |
CompanyName | Text (40) | True | False | Name of shipping company. | |
Phone | Text (24) | False | False | Phone number includes country code or area code. |
Fieldname | Default Value | Data Type | Required | Is PK? | Description |
---|---|---|---|---|---|
SupplierID | Auto Number | False | True | Number automatically assigned to new supplier. | |
CompanyName | Text (40) | True | False | ||
ContactName | Text (30) | False | False | ||
ContactTitle | Text (30) | False | False | ||
Address | Text (60) | False | False | Street or post-office box. | |
City | Text (15) | False | False | ||
Region | Text (15) | False | False | State or province. | |
PostalCode | Text (10) | False | False | ||
Country | Text (15) | False | False | ||
Phone | Text (24) | False | False | Phone number includes country code or area code. | |
Fax | Text (24) | False | False | Phone number includes country code or area code. | |
HomePage | Hyperlink | False | False | Supplier's home page on World Wide Web. |
Click here to return to the contents list
Name | Type | SQL | Description |
---|---|---|---|
Alphabetical List of Products | Unknown Query type 8 | SELECT DISTINCTROW Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=No));
| Underlying query for Alphabetical List of Products report. |
Catalog | Unknown Query type 8 | SELECT DISTINCTROW Categories.CategoryName, Categories.Description, Categories.Picture, Products.ProductID, Products.ProductName, Products.QuantityPerUnit, Products.UnitPrice
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=No));
| Underlying query for the Catalog report. |
Category Sales for 1995 | Select | SELECT DISTINCTROW [Product Sales for 1995].CategoryName, Sum([Product Sales for 1995].ProductSales) AS CategorySales
FROM [Product Sales for 1995]
GROUP BY [Product Sales for 1995].CategoryName;
| Totals product sales by category based on values returned by the Product Sales for 1995 query. |
Current Product List | Select | SELECT [Product List].ProductID, [Product List].ProductName
FROM Products AS [Product List]
WHERE ((([Product List].Discontinued)=No))
ORDER BY [Product List].ProductName;
| Filters records in Products table; query returns only products that are not discontinued. |
Customers and Suppliers by City | Union | SELECT City, CompanyName, ContactName, "Customers" AS [Relationship]
FROM Customers
UNION SELECT City, CompanyName, ContactName, "Suppliers"
FROM Suppliers
ORDER BY City, CompanyName;
| (Union) Returns list of suppliers and customers in each city. |
Employee Sales by Country | Select | PARAMETERS [Beginning Date] DateTime, [Ending Date] DateTime;
SELECT DISTINCTROW Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal AS SaleAmount
FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Employees.EmployeeID = Orders.EmployeeID
WHERE (((Orders.ShippedDate) Between [Beginning Date] And [Ending Date]));
| (Parameter) Record source for Employee Sales by Country report. Prompts for beginning and ending dates. |
Invoices | Select | SELECT DISTINCTROW Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country, [FirstName] & " " & [LastName] AS Salesperson, Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount, CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100 AS ExtendedPrice, Orders.Freight
FROM Shippers INNER JOIN (Products INNER JOIN ((Employees INNER JOIN (Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) ON Employees.EmployeeID = Orders.EmployeeID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID) ON Shippers.ShipperID = Orders.ShipVia;
| (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 | Select | SELECT DISTINCTROW Invoices.*
FROM Invoices
WHERE (((Invoices.OrderID)=[Forms]![Orders]![OrderID]));
| Filters records in Invoice report. Referred to in the Click event of the Print button on the Orders form. |
Order Details Extended | Select | SELECT DISTINCTROW [Order Details].OrderID, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount, CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100 AS ExtendedPrice
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID
ORDER BY [Order Details].OrderID;
| Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. |
Order Subtotals | Select | SELECT DISTINCTROW [Order Details].OrderID, Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100) AS Subtotal
FROM [Order Details]
GROUP BY [Order Details].OrderID;
| Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order. |
Orders Qry | Unknown Query type 8 | SELECT DISTINCTROW Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
| Underlying query for the Orders form. |
Product Sales for 1995 | Select | SELECT DISTINCTROW Categories.CategoryName, Products.ProductName, Sum(CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100) AS ProductSales
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID
WHERE (((Orders.ShippedDate) Between #1/1/95# And #12/31/95#))
GROUP BY Categories.CategoryName, Products.ProductName;
| Record source for Category Sales for 1995 query. Uses Sum and CCur functions. |
Products Above Average Price | Select | SELECT DISTINCTROW Products.ProductName, Products.UnitPrice
FROM Products
WHERE (((Products.UnitPrice)>(SELECT AVG([UnitPrice]) From Products)))
ORDER BY Products.UnitPrice DESC;
| (Subquery) Returns products that have a unit price higher than the average. |
Products by Category | Unknown Query type 8 | SELECT DISTINCTROW Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)<>Yes))
ORDER BY Categories.CategoryName, Products.ProductName;
| Underlying query for the Products by Category report. |
Quarterly Orders | Select | SELECT DISTINCTROW Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Orders.OrderDate) Between #1/1/95# And #12/31/95#));
| Record source for Quarterly Orders form. Lists only customers who had orders in 1995. |
Quarterly Orders by Product | Crosstab | TRANSFORM Sum(CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100) AS ProductAmount
SELECT Products.ProductName, Orders.CustomerID, Year([OrderDate]) AS OrderYear
FROM Products INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID
WHERE (((Orders.OrderDate) Between #1/1/95# And #12/31/95#))
GROUP BY Products.ProductName, Orders.CustomerID, Year([OrderDate])
PIVOT "Qtr " & DatePart("q",[OrderDate],1,0) In ("Qtr 1","Qtr 2","Qtr 3","Qtr 4");
| (Crosstab) Record source for Quarterly Orders Subform. |
Sales by Category | Select | SELECT DISTINCTROW Categories.CategoryID, Categories.CategoryName, Products.ProductName, Sum([Order Details Extended].ExtendedPrice) AS ProductSales
FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details Extended] ON Orders.OrderID = [Order Details Extended].OrderID) ON Products.ProductID = [Order Details Extended].ProductID) ON Categories.CategoryID = Products.CategoryID
WHERE (((Orders.OrderDate) Between #1/1/95# And #12/31/95#))
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName
ORDER BY Products.ProductName;
| Record source for Sales by Category report. |
Sales by Year | Select | PARAMETERS Forms![Sales by Year Dialog]!BeginningDate DateTime, Forms![Sales by Year Dialog]!EndingDate DateTime;
SELECT DISTINCTROW Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal, Format([ShippedDate],"yyyy") AS Year
FROM Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID
WHERE (((Orders.ShippedDate) Is Not Null And (Orders.ShippedDate) Between [Forms]![Sales by Year Dialog]![BeginningDate] And [Forms]![Sales by Year Dialog]![EndingDate]));
| (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 | Unknown Query type 8 | SELECT DISTINCTROW [Order Subtotals].Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName, Orders.ShippedDate
FROM Customers INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Customers.CustomerID = Orders.CustomerID
WHERE ((([Order Subtotals].Subtotal)>2500) AND ((Orders.ShippedDate) Between #1/1/95# And #12/31/95#));
| Underlying query for the Sales Totals by Amount report. |
Summary of Sales by Quarter | Unknown Query type 8 | SELECT DISTINCTROW Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal
FROM Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID
WHERE (((Orders.ShippedDate) Is Not Null))
ORDER BY Orders.ShippedDate;
| Underlying query for the Summary of Sales by Quarter report. |
Summary of Sales by Year | Unknown Query type 8 | SELECT DISTINCTROW Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal
FROM Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID
WHERE (((Orders.ShippedDate) Is Not Null))
ORDER BY Orders.ShippedDate;
| Underlying query for the Summary of Sales by Year report. |
Ten Most Expensive Products | Select | SELECT DISTINCTROW TOP 10 Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC;
| (Top Values) Returns 10 most expensive products. Specifies the number of highest values to return using the Top Values box on the toolbar. |
Click here to return to the contents list
Name | Created | Last Updated | Has Module | Record Source | Description |
---|---|---|---|---|---|
Categories | 13/09/1995 10:51:50 | 21/08/1996 10:03:29 | False | Categories | Add and edit product categories. Main form displays category information; subform displays limited product information. |
Customer Labels Dialog | 13/09/1995 10:51:51 | 21/08/1996 09:43:32 | False | Dialog box used to preview or print Customer Labels report. Uses option group to specify all countries or specific country, and a combo box to select the country. Has Preview, Print, and Cancel command buttons. Uses macros. | |
Customer Orders | 13/09/1995 10:51:51 | 16/09/1996 18:46:23 | False | Customers | Read-only form. Displays customer name and country. Displays all the orders for the selected company or country and then displays detail records for selected order. |
Customer Orders Subform1 | 24/07/1996 16:27:27 | 10/10/1996 10:47:12 | True | Orders | Subform used on Customer Orders form. |
Customer Orders Subform2 | 13/09/1995 10:51:53 | 16/09/1996 18:47:36 | False | Order Details Extended | Subform used on Customer Orders form. |
Customer Phone List | 13/09/1995 10:51:53 | 27/09/1996 13:47:52 | False | Customers | View and print customer phone numbers. Uses a macro and alphabetical buttons to filter company names. Form header and footer display only in Form view. |
Customers | 13/09/1995 10:51:55 | 21/08/1996 10:05:19 | False | Customers | Add and edit customer information such as name, address, and phone number. Single-column form; uses a background picture; uses macro to validate customer ID. |
Employees | 24/05/1996 12:25:01 | 10/10/1996 10:47:12 | True | Employees | Add and edit corporate and personal information for employees. Uses tab control to separate company information from personal information; has photo of employee. |
Employees (page break) | 13/09/1995 10:51:55 | 21/08/1996 11:38:29 | False | Employees | Add and edit corporate and personal information for employees. Two-page form; uses command buttons to page up and down; has photo of employee. |
Main Switchboard | 13/09/1995 10:51:56 | 10/10/1996 10:47:12 | True | Provides access to other forms and reports in the database. Uses command buttons to open other forms. Displays Northwind logo. | |
Orders | 27/09/1996 13:49:30 | 10/10/1996 10:47:12 | True | Orders Qry | Add and edit orders. Has order information in main form; products ordered in subform. Calculates order subtotal in subform and displays it on main form. Has button that prints Invoice report for current order. Has button that opens a Word document. |
Orders Subform | 13/09/1995 10:51:58 | 10/10/1996 10:47:12 | True | Order Details Extended | Subform used on Orders form. |
Product List | 13/09/1995 10:51:59 | 05/09/1996 16:48:09 | False | Products | View limited product information. Used as a pop-up form with Suppliers form; used as a subform on Categories form. |
Products | 27/09/1996 13:49:32 | 10/10/1996 10:47:12 | True | Products | Add and edit complete product information. Single-column form; uses a background picture. Has button that previews product report. Has button that outputs product report as HTML. |
Quarterly Orders | 13/09/1995 10:52:00 | 21/08/1996 10:05:53 | False | Quarterly Orders | Read-only form. Displays quarter totals for each product and a total for 1994. |
Quarterly Orders Subform | 13/09/1995 10:52:01 | 21/08/1996 10:06:07 | False | Quarterly Orders by Product | Subform used on Quarterly Orders form. |
Sales Analysis | 15/09/1995 19:52:55 | 10/10/1996 10:47:12 | True | Review employee sales for one country or all countries in a PivotTable. Totals include each employee's sales for each quarter, and total and average sales for each year. | |
Sales by Year Dialog | 13/09/1995 10:52:04 | 10/10/1996 10:47:12 | True | Dialog box opened from Open event of Sales by Year report. Prompts for beginning and ending date; has check box for displaying detail records; has OK and Cancel command buttons. Uses event procedures. | |
Sales Reports Dialog | 13/09/1995 10:52:05 | 10/10/1996 10:47:12 | True | Dialog box used to preview or print sales reports. Displays report choices in an option group; enables a combo box to select a category for one report. Has Preview, Print, and Cancel command buttons. Uses event procedures. | |
Startup | 13/09/1995 10:52:06 | 16/09/1996 18:51:28 | False | Displays description of and instructions for using the Northwind sample database. Modal, pop-up form; displays Northwind logo; uses event procedures to make light flash and to reset startup form option. | |
Suppliers | 27/09/1996 13:49:33 | 10/10/1996 10:47:12 | True | Suppliers | Add and edit supplier information such as name, address, phone number, and hyperlink to home page. Uses command buttons and event procedures to open the Product List and Products forms. |
Click here to return to the contents list
Name | Created | Last Updated | Has Module | Record Source | Description |
---|---|---|---|---|---|
Alphabetical List of Products | 13/09/1995 10:52:10 | 16/09/1996 18:52:29 | False | Alphabetical List of Products | Prints products grouped by first letter of name. Uses Left function to return first character of product names. |
Catalog | 13/09/1995 10:52:11 | 16/09/1996 18:53:11 | False | Catalog | Prints a catalog of products. Has two-page report header; uses photos for each category; starts each category on a new page; keeps all records for a category on same page; prints an order form in the report footer on a separate page. |
Customer Labels | 13/09/1995 10:52:12 | 16/09/1996 18:53:40 | False | Customers | Prints customers' company names and addresses on 3-up labels. |
Employee Sales by Country | 13/09/1995 10:52:13 | 10/10/1996 10:47:12 | True | Employee Sales by Country | Prints sales grouped by country and employee. Calculates subtotals, grand total, percents; prompts for date range; prints range on report; prints message when employee's total reaches goal; resets page number to 1 for new country. |
Invoice | 13/09/1995 10:52:15 | 16/09/1996 18:54:27 | False | Invoices | Prints each invoice on a separate page. Uses IIf function in address controls; uses Sum function to calculate invoice subtotal. |
Products by Category | 13/09/1995 10:52:15 | 16/09/1996 18:54:53 | False | Products by Category | Prints products by category. Has 3 columns per page; starts each category in new column; uses Count function to total products in each category. |
Sales by Category | 16/09/1996 11:18:12 | 16/09/1996 18:55:22 | False | Sales by Category | Prints sales for 1994 by category. Shows sales in a subreport and in a chart on the main report. |
Sales by Category Subreport | 13/09/1995 10:52:17 | 21/08/1996 13:43:19 | False | Sales by Category | Subreport for Sales by Category report. |
Sales by Year | 13/09/1995 10:52:19 | 10/10/1996 10:47:12 | True | Sales by Year | Prints quarter totals in subreport in group header; optionally prints detail records. Has form that prompts for date range; displays page header on pages that don't have a group header. |
Sales by Year Subreport | 13/09/1995 10:52:19 | 16/09/1996 18:56:00 | False | Sales by Year | Subreport for Sales by Year report. |
Sales Totals by Amount | 13/09/1995 10:52:21 | 16/09/1996 18:56:17 | False | Sales Totals by Amount | Prints sales in descending order by amount. Prints top 10 customers on first page; prints page total in page footer. |
Summary of Sales by Quarter | 13/09/1995 10:52:22 | 16/09/1996 18:56:36 | False | Summary of Sales by Quarter | Prints summary report showing sales from multiple years for each quarter. Uses DatePart function to group records by quarter; uses Count function to count orders and Sum function to calculate totals. |
Summary of Sales by Year | 13/09/1995 10:52:23 | 16/09/1996 18:56:59 | False | Summary of Sales by Year | Prints summary report showing quarterly sales for each year. Uses DatePart function to return year; uses Count function to count orders and Sum function to calculate totals. |
Click here to return to the contents list
Name | Created | Last Updated | Type | No. Lines | Description |
---|---|---|---|---|---|
Northwind Help Function | 02/08/1996 16:04:55 | 10/10/1996 10:47:12 | Normal Module | 55 | Contains the function that calls Show Me Help for Northwind. |
Startup | 30/08/1996 10:40:32 | 10/10/1996 10:46:51 | Normal Module | 99 | Functions used on the Startup form. |
Utility Functions | 13/09/1995 10:52:25 | 10/10/1996 10:47:12 | Normal Module | 21 | Functions used in database objects. |
Click here to return to the contents list
Prototype | No. Lines | Description |
---|---|---|
Function ShowHelpAPI() As Boolean | 37 |
Prototype | No. Lines | Description |
---|---|---|
Function OpenStartup() As Boolean | 32 | |
Function HideStartupForm() | 25 | |
Function CloseForm() | 4 | |
Function IsItAReplica() As Boolean | 22 |
Prototype | No. Lines | Description |
---|---|---|
Function IsLoaded(ByVal strFormName As String) As Boolean | 11 |
Click here to return to the contents list
Prototype | No. Lines | Description |
---|---|---|
Sub Form_Current() | 20 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub Form_AfterUpdate() | 3 |
Prototype | No. Lines | Description |
---|---|---|
Function OpenForms(strFormName As String) As Integer | 15 | |
Sub ExitMicrosoftAccess_Click() | 13 | |
Sub DisplayDatabaseWindow_Click() | 21 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub CustomerID_AfterUpdate() | 8 | |
Private Sub CustomerID_BeforeUpdate(Cancel As Integer) | 13 | |
Sub PrintInvoice_Click() | 23 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer) | 16 | |
Private Sub Form_BeforeUpdate(Cancel As Integer) | 16 | |
Private Sub Form_Error(DataErr As Integer, Response As Integer) | 14 | |
Private Sub ProductID_AfterUpdate() | 17 | |
Private Sub ProductID_BeforeUpdate(Cancel As Integer) | 17 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub OutputToHTML_Click() | 21 | |
Private Sub ProductName_AfterUpdate() | 9 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub btnEdit_Click() | 8 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub Cancel_Click() | 14 | |
Private Sub OK_Click() | 24 |
Prototype | No. Lines | Description |
---|---|---|
Sub PrintReports(PrintMode As Integer) | 29 | |
Private Sub Cancel_Click() | 13 | |
Private Sub Preview_Click() | 5 | |
Private Sub Print_Click() | 5 | |
Private Sub ReportToPrint_AfterUpdate() | 11 |
Prototype | No. Lines | Description |
---|---|---|
Sub AddProducts_Click() | 23 | |
Private Sub Form_BeforeUpdate(Cancel As Integer) | 29 | |
Private Sub Form_Close() | 5 | |
Private Sub Form_Current() | 23 | |
Private Sub ReviewProducts_Click() | 29 |
Click here to return to the contents list
Report Name | Module Name | No. Lines |
---|---|---|
Employee Sales by Country | Report_Employee Sales by Country | 46 |
Sales by Year | Report_Sales by Year | 136 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) | 4 | |
Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) | 12 | |
Private Sub Report_NoData(Cancel As Integer) | 13 |
Prototype | No. Lines | Description |
---|---|---|
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) | 5 | |
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer) | 12 | |
Private Sub GroupFooter1_Retreat() | 6 | |
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) | 21 | |
Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer) | 4 | |
Private Sub Report_Close() | 8 | |
Private Sub Report_NoData(Cancel As Integer) | 13 | |
Private Sub Report_Open(Cancel As Integer) | 20 | |
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) | 4 |
Click here to return to the contents list
Name | Date Created | Last Updated | Description |
---|---|---|---|
Customer Labels Dialog | 13/09/1995 10:52:23 | 19/08/1996 15:53:34 | Attached to the Customer Labels Dialog form. Previews or prints the Customer Labels report. Enables or disables the SelectCountry combo box. |
Customer Phone List | 27/09/1996 13:25:07 | 27/09/1996 13:25:09 | Attached to the Customer Phone Numbers form. Shows all records when form is opened; filters customers by first letter of company name. |
Customers | 13/09/1995 10:52:24 | 19/08/1996 16:08:29 | Attached to the Customers form. Validates that the customer ID is unique before you leave the field. |
Employees (page break) | 24/05/1996 13:20:30 | 19/08/1996 15:21:34 | Attached to the Employees (page break) form. Used to move between pages of the form. |
Sales Totals by Amount | 13/09/1995 10:52:24 | 10/06/1996 18:09:43 | Attached to the Sales Totals by Amount report. Shows a page break and hides the group footer after the 10th record; prints a page total in the page footer. |
Sample Autokeys | 13/09/1995 10:52:24 | 13/09/1995 10:52:24 | Defines a key combination used on the Customer Phone List form. Key combinations for other forms could be added. |
Suppliers | 13/09/1995 10:52:25 | 13/09/1995 10:52:25 | Could be attached to the Suppliers form. Opens the Product and Product List forms; synchronizes the records on the Suppliers and Product List forms when both are open; validates the postal code. |
Click here to return to the contents list
Primary Name | Foreign Name | Description |
---|---|---|
Categories.CategoryID | Products.CategoryID | |
Customers.CustomerID | Orders.CustomerID | Cascade updates |
Employees.EmployeeID | Orders.EmployeeID | |
Orders.OrderID | Order Details.OrderID | Cascade deletes |
Products.ProductID | Order Details.ProductID | |
Shippers.ShipperID | Orders.ShipVia | |
Suppliers.SupplierID | Products.SupplierID |
Click here to return to the contents list
Please note that MDBDoc97 only displays information about custom command bars.
Name | Visible | NameLocal |
---|---|---|
NorthwindCustomMenuBar | True | NorthwindCustomMenuBar |
Click here to return to the contents list
Name | Full Path | Reference Broken |
---|---|---|
Visual Basic For Applications | C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLL | False |
Microsoft Access 8.0 Object Library | C:\Program Files\Microsoft Office\Office\MSACC8.OLB | False |
Microsoft Office 8.0 Object Library | C:\Program Files\Microsoft Office\Office\MSO97.DLL | False |
Microsoft DAO 3.5 Object Library | C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL | False |