How to Make a Bill of Materials With Access 2007

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Bill of Materials With Access 2007
A database is a way of organising and maintaining data. (database on paper image by .shock from

A bill of materials is a list of raw materials, components and parts needed to manufacture a product. A Microsoft Access 2007 database is the ideal way to keep track of what's needed to manufacture items. Access 2007 can keep track of what items you have at hand and what items you need to order. You don't need any database experience with Microsoft Access; the accessible interface can be used by the novice developer.

Skill level:

Other People Are Reading


  1. 1

    Click the "Microsoft Office" button and then click "New."

  2. 2

    Type "Bill of Materials" into the "File Name" text box.

  3. 3

    Click "Create."

  4. 4

    Click the "Home" tab and then click "View."

  5. 5

    Click "Design View."

  6. 6

    Type the field names into column 1, under "Field Name." Field names are the groups of data that you want to include in your table. For a bill of materials, you'll want to include the item, the item description, cost per item, number required and the item grade. Type "Item" into column 1, row 1; "Description" into column 1, row 2; "Cost per item" into column 1, row 3; "Number required" into column 1, row 4; and "Grade" into column 1, row 5.

  7. 7

    Type the data type into the second column for each entry you made in column 1. For this example, type "Text" into column 2, rows 1 and 2, and "Number" into column 2, rows 3, 4 and 5.

  8. 8

    Save your table by clicking the "Microsoft Office" button and then clicking "Save." Your database is now ready to use for data entry.

Tips and warnings

  • Do not open a new database with the same name: each database name must be unique. If you make another "Bill of Materials" database, Access will write over the data in your existing database with any entries you make in the second database.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.