Database information for file: C:\Users\John\Documents\Northwind 2007.accdb, created 18/10/2015 15:54:58

Application: Northwind 2007

Contents

Contents

Database Properties
NameTypeValue
NameMemoC:\Users\John\Documents\Northwind 2007.accdb
ConnectMemo
TransactionsYes/NoTrue
UpdatableYes/NoTrue
CollatingOrderLong Integer1033
QueryTimeoutLong Integer60
VersionMemo12.0
RecordsAffectedSingle0
ReplicaIDGUID
DesignMasterIDGUID
ConnectionEmpty
ANSI Query ModeSingle0
Themed Form ControlsSingle1
AccessVersionString09.50
NavPane CategorySingle0
UseMDIModeInteger0
ShowDocumentTabsYes/NoTrue
BuildSingle606
HasOfflineListsLong Integer70
Picture Property Storage FormatSingle0
CheckTruncatedNumFieldsSingle0
NavPane ClosedSingle0
NavPane WidthSingle289
NavPane View BySingle0
NavPane Sort BySingle1
ProjVerLong Integer140
Office Online Template IDStringTC012289971033
StartUpShowDBWindowYes/NoFalse
StartUpShowStatusBarYes/NoTrue
AllowShortcutMenusYes/NoFalse
AllowFullMenusYes/NoFalse
AllowBuiltInToolbarsYes/NoTrue
AllowToolbarChangesYes/NoTrue
AllowSpecialKeysYes/NoTrue
UseAppIconForFrmRptYes/NoFalse
AllowDatasheetSchemaYes/NoTrue
Show Values LimitSingle1000
Show Values in IndexedSingle1
Show Values in Non-IndexedSingle1
Show Values in RemoteSingle0
Auto CompactSingle0
Theme Resource NameStringOffice Theme
Show Navigation Pane Search BarSingle0

Click here to return to the contents list

Tables

Table Summary Information
NameCreatedLast UpdatedRecord CountTypeDescription
Customers10/04/2010 14:40:0427/07/2014 15:22:2429Normal table
Data26/05/2012 13:37:2726/05/2012 13:37:276Normal table
Employee Privileges10/04/2010 14:40:0310/04/2010 14:40:281Normal table
Employees10/04/2010 14:40:0410/04/2010 14:40:289Normal table
Inventory Transaction Types10/04/2010 14:40:0310/04/2010 14:40:284Normal table
Inventory Transactions10/04/2010 14:40:0410/04/2010 14:40:28102Normal table
Invoices10/04/2010 14:40:0410/04/2010 14:40:2835Normal table
Order Details10/04/2010 14:40:0418/05/2014 20:14:5658Normal table
Order Details Status10/04/2010 14:40:0310/04/2010 14:40:286Normal table
Orders10/04/2010 14:40:0310/04/2010 14:40:2848Normal table
Orders Status10/04/2010 14:40:0410/04/2010 14:40:284Normal table
Orders Tax Status10/04/2010 14:40:0410/04/2010 14:40:282Normal table
Privileges10/04/2010 14:40:0410/04/2010 14:40:281Normal table
Products10/04/2010 14:40:0410/04/2010 14:40:2845Normal table
Purchase Order Details10/04/2010 14:40:0410/04/2010 14:40:2855Normal table
Purchase Order Status10/04/2010 14:40:0410/04/2010 14:40:284Normal table
Purchase Orders10/04/2010 14:40:0410/04/2010 14:40:2828Normal table
Sales Reports10/04/2010 14:40:0410/04/2010 14:40:045Normal table
Shippers10/04/2010 14:40:0410/04/2010 14:40:283Normal table
Strings10/04/2010 14:40:0310/04/2010 14:40:0362Normal table
Suppliers10/04/2010 14:40:0310/04/2010 14:40:2810Normal table

Table Details

List of fields within the Customers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
CompanyText (50)FalseFalse
Last NameText (50)FalseFalse
First NameText (50)FalseFalse
E-mail AddressText (50)FalseFalse
Job TitleText (50)FalseFalse
Business PhoneText (25)FalseFalse
Home PhoneText (25)FalseFalse
Mobile PhoneText (25)FalseFalse
Fax NumberText (25)FalseFalse
AddressMemoFalseFalse
CityText (50)FalseFalse
State/ProvinceText (50)FalseFalse
ZIP/Postal CodeText (15)FalseFalse
Country/RegionText (50)FalseFalse
Web PageHyperlinkFalseFalse
NotesMemoFalseFalse
AttachmentsUnknown field type 101FalseFalse

