Database information for file: C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb, created 31/10/2015 17:20:16

Application: Northwind

Contents

Contents

Database Properties
NameTypeValue
NameMemoC:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb
ConnectMemo
TransactionsYes/NoTrue
UpdatableYes/NoTrue
CollatingOrderLong Integer1033
QueryTimeoutLong Integer60
VersionMemo3.0
RecordsAffectedSingle0
ReplicaIDGUID
DesignMasterIDGUID
ConnectionEmpty
AccessVersionString07.53
BuildSingle5903
StartUpFormString(none)
StartUpShowDBWindowYes/NoTrue
StartUpShowStatusBarYes/NoTrue
AllowShortcutMenusYes/NoTrue
AllowFullMenusYes/NoTrue
AllowBuiltInToolbarsYes/NoTrue
AllowToolbarChangesYes/NoTrue
AllowBreakIntoCodeYes/NoTrue
AllowSpecialKeysYes/NoTrue
StartUpMenuBarStringNorthwindCustomMenuBar

Click here to return to the contents list

Tables

Table Summary Information
NameCreatedLast UpdatedRecord CountTypeDescription
Categories13/09/1995 10:51:3013/09/1995 10:52:278Normal tableCategories of Northwind products.
Customers13/09/1995 10:51:3220/08/1996 11:27:4391Normal tableCustomers' names, addresses, and phone numbers.
Employees13/09/1995 10:51:3320/08/1996 15:45:249Normal tableEmployees' names, titles, and personal information.
Order Details13/09/1995 10:51:3420/08/1996 19:30:212155Normal tableDetails on products, quantities, and prices for each order in the Orders table.
Orders13/09/1995 10:51:3813/09/1995 10:52:28830Normal tableCustomer name, order date, and freight charge for each order.
Products13/09/1995 10:51:4116/09/1996 18:22:4077Normal tableProduct names, suppliers, prices, and units in stock.
Shippers13/09/1995 10:51:4213/09/1995 10:52:283Normal tableShippers' names and phone numbers.
Suppliers13/09/1995 10:51:4225/09/1996 13:45:3929Normal tableSuppliers' names, addresses, phone numbers, and hyperlinks to home pages.

Table Details

List of fields within the Categories table
FieldnameDefault ValueData TypeRequiredIs PK?Description
CategoryIDAuto NumberFalseTrueNumber automatically assigned to a new category.
CategoryNameText (15)TrueFalseName of food category.
DescriptionMemoFalseFalse
PictureLong Binary (OLE Object)FalseFalseA picture representing the food category.

List of fields within the Customers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
CustomerIDText (5)FalseTrueUnique five-character code based on customer name.
CompanyNameText (40)TrueFalse
ContactNameText (30)FalseFalse
ContactTitleText (30)FalseFalse
AddressText (60)FalseFalseStreet or post-office box.
CityText (15)FalseFalse
RegionText (15)FalseFalseState or province.
PostalCodeText (10)FalseFalse
CountryText (15)FalseFalse
PhoneText (24)FalseFalsePhone number includes country code or area code.
FaxText (24)FalseFalsePhone number includes country code or area code.

List of fields within the Employees table
FieldnameDefault ValueData TypeRequiredIs PK?Description
EmployeeIDAuto NumberFalseTrueNumber automatically assigned to new employee.
LastNameText (20)TrueFalse
FirstNameText (10)TrueFalse
TitleText (30)FalseFalseEmployee's title.
TitleOfCourtesyText (25)FalseFalseTitle used in salutations.
BirthDateDate / TimeFalseFalse
HireDateDate / TimeFalseFalse
AddressText (60)FalseFalseStreet or post-office box.
CityText (15)FalseFalse
RegionText (15)FalseFalseState or province.
PostalCodeText (10)FalseFalse
CountryText (15)FalseFalse
HomePhoneText (24)FalseFalsePhone number includes country code or area code.
ExtensionText (4)FalseFalseInternal telephone extension number.
PhotoLong Binary (OLE Object)FalseFalsePicture of employee.
NotesMemoFalseFalseGeneral information about employee's background.
ReportsToLongFalseFalseEmployee's supervisor.

List of fields within the Order Details table
FieldnameDefault ValueData TypeRequiredIs PK?Description
OrderIDLongFalseTrueSame as Order ID in Orders table.
ProductIDLongTrueTrueSame as Product ID in Products table.
UnitPrice0CurrencyTrueFalse
Quantity1IntegerTrueFalse
Discount0SingleTrueFalse

