The Northwind 2.0 Developer Edition Template expands on the concepts of the Northwind 2.0 Starter edition, with a more complete data model and more sophisticated features. To learn more, select any of the following topics.
About the Template
The Northwind 2.0 Developer Edition template showcases major features of Access; it is not designed to run a company nor show you how to build such an application.
Northwind is a fictitious trading company whose customers are independent grocery stores.
Customers call in orders or place them over the internet. In this template, Internet orders are a mockup.
Northwind invoices, ships, collects payments, and closes orders. Purchase orders and inventory management are also included in this edition.
Sample data in the template will help you started quickly.
Northwind 2.0 Developer edition includes a feature matrix accessible from the custom Home ribbon Northwind Features button. It contains a list of notable concepts implemented in this version. Each concept topic outlines how you can view an example of it within the Northwind 2.0 Developer template, as well as handy links to learn more about the topic:
Click for On-Line Help opens a Web page addressing the topic.
Click for in-App Help opens the access application’s internal Help library to the topic.
Multiple Form Instances
By default, Access forms can be instantiated only once. In this template, Northwind Orders and Purchase Orders forms (frmOrderDetails and frmPurchaseOrderDetails) can be instantiated multiple times concurrently. In these forms, follow the for a deeper dive into how this is accomplished.
Cascading Combo Boxes
Refer to the Orders form for a method of implementing cascading combo boxes where a Product Categories combobox leads to a Products combobox with only the products for the selected category.
Validating Required Fields
This edition features the VBA function ValidateForm() to highlight required form fields that are empty. For an example, try creating an Order without completing fields Customer and Tax Status. You can further investigate how this was accomplished using the on the Order screen.
“Lazy Loading” Subforms
Sometimes referred to as “late binding,” lazy loading in a tab control delays loading a tab’s subform contents until the tab is selected. By default, Access loads subforms before loading the form itself. Late binding can improve form performance (loading speed).
See the Product Detail form.
Street Address Map Link
The Company Detail form (frmCompanyDetail) features a Map button that opens the default Web browser to a map of the company’s address. Northwind 2.0 Developer implements this using Microsoft Bing maps, but could use any Web-based map site, such as Google Maps or MapQuest.
Company List and Company Detail forms also demonstrate a means to allow users to view a form’s current filters.
Both Orders and Purchase Orders implement very simple workflows. These demonstrate a means for controlling the sequence of data updates required to enforce business rules for moving an order from one status to the next.
Report Fall Catalog - demonstrates a number of more advanced report development topics
Multiple sections (Introduction, TOC, Categories, Order form)
TOC and pagination
Resulting report is a publisher-quality catalog
Monthly Sales By Employee – The report can be filtered at runtime in Report View.
Northwind has a simple but correct Relational Database Design.
Tables hold specific information about Northwind's business.
Fields in the tables have specific properties set to make them required or to enforce a certain data type (for example, numeric, date, and yes/no).
Relations between tables enforce business rules and ensure data consistency (for example, an order must be for an existing customer).
To explore Northwind's database design, press F11 to open the Navigation Pane which displays tables and other objects, or choose Develop > Relationships in the ribbon.
To see the full-size database design image click here
Programming and Visual Basic for Applications (VBA)
This edition features more extensive implementation using VBA instead of macros.
Examining the VBA modules, you may find examples of alternate or Equivalent Syntax. This is included to help you recognize different syntax that accomplishes exactly or approximately the same result.
Programming facilitates application flow (for example, Opening the next form) or enforces business rules (for example, you cannot update an Order status to “Closed” without first receiving payment for it).
Northwind Developer uses different examples of Programming to show Access capabilities:
Expressions in the Employees table create the FullNameFNLN and FullNameLNFN fields. An expression field in a table can be used elsewhere, for example, to show the employee's full name in the Access main window title.
In Northwind 2.0 Developer Edition, macros are replaced with VBA procedures. To view the VBA editor, press Alt+F11.
By default, Access creates macros when you use Wizards, such as when dropping a button on a form in design view. Access can convert macros to VBA for you: In form Design view, Design > Tools > Convert Form’s Macros to Visual Basic.
To explore form programming, open the form in Design view, then select Form Design > Property Sheet to inspect the properties of the selected object. Most of the code is accessed from the Events tab of the property sheet, as shown below.
Most Northwind forms contain a special help link denoted with the symbol:
This symbol will link contextually to Microsoft web pages devoted to all things Northwind, featuring detailed discussions on the Northwind application form objects, their showcased functionality, and how it was accomplished.