Summary of "11 More about queries"

Main Ideas and Concepts:

AND Search
- To find records that meet multiple criteria simultaneously.
- Example: Searching for people with the surname "Smith" who live in "Sydney".
- The query design includes conditions LIKE surname = 'Smith' AND suburb = 'Sydney'.
OR Search
- To find records that meet at least one of multiple criteria.
- Example: Searching for people with the surname "Smith" or those living in "Saint Mary's".
- The query design includes conditions LIKE surname = 'Smith' OR suburb = 'Saint Mary’s'.
Active Queries
- Queries that prompt the user for input to search dynamically.
- Example: A query that asks for a surname or suburb to filter results.
- The design includes prompts LIKE Please enter surname and Please enter suburb.
Handling Null Responses
- Understanding that a null response indicates no matching records, which is a valid outcome.
Using Wildcards
- Implementing wildcards to search for partial matches in surnames.
- Example: Using the LIKE operator with wildcards to search for names LIKE "Smith" or "Smythe".
- The syntax involves LIKE '*[input]*' to allow for flexible searching.
Naming Conventions
- Emphasizing the importance of saving queries, tables, and forms with relevant and intuitive names for easy identification later.

Creating an AND Search:
- Open query design.
- Select fields: Title, First Name, Last Name, Suburb, Email.
- Set criteria: surname = 'Smith' and suburb = 'Sydney'.
- Run and save the query with a relevant name.
Creating an OR Search:
- Open query design.
- Select fields: Title, First Name, Last Name, Suburb, Email.
- Set criteria on separate lines: surname = 'Smith' OR suburb = 'Saint Mary’s'.
- Run and save the query with a relevant name.
Creating an Active Query:
- Open query design.
- Select fields: Title, First Name, Last Name, Suburb, Email.
- Set prompts for input: Please enter surname and Please enter suburb.
- Save the query with a relevant name.
Creating a Partial Match Query:
- Open query design.
- Select fields: Title, First Name, Last Name, Suburb, Email.
- Use the syntax: LIKE '*[input]*' for surname searches.
- Save the query with a relevant name.

The video appears to feature a single speaker who provides instructions and examples throughout the presentation. The speaker's name is not mentioned in the subtitles.