List of fields within the Data table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
Field1Text (255)FalseFalse
Field2Text (255)FalseFalse
Field3Text (255)FalseFalse
Field4Text (255)FalseFalse
Field5Text (255)FalseFalse
Field6Text (255)FalseFalse

List of fields within the Employee Privileges table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Employee IDLongFalseTrue
Privilege IDLongFalseTrue

List of fields within the Employees table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
CompanyText (50)FalseFalse
Last NameText (50)FalseFalse
First NameText (50)FalseFalse
E-mail AddressText (50)FalseFalse
Job TitleText (50)FalseFalse
Business PhoneText (25)FalseFalse
Home PhoneText (25)FalseFalse
Mobile PhoneText (25)FalseFalse
Fax NumberText (25)FalseFalse
AddressMemoFalseFalse
CityText (50)FalseFalse
State/ProvinceText (50)FalseFalse
ZIP/Postal CodeText (15)FalseFalse
Country/RegionText (50)FalseFalse
Web PageHyperlinkFalseFalse
NotesMemoFalseFalse
AttachmentsUnknown field type 101FalseFalse

List of fields within the Inventory Transaction Types table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDByteFalseTrue
Type NameText (50)TrueFalse

List of fields within the Inventory Transactions table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Transaction IDAuto NumberFalseTrue
Transaction TypeByteTrueFalse
Transaction Created Date=Now()Date / TimeFalseFalse
Transaction Modified Date=Now()Date / TimeFalseFalse
Product IDLongTrueFalse
QuantityLongTrueFalse
Purchase Order IDLongFalseFalse
Customer Order IDLongFalseFalse
CommentsText (255)FalseFalse

List of fields within the Invoices table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Invoice IDAuto NumberFalseTrue
Order IDLongFalseFalse
Invoice Date=Now()Date / TimeFalseFalse
Due DateDate / TimeFalseFalse
Tax0CurrencyFalseFalse
Shipping0CurrencyFalseFalse
Amount Due0CurrencyFalseFalse

List of fields within the Order Details table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
Order IDLongTrueFalse
Product IDLongFalseFalse
Quantity0DecimalTrueFalse
Unit Price0CurrencyFalseFalse
Discount0DoubleTrueFalse
Status IDLongFalseFalse
Date AllocatedDate / TimeFalseFalse
Purchase Order IDLongFalseFalse
Inventory IDLongFalseFalse

List of fields within the Order Details Status table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Status IDLongFalseTrue
Status NameText (50)TrueFalse

List of fields within the Orders table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Order IDAuto NumberFalseTrue
Employee IDLongFalseFalse
Customer IDLongFalseFalse
Order DateNow()Date / TimeFalseFalse
Shipped DateDate / TimeFalseFalse
Shipper IDLongFalseFalse
Ship NameText (50)FalseFalse
Ship AddressMemoFalseFalse
Ship CityText (50)FalseFalse
Ship State/ProvinceText (50)FalseFalse
Ship ZIP/Postal CodeText (50)FalseFalse
Ship Country/RegionText (50)FalseFalse
Shipping Fee0CurrencyFalseFalse
Taxes0CurrencyFalseFalse
Payment TypeText (50)FalseFalse
Paid DateDate / TimeFalseFalse
NotesMemoFalseFalse
Tax Rate0DoubleFalseFalse
Tax StatusByteFalseFalse
Status ID0ByteFalseFalse

List of fields within the Orders Status table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Status IDByteFalseTrue
Status NameText (50)TrueFalse

List of fields within the Orders Tax Status table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDByteFalseTrue
Tax Status NameText (50)TrueFalse

List of fields within the Privileges table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Privilege IDAuto NumberFalseTrue
Privilege NameText (50)FalseFalse

