Access 2019: Queries

Contents

• Introduction Introduction

  • Do more with Access queries

    1m 6s
  • Follow along with the exercise files

    1m 24s
• 1. Introduction to Access Queries 1. Introduction to Access Queries

  • (Locked)
    The H+ Sport database

    5m 9s
  • Understand queries

    4m 15s
  • (Locked)
    Create a query with the wizard

    3m 13s
  • (Locked)
    Create a summary query with the wizard

    3m 8s
  • (Locked)
    Build a query in design view

    5m 11s
  • (Locked)
    Modify the query design interface

    3m 17s
• 2. Creating Simple Select Queries 2. Creating Simple Select Queries

  • Define query criteria

    6m 28s
  • (Locked)
    Understand comparison operators

    3m 18s
  • (Locked)
    Use wildcards in criteria

    3m 23s
  • (Locked)
    Rename the column headers

    2m 54s
  • (Locked)
    Explore the property sheet

    6m 23s
  • (Locked)
    Work with joins

    6m
  • (Locked)
    Challenge: Create a select query

    31s
  • (Locked)
    Solution: Create a select query

    2m 42s
• 3. Creating Parameter Queries 3. Creating Parameter Queries

  • Understand parameter queries

    6m 19s
  • (Locked)
    Obtain parameters from forms

    6m 37s
  • (Locked)
    Use a combo box to select criteria

    4m
  • (Locked)
    Challenge: Gather employee emails based on department

    38s
  • (Locked)
    Solution: Gather employee emails based on department

    4m 46s
• 4. Use the Built-In Functions 4. Use the Built-In Functions

  • Explore the Expression Builder interface

    4m 40s
  • (Locked)
    Use mathematical operators

    6m 6s
  • (Locked)
    Apply functions to text

    8m 19s
  • (Locked)
    Challenge: Convert US dollars to Canadian dollars

    27s
  • (Locked)
    Solution: Convert US dollars to Canadian dollars

    3m 24s
• 5. Aggregate Records with a Totals Query 5. Aggregate Records with a Totals Query

  • Summarize data with aggregate functions

    3m 51s
  • (Locked)
    Understand the Totals field

    6m 47s
  • (Locked)
    Using the WHERE clause

    2m 4s
• 6. Working with Dates in Queries 6. Working with Dates in Queries

  • (Locked)
    Dates as serial numbers

    3m 58s
  • (Locked)
    Select a range of dates or times

    3m
  • (Locked)
    Date and time functions

    4m 56s
  • (Locked)
    Format dates

    4m 38s
  • (Locked)
    Sort dates chronologically

    5m 1s
  • (Locked)
    Obtain today's date

    3m 22s
  • (Locked)
    Calculate elapsed time with DateDiff()

    3m 47s
  • (Locked)
    Calculate time intervals with DateAdd()

    4m 4s
  • (Locked)
    Challenge: Expand order details

    34s
  • (Locked)
    Solution: Expand order details

    5m 6s
• 7. Understanding Program Flow Functions 7. Understanding Program Flow Functions

  • (Locked)
    IIf() conditional statement

    2m 20s
  • (Locked)
    Create an IIf() function

    5m 34s
  • (Locked)
    Use the Switch() function

    6m 8s
  • (Locked)
    Challenge: Calculate sales price for a product line

    27s
  • (Locked)
    Solution: Calculate sales price for a product line

    4m 6s
• 8. Alternative Query Types 8. Alternative Query Types

  • (Locked)
    Find duplicate records

    3m 42s
  • (Locked)
    Identify unmatched records

    3m 30s
  • (Locked)
    Create an unmatched records query

    2m 10s
  • (Locked)
    Make a crosstab query

    2m 22s
  • (Locked)
    Add information to a crosstab query

    6m 3s
  • (Locked)
    Create a backup of the database

    1m 48s
  • (Locked)
    Update data with a query

    4m 34s
  • (Locked)
    Make table, delete, and append queries: Part 1

    3m 23s
  • (Locked)
    Make table, delete, and append queries: Part 2

    3m 15s
• 9. Write Queries with Structured Query Language 9. Write Queries with Structured Query Language

  • (Locked)
    Explore the basics of SQL

    6m 14s
  • (Locked)
    Create a union query to join tables

    3m 11s
  • (Locked)
    Nest SQL code in other queries

    4m
• 10. Useful Query Tricks 10. Useful Query Tricks

  • (Locked)
    Pull random records from the database

    2m 38s
  • (Locked)
    Return records above or below average

    3m 43s
  • (Locked)
    Process a column of values with domain functions

    5m 33s
  • (Locked)
    Challenge: Identify the highest and lowest pricing markup

    22s
  • (Locked)
    Solution: Identify the highest and lowest pricing markup

    5m 34s
• Conclusion Conclusion

  • (Locked)
    Next steps

    47s