This course is all about providing those enhancements and final bits of polish that will take a database to the next level in professional development. In order to get the most out of this course, some familiarity with Access is required, including how to work with Table, Forms, Queries, and Report objects.
- [Voiceover] This course is all about providing those enhancements and final bits of polish that will take your database to the next level in professional development. To that end, I need to assume that you'll have some familiarity with how an Access database functions and what the various objects within the database are. We're going to be using buttons and macros to control navigation and dig into the property sheets of various forms and query designers to fine-tune their operation. If you're brand-new to Access database development, then this probably isn't the best course to start with. However, if you've already built a basic Access database, or have taken my Access 2016 Essential Training course, then you'll have everything you need to hit the ground running here.
Author
Released
7/20/2016- Creating an AutoExec macro
- Creating a kiosk experience
- Working with hidden objects: queries, tables, and more
- Splitting a database into back and front ends
- Creating a dynamic reporting tool
- Adding shortcuts and other aids to end users
- Writing custom VBA functions
- Packaging and distributing your Access application
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2016 Essential Training
with Adam Wilbert6h 45m Beginner -
Access 2016: Queries
with Adam Wilbert4h 10m Intermediate -
Access 2016: Forms and Reports
with Adam Wilbert4h 59m Intermediate
-
Introduction
-
Welcome57s
-
-
1. Create a Startup Experience
-
Explore startup options7m 4s
-
Launch a splash screen7m 8s
-
Hide the Ribbon5m 28s
-
Create a kiosk experience6m 14s
-
-
2. Work with Hidden Objects
-
Embed queries in reports4m 40s
-
Access the system tables4m 6s
-
-
3. Split a Database
-
Create a back end4m 11s
-
-
4. Create Cascading Combo Boxes
-
Build the combo boxes7m 47s
-
Cascade the results5m 15s
-
-
5. Create a Dynamic Reporting Tool
-
Build the form8m 37s
-
Build the query8m 6s
-
Build the report7m 18s
-
Finalize the reporting tool5m 12s
-
6. Aid Your End Users
-
Add customized shortcut keys4m 50s
-
Leverage split forms6m 30s
-
-
7. Write Custom Functions in Visual Basic
-
VBA function basics6m 9s
-
-
8. Distribute Your Application
-
Package your application3m 31s
-
Conclusion
-
Next steps38s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: What you should know before watching this course