Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

MS Access assignment PAPER

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.

Write a code to update (your inventory table, can be CD list or DVD list) from the list.

- 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.

Show more
Elite2
Elite2
  • @
  • 331 orders completed
ANSWER

Tutor has posted answer for $25.00. See answer's preview

$25.00

****** * ****** ***** spreadsheet **** **** ** ****** the ********* ****** a **** ******************** ** **** the spreadsheet ** * ***** ** *** ******** **** *** **** the *********** ******** using *** wizard *** *** **** lose * ******** ****** a form (frmUpdateMedia) write a VBA **** ** ******* *** data *** display ** ** * ******* dropdownbox ** *** from ********

Click here to download attached files: WEEK7.zip
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question