Summary of "11 More about queries"
Main Ideas and Concepts:
- AND Search
- 
        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 surnameandPlease enter suburb.
 
- 
        Handling Null Responses
        - Understanding that a null response indicates no matching records, which is a valid outcome.
 
- Using Wildcards
- 
        Naming Conventions
        - Emphasizing the importance of saving queries, tables, and forms with relevant and intuitive names for easy identification later.
 
Methodology and Instructions:
- Creating an AND Search:
- Creating an OR Search:
        - Open query design.
- Select fields: Title, First Name, Last Name, Suburb, Email.
- Set criteria on separate lines: surname = 'Smith'ORsuburb = '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 surnameandPlease 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.
 
Speakers/Sources:
- 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.
Category
Educational