Video summary

11 More about queries

Main summary

Key takeaways

Educational

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.

Methodology and Instructions:

  • 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.

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.

Original video