Access 2016: Queries

Contents

• Introduction Introduction

  • Welcome

    1m 3s
  • Using the exercise files

    30s
  • Trusting the exercise files

    1m 45s
  • Explaining the challenges

    17s
• 1. Introduction to Access Queries 1. Introduction to Access Queries

  • (Locked)
    The H+ Sport database

    5m 39s
  • Understand queries

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

    6m 40s
  • (Locked)
    Modify a query with the design interface

    8m 57s
• 2. Creating Simple Select Queries 2. Creating Simple Select Queries

  • Define query criteria

    8m 35s
  • (Locked)
    Understand comparison operators

    4m 2s
  • (Locked)
    Use wildcards in criteria

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

    3m 11s
  • (Locked)
    Explore the property sheet

    7m 31s
  • (Locked)
    Work with joins

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

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

    3m 15s
• 3. Creating Parameter Queries 3. Creating Parameter Queries

  • Understand parameter queries

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

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

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

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

    6m 1s
• 4. Use the Built-In Functions 4. Use the Built-In Functions

  • Explore the Expression Builder interface

    4m 29s
  • (Locked)
    Use mathematical operators

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

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

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

    2m 37s
• 5. Aggregating Records with a Totals Query 5. Aggregating Records with a Totals Query

  • Summarize data with aggregate functions

    4m 30s
  • (Locked)
    Understand the Totals field

    5m 53s
  • (Locked)
    Use the WHERE clause

    1m 54s
• 6. Working with Dates in Queries 6. Working with Dates in Queries

  • Dates as serial numbers

    4m 52s
  • (Locked)
    Select a range of dates or times

    3m 10s
  • (Locked)
    Date and time functions

    4m 42s
  • (Locked)
    Format dates

    5m 9s
  • (Locked)
    Sort dates chronologically

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

    2m 9s
  • (Locked)
    Calculate elapsed time with DateDiff()

    4m 43s
  • (Locked)
    Calculate time intervals with DateAdd()

    4m
  • (Locked)
    Challenge: Expand order details

    33s
  • (Locked)
    Solution: Expand order details

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

  • (Locked)
    IIf() conditional statement

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

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

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

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

    5m 57s
• 8. Alternative Query Types 8. Alternative Query Types

  • (Locked)
    Find duplicate records

    4m 20s
  • (Locked)
    Identify unmatched records

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

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

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

    5m 46s
  • (Locked)
    Create a backup of the database

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

    4m 41s
  • (Locked)
    Make table, delete, and append queries

    6m 51s
• 9. Writing Queries with Structured Query Language 9. Writing Queries with Structured Query Language

  • (Locked)
    Explore the basics of SQL

    5m 59s
  • (Locked)
    Create a union query to join tables

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

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

  • (Locked)
    Pull random records from the database

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

    4m 8s
  • (Locked)
    Process a column of values with domain functions

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

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

    4m 14s
• Conclusion Conclusion

  • (Locked)
    Next steps

    46s