Conditional Statements allow for the creation of automated decision making process. In this movie, Adam provides an outline of how Access uses the IIF() function to create a basic If-Then statement. The function requires an expression to evaluate, and then returns one element if the expression is true, and another if the expression is false.
- [Voiceover] In this chapter, we're gonna take a look at…creating a new function called a conditional statement.…Conditional statements are one of my favorite features…of access queries.…The allow you to create an automated…decision-making process.…They're very flexible and powerful…and you can automate some complex tasks…in a short amount of time.…Essentially a conditional is an if, then statement.…In Access, we'll use the function called IIF.…The IIF function has a specific syntax…that must be followed.…It has three required arguments.…The expression to evaluate,…the piece to return if true…and the piece to return if false.…
And if you're wondering,…no that isn't a typo,…there are two I's in this function's name.…The first I stands for inline…so sometimes you might hear this…referred to as the Inline IF function.…The first argument of IIF is the expression.…Here we can use any mathematical expression…that evaluates to true of false.…Usually this will involve…the mathematical expressions…or text expressions that we've learned…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- 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.