Access 2019: Tips, Tricks, and Techniques

Course 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.

Course Circullum

Introduction

Advance your Access skills
What you should know before watching this course
Follow along and use the exercise files

1. Create a Start-Up Experience

Create a main menu
Explore the start-up options
Launch a splash screen
Create an AutoExec macro
Hide the ribbon

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
Create 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 the 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: