Database information for file: C:\Users\john2\Documents\Northwind 2013.accdb, created 05/06/2021 16:21:40

Key data
Setting	Value
Application name:	Database3
Is it compiled?	False
Does it have a broken reference?	False

Database Properties
Name	Type	Value
Name	Memo	C:\Users\john2\Documents\Northwind 2013.accdb
Connect	Memo
Transactions	Yes/No	True
Updatable	Yes/No	True
CollatingOrder	Long Integer	1033
QueryTimeout	Long Integer	60
Version	Memo	14.0
RecordsAffected	Single	0
ReplicaID	GUID
DesignMasterID	GUID
Connection	Empty
ANSI Query Mode	Single	0
Themed Form Controls	Single	1
Use Microsoft Access 2007 compatible cache	Single	0
Clear Cache on Close	Single	0
Never Cache	Single	0
AccessVersion	String	09.50
NavPane Category	Single	4
Show Navigation Pane Search Bar	Single	1
UseMDIMode	Integer	0
ShowDocumentTabs	Yes/No	True
Picture Property Storage Format	Single	0
WebDesignMode	Integer	0
CheckTruncatedNumFields	Single	1
NavPane Closed	Single	0
NavPane Width	Single	215
NavPane View By	Single	0
NavPane Sort By	Single	1
NavPane Category Name	String	Northwind Traders
Office Online Template ID	String	TC012289971033
ProjVer	Long Integer	140
Theme Resource Name	String	Office Theme
HasOfflineLists	Long Integer	70

Click here to return to the contents list

Tables

Table Summary Information
Name	Created	Last Updated	Record Count	Type
calcField	08/10/2015 19:41:15	08/10/2015 19:41:15	0	Normal table
Customers	08/10/2015 19:12:35	08/10/2015 19:12:39	29	Normal table
Employee Privileges	08/10/2015 19:12:35	08/10/2015 19:14:05	1	Normal table
Employees	08/10/2015 19:12:35	08/10/2015 19:12:39	9	Normal table
Inventory Transaction Types	08/10/2015 19:12:35	08/10/2015 19:12:39	4	Normal table
Inventory Transactions	08/10/2015 19:12:35	08/10/2015 19:34:04	102	Normal table
Invoices	08/10/2015 19:12:35	08/10/2015 19:12:39	35	Normal table
Order Details	08/10/2015 19:12:35	08/10/2015 19:12:39	58	Normal table
Order Details Status	08/10/2015 19:12:35	08/10/2015 19:12:39	6	Normal table
Orders	08/10/2015 19:12:35	08/10/2015 19:14:43	48	Normal table
Orders Status	08/10/2015 19:12:35	08/10/2015 19:12:39	4	Normal table
Orders Tax Status	08/10/2015 19:12:35	08/10/2015 19:12:39	2	Normal table
Privileges	08/10/2015 19:12:35	08/10/2015 19:12:39	1	Normal table
Products	08/10/2015 19:12:35	08/10/2015 19:15:45	45	Normal table
Purchase Order Details	08/10/2015 19:12:35	08/10/2015 19:15:34	55	Normal table
Purchase Order Status	08/10/2015 19:12:35	08/10/2015 19:12:39	4	Normal table
Purchase Orders	08/10/2015 19:12:35	08/10/2015 19:15:20	28	Normal table
Sales Reports	08/10/2015 19:12:35	08/10/2015 19:12:35	5	Normal table
Shippers	08/10/2015 19:12:35	08/10/2015 19:12:39	3	Normal table
Strings	08/10/2015 19:12:35	08/10/2015 19:12:35	62	Normal table
Suppliers	08/10/2015 19:12:35	08/10/2015 19:12:39	10	Normal table

Table Details

List of fields within the calcField table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
ID		Auto Number	False	True
CalculatedField		Long	False	False

Indexes on table calcField
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	ID

List of fields within the Customers table
Fieldname	Data Type	Required	Is PK?
ID	Auto Number	False	True
Company	Text (50)	False	False
Last Name	Text (50)	False	False
First Name	Text (50)	False	False
E-mail Address	Text (50)	False	False
Job Title	Text (50)	False	False
Business Phone	Text (25)	False	False
Home Phone	Text (25)	False	False
Mobile Phone	Text (25)	False	False
Fax Number	Text (25)	False	False
Address	Memo	False	False
City	Text (50)	False	False
State/Province	Text (50)	False	False
ZIP/Postal Code	Text (15)	False	False
Country/Region	Text (50)	False	False
Web Page	Hyperlink	False	False
Notes	Memo	False	False
Attachments	Attachment	False	False

Indexes on table Customers
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
City	False	False	False	False	False	False	City
Company	False	False	False	False	False	False	Company
First Name	False	False	False	False	False	False	First Name
Last Name	False	False	False	False	False	False	Last Name
Postal Code	False	False	False	False	False	False	ZIP/Postal Code
PrimaryKey	True	False	False	False	True	True	ID
State/Province	False	False	False	False	False	False	State/Province

List of fields within the Employee Privileges table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Employee ID		Long	False	True
Privilege ID		Long	False	True

Indexes on table Employee Privileges
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
EmployeePriviligesforEmployees	False	False	False	False	False	False	Employee ID
EmployeePriviligesLookup	False	False	False	False	False	False	Privilege ID
New_EmployeePriviligesforEmployees	False	True	False	False	False	False	Employee ID
New_EmployeePriviligesLookup	False	True	False	False	False	False	Privilege ID
PrimaryKey	True	False	False	False	True	True	Employee ID,Privilege ID
Privilege ID	False	False	False	False	False	False	Privilege ID

List of fields within the Employees table
Fieldname	Data Type	Required	Is PK?
ID	Auto Number	False	True
Company	Text (50)	False	False
Last Name	Text (50)	False	False
First Name	Text (50)	False	False
E-mail Address	Text (50)	False	False
Job Title	Text (50)	False	False
Business Phone	Text (25)	False	False
Home Phone	Text (25)	False	False
Mobile Phone	Text (25)	False	False
Fax Number	Text (25)	False	False
Address	Memo	False	False
City	Text (50)	False	False
State/Province	Text (50)	False	False
ZIP/Postal Code	Text (15)	False	False
Country/Region	Text (50)	False	False
Web Page	Hyperlink	False	False
Notes	Memo	False	False
Attachments	Attachment	False	False

Indexes on table Employees
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
City	False	False	False	False	False	False	City
Company	False	False	False	False	False	False	Company
First Name	False	False	False	False	False	False	First Name
Last Name	False	False	False	False	False	False	Last Name
Postal Code	False	False	False	False	False	False	ZIP/Postal Code
PrimaryKey	True	False	False	False	True	True	ID
State/Province	False	False	False	False	False	False	State/Province

List of fields within the Inventory Transaction Types table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
ID		Byte	False	True
Type Name		Text (50)	True	False

Indexes on table Inventory Transaction Types
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	ID

List of fields within the Inventory Transactions table
Fieldname	Default Value	Data Type	Required	Is PK?
Transaction ID		Auto Number	False	True
Transaction Type		Byte	True	False
Transaction Created Date	=Now()	Date / Time	False	False
Transaction Modified Date	=Now()	Date / Time	False	False
Product ID		Long	True	False
Quantity		Long	True	False
Purchase Order ID		Long	False	False
Customer Order ID		Long	False	False
Comments		Text (255)	False	False

Indexes on table Inventory Transactions
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
Customer Order ID	False	False	False	False	False	False	Customer Order ID
New_OrdersOnInventoryTransactions	False	True	False	False	False	False	Customer Order ID
New_ProductOnInventoryTransaction	False	True	False	False	False	False	Product ID
New_PuchaseOrdersonInventoryTransactions	False	True	False	False	False	False	Purchase Order ID
New_TransactionTypesOnInventoryTransactiosn	False	True	False	False	False	False	Transaction Type
OrdersOnInventoryTransactions	False	False	False	False	False	False	Customer Order ID
PrimaryKey	True	False	False	False	True	True	Transaction ID
Product ID	False	False	False	False	False	False	Product ID
ProductOnInventoryTransaction	False	False	False	False	False	False	Product ID
PuchaseOrdersonInventoryTransactions	False	False	False	False	False	False	Purchase Order ID
Purchase Order ID	False	False	False	False	False	False	Purchase Order ID
TransactionTypesOnInventoryTransactiosn	False	False	False	False	False	False	Transaction Type

List of fields within the Invoices table
Fieldname	Default Value	Data Type	Required	Is PK?
Invoice ID		Auto Number	False	True
Order ID		Long	False	False
Invoice Date	=Now()	Date / Time	False	False
Due Date		Date / Time	False	False
Tax	0	Currency	False	False
Shipping	0	Currency	False	False
Amount Due	0	Currency	False	False

Indexes on table Invoices
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
New_OrderInvoice	False	True	False	False	False	False	Order ID
Order ID	False	False	False	False	False	False	Order ID
OrderInvoice	False	False	False	False	False	False	Order ID
PrimaryKey	True	False	False	False	True	True	Invoice ID

List of fields within the Order Details table
Fieldname	Default Value	Data Type	Required	Is PK?
ID		Auto Number	False	True
Order ID		Long	True	False
Product ID		Long	False	False
Quantity	0	Decimal	True	False
Unit Price	0	Currency	False	False
Discount	0	Double	True	False
Status ID		Long	False	False
Date Allocated		Date / Time	False	False
Purchase Order ID		Long	False	False
Inventory ID		Long	False	False

Indexes on table Order Details
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
ID	False	False	False	False	False	False	ID
Inventory ID	False	False	False	False	False	False	Inventory ID
New_OrderDetails	False	True	False	False	False	False	Order ID
New_OrderStatusLookup	False	True	False	False	False	False	Status ID
New_ProductsOnOrders	False	True	False	False	False	False	Product ID
OrderDetails	False	False	False	False	False	False	Order ID
OrderID	False	False	False	False	False	False	Order ID
OrderStatusLookup	False	False	False	False	False	False	Status ID
PrimaryKey	True	False	False	False	True	True	ID
ProductID	False	False	False	False	False	False	Product ID
ProductsOnOrders	False	False	False	False	False	False	Product ID
Purchase Order ID	False	False	False	False	False	False	Purchase Order ID
Status ID	False	False	False	False	False	False	Status ID

List of fields within the Order Details Status table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Status ID		Long	False	True
Status Name		Text (50)	True	False

Indexes on table Order Details Status
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	Status ID

List of fields within the Orders table
Fieldname	Default Value	Data Type	Required	Is PK?
Order ID		Auto Number	False	True
Employee ID		Long	False	False
Customer ID		Long	False	False
Order Date	Now()	Date / Time	False	False
Shipped Date		Date / Time	False	False
Shipper ID		Long	False	False
Ship Name		Text (50)	False	False
Ship Address		Memo	False	False
Ship City		Text (50)	False	False
Ship State/Province		Text (50)	False	False
Ship ZIP/Postal Code		Text (50)	False	False
Ship Country/Region		Text (50)	False	False
Shipping Fee	0	Currency	False	False
Taxes	0	Currency	False	False
Payment Type		Text (50)	False	False
Paid Date		Date / Time	False	False
Notes		Memo	False	False
Tax Rate	0	Double	False	False
Tax Status		Byte	False	False
Status ID	0	Byte	False	False

Indexes on table Orders
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
CustomerID	False	False	False	False	False	False	Customer ID
CustomerOnOrders	False	False	False	False	False	False	Customer ID
EmployeeID	False	False	False	False	False	False	Employee ID
EmployeesOnOrders	False	False	False	False	False	False	Employee ID
ID	False	False	False	False	False	False	Order ID
New_CustomerOnOrders	False	True	False	False	False	False	Customer ID
New_EmployeesOnOrders	False	True	False	False	False	False	Employee ID
New_OrderStatus	False	True	False	False	False	False	Status ID
New_ShipperOnOrder	False	True	False	False	False	False	Shipper ID
New_TaxStatusOnOrders	False	True	False	False	False	False	Tax Status
OrderStatus	False	False	False	False	False	False	Status ID
PrimaryKey	True	False	False	False	True	True	Order ID
ShipperID	False	False	False	False	False	False	Shipper ID
ShipperOnOrder	False	False	False	False	False	False	Shipper ID
Status ID	False	False	False	False	False	False	Status ID
TaxStatusOnOrders	False	False	False	False	False	False	Tax Status
ZIP/Postal Code	False	False	False	False	False	False	Ship ZIP/Postal Code

List of fields within the Orders Status table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Status ID		Byte	False	True
Status Name		Text (50)	True	False

Indexes on table Orders Status
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	Status ID

List of fields within the Orders Tax Status table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
ID		Byte	False	True
Tax Status Name		Text (50)	True	False

Indexes on table Orders Tax Status
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	ID

List of fields within the Privileges table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Privilege ID		Auto Number	False	True
Privilege Name		Text (50)	False	False

Indexes on table Privileges
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	Privilege ID

List of fields within the Products table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Supplier IDs		Unknown field type 104	False	False
ID		Auto Number	False	True
Product Code		Text (25)	False	False
Product Name		Text (50)	False	False
Description		Memo	False	False
Standard Cost	0	Currency	False	False
List Price	0	Currency	True	False
Reorder Level		Integer	False	False	Inventory quantity that triggers reordering
Target Level		Long	False	False	Desired Inventory level after a purchase reorder
Quantity Per Unit		Text (50)	False	False
Discontinued	No	Boolean	True	False
Minimum Reorder Quantity		Integer	False	False
Category		Text (50)	False	False
Attachments		Attachment	False	False

