MS Access - Queries Part 3: LIKE and NULL in queries

There are times when you want to search for values that form a part of the field value, for example all the records where this field starts with a something or ends with a something, etc). Sometimes you want to find the records where a field has been filled in or when it's been left out. We use the LIKE and NULL for these queries.

Microsoft Access Queries Video Series
Part 1 Basic queries - MS Access - Queries Part 1: Basic que...
Part 2 BETWEEN and IN in queries - MS Access - Queries Part 2: BETWEEN a...
Part 3 LIKE and NULL in queries - MS Access - Queries Part 3: LIKE and ...
Part 4 Separate queries - MS Access - Queries Part 4: Separate ...
Part 5 Grouping in queries - MS Access - Queries Part 5: Grouping ...
Part 6 Calculated Fields in queries - MS Access - Queries Part 6: Calculate...
Part 7 More Examples of Calculated Fields - MS Access - Queries Part 7: More Exam...

#MrLongEducation #Access #Query

• #education
• #mister_long
• #mr_long
• #mister_long_education
• #cat
• #computer_application_technology
• #grade_12
• #grade_11
• #microsoft
• #access
• #ms_access
• #computers
• #database
• #databases
• #db
• #tables
• #caps
• #queries
• #query
• #like
• #null
• #is_null
• #is_not_null
• #wildcard
• #wildcards
• #star
• #starts_with
• #ends_with
• #has_in_it