Create a simple excel spreadsheet with data to update the database. This can hold any type of data to be used in this database.
In MS Access
1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database
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. The spreadsheet should contain new DVDs.
4. Write code to update the inventory DVD table, from the list.
21 freelancers are bidding on average $116 for this job
Hello, I am going to take your words at face value that those are exactly the 4 things you need done, no more no less. I will deliver one Excel spreadsheet and one Access database fulfilling the requirements.
Could you please clarify 'This can hold any type of data to be used in this database', are you saying the spreadsheet columns could change? i.e. Title, Rating, Format etc. wouldn't remain static