The Excel analyst's guide to Access

Alexander, Michael 1972- (Author).

Summary: "Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how"--Resource description page.

Record details

ISBN: 6612685069
ISBN: 9786612685064
ISBN: 9781282685062
ISBN: 1282685066
ISBN: 9781118081808
ISBN: 1118081803
ISBN: 9780470567012
ISBN: 0470567015
ISBN: 0470646543
ISBN: 9780470646540
Physical Description: 1 online resource (xxxiv, 590 pages) : illustrations
remote
Publisher: Indianapolis, IN : Wiley Pub., ©2010.

Content descriptions

Formatted Contents Note:	Getting Help in Access -- Appendix D: Data Analyst's Function Reference -- Abs -- Asc -- Atn -- Choose -- Chr -- Cos -- Date -- DateAdd -- DateDiff -- DatePart -- DateSerial -- DateValue -- Day -- DDB -- Domain Aggregate Functions -- Exp -- FormatCurrency -- FormatDateTime -- FormatNumber -- FormatPercent -- FV -- Hour -- IIf -- InStr -- InStrRev -- IPmt -- IRR -- IsError -- IsNull -- IsNumeric -- LCase -- Left -- Len -- Log -- Mid -- Minute -- MIRR -- Month -- MonthName -- Now -- NPer -- NPV -- NZ -- Partition -- Pmt -- PPmt -- PV -- Rate -- Replace -- Right -- Rnd -- Round -- Second -- Sgn -- Sin -- SLN -- Space -- SQL Aggregate Functions -- Sqr -- Str -- StrConv -- String -- StrReverse -- Switch -- SYD -- Tan -- Time -- TimeSerial -- TimeValue -- Trim, LTrim, RTrim -- TypeName -- UCase -- Val -- VarType -- Weekday -- WeekdayName -- Year -- Index.
Language Note:	English.
Source of Description Note:	Print version record.