->

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


  • 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


 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