List of fields within the Products table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Supplier IDsUnknown field type 104FalseFalse
IDAuto NumberFalseTrue
Product CodeText (25)FalseFalse
Product NameText (50)FalseFalse
DescriptionMemoFalseFalse
Standard Cost0CurrencyFalseFalse
List Price0CurrencyTrueFalse
Reorder LevelIntegerFalseFalseInventory quantity that triggers reordering
Target LevelLongFalseFalseDesired Inventory level after a purchase reorder
Quantity Per UnitText (50)FalseFalse
DiscontinuedNoBooleanTrueFalse
Minimum Reorder QuantityIntegerFalseFalse
CategoryText (50)FalseFalse
AttachmentsUnknown field type 101FalseFalse

List of fields within the Purchase Order Details table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
Purchase Order IDLongTrueFalse
Product IDLongFalseFalse
QuantityDecimalTrueFalse
Unit CostCurrencyTrueFalse
Date ReceivedDate / TimeFalseFalse
Posted To InventoryNoBooleanTrueFalse
Inventory IDLongFalseFalse

List of fields within the Purchase Order Status table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Status IDLongFalseTrue
StatusText (50)FalseTrue

List of fields within the Purchase Orders table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Purchase Order IDAuto NumberFalseTrue
Supplier IDLongFalseFalse
Created ByLongFalseFalse
Submitted DateDate / TimeFalseFalse
Creation DateNow()Date / TimeFalseFalse
Status ID0LongFalseFalse
Expected DateDate / TimeFalseFalse
Shipping Fee0CurrencyTrueFalse
Taxes0CurrencyTrueFalse
Payment DateDate / TimeFalseFalse
Payment Amount0CurrencyFalseFalse
Payment MethodText (50)FalseFalse
NotesMemoFalseFalse
Approved ByLongFalseFalse
Approved DateDate / TimeFalseFalse
Submitted ByLongFalseFalse

List of fields within the Sales Reports table
FieldnameDefault ValueData TypeRequiredIs PK?Description
Group ByText (50)TrueTrue
DisplayText (50)FalseFalse
TitleText (50)FalseFalse
Filter Row SourceMemoFalseFalse
DefaultNoBooleanTrueFalse

List of fields within the Shippers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
CompanyText (50)FalseFalse
Last NameText (50)FalseFalse
First NameText (50)FalseFalse
E-mail AddressText (50)FalseFalse
Job TitleText (50)FalseFalse
Business PhoneText (25)FalseFalse
Home PhoneText (25)FalseFalse
Mobile PhoneText (25)FalseFalse
Fax NumberText (25)FalseFalse
AddressMemoFalseFalse
CityText (50)FalseFalse
State/ProvinceText (50)FalseFalse
ZIP/Postal CodeText (15)FalseFalse
Country/RegionText (50)FalseFalse
Web PageHyperlinkFalseFalse
NotesMemoFalseFalse
AttachmentsUnknown field type 101FalseFalse

List of fields within the Strings table
FieldnameDefault ValueData TypeRequiredIs PK?Description
String IDAuto NumberFalseTrue
String DataText (255)FalseFalse

List of fields within the Suppliers table
FieldnameDefault ValueData TypeRequiredIs PK?Description
IDAuto NumberFalseTrue
CompanyText (50)FalseFalse
Last NameText (50)FalseFalse
First NameText (50)FalseFalse
E-mail AddressText (50)FalseFalse
Job TitleText (50)FalseFalse
Business PhoneText (25)FalseFalse
Home PhoneText (25)FalseFalse
Mobile PhoneText (25)FalseFalse
Fax NumberText (25)FalseFalse
AddressMemoFalseFalse
CityText (50)FalseFalse
State/ProvinceText (50)FalseFalse
ZIP/Postal CodeText (15)FalseFalse
Country/RegionText (50)FalseFalse
Web PageHyperlinkFalseFalse
NotesMemoFalseFalse
AttachmentsUnknown field type 101FalseFalse

Click here to return to the contents list

Queries

Query Information
NameTypeSQLDescription
Customers ExtendedSelectSELECT 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 ExtendedSelectSELECT 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]));
InventorySelectSELECT 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 HoldSelectSELECT [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 OrderSelectSELECT [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 PurchasedSelectSELECT [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 SoldSelectSELECT [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 DataSelectSELECT 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 ExtendedSelectSELECT [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 TotalsSelectSELECT [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 SubtotalsSelectSELECT [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 SummarySelectSELECT 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 DateSelectSELECT 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 OrdersSelectSELECT [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 PurchasesSelectSELECT [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 CategorySelectSELECT 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 DateSelectSELECT 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 DateSelectSELECT 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 TransactionsUnionSELECT [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 OrderSelectSELECT [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 ExtendedSelectSELECT [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 TotalsSelectSELECT [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 SummarySelectSELECT [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 AnalysisSelectSELECT 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 ExtendedSelectSELECT 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 ExtendedSelectSELECT 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 AmountSelectSELECT 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
NameCreatedLast UpdatedHas ModuleRecord SourceDescription
Active Orders Subform for Home10/04/2010 14:40:0610/04/2010 14:40:06FalseSELECT 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 Details10/04/2010 14:40:0510/04/2010 14:40:05FalseCustomers Extended
Customer List10/04/2010 14:40:0610/04/2010 14:40:06FalseCustomers Extended
Customer Orders Subform10/04/2010 14:40:0510/04/2010 14:40:05FalseOrder Summary
Employee Details10/04/2010 14:40:0510/04/2010 14:40:05FalseEmployees Extended
Employee List10/04/2010 14:40:0610/04/2010 14:40:06FalseEmployees Extended
Employee Orders Subform10/04/2010 14:40:0610/04/2010 14:40:06FalseOrder Summary
Home10/04/2010 14:40:0510/04/2010 14:40:05FalseStrings
Inventory List10/04/2010 14:40:0510/04/2010 14:40:05TrueInventory
Inventory to reorder Subform for Home10/04/2010 14:40:0610/04/2010 14:40:06FalseSELECT Inventory.* FROM Inventory WHERE (((Inventory.[Current Level])<[Reorder Level]));
Login Dialog10/04/2010 14:40:0610/04/2010 14:40:06False
Order Details10/04/2010 14:40:0510/04/2010 14:40:05TrueSELECT 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 List10/04/2010 14:40:0610/04/2010 14:40:06FalseOrder Summary
Order Subform for Order Details10/04/2010 14:40:0510/04/2010 14:40:05TrueOrder Details Extended
Product Category Sales by Month10/04/2010 14:40:0610/04/2010 14:40:06FalseProduct Category Sales by Date
Product Details10/04/2010 14:40:0610/04/2010 14:40:06FalseProducts
Product Sales by Category Chart10/04/2010 14:40:0510/04/2010 14:40:05FalseProduct Sales by Category
Product Sales by Total Revenue Chart10/04/2010 14:40:0510/04/2010 14:40:05FalseProduct Sales Total by Date
Product Sales Qty by Employee Chart10/04/2010 14:40:0510/04/2010 14:40:05FalseProduct Sales Qty by Employee and Date
Product Transactions Subform for Product Details10/04/2010 14:40:0610/04/2010 14:40:06FalseProduct Transactions
Purchase Order Details10/04/2010 14:40:0510/04/2010 14:40:05TrueSELECT [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 List10/04/2010 14:40:0610/04/2010 14:40:06FalsePurchase Summary
Purchases Subform for Purchase Order Details10/04/2010 14:40:0610/04/2010 14:40:06TruePurchase Details Extended
Receiving Subform for Purchase Order Details10/04/2010 14:40:0510/04/2010 14:40:05TruePurchase Details Extended
Sales Analysis Form10/04/2010 14:40:0610/04/2010 14:40:06FalseSales Analysis
Sales Analysis Subform for Home Chart10/04/2010 14:40:0610/04/2010 14:40:06FalseSELECT 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 Dialog10/04/2010 14:40:0510/04/2010 14:40:05True
Shipper Details10/04/2010 14:40:0610/04/2010 14:40:06FalseShippers Extended
Shipper List10/04/2010 14:40:0610/04/2010 14:40:06FalseShippers Extended
Startup Screen10/04/2010 14:40:0610/04/2010 14:40:06False
Supplier Details10/04/2010 14:40:0510/04/2010 14:40:05FalseSuppliers Extended
Supplier List10/04/2010 14:40:0510/04/2010 14:40:05FalseSuppliers Extended
Supplier Products Subform10/04/2010 14:40:0510/04/2010 14:40:05FalseProducts
Supplier Purchases Subform10/04/2010 14:40:0510/04/2010 14:40:05FalsePurchase Orders

Click here to return to the contents list

Reports

Information about the reports within this database
NameCreatedLast UpdatedHas ModuleRecord SourceDescription
Customer Address Book10/04/2010 14:40:0610/04/2010 14:40:06FalseCustomers Extended
Customer Phone Book10/04/2010 14:40:0610/04/2010 14:40:06FalseCustomers Extended
Employee Address Book10/04/2010 14:40:0610/04/2010 14:40:06FalseEmployees Extended
Employee Phone Book10/04/2010 14:40:0610/04/2010 14:40:06FalseEmployees Extended
Invoice10/04/2010 14:40:0610/04/2010 14:40:06FalseInvoice Data
Monthly Sales Report10/04/2010 14:40:0610/04/2010 14:40:06TrueSales Analysis
Product Category Sales by Month10/04/2010 14:40:0610/04/2010 14:40:06False
Product Sales by Category10/04/2010 14:40:0610/04/2010 14:40:06False
Product Sales by Total Revenue10/04/2010 14:40:0610/04/2010 14:40:06False
Product Sales Quantity by Employee10/04/2010 14:40:0610/04/2010 14:40:06False
Quarterly Sales Report10/04/2010 14:40:0610/04/2010 14:40:06TrueSales Analysis
Supplier Address Book10/04/2010 14:40:0610/04/2010 14:40:06FalseSuppliers Extended
Supplier Phone Book10/04/2010 14:40:0610/04/2010 14:40:06FalseSuppliers Extended
Top Ten Biggest Orders10/04/2010 14:40:0610/04/2010 14:40:06FalseTop Ten Orders by Sales Amount
Yearly Sales Report10/04/2010 14:40:0610/04/2010 14:40:06TrueSales Analysis

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
CustomerOrders10/04/2010 14:40:0510/04/2010 14:40:05Normal Module67
DomainFunctionWrappers10/04/2010 14:40:0510/04/2010 14:40:05Normal Module128
ErrorHandling10/04/2010 14:40:0510/04/2010 14:40:05Class Module73
Inventory10/04/2010 14:40:0510/04/2010 14:40:05Normal Module339
Privileges10/04/2010 14:40:0510/04/2010 14:40:05Normal Module34
PurchaseOrders10/04/2010 14:40:0510/04/2010 14:40:05Normal Module156
RecordsetWrapper10/04/2010 14:40:0510/04/2010 14:40:05Class Module152
Utilities10/04/2010 14:40:0510/04/2010 14:40:05Normal Module186

Click here to return to the contents list

Code routines within the module CustomerOrders
PrototypeNo. LinesDescription
Function CreateInvoice(OrderID As Long, Amt As Currency, InvoiceID As Long) As Boolean13
Function IsInvoiced(OrderID As Long) As Boolean1
Function PrintInvoice(OrderID As Long) As Boolean1
Function SetStatus(OrderID As Long, Status As CustomerOrderStatusEnum) As Boolean10
Function Delete(OrderID As Long) As Boolean4

Code routines within the module DomainFunctionWrappers
PrototypeNo. LinesDescription
Private Function DomainFunctionWrapper(DomainFunction As DomainFunctionWrapperEnum, Expr As String, Domain As String, Optional Criteria As String) As Variant33
Public Function DLookupWrapper(Expr As String, Domain As String, Optional Criteria As String) As Variant1
Public Function DLookupStringWrapper(Expr As String, Domain As String, Optional Criteria As String, Optional ValueIfNull As String = "") As String1
Public Function DLookupNumberWrapper(Expr As String, Domain As String, Optional Criteria As String, Optional ValueIfNull = 0) As Variant1
Public Function DCountWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long1
Public Function DMaxWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long1
Public Function DMinWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long1
Public Function DSumWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long1
Public Function DAvgWrapper(Expr As String, Domain As String, Optional Criteria As String) As Long1

Code routines within the module ErrorHandling
PrototypeNo. LinesDescription
Public Function LogError(strLocation As String, ParamArray State()) As Boolean20
Function TryToCloseObject() As Boolean10
Function TryToSaveRecord() As Boolean1
Function TryToRunCommand(Command As AcCommand) As Boolean10
Function TryToGoToRecord(Record As AcRecord) As Boolean9

Code routines within the module Inventory
PrototypeNo. LinesDescription
Public Property Get NewInventoryID() As Long1
Function AddPurchase(PurchaseOrderID As Long, ProductID As Long, Qty As Long, ByRef InventoryID As Long) As Boolean11
Function RemovePurchase(lInventoryID As Long)1
Function GetQtyAvailable(ProductID As Long) As Long1
Function GetQtyOnHand(ProductID As Long) As Long1
Function GetQtyToReorder(ProductID As Long) As Long1
Function GetQtyOnBackOrder(ProductID As Long) As Long1
Private Function GetInventoryQuantity(FieldName As String, ProductID As Long) As Long1
Function RequestHold(OrderID As Long, IT As InventoryTransaction) As Boolean9
Function AddHold(OrderID As Long, IT As InventoryTransaction) As Boolean28
Function ModifyHold(IT As InventoryTransaction) As Boolean20
Function HoldToSold(InventoryID As Long) As Boolean9
Function RemoveHold(InventoryID As Long) As Boolean1
Function GetTransaction(IT As InventoryTransaction) As Boolean12
Function EditTransaction(IT As InventoryTransaction, Optional CustomerOrderID, Optional PurchaseOrderID) As Boolean28
Function DeleteTransaction(InventoryID As Long) As Boolean4
Function RestockProduct(ProductID As Long) As Boolean35
Function FindProductSupplier(ProductID As Long) As Long1
Function GetRestockingPurchaseOrder(SupplierID) As Long1
Function FillBackOrders(ProductID) As Boolean25
Function FillBackOrder(OrderID As Long, IT As InventoryTransaction) As Boolean6

Code routines within the module Privileges
PrototypeNo. LinesDescription
Private Function EmployeeHas(EmployeeID As Long, PrivilegeID As PrivilegeEnum) As Boolean1
Public Function CanApprovePurchases() As Boolean3
Public Function IsAdministrator() As Boolean3
Public Function GetCurrentUserID() As Long1

Code routines within the module PurchaseOrders
PrototypeNo. LinesDescription
Function Generate(SupplierID As Long, ProductID As Long, Quantity As Long, OrderID As Long, PurchaseOrderID As Long) As Boolean5
Function Create(SupplierID As Long, EmployeeID As Long, OrderID As Long, PurchaseOrderID As Long) As Boolean23
Function CreateLineItem(PurchaseOrderID As Long, ProductID As Long, UnitCost As Long, Quantity As Long) As Boolean11
Sub OpenOrder(Optional PurchaseOrderID As Long)5
Sub NewOrder()1
Function Delete(PurchaseOrderID As Long) As Boolean4
Private Function SetStatus(PurchaseOrderID As Long, Status As PurchaseOrderStatusEnum) As Boolean21
Function GetStatus(PurchaseOrderID) As PurchaseOrderStatusEnum5
Function MarkApproved(PurchaseOrderID As Long) As Boolean7
Function MarkSubmitted(PurchaseOrderID As Long) As Boolean1
Function Exists(PurchaseOrderID As Long) As Boolean1
Function GetStandardCost(lProductID As Long) As Currency1
Function GetListPrice(lProductID As Long) As Currency1

Code routines within the module RecordsetWrapper
PrototypeNo. LinesDescription
Public Function GetRecordsetClone(rs As DAO.Recordset2) As DAO.Recordset26
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 Boolean26
Public Function Delete() As Boolean10
Public Function AddNew() As Boolean10
Public Function Edit() As Boolean10
Public Function Update() As Boolean10
Public Function MoveNext() As Boolean10
Public Function CloseRecordset() As Boolean11
Public Property Get Recordset() As DAO.Recordset21
Private Sub Class_Terminate()4

Code routines within the module Utilities
PrototypeNo. LinesDescription
Function MsgBoxYesNo(StringID As StringIDEnum, Optional ByVal strInsert As String) As Boolean1
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 VbMsgBoxResult1
Function LoadString(StringID As StringIDEnum) As String5
Function InsertString(StringID As StringIDEnum, strInsert As String) As String1
Function HasSourceCode() As Boolean5
Function IsRuntime() As Boolean1
Function DebuggingSupported() As Boolean1

Click here to return to the contents list

Form Modules

Code routines within the module Form_Inventory List
PrototypeNo. LinesDescription
Private Sub cmdPurchase_Click()8

Code routines within the module Form_Order Details
PrototypeNo. LinesDescription
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 Long1
Function ValidateShipping() As Boolean8
Function ValidatePaymentInfo() As Boolean4
Sub SetFormState(Optional fChangeFocus As Boolean = True)21
Function ValidateOrder(Validation_OrderStatus As CustomerOrderStatusEnum) As Boolean38

Code routines within the module Form_Order Subform for Order Details
PrototypeNo. LinesDescription
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
PrototypeNo. LinesDescription
Public Function GetPurchaseDetailsSubform() As [Form_Purchases Subform for Purchase Order Details]1
Private Function PurchaseContainsLineItems() As Boolean1
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 Boolean16
Private Function PurchaseOrder_ContainsPostedInventory() As Boolean10
Function PurchaseOrderIsValid() As Boolean21
Public Sub InitFormState()21

Code routines within the module Form_Purchases Subform for Purchase Order Details
PrototypeNo. LinesDescription
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 Boolean1

Code routines within the module Form_Receiving Subform for Purchase Order Details
PrototypeNo. LinesDescription
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
PrototypeNo. LinesDescription
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 Date1

Click here to return to the contents list

Report Modules

Details of reports within this database
Report NameModule NameNo. Lines
Monthly Sales ReportReport_Monthly Sales Report38
Quarterly Sales ReportReport_Quarterly Sales Report43
Yearly Sales ReportReport_Yearly Sales Report36
Code routines within the module Report_Monthly Sales Report
PrototypeNo. LinesDescription
Private Sub Report_Open(Cancel As Integer)30

Code routines within the module Report_Quarterly Sales Report
PrototypeNo. LinesDescription
Private Sub Report_Open(Cancel As Integer)36

Code routines within the module Report_Yearly Sales Report
PrototypeNo. LinesDescription
Private Sub Report_Open(Cancel As Integer)28

Click here to return to the contents list

Macros

Details of Macros within this database
NameDate CreatedLast UpdatedDescription
AutoExec10/04/2010 14:40:0510/04/2010 14:40:05
Delete All Data10/04/2010 14:40:0510/04/2010 14:40:05

Click here to return to the contents list

Relationships

Details of table relationships within this database
Primary NameForeign NameDescription
Customers.IDOrders.Customer ID
Employees.IDEmployee Privileges.Employee ID
Privileges.Privilege IDEmployee Privileges.Privilege ID
Employees.IDOrders.Employee ID
Employees.IDPurchase Orders.Created By
Inventory Transactions.Transaction IDPurchase Order Details.Inventory ID
Orders.Order IDOrder Details.Order IDCascade deletes
Orders.Order IDInvoices.Order IDCascade deletes
Orders.Order IDInventory Transactions.Customer Order ID
Orders Status.Status IDOrders.Status ID
Order Details Status.Status IDOrder Details.Status ID
Products.IDInventory Transactions.Product ID
Products.IDPurchase Order Details.Product ID
Products.IDOrder Details.Product ID
Purchase Orders.Purchase Order IDInventory Transactions.Purchase Order ID
Purchase Orders.Purchase Order IDPurchase Order Details.Purchase Order IDCascade deletes
Purchase Order Status.Status IDPurchase Orders.Status ID
Shippers.IDOrders.Shipper ID
Suppliers.IDPurchase Orders.Supplier ID
Orders Tax Status.IDOrders.Tax Status
Inventory Transaction Types.IDInventory 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
NameFull PathReference Broken
Visual Basic For ApplicationsC:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLFalse
Microsoft Access 15.0 Object LibraryC:\Program Files (x86)\Microsoft Office\Office15\MSACC.OLBFalse
OLE AutomationC:\Windows\SysWOW64\stdole2.tlbFalse
C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\ACEDAO.DLLFalse
Microsoft ActiveX Data Objects 2.8 LibraryC:\Program Files (x86)\Common Files\System\ado\msado28.tlbFalse

Click here to return to the contents list