Access keeps track of everything that happens in your database through a collection of hidden system tables. The MSysObjects table specifically presents an opportunity to work with the database objects in a new way. In this movie, Adam explores the contents of the hidden system tables to see how they can be leveraged in the database.
- [Voiceover] Access keeps track of everything…that happens in your database…through a collection of hidden system tables.…Usually these are kept far out of reach,…but it's interesting to know that they exist…and see how things work under the hood.…Before we do, however, a word of caution.…Messing about with the system tables can be dangerous.…And at no point should you attempt…to modify anything in them.…If any changes are made to a system table…it can corrupt the entire database.…Now with that said, we can reveal the system tables…by right clicking in the navigation pane over here…and choosing Navigation Options…and then turning on these two check boxes.…
Show Hidden Objects and Show System Objects.…When I say OK, you'll notice that our navigation pane grows…and we see lots of new hidden system tables…that all start with the prefix MSys.…We can work with these hidden system tables…just like any other table of the database…by double clicking on it to see the information.…Let's double click on MSysAccessStorage.…
Author
Adam Wilbert
Released
7/20/2016- Creating an AutoExec macro
- Creating a kiosk experience
- Working with hidden objects: queries, tables, and more
- Splitting a database into back and front ends
- Creating a dynamic reporting tool
- Adding shortcuts and other aids to end users
- Writing custom VBA functions
- Packaging and distributing your Access application
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Create a Startup Experience
-
Explore startup options7m 4s
-
Launch a splash screen7m 8s
-
Hide the Ribbon5m 28s
-
Create a kiosk experience6m 14s
-
-
2. Work with Hidden Objects
-
Embed queries in reports4m 40s
-
Access the system tables4m 6s
-
-
3. Split a Database
-
Create a back end4m 11s
-
-
4. Create Cascading Combo Boxes
-
Build the combo boxes7m 47s
-
Cascade the results5m 15s
-
-
5. Create a Dynamic Reporting Tool
-
Build the form8m 37s
-
Build the query8m 6s
-
Build the report7m 18s
-
Finalize the reporting tool5m 12s
-
6. Aid Your End Users
-
Add customized shortcut keys4m 50s
-
Leverage split forms6m 30s
-
-
7. Write Custom Functions in Visual Basic
-
VBA function basics6m 9s
-
-
8. Distribute Your Application
-
Package your application3m 31s
-
Conclusion
-
Next steps38s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Access the system tables