Relational Databases with MS Access

Relational Databases with MS Access

1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run

Check before you submit. Get Turnitin Score Report in 15 Minutes.

Don't risk the 'Red' score. Get the exact same Turnitin report your professor uses. Join 50,000+ students who submitted their essays with confidence this semester.

Get Turnitin Score Report Request Human Rewrite

2) Your code (for the button) will dynamically read the caption from the table and assign it to the button

HINT: Variables (table name) in other areas of the code should not be “hard-coded”. If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change – the caption on the button for that table must change as well. Test it out …

3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.

I wrote database and table stumped after that……below are my professors remarks what i need done

When I change an entry in the MainMenu table, I should see that change in the buttons, I do not. Please update and I will update the points…

Attachments: