From the course: Access 2016: Advanced Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Query a list of database objects
From the course: Access 2016: Advanced Tips and Tricks
Query a list of database objects
- [Voiceover] The MsysObject system table presents us with an opportunity to get a dynamic listing of all of the objects within our database. By making use of some creative query criteria and the type field that we explored in the last movie, we can use this normally hidden table to help end users navigate the database. Let me show you how we can create a dynamic Combo Box that instantly allows any report to be run from our menu system as soon as they're added into the database. On our Main Menu form here, we currently have a single button that says, "View Report". And this is gonna view the orders by State report, but previously we also added in a new report here called "Customer Lifetime Sales". In order to add this into our Main Menu, we'd have to create a new button. Let's change this up by creating a drop-down list that'll list out the different reports that occur inside the database. To do this, I'll take my Main Menu into Design View. Let's right-click on the tab up here and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.