Access 2016: Advanced Tips and Tricks

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files
• Adding exercise files to a trusted location

1. Create a Startup Experience

• Explore startup options
• Launch a splash screen
• Create an AutoExec macro
• Hide the Ribbon
• Create a kiosk experience

2. Work with Hidden Objects

• Embed queries in reports
• Hide tables and other objects
• Access the system tables
• Query a list of database objects

3. Split a Database

• Create a back end
• Password-protect a back end
• Link to a password-protected back end
• Creating customized front ends

4. Create Cascading Combo Boxes

• Build the combo boxes
• Cascade the results

5. Create a Dynamic Reporting Tool

• Understand how the reporting tool works
• Build the form
• Build the query
• Build the report
• Finalize the reporting tool

6. Aid Your End Users

• Add customized shortcut keys
• Create tooltips and status messages
• Provide task-specific help dialog boxes
• Leverage split forms
• Add edit buttons to tabular data

7. Write Custom Functions in Visual Basic

• VBA function basics
• Use custom functions in queries
• Create a Select Case function

8. Distribute Your Application

• Install the free Access Runtime
• Package your application

Conclusion

• Next steps