Lynda.com - Access 2010: Queries in Depth | 267 MB
Duration: 3h 02m | Video: AVC (.mov) 960x540 15fps 150Kbps | Audio: AAC 48KHz 96Kbps 1ch
Genre: eLearning | Language: English
Duration: 3h 02m | Video: AVC (.mov) 960x540 15fps 150Kbps | Audio: AAC 48KHz 96Kbps 1ch
Genre: eLearning | Language: English
In Access 2010: Queries in Depth, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria. Exercise files are included with the course.
Topics include:
* Naming conventions and best practices
* Working with joins
* Using comparison operators
* Defining criteria for select queries
* Creating parameter queries
* Creating calculated fields
* Working with dates and times
* Using the Expression Builder
* Creating conditional statements
* Making, deleting and appending records
* Building reports
No mirrors below please.