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


InAccess2007:QueriesinDepth,authorAdamWilbertillustrateshowtocreateandleveragereal-worldqueriesandturnrawdataintousableinformation.Thecoursecoverssettingupqueries,performingcalculations,usingthebuilt-inAccessfunctionstofurtherrefinequeryresults,andidentifyingtopperformersorareasforimprovementbasedonarangeofcriteria.Exercisefilesareincludedwiththecourse.
Topicsinclude:

*Namingconventionsandbestpractices
*Workingwithjoinsandprimarykeys
*Usingcomparisonoperators
*Printingqueryresults
*Creatingparameterqueries
*Creatingcalculatedfields
*UsingtheExpressionBuilder
*Makingconditionalstatements
*Appendingqueries
*Updatingqueries