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
User Experience for the WebOpen2Study Intro to the Design of Everyday Things
Udacity UX-Design for Business
Fraunhofer IESE via Independent UX Design for Mobile Developers
Google via Udacity SAP's UX Strategy in a Nutshell by Sam Yen
SAP Learning