Indexes on table Products
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	ID
Product Code	False	False	False	False	False	False	Product Code

List of fields within the Purchase Order Details table
Fieldname	Default Value	Data Type	Required	Is PK?
ID		Auto Number	False	True
Purchase Order ID		Long	True	False
Product ID		Long	False	False
Quantity		Decimal	True	False
Unit Cost		Currency	True	False
Date Received		Date / Time	False	False
Posted To Inventory	No	Boolean	True	False
Inventory ID		Long	False	False

Indexes on table Purchase Order Details
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
ID	False	False	False	False	False	False	ID
Inventory ID	False	False	False	False	False	False	Inventory ID
InventoryTransactionsOnPurchaseOrders	False	False	False	False	False	False	Inventory ID
New_InventoryTransactionsOnPurchaseOrders	False	True	False	False	False	False	Inventory ID
New_ProductOnPurchaseOrderDetails	False	True	False	False	False	False	Product ID
New_PurchaseOrderDeatilsOnPurchaseOrder	False	True	False	False	False	False	Purchase Order ID
OrderID	False	False	False	False	False	False	Purchase Order ID
PrimaryKey	True	False	False	False	True	True	ID
ProductID	False	False	False	False	False	False	Product ID
ProductOnPurchaseOrderDetails	False	False	False	False	False	False	Product ID
PurchaseOrderDeatilsOnPurchaseOrder	False	False	False	False	False	False	Purchase Order ID

List of fields within the Purchase Order Status table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
Status ID		Long	False	True
Status		Text (50)	False	True

Indexes on table Purchase Order Status
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	Status ID

List of fields within the Purchase Orders table
Fieldname	Default Value	Data Type	Required	Is PK?
Purchase Order ID		Auto Number	False	True
Supplier ID		Long	False	False
Created By		Long	False	False
Submitted Date		Date / Time	False	False
Creation Date	Now()	Date / Time	False	False
Status ID	0	Long	False	False
Expected Date		Date / Time	False	False
Shipping Fee	0	Currency	True	False
Taxes	0	Currency	True	False
Payment Date		Date / Time	False	False
Payment Amount	0	Currency	False	False
Payment Method		Text (50)	False	False
Notes		Memo	False	False
Approved By		Long	False	False
Approved Date		Date / Time	False	False
Submitted By		Long	False	False

Indexes on table Purchase Orders
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
EmployeesOnPurchaseOrder	False	False	False	False	False	False	Created By
ID	False	False	False	False	False	True	Purchase Order ID
New_EmployeesOnPurchaseOrder	False	True	False	False	False	False	Created By
New_PurchaseOrderStatusLookup	False	True	False	False	False	False	Status ID
New_SuppliersOnPurchaseOrder	False	True	False	False	False	False	Supplier ID
PrimaryKey	True	False	False	False	True	True	Purchase Order ID
PurchaseOrderStatusLookup	False	False	False	False	False	False	Status ID
Status ID	False	False	False	False	False	False	Status ID
SupplierID	False	False	False	False	False	False	Supplier ID
SuppliersOnPurchaseOrder	False	False	False	False	False	False	Supplier ID

List of fields within the Sales Reports table
Fieldname	Default Value	Data Type	Required	Is PK?
Group By		Text (50)	True	True
Display		Text (50)	False	False
Title		Text (50)	False	False
Filter Row Source		Memo	False	False
Default	No	Boolean	True	False

Indexes on table Sales Reports
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	Group By

List of fields within the Shippers table
Fieldname	Data Type	Required	Is PK?
ID	Auto Number	False	True
Company	Text (50)	False	False
Last Name	Text (50)	False	False
First Name	Text (50)	False	False
E-mail Address	Text (50)	False	False
Job Title	Text (50)	False	False
Business Phone	Text (25)	False	False
Home Phone	Text (25)	False	False
Mobile Phone	Text (25)	False	False
Fax Number	Text (25)	False	False
Address	Memo	False	False
City	Text (50)	False	False
State/Province	Text (50)	False	False
ZIP/Postal Code	Text (15)	False	False
Country/Region	Text (50)	False	False
Web Page	Hyperlink	False	False
Notes	Memo	False	False
Attachments	Attachment	False	False

Indexes on table Shippers
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
City	False	False	False	False	False	False	City
Company	False	False	False	False	False	False	Company
First Name	False	False	False	False	False	False	First Name
Last Name	False	False	False	False	False	False	Last Name
Postal Code	False	False	False	False	False	False	ZIP/Postal Code
PrimaryKey	True	False	False	False	True	True	ID
State/Province	False	False	False	False	False	False	State/Province

List of fields within the Strings table
Fieldname	Default Value	Data Type	Required	Is PK?	Description
String ID		Auto Number	False	True
String Data		Text (255)	False	False

Indexes on table Strings
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
PrimaryKey	True	False	False	False	True	True	String ID

List of fields within the Suppliers table
Fieldname	Data Type	Required	Is PK?
ID	Auto Number	False	True
Company	Text (50)	False	False
Last Name	Text (50)	False	False
First Name	Text (50)	False	False
E-mail Address	Text (50)	False	False
Job Title	Text (50)	False	False
Business Phone	Text (25)	False	False
Home Phone	Text (25)	False	False
Mobile Phone	Text (25)	False	False
Fax Number	Text (25)	False	False
Address	Memo	False	False
City	Text (50)	False	False
State/Province	Text (50)	False	False
ZIP/Postal Code	Text (15)	False	False
Country/Region	Text (50)	False	False
Web Page	Hyperlink	False	False
Notes	Memo	False	False
Attachments	Attachment	False	False

Indexes on table Suppliers
Index name	Primary	Foreign	Ignore Nulls	Clustered	Required	Unique	Fields
City	False	False	False	False	False	False	City
Company	False	False	False	False	False	False	Company
First Name	False	False	False	False	False	False	First Name
Last Name	False	False	False	False	False	False	Last Name
Postal Code	False	False	False	False	False	False	ZIP/Postal Code
PrimaryKey	True	False	False	False	True	True	ID
State/Province	False	False	False	False	False	False	State/Province

Click here to return to the contents list

Queries

Query Information
Name	Type	SQL	Description
Customers Extended	Select	SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Contact Name], Customers.* FROM Customers ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));
Employees Extended	Select	SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Employee Name], Employees.* FROM Employees ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));
Inventory	Select	SELECT Products.ID AS [Product ID], Products.[Product Name], Products.[Product Code], Nz([Quantity Purchased],0) AS [Qty Purchased], Nz([Quantity Sold],0) AS [Qty Sold], Nz([Quantity On Hold],0) AS [Qty On Hold], [Qty Purchased]-[Qty Sold] AS [Qty On Hand], [Qty Purchased]-[Qty Sold]-[Qty On Hold] AS [Qty Available], Nz([Quantity On Order],0) AS [Qty On Order], Nz([Quantity On Back Order],0) AS [Qty On Back Order], Products.[Reorder Level], Products.[Target Level], [Target Level]-[Current Level] AS [Qty Below Target Level], [Qty Available]+[Qty On Order]-[Qty On Back Order] AS [Current Level], IIf([Qty Below Target Level]>0,IIf([Qty Below Target Level]<[Minimum ReOrder Quantity],[Minimum Reorder Quantity],[Qty Below Target Level]),0) AS [Qty To Reorder] FROM ((((Products LEFT JOIN [Inventory Sold] ON Products.ID=[Inventory Sold].[Product ID]) LEFT JOIN [Inventory Purchased] ON Products.ID=[Inventory Purchased].[Product ID]) LEFT JOIN [Inventory On Hold] ON Products.ID=[Inventory On Hold].[Product ID]) LEFT JOIN [Inventory On Order] ON Products.ID=[Inventory On Order].[Product ID]) LEFT JOIN [Products On Back Order] ON Products.ID=[Products On Back Order].[Product ID];
Inventory on Hold	Select	`SELECT [Inventory Transactions].[Product ID], Sum([Inventory Transactions].Quantity) AS [Quantity On Hold] FROM [Inventory Transactions] WHERE ((([Inventory Transactions].[Transaction Type])=3)) GROUP BY [Inventory Transactions].[Product ID];`
Inventory on Order	Select	`SELECT [Purchase Order Details].[Product ID] AS [Product ID], Sum([Purchase Order Details].Quantity) AS [Quantity On Order] FROM [Purchase Order Details] WHERE ((([Purchase Order Details].[Posted To Inventory])=False)) GROUP BY [Purchase Order Details].[Product ID];`
Inventory Purchased	Select	`SELECT [Inventory Transactions].[Product ID], Sum([Inventory Transactions].Quantity) AS [Quantity Purchased] FROM [Inventory Transactions] WHERE ((([Inventory Transactions].[Transaction Type])=1)) GROUP BY [Inventory Transactions].[Product ID];`
Inventory Sold	Select	`SELECT [Inventory Transactions].[Product ID], Sum([Inventory Transactions].Quantity) AS [Quantity Sold] FROM [Inventory Transactions] WHERE ((([Inventory Transactions].[Transaction Type])=2)) GROUP BY [Inventory Transactions].[Product ID];`
Invoice Data	Select	SELECT Orders.[Order ID], Orders.[Ship Name], Orders.[Ship Address], Orders.[Ship City], Orders.[Ship State/Province], Orders.[Ship ZIP/Postal Code], Orders.[Ship Country/Region], Orders.[Customer ID], Customers.Company AS [Customer Name], Customers.Address, Customers.City, Customers.[State/Province], Customers.[ZIP/Postal Code], Customers.[Country/Region], [Employees Extended].[Employee Name] AS Salesperson, Orders.[Order Date], Orders.[Shipped Date], Shippers.Company AS [Shipper Name], [Order Details].[Product ID], Products.ID AS [Product ID], [Order Details].[Unit Price], [Order Details].Quantity, [Order Details].Discount, CCur(Nz([Unit Price][Quantity](1-[Discount]),0)/100)*100 AS ExtendedPrice, Orders.[Shipping Fee], Products.[Product Name] FROM (Shippers RIGHT JOIN (Customers RIGHT JOIN (Orders LEFT JOIN [Employees Extended] ON Orders.[Employee ID]=[Employees Extended].ID) ON Customers.ID=Orders.[Customer ID]) ON Shippers.ID=Orders.[Shipper ID]) LEFT JOIN ([Order Details] LEFT JOIN Products ON [Order Details].[Product ID]=Products.ID) ON Orders.[Order ID]=[Order Details].[Order ID];	(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	Select	`SELECT [Order Details]., CCur([Quantity][Unit Price]*(1-[Discount])) AS [Extended Price], [Order Details Status].[Status Name] FROM [Order Details] LEFT JOIN [Order Details Status] ON [Order Details].[Status ID]=[Order Details Status].[Status ID];`
Order Price Totals	Select	`SELECT [Order Details Extended].[Order ID] AS OrderID, Sum([Order Details Extended].[Extended Price]) AS [Price Total] FROM [Order Details Extended] GROUP BY [Order Details Extended].[Order ID];`
Order Subtotals	Select	`SELECT [Order Details].[Order ID], Sum(CCur([Unit Price][Quantity](1-[Discount])/100)*100) AS Subtotal FROM [Order Details] GROUP BY [Order Details].[Order ID];`	Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order.
Order Summary	Select	SELECT Orders.[Order ID], Orders.[Employee ID], Orders.[Customer ID], Orders.[Order Date], Orders.[Shipped Date], [Order Price Totals].[Price Total] AS [Sub Total], Orders.[Shipping Fee], Orders.Taxes, [Sub Total]+[Shipping Fee]+[Taxes] AS [Order Total], Orders.[Ship Name], Orders.[Ship Address], Orders.[Paid Date], [Orders Status].[status name] AS Status FROM [Orders Status] RIGHT JOIN (Orders LEFT JOIN [Order Price Totals] ON Orders.[Order ID]=[Order Price Totals].OrderID) ON [Orders Status].[Status ID]=Orders.[Status ID] ORDER BY Orders.[Order ID] DESC;
Product Category Sales by Date	Select	`SELECT Orders.[Order Date], Sum([Order Details].Quantity) AS SumOfQuantity, Products.Category FROM Products INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.[Order ID]=[Order Details].[Order ID]) ON Products.ID=[Order Details].[Product ID] GROUP BY Orders.[Order Date], Products.Category ORDER BY Orders.[Order Date] DESC;`
Product Orders	Select	SELECT [Order Details].[Product ID], Orders.[Order ID], Orders.[Order Date], Orders.[Shipped Date], Orders.[Customer ID], [Order Details].Quantity, [Order Details].[Unit Price], [Order Details].Discount, "Sale" AS [Transaction], [Customers Extended].Company AS [Company Name], [Order Details].[Status ID] FROM ([Customers Extended] INNER JOIN Orders ON [Customers Extended].ID=Orders.[Customer ID]) INNER JOIN [Order Details] ON Orders.[Order ID]=[Order Details].[Order ID] ORDER BY Orders.[Order Date];
Product Purchases	Select	SELECT [Purchase Order Details].[Product ID], [Purchase Orders].[Purchase Order ID], [Purchase Orders].[Creation Date], [Purchase Order Details].Quantity, [Purchase Order Details].[Unit Cost], "Purchase" AS [Transaction], Suppliers.Company AS [Company Name], [Purchase Order Details].[Posted To Inventory] FROM Suppliers INNER JOIN ([Purchase Orders] INNER JOIN [Purchase Order Details] ON [Purchase Orders].[Purchase Order ID]=[Purchase Order Details].[Purchase Order ID]) ON Suppliers.ID=[Purchase Orders].[Supplier ID] WHERE ((([Purchase Order Details].[Posted To Inventory])=True)) ORDER BY [Purchase Orders].[Creation Date];
Product Sales by Category	Select	`SELECT Orders.[Order Date], Products.[Product Name], Products.Category, [Quantity]*[Unit Price] AS Amount FROM Orders INNER JOIN (Products INNER JOIN [Order Details] ON Products.ID=[Order Details].[Product ID]) ON Orders.[Order ID]=[Order Details].[Order ID] ORDER BY Orders.[Order Date], Products.[Product Name];`
Product Sales Qty by Employee and Date	Select	SELECT Orders.[Order Date], [Employees Extended].[Employee Name], Sum([Order Details].Quantity) AS SumOfQuantity, Products.[Product Name] FROM Products INNER JOIN (([Employees Extended] INNER JOIN Orders ON [Employees Extended].ID=Orders.[Employee ID]) INNER JOIN [Order Details] ON Orders.[Order ID]=[Order Details].[Order ID]) ON Products.ID=[Order Details].[Product ID] GROUP BY Orders.[Order Date], [Employees Extended].[Employee Name], Products.[Product Name] ORDER BY Orders.[Order Date] DESC , [Employees Extended].[Employee Name], Products.[Product Name];
Product Sales Total by Date	Select	`SELECT Products.[Product Name], Orders.[Order Date], Sum([Unit Price][Quantity]) AS Amount FROM Orders INNER JOIN (Products INNER JOIN [Order Details] ON Products.ID=[Order Details].[Product ID]) ON Orders.[Order ID]=[Order Details].[Order ID] GROUP BY Products.[Product Name], Orders.[Order Date], Products.[Product Name] ORDER BY Sum([Unit Price][Quantity]) DESC , Products.[Product Name];`
Product Transactions	Union	`SELECT [Product ID], [Order Date], [Company Name], [Transaction], [Quantity] FROM [Product Orders] UNION SELECT [Product ID], [Creation Date], [Company Name], [Transaction], [Quantity] FROM [Product Purchases] ORDER BY [Order Date] DESC;`
Products on Back Order	Select	`SELECT [Order Details].[Product ID] AS [Product ID], Sum([Order Details].Quantity) AS [Quantity On Back Order] FROM [Order Details] WHERE ((([Order Details].[Status ID])=4)) GROUP BY [Order Details].[Product ID];`
Purchase Details Extended	Select	`SELECT [Purchase Order Details]., [Quantity][Unit Cost] AS [Extended Price], Products.[Product Name] FROM Products INNER JOIN [Purchase Order Details] ON Products.ID=[Purchase Order Details].[Product ID];`
Purchase Price Totals	Select	`SELECT [Purchase Details Extended].[Purchase Order ID] AS [Purchase ID], Sum([Purchase Details Extended].[Extended Price]) AS [Price Total] FROM [Purchase Details Extended] GROUP BY [Purchase Details Extended].[Purchase Order ID];`
Purchase Summary	Select	SELECT [Purchase Orders].[Creation Date], [Purchase Order Status].Status, [Purchase Orders].[Supplier ID], [Purchase Orders].[Shipping Fee], [Purchase Orders].Taxes, [Sub Total]+[Shipping Fee]+[Taxes] AS [Order Total], [Purchase Price Totals].[Price Total] AS [Sub Total], [Purchase Orders].[Payment Date], [Purchase Orders].[Approved By], [Purchase Orders].[Approved Date], [Purchase Orders].[Submitted By], [Purchase Orders].[Submitted Date], [Purchase Orders].[Status ID], [Purchase Orders].[Purchase Order ID] FROM [Purchase Order Status] INNER JOIN ([Purchase Orders] INNER JOIN [Purchase Price Totals] ON [Purchase Orders].[Purchase Order ID]=[Purchase Price Totals].[Purchase ID]) ON [Purchase Order Status].[Status ID]=[Purchase Orders].[Status ID] ORDER BY [Purchase Orders].[Status ID], [Purchase Orders].[Purchase Order ID] DESC;
Sales Analysis	Select	SELECT Orders.[Order ID], Orders.[Order Date], [Employees Extended].[Employee Name] AS Employee, [Customers Extended].Company AS [Customer Name], Products.[Product Name], [Order Details Extended].[Extended Price] AS Sales, [Customers Extended].[State/Province], [Customers Extended].[Country/Region], [Employees Extended].ID AS [Employee ID], Products.ID AS [Product ID], [Customers Extended].ID AS [Customer ID], Year([Order Date]) AS [Year], Month([Order Date]) AS [Month], DatePart("q",[Order Date]) AS Quarter, Format([Order Date],"mmmm") AS [Month Name], Products.Category, Products.[Product Name] AS Product, [Customers Extended].Company AS Customer, (Month([Order Date]) Mod 3) AS MonthOfQuarter FROM ((((Orders INNER JOIN [Customers Extended] ON Orders.[Customer ID]=[Customers Extended].ID) LEFT JOIN [Employees Extended] ON Orders.[Employee ID]=[Employees Extended].ID) INNER JOIN [Order Details Extended] ON Orders.[Order ID]=[Order Details Extended].[Order ID]) INNER JOIN Products ON [Order Details Extended].[Product ID]=Products.ID) INNER JOIN Invoices ON Orders.[Order ID]=Invoices.[Order ID];
Shippers Extended	Select	SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Contact Name], Shippers.* FROM Shippers ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));
Suppliers Extended	Select	SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Contact Name], Suppliers.* FROM Suppliers ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));
Top Ten Orders by Sales Amount	Select	`SELECT DISTINCTROW TOP 10 Orders.[Order ID], Orders.[Order Date], [Order Subtotals].Subtotal AS SaleAmount, [Customers Extended].Company AS CompanyName, Orders.[Shipped Date] FROM [Customers Extended] INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.[Order ID]=[Order Subtotals].[Order ID]) ON [Customers Extended].ID=Orders.[Customer ID] ORDER BY [Order Subtotals].Subtotal DESC;`

Click here to return to the contents list

Forms

Information about forms within this database
Name	Created	Last Updated	Has Module	Record Source
Active Orders Subform for Home	08/10/2015 19:12:36	08/10/2015 19:35:07	False	SELECT Orders.[Order ID], Orders.[Employee ID], Orders.[Customer ID], Orders.[Order Date], Orders.Taxes, [Order Price Totals].[Price Total], Customers.Company, Orders.[Status ID] FROM Customers INNER JOIN (Orders INNER JOIN [Order Price Totals] ON Orders.[Order ID]=[Order Price Totals].OrderID) ON Customers.ID=Orders.[Customer ID] WHERE ((Not (Orders.[Status ID])=3)) ORDER BY Orders.[Order Date] DESC;
Customer Details	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Customers Extended
Customer List	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Customers Extended
Customer Orders Subform	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Order Summary
Employee Details	08/10/2015 19:12:35	08/10/2015 19:35:07	False	Employees Extended
Employee List	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Employees Extended
Employee Orders Subform	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Order Summary
Home	08/10/2015 19:12:36	08/10/2015 19:35:07	False	Strings
Inventory List	08/10/2015 19:12:36	08/10/2015 19:35:08	True	Inventory
Inventory to reorder Subform for Home	08/10/2015 19:12:36	08/10/2015 19:35:07	False	SELECT Inventory.* FROM Inventory WHERE (((Inventory.[Current Level])<[Reorder Level]));
Login Dialog	08/10/2015 19:12:36	08/10/2015 19:35:08	False
Order Details	08/10/2015 19:12:36	08/10/2015 19:35:08	True	SELECT Orders.*, [Orders Status].[Status Name], [Customers Extended].[E-mail Address] FROM [Customers Extended] INNER JOIN ([Orders Status] INNER JOIN Orders ON [Orders Status].[Status ID]=Orders.[Status ID]) ON [Customers Extended].ID=Orders.[Customer ID];
Order List	08/10/2015 19:12:36	08/10/2015 19:35:08	False	Order Summary
Order Subform for Order Details	08/10/2015 19:12:35	08/10/2015 19:35:08	True	Order Details Extended
Product Category Sales by Month	08/10/2015 19:12:36	05/06/2021 16:21:41	False	Product Category Sales by Date
Product Details	08/10/2015 19:12:36	08/10/2015 19:35:08	False	Products
Product Sales by Category Chart	08/10/2015 19:12:36	05/06/2021 16:21:41	False	Product Sales by Category
Product Sales by Total Revenue Chart	08/10/2015 19:12:35	05/06/2021 16:21:41	False	Product Sales Total by Date
Product Sales Qty by Employee Chart	08/10/2015 19:12:36	05/06/2021 16:21:41	False	Product Sales Qty by Employee and Date
Product Transactions Subform for Product Details	08/10/2015 19:12:36	05/06/2021 16:21:41	False	Product Transactions
Purchase Order Details	08/10/2015 19:12:35	08/10/2015 19:35:08	True	SELECT [Purchase Orders].*, [Purchase Order Status].Status FROM [Purchase Order Status] RIGHT JOIN [Purchase Orders] ON [Purchase Order Status].[Status ID]=[Purchase Orders].[Status ID];
Purchase Order List	08/10/2015 19:12:36	08/10/2015 19:35:08	False	Purchase Summary
Purchases Subform for Purchase Order Details	08/10/2015 19:12:36	08/10/2015 19:35:08	True	Purchase Details Extended
Receiving Subform for Purchase Order Details	08/10/2015 19:12:36	08/10/2015 19:35:08	True	Purchase Details Extended
Sales Analysis Form	08/10/2015 19:12:36	05/06/2021 16:21:42	False	Sales Analysis
Sales Analysis Subform for Home Chart	08/10/2015 19:12:36	05/06/2021 16:21:42	False	SELECT DISTINCTROW Employees.[Country/Region], Employees.[Last Name], Employees.[First Name], Orders.[Shipped Date], Orders.[Order ID], [Order Subtotals].Subtotal AS [Sale Amount] FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.[Order ID]=[Order Subtotals].[Order ID]) ON Employees.ID=Orders.[Employee ID] WHERE (((Year([Shipped Date]))=Year(Date())) AND ((DatePart("q",[Shipped Date]))=DatePart("q",Date())));
Sales Reports Dialog	08/10/2015 19:12:36	08/10/2015 19:35:09	True
Shipper Details	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Shippers Extended
Shipper List	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Shippers Extended
Startup Screen	08/10/2015 19:12:36	08/10/2015 19:12:36	False
Supplier Details	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Suppliers Extended
Supplier List	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Suppliers Extended
Supplier Products Subform	08/10/2015 19:12:36	05/06/2021 16:21:42	False	Products
Supplier Purchases Subform	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Purchase Orders

