Music
For this database project, you will use MS Access to create a database of vendors, and the related items they sell to your hardware store. For example, if you are Lowe’s® or Home Depot®, you purchase items to sell from various vendors, such as Black and Decker®. Some of those items may be power tools or hand tools. You may purchase items for sale from other vendors, such as garden tools. Your database is made up of two tables: * The vendor table,– it will contain at least four vendors in it. * And the item table,– it will contain at least three items for each vendor.
In this project, you will:
1. Design the Table Structure 2. Enter the Data. Print. 3. Relate the two tables. Print. 4. Then delete one Item record. Print 5. Create three Queries. Print. 6. Create one Report. Print. 7. In addition, you may choose to create yet another report for up to 5 points extra credit. Print.
1. DESIGN YOUR TABLE STRUCTURE.
You will do this for both tables. Please note the information below describing both tables. Your tables must include the information below. You must have the same field names, and each field must have the same data type, same field size and other information that must be defined in the field properties.
DATABASE NAME – When you save your database, you must save it as Lastname-Hardware_Store, ex. KING_Hardware_Store
VENDOR TABLE Field Name | Data Type | Field Size | Other Information | Vendor ID | Text | 5 Chars | Primary Key – may contain alpha and numeric. You create this, do not use autonumber. | Vendor Name | Text | 20 Chars | | Vendor City | Text | 12 Chars | | Vendor State | Text | 2 Chars | Must be uppercase |
ITEM TABLE Field Name | Data Type | Field Size | Other Information | Item ID | Auto-number | | Primary Key, this must be autonumber | Description | Text | 20 Chars | | Vendor ID | Text | 5 Chars | For each record, the data element in this field
In this project, you will:
1. Design the Table Structure 2. Enter the Data. Print. 3. Relate the two tables. Print. 4. Then delete one Item record. Print 5. Create three Queries. Print. 6. Create one Report. Print. 7. In addition, you may choose to create yet another report for up to 5 points extra credit. Print.
1. DESIGN YOUR TABLE STRUCTURE.
You will do this for both tables. Please note the information below describing both tables. Your tables must include the information below. You must have the same field names, and each field must have the same data type, same field size and other information that must be defined in the field properties.
DATABASE NAME – When you save your database, you must save it as Lastname-Hardware_Store, ex. KING_Hardware_Store
VENDOR TABLE Field Name | Data Type | Field Size | Other Information | Vendor ID | Text | 5 Chars | Primary Key – may contain alpha and numeric. You create this, do not use autonumber. | Vendor Name | Text | 20 Chars | | Vendor City | Text | 12 Chars | | Vendor State | Text | 2 Chars | Must be uppercase |
ITEM TABLE Field Name | Data Type | Field Size | Other Information | Item ID | Auto-number | | Primary Key, this must be autonumber | Description | Text | 20 Chars | | Vendor ID | Text | 5 Chars | For each record, the data element in this field