Lynda com Access 2007 Queries in Depth 英文正式版(教學)





軟體簡介:



LyndacomAccess2007QueriesinDepth英文正式版(教學)









InAccess2007:QueriesinDepth,authorAdamWilbertillustrates
howtocreateandleveragereal-worldqueriesandturnrawdata
intousableinformation.Thecoursecoverssettingupqueries,
performingcalculations,usingthebuilt-inAccessfunctionsto
furtherrefinequeryresults,andidentifyingtopperformersor
areasforimprovementbasedonarangeofcriteria.Exercisefiles
areincludedwiththecourse.

Topicsinclude:

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