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

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

目錄:

Introduction
Welcome01m10s
Usingtheexercisefiles00m41s
Introducingthedatabase04m29s
Previewingthecourse02m49s
17m17s
1.CreatingQueriesinAccess
Understandingqueries03m31s
Followingnamingconventionsandbestpractices02m56s
UsingtheQueryWizard05m21s
Exploringthedesigninterface05m29s
26m39s
2.CreatingSimpleSelectQueries
Definingcriteria05m40s
Understandingcomparisonoperators03m19s
Definingthecolumnheaders02m49s
Exploringthepropertysheet07m32s
Printingqueryresults02m41s
Workingwithjoins04m38s
14m14s
3.CreatingParameterQueries
Understandingparameterqueries04m27s
Obtainingparametersfromforms05m17s
Creatingacombobox04m30s
23m24s
4.ApplyingAggregateCalculations(akaTotalsQueries)
UnderstandingtheTotalsfield05m31s
Creatingaggregatecalculations03m31s
ExploringtheExpressionBuilderinterface04m28s
Usingmathematicaloperators05m46s
Applyingtextfunctions04m08s
24m23s
5.WorkingwithDatesinQueries
Understandingdatesasserialnumbers02m42s
Specifyingarangeofdatesortimes03m47s
Formattingdates04m31s
UsingotherDate/Timefunctions03m47s
Definingtodaysdate02m41s
Calculatingtimeintervals06m55s
20m09s
6.UnderstandingConditionalStatements
IntroducingtheconditionalIIffunction02m57s
CreatinganIIffunction07m31s
NestingIIffunctions04m57s
UsingtheSwitchfunction04m44s
20m41s
7.LinkingItAllTogether
Understandingthereportingtool02m13s
Buildingtheform06m57s
Buildingthequery05m04s
Buildingthereport03m30s
Finalizingthereportingtool02m57s
25m37s
8.AlternativeQueryTypes
Findingduplicaterecords02m17s
Identifyingunmatchedrecords02m29s
Creatingcrosstabresults02m57s
Creatingbackups01m29s
Creatingupdatequeries03m22s
Making,deleting,andappendingrecords05m36s
Unitingtables03m16s
EmbeddingSQLcodeinqueries04m11s
01m00s
Conclusion
NextSteps01m00s

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