Access 2019: Tips, Tricks, and Techniques

Learn how to design better databases using Access 2019. Pick up tips and techniques that can help you transform a boring database into a fast, efficient, and even fun environment.

Introduction

• Advance your Access skills
• What you should know before watching this course
• Follow along and use the exercise files

1. Create a Start-Up Experience

• Create a main menu
• Explore the start-up 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
• 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 the 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