Lynda.com Access 2010 Queries in Depth 英文版 CD

InAccess2010:QueriesinDepth,authorAdamWilbertillustrateshowtocreateandleveragereal-worldqueriesandturnrawdataintousableinformation.Thecoursecoverssettingupqueries,performingcalculations,usingthebuilt-inAccessfunctionstofurtherrefinequeryresults,andidentifyingtopperformersorareasforimprovementbasedonarangeofcriteria.Exercisefileareincludedwiththecourse.

Topicsinclude:
Namingconventionsandbestpractices
Workingwithjoins
Usingcomparisonoperators
Definingcriteriaforselectqueries
Creatingparameterqueries
Creatingcalculatedfields
Workingwithdatesandtimes
UsingtheExpressionBuilder
Creatingconditionalstatements
Making,deletingandappendingrecords