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.

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.

Notable Quotes

— 00:00 — « No notable quotes »

Category

Educational

Video