List of fields within the Orders table
FieldnameDefault ValueData TypeRequiredIs PK?Description
OrderIDAuto NumberFalseTrueUnique order number.
CustomerIDText (5)FalseFalseSame entry as in Customers table.
EmployeeIDLongFalseFalseSame entry as in Employees table.
OrderDateDate / TimeFalseFalse
RequiredDateDate / TimeFalseFalse
ShippedDateDate / TimeFalseFalse
ShipViaLongFalseFalseSame as Shipper ID in Shippers table.
Freight0CurrencyFalseFalse
ShipNameText (40)FalseFalseName of person or company to receive the shipment.
ShipAddressText (60)FalseFalseStreet address only -- no post-office box allowed.
ShipCityText (15)FalseFalse
ShipRegionText (15)FalseFalseState or province.
ShipPostalCodeText (10)FalseFalse
ShipCountryText (15)FalseFalse

List of fields within the Products table
FieldnameDefault ValueData TypeRequiredIs PK?Description
ProductIDAuto NumberFalseTrueNumber automatically assigned to new product.
ProductNameText (40)TrueFalse
SupplierIDLongFalseFalseSame entry as in Suppliers table.
CategoryIDLongFalseFalseSame entry as in Categories table.
QuantityPerUnitText (20)FalseFalse(e.g., 24-count case, 1-liter bottle).
UnitPrice0CurrencyFalseFalse
UnitsInStock0IntegerFalseFalse
UnitsOnOrder0IntegerFalseFalse
ReorderLevel0IntegerFalseFalseMinimum units to maintain in stock.
Discontinued=NoBooleanFalseFalseYes means item is no longer available.

List of fields within the Shippers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
ShipperIDAuto NumberFalseTrueNumber automatically assigned to new shipper.
CompanyNameText (40)TrueFalseName of shipping company.
PhoneText (24)FalseFalsePhone number includes country code or area code.

List of fields within the Suppliers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
SupplierIDAuto NumberFalseTrueNumber automatically assigned to new supplier.
CompanyNameText (40)TrueFalse
ContactNameText (30)FalseFalse
ContactTitleText (30)FalseFalse
AddressText (60)FalseFalseStreet or post-office box.
CityText (15)FalseFalse
RegionText (15)FalseFalseState or province.
PostalCodeText (10)FalseFalse
CountryText (15)FalseFalse
PhoneText (24)FalseFalsePhone number includes country code or area code.
FaxText (24)FalseFalsePhone number includes country code or area code.
HomePageHyperlinkFalseFalseSupplier's home page on World Wide Web.

Click here to return to the contents list

Queries

