Select any topic below to learn about Product Categories in the Northwind Developer Edition.
Only this Developer Edition of the Northwind Product Categories sample application has the Product Categories module. In the Starter Edition, Product Category is a field in the Products table. The Developer Edition expands upon the database schema (tables used) in the Starter Edition and uses more advanced features. It is meant to introduce you to the major features of Microsoft Access, not to run any specific business.
In Northwind 2.0 Developer Edition, product categories are available via the System Admin button on the custom Home tab.
In this section, we address noteworthy implementation details of the Product Categories form sfrmProductCategories.
-
The Product Categories form gets its data from a simple, single-table query, qryProductCategories (see RecordSource property). Best practice is to base a data entry form on a simple query.
-
This form uses a listbox to drive form navigation. When the user selects a category from the listbox, the listbox’s AfterUpdate event moves the form’s recordset bookmark to the selected category’s detail record.
-
Product Categories also implements an Attachment field to display the image of each product category. In the table ProductCategories, field ProductCategoryImage is defined as data type Attachment. Including the attachment field in a form or report enables the image to display in form view or report view. These images are used in the Fall Catalog report.
-
Northwind 2.0 Developer Edition: Things you should know
-
Northwind 2.0 Developer Edition: All topics
