Microsoft Access Database Assignment
Purpose:
The purpose of this assignment is to demonstrate skills developed using Access. In this assignment, you are to create a database as described below.
Scenario:
You are the owner of a highly successful Mediterranean Restaurant, and your clientele is grown due to the overwhelming signature Gyros the restaurant serves. Up until now, you have been using a rolodex to keep track of your vendors. However, you have completed your computer class and learned how to use MS Access. It is now time to put the skills to the test and create a more sophisticated tracking system. Your database will contain information on each supply item and the vendor contact information that sells the item.
REQUIREMENTS:
·
You must use Access to complete this assignment. Using other software will result in a grade of zero.
· When you are finished, your database must contain TWO tables, Suppliers and Products.
· The Suppliers table must contain the following fields:
o
Vendor ID
o Vendor Name
o Contact name
o Business Phone (use input mask)
o Email
o You must have at least (10) different records. You need to make up this data, it is not provided.
· The Products table must contain the following fields:
o sequence (AutoNumber)
o Product Brand
o Product Description
o Vendor ID
o You should have at least (4) vendors selling the same item. You need to make up the data, it is not provided.
· You should create one report that groups all products by vendor, listing out each product the vendor supplies, sorting the products by name alphabetically.
· The report should be formatted in a manner that gives a professional appearance, with columns aligned.
· Finally, you need to use forms to give a user-friendly way to input, add, and update data in the tables.
Microsoft Access Database Assignment
Purpose:
The purpose of this assignment is to demonstrate skills developed using Access. In this assignment, you are to create a database as described below.
Scenario:
You are the owner of a highly successful Mediterranean Restaurant, and your clientele is grown due to the overwhelming signature Gyros the restaurant serves. Up until now, you have been using a rolodex to keep track of your vendors. However, you have completed your computer class and learned how to use MS Access. It is now time to put the skills to the test and create a more sophisticated tracking system. Your database will contain information on each supply item and the vendor contact information that sells the item.
REQUIREMENTS:
·
You must use Access to complete this assignment. Using other software
will result in a grade of zero.
· When you are finished, your database must contain TWO tables, Suppliers and Products.
· The Suppliers table must contain the following fields:
· Vendor ID
· Vendor Name
· Contact name
· Business Phone (use input mask)
· You must have at least (10) different records. You need to make up this data, it is not provided.
· The Products table must contain the following fields:
· sequence (AutoNumber)
· Product Brand
· Product Description
· Vendor ID
· You should have at least (4) vendors selling the same item. You need to make up the data, it is not provided.
· You should create one report that groups all products by vendor, listing out each product the vendor supplies, sorting the products by name alphabetically.
· The report should be formatted in a manner that gives a professional appearance, with columns aligned.
· Finally, you need to use forms to give a user-friendly way to input, add, and update data in the tables.
Database Assignment
Rubric
Critical Elements
Distinguished
Proficient
Emerging
Not Evident
Value
Structure
At least 90% of the tables are created correctly
(32-35)
At least 80% of the tables are created correctly.
(28-31)
At least 75% of the tables are created correctly.
(25-27)
Less than 75% of the tables are created correctly
(0-24)
35
Data
At least 90% of the data is loaded into the tables
(9-10)
At least 80% of the data is loaded into the tables
(8)
At least 75% of the data, is loaded into the tables
(7)
Less than 75% of the data is loaded into the tables
(0-6)
10
Reporting
At least 90% or more of the report correctly interprets the numerical problem data. The report is formatted to be professional in appearance with columns aligned.
(27-30)
At least 80% or more of the report correctly interprets the numerical problem data. The report is formatted to be professional in appearance with columns aligned.
(24-26)
At least 75% or more of the report correctly interprets the numerical problem data. Contains minor formatting errors.
(21-23)
Less than 75% of the report correctly interprets the numerical problem data. The report is not formatted, columns are not aligned.
(0-20)
30
Data Entry Forms
At least 90% or more of the form allow for accurate data entry.
(23-25)
At least 80% or more of the form allows for accurate data entry.
(20-22)
At least 75% or more of the form allows for accurate data entry.
(18-19)
Less than 75% of the form allows for accurate data entry.
(0-17)
25
Comments:
Earned Total:
100