Join Adam Wilbert for an in-depth discussion in this video Creating a Select...Case function, part of Access 2013: Tips & Tricks.
…The age function and the square meter function…that we just created involve some fairly simple calculations.…But you're not limited to just these types of conversion calculations.…Functions can actually leverage lots of the more…traditional programming constructs that area available in Visual Basic.…Let's write out a slightly more complex function that will be…difficult to construct with the tools…available in the Access Expression Builder.…In this example I want to calculate our employee bonuses…based off of the current salary and job ratings.…If we open up our employees table we'll see that we have a salary column…here lists the current salary, and we also have a column for their job ratings here.…
I want to use both of these columns to calculate their annual bonus.…Let's create a custom function that'll help us out with this.…I'm going to go ahead and close the employees' table…and we'll go down into the module my functions.…I'll right click on it and choose to open it in Design View.…That'll open up my function code in Visual Basic.…
- 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.