Join Adam Wilbert for an in-depth discussion in this video Using custom functions in the database, part of Access 2013: Tips & Tricks.
…Once your custom public functions have been defined…in a visual basic module, such as the my…functions module we created in the last movie,…you can make use of them throughout your database.…Let's take a look at a couple of examples.…First, let's make use of that age function that we defined.…To do that I'm going to go ahead and create a new query.…I'll go to the Create tab and choose Query Design.…I'm going to choose to pull out some information from my Employees table.…So I'll select that from the Show Table window, and say…Add, and then close to get rid of the Show Table window.…Now, here we can use our age function to…determine how long each employee has been with the company.…
For instance, we have this hire date here, and technically we're not calculating…their age, we're calculation the number of years that they've been with the company.…So let's go ahead and create a query that displays this.…First I'll add my first and and last name of each of my employees.…Then I'll add in the hire date.…In the fourth column, I'm going to right-click and…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- 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.Cancel
Take 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.