Okay so I am in an advance class for Access and I am very lost when it comes to coding…

Okay so I am in an advance class for Access and I am very lost when it comes to coding with VBA! I think I am ruining my database so I am looking for help. How much do you charge to actually do the assignment? ( I know thats terrible!!! But it is due Sunday at midnight) This is the assignment let me know how much you would charge?
Create a simple excel spreadsheet with data to update the database.

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)

– delete the current records then insert the records from the spread sheet extra credit (advanced way)

– compare each record if it is new add it to the table, if it exists update the info from the spread sheet. If you are going to do this option please indicate in the student comments so I can look for it, make sure you upload the spread sheet with the database