From the course: Access 2021: Tips, Tricks, and Techniques
Join today to access over 24,700 courses taught by industry experts.
Use custom functions in queries
From the course: Access 2021: Tips, Tricks, and Techniques
Use custom functions in queries
- [Instructor] Once your custom public functions have been defined in a visual basic module, such as the My Functions module that we created in the prior movie, you can now use those functions throughout your database. Let's take a look at a couple of examples. I'm going to click on the View Employee Records button. That'll open up our employee form. Now you'll remember that this is a split form that's displaying a tabular view of our employee data table. Right now we have a separate column for first name and last name. Instead of displaying the full name of each employee, I'd rather use our formatted name function in order to display just their last name, comma, first initial. And over here on the right, we have a column for the hire date. This is currently displaying the actual day that each employee was hired. Instead of this detail view of the employee's records, I'd rather just see the number of years that each…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.