Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2016: Advanced Tips and Tricks

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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
1. Create a Startup Experience
  • Explore startup options
  • Launch a splash screen
  • Create an AutoExec macro
  • Hide the Ribbon
  • Create a kiosk experience
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
  • Link to a password-protected back end
  • Creating 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 Your 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
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.8 rating at LinkedIn Learning based on 35 ratings

Start your review of Access 2016: Advanced Tips and Tricks

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.