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
()
Ex_Files_Access_2019_Tips.zip
(123.0 MB)