Click here to return to the contents list

Reports

Information about the reports within this database
Name	Created	Last Updated	Has Module	Record Source
Customer Address Book	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Customers Extended
Customer Phone Book	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Customers Extended
Employee Address Book	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Employees Extended
Employee Phone Book	08/10/2015 19:12:36	08/10/2015 19:35:09	False	Employees Extended
Invoice	08/10/2015 19:12:36	05/06/2021 16:21:43	False	Invoice Data
Monthly Sales Report	08/10/2015 19:12:36	05/06/2021 16:21:43	True	Sales Analysis
Product Category Sales by Month	08/10/2015 19:12:36	08/10/2015 19:12:36	False
Product Sales by Category	08/10/2015 19:12:36	08/10/2015 19:12:36	False
Product Sales by Total Revenue	08/10/2015 19:12:36	08/10/2015 19:12:36	False
Product Sales Quantity by Employee	08/10/2015 19:12:36	08/10/2015 19:12:36	False
Quarterly Sales Report	08/10/2015 19:12:36	05/06/2021 16:21:44	True	Sales Analysis
Supplier Address Book	08/10/2015 19:12:36	08/10/2015 19:35:10	False	Suppliers Extended
Supplier Phone Book	08/10/2015 19:12:36	08/10/2015 19:35:10	False	Suppliers Extended
Top Ten Biggest Orders	08/10/2015 19:12:36	05/06/2021 16:21:44	False	Top Ten Orders by Sales Amount
Yearly Sales Report	08/10/2015 19:12:36	05/06/2021 16:21:44	True	Sales Analysis

Click here to return to the contents list

Modules

Ordinary and Class Modules

Details of the ordinary and class modules within this database
Name	Created	Last Updated	Type	No. Lines
CustomerOrders	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	67
DomainFunctionWrappers	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	128
ErrorHandling	08/10/2015 19:12:35	08/10/2015 19:12:35	Class Module	73
Inventory	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	339
Privileges	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	34
PurchaseOrders	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	156
RecordsetWrapper	08/10/2015 19:12:35	08/10/2015 19:12:35	Class Module	152
Utilities	08/10/2015 19:12:35	08/10/2015 19:12:35	Normal Module	186

Click here to return to the contents list

Code routines within the module CustomerOrders
Prototype	No. Lines	Description
Function CreateInvoice(OrderID As Long, Amt As Currency, InvoiceID As Long) As Boolean	13
Function IsInvoiced(OrderID As Long) As Boolean	1
Function PrintInvoice(OrderID As Long) As Boolean	1
Function SetStatus(OrderID As Long, Status As CustomerOrderStatusEnum) As Boolean	10
Function Delete(OrderID As Long) As Boolean	4

