Page 561 - Using MIS

Figure AE-8
Bill of Materials Example

AE7-2. Figure AE-8 is a sample bill of materials (BOM), a form that shows the compo-
nents and parts used to construct a product. In this example, the product is a
child’s wagon. Such bills of materials are an essential part of manufacturing functional
applications as well as ERP applications.
This particular example is a form produced using Microsoft Access. Creating such
a form is a bit tricky, so this exercise will guide you through the steps required. You can
then apply what you learn to produce a similar report. You can also use Access to ex-
periment on extensions of this form.
a. Create a table named PART with columns PartNumber, Level, Description,
QuantityRequired, and PartOf. Description and Level should be text, PartNumber
should be AutoNumber, and QuantityRequired and PartOf should be numeric, long
integer. Add the PART data shown in Figure AE-8 to your table.
b. Create a query that has all columns of PART. Restrict the view to rows having a value
of 1 for Level. Name your query Level1.
c. Create two more queries that are restricted to rows having values of 2 or 3 for Level.
Name your queries Level2 and Level3, respectively.
d. Create a form that contains PartNumber, Level, and Description from Level1. You
can use a wizard for this if you want. Name the form Bill of Materials.
e. Select the Subform/Subreport tool in the Controls section of the DESIGN ribbon
and create a subform in your form in part d. Set the data on this form to be all of the
columns of Level2. After you have created the subform, ensure that the Link Child
Fields property is set to PartOf and that the Link Master Fields property is set to
PartNumber. Close the Bill of Materials form.

529