Access 2021: Tips, Tricks, and Techniques

2h 50mAdvanced2022-03-01

Authors

Adam Wilbert

Data Visualization Expert

Course details

This course provides tips and techniques to help Access developers create a better user experience and transform it 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, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for.

Skills covered

Microsoft AccessDesktop DatabasesMicrosoft OfficeTips, Tricks, & TechniquesOffice 365Business Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Advance your Access skills
02 - What you should know
03 - Following along and using the exercise files

1. Create a Startup Experience

04 - Create a main menu
05 - Explore the startup options
06 - Launch a splash screen
07 - Create an AutoExec macro
08 - Hide the ribbon

2. Work with Hidden Objects

09 - Embed queries in reports
10 - Hide tables and other objects
11 - Access the system tables
12 - Query a list of database objects

3. Split a Database

13 - Create a back end
14 - Password-protect a back end
15 - Link to a password-protected back end
16 - Create customized front ends

4. Create Cascading Combo Boxes

17 - Build the combo boxes
18 - Cascade the results

5. Create a Dynamic Reporting Tool

19 - Understand how the reporting tool works
20 - Build the form
21 - Build the query
22 - Build the report
23 - Finalize the reporting tool

6. Aid Your End Users

24 - Add customized shortcut keys
25 - Create helpful tooltip messages
26 - Provide task-specific help dialog boxes
27 - Leverage split forms
28 - Add edit buttons to tabular data

7. Write Custom Functions in Visual Basic

29 - VBA function basics
30 - Use custom functions in queries
31 - Create a Select Case function

8. Distribute Your Application

32 - Install the free Access Runtime
33 - Package your application

Conclusion

34 - Next steps