Query Information
NameTypeSQLDescription
Alphabetical List of ProductsUnknown Query type 8SELECT 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.
CatalogUnknown Query type 8SELECT 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 1995SelectSELECT 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 ListSelectSELECT [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 CityUnionSELECT 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 CountrySelectPARAMETERS [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.
InvoicesSelectSELECT 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 FilterSelectSELECT 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 ExtendedSelectSELECT 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 SubtotalsSelectSELECT 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 QryUnknown Query type 8SELECT 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 1995SelectSELECT 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 PriceSelectSELECT 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 CategoryUnknown Query type 8SELECT 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 OrdersSelectSELECT 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 ProductCrosstabTRANSFORM 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 CategorySelectSELECT 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 YearSelectPARAMETERS 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 AmountUnknown Query type 8SELECT 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 QuarterUnknown Query type 8SELECT 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 YearUnknown Query type 8SELECT 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 ProductsSelectSELECT 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

Forms

Information about forms within this database
NameCreatedLast UpdatedHas ModuleRecord SourceDescription
Categories13/09/1995 10:51:5021/08/1996 10:03:29FalseCategoriesAdd and edit product categories. Main form displays category information; subform displays limited product information.
Customer Labels Dialog13/09/1995 10:51:5121/08/1996 09:43:32FalseDialog 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 Orders13/09/1995 10:51:5116/09/1996 18:46:23FalseCustomersRead-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 Subform124/07/1996 16:27:2710/10/1996 10:47:12TrueOrdersSubform used on Customer Orders form.
Customer Orders Subform213/09/1995 10:51:5316/09/1996 18:47:36FalseOrder Details ExtendedSubform used on Customer Orders form.
Customer Phone List13/09/1995 10:51:5327/09/1996 13:47:52FalseCustomersView and print customer phone numbers. Uses a macro and alphabetical buttons to filter company names. Form header and footer display only in Form view.
Customers13/09/1995 10:51:5521/08/1996 10:05:19FalseCustomersAdd and edit customer information such as name, address, and phone number. Single-column form; uses a background picture; uses macro to validate customer ID.
Employees24/05/1996 12:25:0110/10/1996 10:47:12TrueEmployeesAdd 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:5521/08/1996 11:38:29FalseEmployeesAdd and edit corporate and personal information for employees. Two-page form; uses command buttons to page up and down; has photo of employee.
Main Switchboard13/09/1995 10:51:5610/10/1996 10:47:12TrueProvides access to other forms and reports in the database. Uses command buttons to open other forms. Displays Northwind logo.
Orders27/09/1996 13:49:3010/10/1996 10:47:12TrueOrders QryAdd 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 Subform13/09/1995 10:51:5810/10/1996 10:47:12TrueOrder Details ExtendedSubform used on Orders form.
Product List13/09/1995 10:51:5905/09/1996 16:48:09FalseProductsView limited product information. Used as a pop-up form with Suppliers form; used as a subform on Categories form.
Products27/09/1996 13:49:3210/10/1996 10:47:12TrueProductsAdd 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 Orders13/09/1995 10:52:0021/08/1996 10:05:53FalseQuarterly OrdersRead-only form. Displays quarter totals for each product and a total for 1994.
Quarterly Orders Subform13/09/1995 10:52:0121/08/1996 10:06:07FalseQuarterly Orders by ProductSubform used on Quarterly Orders form.
Sales Analysis15/09/1995 19:52:5510/10/1996 10:47:12TrueReview 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 Dialog13/09/1995 10:52:0410/10/1996 10:47:12TrueDialog 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 Dialog13/09/1995 10:52:0510/10/1996 10:47:12TrueDialog 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.
Startup13/09/1995 10:52:0616/09/1996 18:51:28FalseDisplays 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.
Suppliers27/09/1996 13:49:3310/10/1996 10:47:12TrueSuppliersAdd 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

Reports

Information about the reports within this database
NameCreatedLast UpdatedHas ModuleRecord SourceDescription
Alphabetical List of Products13/09/1995 10:52:1016/09/1996 18:52:29FalseAlphabetical List of ProductsPrints products grouped by first letter of name. Uses Left function to return first character of product names.
Catalog13/09/1995 10:52:1116/09/1996 18:53:11FalseCatalogPrints 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 Labels13/09/1995 10:52:1216/09/1996 18:53:40FalseCustomersPrints customers' company names and addresses on 3-up labels.
Employee Sales by Country13/09/1995 10:52:1310/10/1996 10:47:12TrueEmployee Sales by CountryPrints 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.
Invoice13/09/1995 10:52:1516/09/1996 18:54:27FalseInvoicesPrints each invoice on a separate page. Uses IIf function in address controls; uses Sum function to calculate invoice subtotal.
Products by Category13/09/1995 10:52:1516/09/1996 18:54:53FalseProducts by CategoryPrints 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 Category16/09/1996 11:18:1216/09/1996 18:55:22FalseSales by CategoryPrints sales for 1994 by category. Shows sales in a subreport and in a chart on the main report.
Sales by Category Subreport13/09/1995 10:52:1721/08/1996 13:43:19FalseSales by CategorySubreport for Sales by Category report.
Sales by Year13/09/1995 10:52:1910/10/1996 10:47:12TrueSales by YearPrints 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 Subreport13/09/1995 10:52:1916/09/1996 18:56:00FalseSales by YearSubreport for Sales by Year report.
Sales Totals by Amount13/09/1995 10:52:2116/09/1996 18:56:17FalseSales Totals by AmountPrints sales in descending order by amount. Prints top 10 customers on first page; prints page total in page footer.
Summary of Sales by Quarter13/09/1995 10:52:2216/09/1996 18:56:36FalseSummary of Sales by QuarterPrints 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 Year13/09/1995 10:52:2316/09/1996 18:56:59FalseSummary of Sales by YearPrints 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

Modules

Ordinary and Class Modules

Details of the ordinary and class modules within this database
NameCreatedLast UpdatedTypeNo. LinesDescription
Northwind Help Function02/08/1996 16:04:5510/10/1996 10:47:12Normal Module55Contains the function that calls Show Me Help for Northwind.
Startup30/08/1996 10:40:3210/10/1996 10:46:51Normal Module99Functions used on the Startup form.
Utility Functions13/09/1995 10:52:2510/10/1996 10:47:12Normal Module21Functions used in database objects.

Click here to return to the contents list

Code routines within the module Northwind Help Function
PrototypeNo. LinesDescription
Function ShowHelpAPI() As Boolean37

Code routines within the module Startup
PrototypeNo. LinesDescription
Function OpenStartup() As Boolean32
Function HideStartupForm()25
Function CloseForm()4
Function IsItAReplica() As Boolean22

Code routines within the module Utility Functions
PrototypeNo. LinesDescription
Function IsLoaded(ByVal strFormName As String) As Boolean11

Click here to return to the contents list

Form Modules

Code routines within the module Form_Customer Orders Subform1
PrototypeNo. LinesDescription
Sub Form_Current()20

Code routines within the module Form_Employees
PrototypeNo. LinesDescription
Private Sub Form_AfterUpdate()3

Code routines within the module Form_Main Switchboard
PrototypeNo. LinesDescription
Function OpenForms(strFormName As String) As Integer15
Sub ExitMicrosoftAccess_Click()13
Sub DisplayDatabaseWindow_Click()21

Code routines within the module Form_Orders
PrototypeNo. LinesDescription
Private Sub CustomerID_AfterUpdate()8
Private Sub CustomerID_BeforeUpdate(Cancel As Integer)13
Sub PrintInvoice_Click()23

Code routines within the module Form_Orders Subform
PrototypeNo. LinesDescription
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

Code routines within the module Form_Products
PrototypeNo. LinesDescription
Private Sub OutputToHTML_Click()21
Private Sub ProductName_AfterUpdate()9

Code routines within the module Form_Sales Analysis
PrototypeNo. LinesDescription
Private Sub btnEdit_Click()8

Code routines within the module Form_Sales by Year Dialog
PrototypeNo. LinesDescription
Private Sub Cancel_Click()14
Private Sub OK_Click()24

Code routines within the module Form_Sales Reports Dialog
PrototypeNo. LinesDescription
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

Code routines within the module Form_Suppliers
PrototypeNo. LinesDescription
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 Modules

Details of reports within this database
Report NameModule NameNo. Lines
Employee Sales by CountryReport_Employee Sales by Country46
Sales by YearReport_Sales by Year136
Code routines within the module Report_Employee Sales by Country
PrototypeNo. LinesDescription
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

Code routines within the module Report_Sales by Year
PrototypeNo. LinesDescription
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

Macros

Details of Macros within this database
NameDate CreatedLast UpdatedDescription
Customer Labels Dialog13/09/1995 10:52:2319/08/1996 15:53:34Attached to the Customer Labels Dialog form. Previews or prints the Customer Labels report. Enables or disables the SelectCountry combo box.
Customer Phone List27/09/1996 13:25:0727/09/1996 13:25:09Attached to the Customer Phone Numbers form. Shows all records when form is opened; filters customers by first letter of company name.
Customers13/09/1995 10:52:2419/08/1996 16:08:29Attached to the Customers form. Validates that the customer ID is unique before you leave the field.
Employees (page break)24/05/1996 13:20:3019/08/1996 15:21:34Attached to the Employees (page break) form. Used to move between pages of the form.
Sales Totals by Amount13/09/1995 10:52:2410/06/1996 18:09:43Attached 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 Autokeys13/09/1995 10:52:2413/09/1995 10:52:24Defines a key combination used on the Customer Phone List form. Key combinations for other forms could be added.
Suppliers13/09/1995 10:52:2513/09/1995 10:52:25Could 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

Relationships

Details of table relationships within this database
Primary NameForeign NameDescription
Categories.CategoryIDProducts.CategoryID
Customers.CustomerIDOrders.CustomerIDCascade updates
Employees.EmployeeIDOrders.EmployeeID
Orders.OrderIDOrder Details.OrderIDCascade deletes
Products.ProductIDOrder Details.ProductID
Shippers.ShipperIDOrders.ShipVia
Suppliers.SupplierIDProducts.SupplierID

Click here to return to the contents list

Command Bars

Please note that MDBDoc97 only displays information about custom command bars.

Details of custom CommandBars within this database
NameVisibleNameLocal
NorthwindCustomMenuBarTrueNorthwindCustomMenuBar

Click here to return to the contents list

References

Details of VBA references within this database
NameFull PathReference Broken
Visual Basic For ApplicationsC:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLLFalse
Microsoft Access 8.0 Object LibraryC:\Program Files\Microsoft Office\Office\MSACC8.OLBFalse
Microsoft Office 8.0 Object LibraryC:\Program Files\Microsoft Office\Office\MSO97.DLLFalse
Microsoft DAO 3.5 Object LibraryC:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLLFalse

Click here to return to the contents list