With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL) and export/import Access data to and from XML both manually and programmatically. The book, which covers the latest release of Access and earlier versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. The text will show you how to write and debug your programming code with the Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a “message box” and reprogram characteristics of a database; query and manipulate your database from a Web browser with Active Server Pages (ASP) and many more practical techniques. Features: Covers in great detail the latest version of Access and all of its features. Includes more than 275 applied examples and 10 projects. Covers Office Web Apps
This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web. Microsoft Excel 2013 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. The chapters are loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed. Features: Explores in great detail the latest version of Excel and all of its features. Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web. Covers Office Web Apps.
As part of the Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Excel programming will also apply to, say, Access programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Excel 2016. Features: * Includes a companion disc with all of the "Hands-On" files needed to complete the chapter projects and all the images from the text * Introduces you to programming Microsoft Excel 2016
Make the most advanced predictive analytical processes easy using Watson Analytics with this easy-to-follow practical guide About This Book This is the first and the only book on IBM Watson Analytics, and it shows you how to leverage Watson in an enterprise environment through rich use cases Incorporate Watson Analytics into your business strategy and confidently add this cutting edge expertise to your resume This book is written by James D Miller, IBM-certified expert and accomplished Director and Sr. Project Leader Who This Book Is For If you want to perform data discovery and analysis and make sense of data you have, this book for you. Data scientists can also use this book to explore a new way to perform data analysis tasks on cloud with ease. This book does not require a programming background. What You Will Learn Study the language of Watson while you discover how easy it is to access and configure Review what a Watson use case is, why it's important, and how to identify one Design Watson Analytical solutions based upon your use cases Understand the basic concepts behind the content analysis cycle and where Watson fits in Explore all the features of Watson, such as Explore, Predict, and Assemble Customize and extend your Watson solutions Use Watson at the Enterprise level Integrate Watson with other toolsets In Detail Today, only a small portion of businesses actually use a real analytical tool as part of routine decision making. IBM Watson Analytics is changing that making the most advanced and predictive analytical techniques understandable and usable for any industry. This book will be the vital tour guide for your trip, starting with what IBM Watson Analytics is. We'll start off with introduction to Watson Analytics and then quickly move on to various use cases under which one can use the different analytics functionalities offered by Watson. During the course of the book, you will learn how to design solutions, and customize and extend Watson analytics. We will conclude by taking Watson Analytics to enterprise and integrating it with other solutions (other IBM solutions and analytics). Now is the time for you to learn IBM Watson to compete in the world. Style and approach Watson provides individuals with the ability to perform sophisticated data discovery and analysis without all of the complexity that usually goes along with it. This book will get you started with Watson analytics and how you can use it in day-to-day data analysis. The book introduces the key concepts and terminology and then uses practical use case examples to reinforce your understanding.