TheMicrosoft(MS) Access Homework (HW) #4 is titled "Basic Skills and Tools - Access". Theassignment is in the attached Introduction to Business Information Systems workbook, Technology...

TheMicrosoft(MS) Access Homework (HW) #4 is titled "Basic Skills and Tools - Access". Theassignment is in the attached Introduction to Business Information Systems workbook, Technology Plugin(TPI).Read the attached TPI-6.

II. You willexecute Making Business Decisions -Academic Software. Use the attached file"T6_AcademicSoftware_Data.xls".

III. Complete questions 1 - 4 under Academic Softwareon Pg.T6-17 & 18 to complete the HWassignment.

A. A.
Special notes
to use with the 4 questions from the workbook:

1.Three tables will be created for this MS Access database according to the assignment instruction:
Categories, Software, and Vendors

2.Use the attached MS Excel file to populate the MS Access database file you will create for this assignment

3.Software ID – Use as the primary key for the Software table.

4.Create unique ID field for vendors and academic categories tables, which are to be used as the primary key:
Vendors (e.g., Academic Software = AS) and Academic Categories (e.g., Math = MTH)