Access 2013: Queries

  • 4.9
  • 0 Enerolled
    • Introduction
      • Welcome 0 min
      • Using the exercise files 0 min
      • Introducing the database 0 min
    • 1. Creating Queries in Access
      • Understanding queries 0 min
      • Using the Query Wizard 0 min
      • Exploring the design interface 0 min
    • 2. Creating Simple Select Queries
      • Defining criteria 0 min
      • Understanding comparison operators 0 min
      • Renaming the column headers 0 min
      • Exploring the property sheet 0 min
      • Working with joins 0 min
      • Challenge: Find the top ten employees 0 min
      • Solution: Find the top ten employees 0 min
    • 3. Creating Parameter Queries
      • Understanding parameter queries 0 min
      • Obtaining parameters from forms 0 min
      • Creating a combo box 0 min
      • Challenge: Build a query that produces an employee phone list 0 min
      • Solution: Build a query that produces an employee phone list 0 min
    • 4. Getting Started with Functions
      • Exploring the Expression Builder interface 0 min
      • Using mathematical operators 0 min
      • Applying functions to text 0 min
      • Challenge: Convert US dollars to Canadian dollars 0 min
      • Solution: Convert US dollars to Canadian dollars 0 min
    • 5. Applying Aggregate Calculations
      • Creating aggregate calculations 0 min
      • Understanding the Totals field 0 min
      • Understanding the WHERE clause 0 min
    • 6. Working with Dates in Queries
      • Understanding how dates are stored 0 min
      • Specifying a range of dates or times 0 min
      • Using date and time functions 0 min
      • Formatting dates 0 min
      • Sorting formatted dates 0 min
      • Defining today's date 0 min
      • Calculating time intervals 0 min
      • Challenge: Collect information on all orders from 2014 0 min
      • Solution: Collect information on all orders from 2014 0 min
    • 7. Understanding Program Flow Functions
      • Introducing IIf 0 min
      • Creating an IIf function 0 min
      • Using the Switch function 0 min
      • Challenge: Calculate sales prices for a product line 0 min
      • Solution: Calculate sales prices for a product line 0 min
    • 8. Alternative Query Types
      • Finding duplicate records 0 min
      • Identifying unmatched records 0 min
      • Creating crosstab results 0 min
      • Creating backups 0 min
      • Creating update queries 0 min
      • Making, deleting, and appending records 0 min
    • 9. Exploring SQL Syntax
      • Understanding SQL basics 0 min
      • Writing SQL queries 0 min
      • Writing a union query 0 min
      • Embedding SQL code in queries 0 min
    • 10. Useful Query Tricks
      • Using domain functions 0 min
      • Returning values above or below average 0 min
      • Returning random records from the database 0 min
      • Challenge: Find out which products have the highest and lowest markup percentage 0 min
      • Solution: Find out which products have the highest and lowest markup percentage 0 min
    • Conclusion
      • Next steps 0 min
  • Description

    Get more out of your Access database than just the data you put into it, using queries—tools that help you translate complex raw data into information you can use to make better decisions. Join Adam Wilbert, as he explains how to create real-world queries to filter and sort data, perform calculations, and refine query results with built-in functions, all while offering challenges that help you master the material. Find out how to identify top performers, automate repetitive analysis tasks, and increase accuracy and consistency in your database using program flow functions.

Trailer video

Build Responsive Websites

Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

This Course Incluce

4 Hours video
Certificate
56 Lectures
Lifetime access