Code routines within the module DomainFunctionWrappers
Prototype	No. Lines	Description
Private Function DomainFunctionWrapper(DomainFunction As DomainFunctionWrapperEnum, Expr As String, Domain As String, Optional Criteria As String) As Variant	33
Public Function DLookupWrapper(Expr As String, Domain As String, Optional Criteria As String) As Variant	1
Public Function DLookupStringWrapper(Expr As String, Domain As String, Optional Criteria As String, Optional ValueIfNull As String = "") As String	1
Public Function DLookupNumberWrapper(Expr As String, Domain As String, Optional Criteria As String, Optional ValueIfNull = 0) As Variant	1
Public Function DCountWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long	1
Public Function DMaxWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long	1
Public Function DMinWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long	1
Public Function DSumWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long	1
Public Function DAvgWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long	1

Code routines within the module ErrorHandling
Prototype	No. Lines	Description
Public Function LogError(strLocation As String, ParamArray State()) As Boolean	20
Function TryToCloseObject() As Boolean	10
Function TryToSaveRecord() As Boolean	1
Function TryToRunCommand(Command As AcCommand) As Boolean	10
Function TryToGoToRecord(Record As AcRecord) As Boolean	9

Code routines within the module Inventory
Prototype	No. Lines	Description
Public Property Get NewInventoryID() As Long	1
Function AddPurchase(PurchaseOrderID As Long, ProductID As Long, Qty As Long, ByRef InventoryID As Long) As Boolean	11
Function RemovePurchase(lInventoryID As Long)	1
Function GetQtyAvailable(ProductID As Long) As Long	1
Function GetQtyOnHand(ProductID As Long) As Long	1
Function GetQtyToReorder(ProductID As Long) As Long	1
Function GetQtyOnBackOrder(ProductID As Long) As Long	1
Private Function GetInventoryQuantity(FieldName As String, ProductID As Long) As Long	1
Function RequestHold(OrderID As Long, IT As InventoryTransaction) As Boolean	9
Function AddHold(OrderID As Long, IT As InventoryTransaction) As Boolean	28
Function ModifyHold(IT As InventoryTransaction) As Boolean	20
Function HoldToSold(InventoryID As Long) As Boolean	9
Function RemoveHold(InventoryID As Long) As Boolean	1
Function GetTransaction(IT As InventoryTransaction) As Boolean	12
Function EditTransaction(IT As InventoryTransaction, Optional CustomerOrderID, Optional PurchaseOrderID) As Boolean	28
Function DeleteTransaction(InventoryID As Long) As Boolean	4
Function RestockProduct(ProductID As Long) As Boolean	35
Function FindProductSupplier(ProductID As Long) As Long	1
Function GetRestockingPurchaseOrder(SupplierID) As Long	1
Function FillBackOrders(ProductID) As Boolean	25
Function FillBackOrder(OrderID As Long, IT As InventoryTransaction) As Boolean	6

Code routines within the module Privileges
Prototype	No. Lines	Description
Private Function EmployeeHas(EmployeeID As Long, PrivilegeID As PrivilegeEnum) As Boolean	1
Public Function CanApprovePurchases() As Boolean	3
Public Function IsAdministrator() As Boolean	3
Public Function GetCurrentUserID() As Long	1

Code routines within the module PurchaseOrders
Prototype	No. Lines	Description
Function Generate(SupplierID As Long, ProductID As Long, Quantity As Long, OrderID As Long, PurchaseOrderID As Long) As Boolean	5
Function Create(SupplierID As Long, EmployeeID As Long, OrderID As Long, PurchaseOrderID As Long) As Boolean	23
Function CreateLineItem(PurchaseOrderID As Long, ProductID As Long, UnitCost As Long, Quantity As Long) As Boolean	11
Sub OpenOrder(Optional PurchaseOrderID As Long)	5
Sub NewOrder()	1
Function Delete(PurchaseOrderID As Long) As Boolean	4
Private Function SetStatus(PurchaseOrderID As Long, Status As PurchaseOrderStatusEnum) As Boolean	21
Function GetStatus(PurchaseOrderID) As PurchaseOrderStatusEnum	5
Function MarkApproved(PurchaseOrderID As Long) As Boolean	7
Function MarkSubmitted(PurchaseOrderID As Long) As Boolean	1
Function Exists(PurchaseOrderID As Long) As Boolean	1
Function GetStandardCost(lProductID As Long) As Currency	1
Function GetListPrice(lProductID As Long) As Currency	1

Code routines within the module RecordsetWrapper
Prototype	No. Lines	Description
Public Function GetRecordsetClone(rs As DAO.Recordset2) As DAO.Recordset2	6
Public Function OpenRecordset(Domain As String, Optional Criteria As String = "1=1", Optional OrderBy As String, Optional RecordsetType As DAO.RecordsetTypeEnum = dbOpenDynaset, Optional RecordsetOptions As DAO.RecordsetOptionEnum ) As Boolean	26
Public Function Delete() As Boolean	10
Public Function AddNew() As Boolean	10
Public Function Edit() As Boolean	10
Public Function Update() As Boolean	10
Public Function MoveNext() As Boolean	10
Public Function CloseRecordset() As Boolean	11
Public Property Get Recordset() As DAO.Recordset2	1
Private Sub Class_Terminate()	4

Code routines within the module Utilities
Prototype	No. Lines	Description
Function MsgBoxYesNo(StringID As StringIDEnum, Optional ByVal strInsert As String) As Boolean	1
Sub MsgBoxOKOnly(StringID As StringIDEnum, Optional ByVal strInsert As String)	1
Function MsgBoxID(StringID As StringIDEnum, Buttons As VbMsgBoxStyle, Optional ByVal strInsert As String) As VbMsgBoxResult	1
Function LoadString(StringID As StringIDEnum) As String	5
Function InsertString(StringID As StringIDEnum, strInsert As String) As String	1
Function HasSourceCode() As Boolean	5
Function IsRuntime() As Boolean	1
Function DebuggingSupported() As Boolean	1

Click here to return to the contents list

Form Modules

Code routines within the module Form_Inventory List
Prototype	No. Lines	Description
Private Sub cmdPurchase_Click()	8

Code routines within the module Form_Order Details
Prototype	No. Lines	Description
Sub SetDefaultShippingAddress()	16
Private Sub cmdDeleteOrder_Click()	12
Private Sub cmdClearAddress_Click()	1
Private Sub ClearShippingAddress()	6
Private Sub cmdCompleteOrder_Click()	8
Private Sub cmdCreateInvoice_Click()	36
Private Sub cmdShipOrder_Click()	13
Private Sub Customer_ID_AfterUpdate()	4
Private Sub Form_Current()	1
Private Sub Form_Load()	1
Function GetDefaultSalesPersonID() As Long	1
Function ValidateShipping() As Boolean	8
Function ValidatePaymentInfo() As Boolean	4
Sub SetFormState(Optional fChangeFocus As Boolean = True)	21
Function ValidateOrder(Validation_OrderStatus As CustomerOrderStatusEnum) As Boolean	38

