Lynda com Access 2010 Queries in Depth 深入認識Access 2010的查詢功能視頻教學 英文正式版


　


　
軟體簡介:
　
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
Definingtoday'sdate02m41s
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