Access 2016: Advanced Tips and Tricks

Download Now

These tips and techniques will help Access developers create a better user experience and transform a boring database into a fast, efficient, and even fun environment. Access expert Adam Wilbert shows how to remove typical Access interface elements (like the Welcome screen) for a better startup experience, and borrow some tricks from web design to make your database more attractive and interactive. Plus, learn how to clean up a cluttered navigation pane, leverage hidden system objects, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for.

Topics include:

• 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