Join Adam Wilbert for an in-depth discussion in this video Understanding comparison operators, part of Access 2010: Queries in Depth.
- View Offline
- Exercise Files
When the fields in your tables are of a numerical datatype, Access provides…additional operators that you can use when writing your queries.…One type is called Comparison operators and they sort and qualify data based on…the numerical value of the record.…Comparison operators are also called relational operators and they don't simply…match an exact value or pattern like we saw with the Like operator.…Comparison operators return records that match the relationship to a value.…For example, whether it's greater than the value you specify or less than or equal to.…
Let's build a query that takes a look at this.…Once again we're going to go the Create tab and Query Design.…This time we need some numerical values.…So let's take a look at our Products table.…I'll double-click on Products to add it to the Query Design View.…Go ahead and close the Show Table window and we'll expand this open so we can…see all of the fields.…Let's go ahead and build our query.…We'll double-click on ProductName, Ounces to get the size, and Price to get the price.…
- Naming conventions and best practices
- Working with joins
- Using comparison operators
- Defining criteria for select queries
- Creating parameter queries
- Creating calculated fields
- Working with dates and times
- Using the Expression Builder
- Creating conditional statements
- Making, deleting and appending records
- Building reports
Skill Level Intermediate
Access 2010 Power Shortcutswith Alicia Katz Pollock3h 43m Intermediate
1. Creating Queries in Access
2. Creating Simple Select Queries
3. Creating Parameter Queries
Creating a combo box4m 30s
4. Applying Aggregate Calculations (aka Totals Queries)
5. Working with Dates in Queries
6. Understanding Conditional Statements
7. Linking It All Together
8. Alternative Query Types
- 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.