The Northwind sample database is a publicly-available fictitious simple transaction processing database that is used here to illustrate the recording, storing, retrieving, and editing of data related to procurement and fulfillment activities of the company, Northwind Traders. If you have access to recent versions of Microsoft Access, you can install the database from a built-in Database Template.
The Northwind database contains a set of data tables. For our purposes, we will work with two tables from the Northwind database: Customers and Orders. Note that the original creators of the database and its tables have taken shortcuts in creating some of the fields and field values in the sense that values don't vary in some places in which they ought to in reality. For our purposes, we have converted the original source tables to...