Overview
-
Create a better user experience for your Access users. Transform a boring database into a fast, efficient, and even fun environment.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Adding exercise files to a trusted location
- Explore startup options
- Launch a splash screen
- Create an AutoExec macro
- Hide the Ribbon
- Create a kiosk experience
- Embed queries in reports
- Hide tables and other objects
- Access the system tables
- Query a list of database objects
- Create a back end
- Password-protect a back end
- Link to a password-protected back end
- Creating customized front ends
- Build the combo boxes
- Cascade the results
- Understand how the reporting tool works
- Build the form
- Build the query
- Build the report
- Finalize the reporting tool
- Add customized shortcut keys
- Create tooltips and status messages
- Provide task-specific help dialog boxes
- Leverage split forms
- Add edit buttons to tabular data
- VBA function basics
- Use custom functions in queries
- Create a Select Case function
- Install the free Access Runtime
- Package your application
- Next steps
