->
Lynda - Access 2013: Queries - 166511
Lynda - Access 2013: Queries
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.


Table of Contents

  • Introduction
  • 1. Creating Queries in Access
  • 2. Creating Simple Select Queries
  • 3. Creating Parameter Queries
  • 4. Getting Started with Functions
  • 5. Applying Aggregate Calculations
  • 6. Working with Dates in Queries
  • 7. Understanding Program Flow Functions
  • 8. Alternative Query Types
  • 9. Exploring SQL Syntax
  • 10. Useful Query Tricks
  • Conclusion
  • Lynda - Access 2013: Queries


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss