- Paperback: 552 pages
- Publisher: Wiley; 1 edition (January 4, 2006)
- Language: English
- ISBN-10: 076459978X
- ISBN-13: 978-0764599781
- Product Dimensions: 7.4 x 1.2 x 9.2 inches
- Shipping Weight: 1.6 pounds (View shipping rates and policies)
- Average Customer Review: 24 customer reviews
- Amazon Best Sellers Rank: #1,161,336 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft Access Data Analysis: Unleashing the Analytical Power of Access 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Customers who viewed this item also viewed
Customers who bought this item also bought
From the Back Cover
- Go beyond Excel® with Access's more powerful analysis capabilities
- Get better visibility into your data with custom views
- Scale up your data pool without limitation
- Master the four fundamentals of data analysis
- Discover shortcuts with the helpful Input Mask Wizard
- Integrate your data with the web and enterprise data sources
- Avoid the common pitfalls of data crunching
- Harness VBA to improve data analysis
- Leverage information from the field with real-world scenarios
Companion web site
See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.
About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than 13 years experience consulting and developing office solutions. Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parlayed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Plano, TX where he serves as the director of an analytical services department of a $700 million company. In his spare time, he runs a free tutorial site, www.datapig technologies.com, where he shares basic Access and Excel tips with intermediate users.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The IT leader says, "OK, please show me how to build an Access Pivot Table - with parameters. Nothing complex, just a simple example."
You give her blank look. Huh? "OK..a pivot table..yeah..ummm...I think I can do that.." And you fumble and stumble through the process until the Team Leader sighs and says, "OK, we'll skip this. Do you have any questions for me?". And you, blushing with embarrasment, are toast.
Why? Because you forgot about the DATA!
And how to manipulate it. You've been pre-occupied so long with cool tricks to make your db app do neat things, that you forgot that people have to take data from a raw source and present it in a meaningful way.
This great book, from Michael Alexander is NOT another whiz-bang developer book, but an intro to Access for Data Analysts.
Alexander takes you from simple concepts to intermediate areas like pivot tables and sub-queries, etc. to advanced topics like VBA and automation.
Everything from soup to nuts, but, the difference is, doing something really USEFUL, instead of making you wade through complex ODBC setups and the like.
For me, an IT consultant, this book was like a refresher, taking me down familiar paths and concepts but reminding me that it's the DATA in the end that really counts here.
If you are a DA who works with Costpoint, etc. you'll really appreciate this book, because it gives you an alternative to working with those blasted limited Excel sheets when your manager finally realizes that Excel isn't cutting it for archiving your growing sheets.
I was extremely suprised at the way this book was composed with smart but simple step by step examples. The first few chapters saved me a ton of time after I learned many built-in functions for cleaning up data. The collection of functions in the appendix are a gold mine since these help you create expressions and also teach you by defining their meaning and use. After reading this book about a month ago I have been using Excel less and less to do my number crunching and reporting. I was a slave to the updating of cells, links,formulas and cleaning data that was given to me every week, month, and quarters. Now I just imported all my data to Access where I can analyze more data ,better and alot quicker than that other program.... I forget what that was, Oh yeah Excel.
You HAVE to get this book in your Access library if you do any work with data analysis and number crunching for financials or statistics. For all of you in any IT field like me that get told to "whip up" a program to crunch some statistics or financials.... this book will be the one to save your butt, it did it for me.
All the tips and tricks that the author mentions throughout the book take your Access skills to a whole new level.
Once you have finished reading this book you won't look at Access the same way.
LOVE LOVE LOVE it!