Provides information on the features and functions of Microsoft Access, covering such topics as normalizing and storing Excel data in a structured relational database, using Excel pivot tables with Access data, using Access to analyze large amounts of data, and getting external data with SQL, ADO, and XML.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Michael Alexander is a Microsoft MVP and a veteran consultant. He creates and shares video tutorials with the Microsoft Excel and Access communities via www.datapigtechnologies.com. Mike has written several books on advanced business analysis, including Microsoft Access 2007 Data Analysis, also from Wiley.
Use the right tool for the job
Like many managers, accountants, and analysts, you've been usingExcel for data analysis. It's a good tool, but you're beginning tofind its limitations frustrating. You're looking for morescalability. More transparency of analytical processes. The abilityto separate data from presentation.
Access makes it all possible, and this guide helps you addAccess to your analytical toolbox. Learn the essentials of usingAccess, basic and advanced analysis techniques, how to buildreports, and much more. Then you can choose the right tool forevery job.
Easily move data between Excel and Access
Normalize and store Excel data in a structured relationaldatabase
Use Access to analyze large amounts of data
Use Excel pivot tables with Access data
Build reports and implement dashboard-style visualizations
Report Access data using Excel's presentation layer
Automate redundant reporting and analysis using Excel and Accessmacros
Save time and increase productivity by automating redundantprocesses using VBA
Get external data using SQL, ADO, and XML
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
GRATIS per la spedizione in U.S.A.
Destinazione, tempi e costiEUR 3,43 per la spedizione in U.S.A.
Destinazione, tempi e costiDa: Better World Books, Mishawaka, IN, U.S.A.
Condizione: Good. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Codice articolo 10742900-6
Quantità: 1 disponibili
Da: SecondSale, Montgomery, IL, U.S.A.
Condizione: Acceptable. Item in acceptable condition including possible liquid damage. As well, answers may be filled in. Lastly, may be missing components, e.g. missing DVDs, CDs, Access Code, etc. Codice articolo 00029798268
Quantità: 1 disponibili
Da: SecondSale, Montgomery, IL, U.S.A.
Condizione: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00066663610
Quantità: 5 disponibili
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condizione: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.15. Codice articolo G0470567015I4N00
Quantità: 1 disponibili
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Paperback. Condizione: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Codice articolo GOR005823516
Quantità: 1 disponibili
Da: AwesomeBooks, Wallingford, Regno Unito
Paperback. Condizione: Very Good. The Excel Analyst's Guide to Access This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Codice articolo 7719-9780470567012
Quantità: 1 disponibili
Da: Reuseabook, Gloucester, GLOS, Regno Unito
Paperback. Condizione: Used; Very Good. Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine. Codice articolo CHL10501166
Quantità: 1 disponibili
Da: One Planet Books, Columbia, MO, U.S.A.
paperback. Condizione: Like New. 1st Edition. Ships in a BOX from Central Missouri! Like Brand NEW. No tears, highlighting or writing because it's never been used! May have minor shelf wear. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Codice articolo 001112322N
Quantità: 3 disponibili
Da: Bahamut Media, Reading, Regno Unito
Paperback. Condizione: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Codice articolo 6545-9780470567012
Quantità: 1 disponibili
Da: TextbookRush, Grandview Heights, OH, U.S.A.
Condizione: Like New. Codice articolo 47744707
Quantità: 1 disponibili