Database Worksheet

REPOSTING FOR THE THIRD TIME.  TWO TUTORS HAVE SCREWED ME OVER.  IF YOU CAN'T DO THIS ASSIGNMENT DO WASTE ANYONE'S TIME PLEASE!

IF YOU HAVE NO FEEDBACK IN YOUR COMMENTS REGARDING MS ACCESS AND/OR MS EXCEL DON'T BOTHER SENDING A HANDSHAKE.

Use the attached database to complete the assignment:

1.  Create a simple excel spreadsheet with data to update the database.   Note, this can hold any type of data to be used in this database.

2.  Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database.  DO NOT manually link the spreadsheeet using the wizard.

3.  Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox, or any from a grid.   Note, VBA Code is needed to complete this step.  I check this by Pressing Control-G and I see your VBA code.  This step will take information in this forma and extract it and then populate a listbox, dropbox, or a drid.

4.  Intgrate the spreadsheet data into the application.  Note, the spreadsheet can contain any special list such as new DVDs, or updated notes.

5.  Write a code to update (your inventory table, can be CD List or DVD list) from the list.  Note, the best way to do this is delete the currect records then insert the records from the spreadsheet.  Then compare each record if it is new add it to the table.  If it exist update the info from the spreadsheet.  If you do this option INDICATE in the student comments so I know.