Overview
-
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.
Syllabus
-
Introduction
- Advance your Access skills
- What you should know before watching this course
- Follow along and use the exercise files
- Create a main menu
- Explore the start-up options
- Launch a splash screen
- Create an AutoExec macro
- Hide the ribbon
- 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
- Create 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
