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.
EUR 10,72 per la spedizione da Regno Unito a Italia
Destinazione, tempi e costiEUR 6,90 per la spedizione da Regno Unito a Italia
Destinazione, tempi e costiDa: 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: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.15. Codice articolo G0470567015I3N00
Quantità: 1 disponibili
Da: ThriftBooks-Atlanta, AUSTELL, GA, 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: 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: Ammareal, Morangis, Francia
Softcover. Condizione: Très bon. Petite(s) trace(s) de pliure sur la couverture. Edition 2010. Ammareal reverse jusqu'à 15% du prix net de cet article à des organisations caritatives. ENGLISH DESCRIPTION Book Condition: Used, Very good. Slightly creased cover. Edition 2010. Ammareal gives back up to 15% of this item's net price to charity organizations. Codice articolo D-587-119
Quantità: 1 disponibili
Da: 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à: 6 disponibili
Da: PBShop.store UK, Fairford, GLOS, Regno Unito
PAP. Condizione: New. New Book. Shipped from UK. Established seller since 2000. Codice articolo FW-9780470567012
Quantità: 15 disponibili