Code routines within the module Form_Order Subform for Order Details
Prototype	No. Lines	Description
Private Sub Product_ID_AfterUpdate()	13
Private Sub Form_Current()	5
Private Sub Quantity_AfterUpdate()	53
Private Sub Status_Name_DblClick(Cancel As Integer)	12

Code routines within the module Form_Purchase Order Details
Prototype	No. Lines	Description
Public Function GetPurchaseDetailsSubform() As [Form_Purchases Subform for Purchase Order Details]	1
Private Function PurchaseContainsLineItems() As Boolean	1
Private Sub Supplier_ID_AfterUpdate()	2
Private Sub Supplier_ID_BeforeUpdate(Cancel As Integer)	12
Private Sub cmdApprovePurchase_Click()	12
Private Sub cmdCancelPurchase_Click()	10
Private Sub cmdClose_Click()	5
Private Sub cmdSubmitforApproval_Click()	11
Private Sub Form_Current()	1
Private Sub TabCtlPurchasing_Change()	6
Private Function FRemovePurchaseLineItems() As Boolean	16
Private Function PurchaseOrder_ContainsPostedInventory() As Boolean	10
Function PurchaseOrderIsValid() As Boolean	21
Public Sub InitFormState()	21

Code routines within the module Form_Purchases Subform for Purchase Order Details
Prototype	No. Lines	Description
Sub InitParentState()	4
Private Sub Form_AfterInsert()	1
Private Sub Form_BeforeUpdate(Cancel As Integer)	4
Private Sub Product_ID_AfterUpdate()	9
Private Sub Quantity_AfterUpdate()	3
Private Sub Quantity_BeforeUpdate(Cancel As Integer)	4
Private Sub Unit_Cost_BeforeUpdate(Cancel As Integer)	4
Private Function RemoveCurrentLineItem() As Boolean	1

Code routines within the module Form_Receiving Subform for Purchase Order Details
Prototype	No. Lines	Description
Private Sub Posted_To_Inventory_AfterUpdate()	48
Private Sub Date_Received_AfterUpdate()	6
Private Sub Form_Current()	1
Private Sub Form_Load()	12

Code routines within the module Form_Sales Reports Dialog
Prototype	No. Lines	Description
Sub PrintReports(ReportView As AcView)	37
Private Sub Form_Load()	2
Sub SetSalesPeriod(SalesPeriod As SalesPeriodEnum)	3
Private Sub lstSalesPeriod_AfterUpdate()	1
Private Sub lstSalesReports_AfterUpdate()	1
Private Sub InitFilterItems()	2
Private Sub cmdPreview_Click()	1
Private Sub cmdPrint_Click()	1
Private Function GetLastOrderDate() As Date	1

Click here to return to the contents list

Report Modules

Details of reports within this database
Report Name	Module Name	No. Lines
Monthly Sales Report	Report_Monthly Sales Report	38
Quarterly Sales Report	Report_Quarterly Sales Report	43
Yearly Sales Report	Report_Yearly Sales Report	36

Code routines within the module Report_Monthly Sales Report
Prototype	No. Lines	Description
Private Sub Report_Open(Cancel As Integer)	30

Code routines within the module Report_Quarterly Sales Report
Prototype	No. Lines	Description
Private Sub Report_Open(Cancel As Integer)	36

Code routines within the module Report_Yearly Sales Report
Prototype	No. Lines	Description
Private Sub Report_Open(Cancel As Integer)	28

Click here to return to the contents list

Macros

Details of Macros within this database
Name	Date Created	Last Updated	Description
AutoExec	08/10/2015 19:12:35	08/10/2015 19:12:35
Delete All Data	08/10/2015 19:12:35	08/10/2015 19:12:35

Click here to return to the contents list

Relationships

Details of table relationships within this database
Primary Name	Foreign Name	Description
MSysNavPaneGroupCategories.Id	MSysNavPaneGroups.GroupCategoryID	Cascade updates Cascade deletes
MSysNavPaneGroups.Id	MSysNavPaneGroupToObjects.GroupID	Cascade updates Cascade deletes
Customers.ID	Orders.Customer ID
Employees.ID	Employee Privileges.Employee ID
Privileges.Privilege ID	Employee Privileges.Privilege ID
Employees.ID	Orders.Employee ID
Employees.ID	Purchase Orders.Created By
Inventory Transactions.Transaction ID	Purchase Order Details.Inventory ID
Orders.Order ID	Order Details.Order ID	Cascade deletes
Orders.Order ID	Invoices.Order ID	Cascade deletes
Orders.Order ID	Inventory Transactions.Customer Order ID
Orders Status.Status ID	Orders.Status ID
Order Details Status.Status ID	Order Details.Status ID
Products.ID	Inventory Transactions.Product ID
Products.ID	Purchase Order Details.Product ID
Products.ID	Order Details.Product ID
Purchase Orders.Purchase Order ID	Inventory Transactions.Purchase Order ID
Purchase Orders.Purchase Order ID	Purchase Order Details.Purchase Order ID	Cascade deletes
Purchase Order Status.Status ID	Purchase Orders.Status ID
Shippers.ID	Orders.Shipper ID
Suppliers.ID	Purchase Orders.Supplier ID
Orders Tax Status.ID	Orders.Tax Status
Inventory Transaction Types.ID	Inventory Transactions.Transaction Type

Click here to return to the contents list

Command Bars

Please note that MDB Doc only displays information about custom command bars.

There are no custom command bars in this database.

Click here to return to the contents list

Data Access Pages

There are no Data Access Pages in this database.

Click here to return to the contents list

References

Details of VBA references within this database
Name	Full Path	Reference Broken
Visual Basic For Applications	C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL	False
Microsoft Access 15.0 Object Library	C:\Program Files (x86)\Microsoft Office\Office15\MSACC.OLB	False
OLE Automation	C:\Windows\SysWOW64\stdole2.tlb	False
	C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\ACEDAO.DLL	False

Click here to return to the contents list

Ribbons

There are no ribbons in this database

Click here to return to the contents list

Import/Export Specifications

There are no Import/Export Specifications in this database.

Click here to return to the contents list

Database information for file: C:\Users\john2\Documents\Northwind 2013.accdb, created 05/06/2021 16:21:40

Contents

Contents

Tables

Table Details

Queries

Forms

Reports

Modules

Ordinary and Class Modules

Form Modules

Report Modules

Macros

Relationships

Command Bars

Data Access Pages

References

Ribbons

Import/Export Specifications