Lynda.com Access 2010 Queries in Depth Lynda.com出品深入認識Access 2010的查詢功能視頻教程 英文版

商品編號：Xjc0662
本站售價：NT$80
碟片片數：1

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱: Lynda.com Access 2010 Queries in Depth
語系版本: 英文版
光碟片數: 單片裝
保護種類: 無
破解說明: 無
系統支援: Windows XP/Vista /7
硬體需求: PC
軟體類型: 視頻教學
更新日期: 2011.07.01
軟體發行: Lynda.com
官方網站: http://www.lynda.com/Access-2010-tutorials/Queries-in-Depth/79412-2.html
中文網站: 無
軟體簡介: (以官方網站為準)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

主講人: Adam Wilbert.
Lynda.com 出品的時長3小時02分鐘的深入認識Access 2010的查詢功能視頻教程。
由Adam Wilbert講述如何建立並最大能力的利用查詢功能把原始資料轉化為可用信
息。內容包括建立查詢，執行計算，利用內建的Access功能進一步細化查詢結果，
並確認是否最佳運行或基於一標準範圍內需要改善的地方。本教程附帶練習文件。

目錄:

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=