Access 2021: Tips, Tricks, and Techniques

Create a better user experience for your Access users. Transform a boring database into a fast, efficient, and even fun environment.

Introduction

• Advance your Access skills
• What you should know
• Following along and using the exercise files

1. Create a Startup Experience

• Create a main menu
• Explore the startup options
• Launch a splash screen
• Create an AutoExec macro
• Hide the ribbon

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
• Create 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 helpful tooltip 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