Uncategorized

Microsoft Access Database Assignment

Microsoft Access Database Assignment

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.

•    You must use Access 2010 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 need to have one report that should provide a list of all the products available, sorted alphabetically by product name, and grouped by the vendors that can supply it.
•    Finally, you need to use forms to give a user-friendly way to input, add, and update data in the tables.