Course Overview

Create a better user experience for your Access users. Transform a boring database into a fast, efficient, and even fun environment.

Course Circullum

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

Adam Wilbert

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: