Homework 11

Data Management at SmallBank

The previous homework focused on retrieving information. This homework focuses on deleting, updating and inserting new information in a table in an enterprise (i.e., remote) database.  Create an Excel app with an interface that looks like the one in the vLab. The app has 4 buttons:

  • "Load Customer table" loads Customer2 (NOT Customer) from SmallBankDB and shows it in a listobject.
  • "Delete selected row" finds the customer ID in the active row, deletes the record on the database that contains that customer ID, and reloads the Customer2 table
  • "Update Selected Row" finds the customer ID in the active row, updates the corresponding record in the database using the info found on the spreadsheet, and reloads the Customer2 table. NOTE: do not try to change the C_id on the screen. It will not work.
  • "Insert New Row" creates a new record on the database using the info found on the spreadsheet, and reloads the Customer2 table.

Notes

Customer2 is shared across many students. If you are testing your app at the same time as somebody else, you might see rows disappear and reappear seemingly randomly, as a result of the other students' activities.

Please add at least as many records than you delete, so that others can also test the table. If you accidentally delete the whole table, email me asap, so I can restore it.