Lynda - Access 2013: Queries in Depth
Lynda - Access 2013: Queries in Depth | 642MB
Duration: 4h 24m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Duration: 4h 24m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.
* Defining criteria
* Understanding comparison operators
* Using joins
* Creating parameter queries
* Using Expression Builder to work with functions
* Working with dates and times
* Creating conditional statements
* Finding duplicate records
* Creating backups
* Making, deleting, and appending records
* Understanding SQL basics and writing SQL queries
* Useful query tricks
* Understanding comparison operators
* Using joins
* Creating parameter queries
* Using Expression Builder to work with functions
* Working with dates and times
* Creating conditional statements
* Finding duplicate records
* Creating backups
* Making, deleting, and appending records
* Understanding SQL basics and writing SQL queries
* Useful query tricks
Lynda - Access 2013: Queries in Depth
No mirrors below please.