Join Adam Wilbert for an in-depth discussion in this video Hiding tables and other objects, part of Access 2013: Tips & Tricks.
…We've cleaned up our Navigation pane a bit by embedding objects wherever possible.…That might still leave a few objects that are necessary to the functionality…of the database, but that we don't want our end users getting to.…For instance, since it's often advisable to get people out…of the underlying data tables in your database and only…allow them to view the information through a form or…report that controls what they can do with those records.…We can get some degree of protection by hiding the…objects that they definitely don't need to have access to.…Now, there's two ways of hiding objects from a Navigation pane.…I'm going to go over to the Customers table and right-click on it and…choose Hide in this Group and you'll…see that it disappears from the Navigation pane.…
The next one, the Employees table, I'm going to…right-click on that and go down to Table Properties.…In the Table Properties we have this check box here that says Hidden.…I'll go ahead and check that on.…Choose Apply and then OK.…Now I've hidden both of those tables from my Navigation page.…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.