Part 2: Vendor Database
Create a vendor database and related reports and queries to capture contact information for potential vendors. As your research your chosen case study and the hardware and software requirements, collect contact information for potential vendors. This information will be used to populate an Access database.
For this assignment, you will be creating an MS Access database file that contains the following components:
a simple database table to hold vendor contact information;
a simple database form that can be used to enter data into the database table; and
a simple database report that can used to present the data as information.
A simple mailing label report.
All aspects of the assignment will be evaluated according to the following criteria and overall professional business-like appearance. This would include clear readability and formatting for both screen and print-based output.
Requirement
Points Allocated
Comments
Launch MS Access and open a Blank Access database.
Save the new database with the following name:
Vendor Database_(First Initial and Last Name)
0.5
Create a table with all the following fields and settings:
A. Vendor ID (autonumber)
B. Company Name (text)
C. Contact’s First Name (text)
D. Contact’s Last Name (text)
E. Billing Address (text) (this is the street address)
F. City (text)
G. State (text—limited to 2 characters)
H. Zip Code (text—limited to 5 characters)
I. Phone Number (text)
J. YTD Orders (currency) (if any)
K. Preferred Vendor (Yes/No)
1.5
The Vendor ID field must be set as the primary key (*). If the Vendor ID is not the primary key, 0.5 points will be deducted. If you have properly set the Vendor ID field as the primary key, it will be numbered automatically (Auto Number).
Name the table as follows:
Vendor Table
0.5
Use the Form Wizard to create a form that uses all the fields from the Vendor table.
1.0
Let the Form Wizard guide you through the completion of the form.
Use…