Access 2016: Advanced Tips and Tricks
Offered By: LinkedIn Learning
Course Description
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
Taught by
Adam Wilbert
Related Courses
Diseño de sistemas de información gerencial para intranet con Microsoft AccessUniversidad del Rosario via edX Competencias digitales de ofimática: Microsoft Access
Universitat Autònoma de Barcelona (Autonomous University of Barcelona) via Coursera Diseño de software para la toma de decisiones organizacionales
Universidad del Rosario via edX Excel to Access: Intro to Microsoft Access for Excel Users
Udemy Access 2007: Shortcuts
LinkedIn Learning