1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wizard but you will lose 4 points)
2. Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid
3. Integrate the spreadsheet data into the application.
HINT: the spreadsheet can contains any special list such new DVDs, or updated notes.
Write a code to update (your inventory table, can be CD list or DVD list) from the list.
HINT: for the update (the easy way)