Assign the caption vc to the vendor code field

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer

Perform the following tasks:
Create a new blank database in which to store all data for the gift shop and save the database as LastnameFirstnameMod1Lab.accdb
Import the Vendor table AND the Item table from the database (Module 1 Lab Assignment.accdb) into the new blank database you created in Step 1.
Open the Vendor table.
Change the field size for the Vendor Code field to 2
Change the field size for the Vendor Name field to 25
Change the field size for the Telephone Number field to 12
Assign the caption VC to the Vendor Code field
Resize the columns to best fit the data
Save the changes to the table and close the table
Open the Item table.
Change the field size for the Vendor Code field to 2
Change the field size for the Item Number field to 4
Change the field size for the Description field to 28
Add the caption Wholesale for the Wholesale Cost field, the caption Retail for the Retail Price field, and the caption VC for the vendor code
The On Hand field should be an Integer field
Resize the columns to best fit the data
Save the changes to the table and close the table
Create a query for the Item table. Include the Item Number, Description, Wholesale Cost,
Retail Price, and Vendor Code. Save the query as Item Query.
Create a form for the Item table. Save the form as Item.
Create a report for the Item table. Include the Item Number, Description, On Hand, and Wholesale Price. Save the report as Item Status Report.
Change the telephone number for Asherton Wholesalers to 111-111-1111.
Update the author (use your name) and title (use ‘Module 1 Lab Assignment’) in the document properties.
Upload your assignment as a Microsoft Access database using the following naming protocol: LastnameFirstnameMod1Lab.accdb

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer

Place this order or similar order and get exceptional paper written by our team of experts at an affordable price

Leave a Reply