中文名: Lynda.com出品深入認識Access 2010的查詢功能視頻教程
英文名: Lynda.com Access 2010 Queries in Depth
資源格式: 光盤鏡像
學校: Lynda.com
主講人: Adam Wilbert
發行日期: 2011年
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

語言：英語
網址：http://www.lynda.com/Access-2010-tutorials/Queries-in-Depth/79412-2.html
類別：教程
（xuehui@TLF）
Lynda.com 出品的時長3小時02分鐘的深入認識Access 2010的查詢功能視頻教程。由Adam Wilbert講述如何建立並最大能力的利用查詢功能把原始數據轉化為可用信息。內容包括建立查詢，執行計算，利用內建的Access功能進一步細化查詢結果，並確認是否最佳運行或基於一標准范圍內需要改善的地方。本教程附帶練習文件。

轉自TLF

目錄:
Introduction
Welcome 01m 10s
Using the exercise files 00m 41s
Introducing the database 04m 29s
Previewing the course 02m 49s
17m 17s
1. Creating Queries in Access
Understanding queries 03m 31s
Following naming conventions and best practices 02m 56s
Using the Query Wizard 05m 21s
Exploring the design interface 05m 29s
26m 39s
2. Creating Simple Select Queries
Defining criteria 05m 40s
Understanding comparison operators 03m 19s
Defining the column headers 02m 49s
Exploring the property sheet 07m 32s
Printing query results 02m 41s
Working with joins 04m 38s
14m 14s
3. Creating Parameter Queries
Understanding parameter queries 04m 27s
Obtaining parameters from forms 05m 17s
Creating a combo box 04m 30s
23m 24s
4. Applying Aggregate Calculations (aka Totals Queries)
Understanding the Totals field 05m 31s
Creating aggregate calculations 03m 31s
Exploring the Expression Builder interface 04m 28s
Using mathematical operators 05m 46s
Applying text functions 04m 08s
24m 23s
5. Working with Dates in Queries
Understanding dates as serial numbers 02m 42s
Specifying a range of dates or times 03m 47s
Formatting dates 04m 31s
Using other Date/Time functions 03m 47s
Defining today's date 02m 41s
Calculating time intervals 06m 55s
20m 09s
6. Understanding Conditional Statements
Introducing the conditional IIf function 02m 57s
Creating an IIf function 07m 31s
Nesting IIf functions 04m 57s
Using the Switch function 04m 44s
20m 41s
7. Linking It All Together
Understanding the reporting tool 02m 13s
Building the form 06m 57s
Building the query 05m 04s
Building the report 03m 30s
Finalizing the reporting tool 02m 57s
25m 37s
8. Alternative Query Types
Finding duplicate records 02m 17s
Identifying unmatched records 02m 29s
Creating crosstab results 02m 57s
Creating backups 01m 29s
Creating update queries 03m 22s
Making, deleting, and appending records 05m 36s
Uniting tables 03m 16s
Embedding SQL code in queries 04m 11s
01m 00s
Conclusion
Next Steps 01m 00s