The Crafty Database
We built a database in Access 2000 for a crafter's accounting application. This application is typically used by a crafter who wants to centralize information about her crafts, ongoing projects, orders for supplies, and orders for the end products. This database was designed to track orders and purchases made at local craft shows. But with Access 2002 and Access 2003, it can also be used to create XML files ( by exporting the information stored in one or more of the tables) for simple web presentation, and/or to import information from the XML of a web site's order screen output into the database. This setup allows the crafter to branch out into Internet sales more simply and elegantly.
Please pardon the typos in our database code and content; great crafters aren't necessarily great typists.
Figure 1 shows the tables included in our database. In this article, we'll focus on the Orders and Products tables.
Figure 1 The Crafty database's data tables.
Figure 2 shows the structure of the Products table and some examples of products. The information and basic conceptual structure of this table will be exported from the database and stored in an XML file for use in the crafters' new web page.
Figure 2 The Products table.