Beginning PhoneGap

"In 2017, Noon Passama developed a group of jewellery pieces influenced by the idea of a numeral system. The body of work has become the starting point of a collaboration with graphic design and art direction Studio Amanda Haas. The result is a publication titled after the jewellery series: 0123456789. It documents the precise information of each piece which equals a numeric value. The book is a pseudo-scientific archeological undertaking, describing a post-apocalyptic world. In this dusty sandy world, the remaining human beings occasionally encounter objects of wonder. This book contains a science-fictional text written by curator Gabriela Acha and otherworldly images of excavation sites by photographer Christian Hagemann. [...] Studio Amanda Haas [...] created the overall concept, story-line and set design of the photography. The book undertakes an experimental research that, while visually exploring the shapes of numbers and the dynamics they create, it also suggests an alternative understanding of their visual manifestations. Each contributor in this book looked at the particular jewellery series from a personal perspective, keeping in mind the overarching questions of possible origin, belonging and cultural affiliation. The fictional story-line established itself surrounding the following presumptions: What if a past or future tribe of (human) beings had created pieces of jewellery that in themselves are not only beautiful, but might even bear a secret force or knowledge beyond the evident? Could there be a transmission of knowledge long after the existence of such a tribe? And if so, what would this lost knowledge be?"--Provided by the publisher.

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.

Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert.

This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products.

This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.

The companion Web site includes all the sample applications and reports discussed.

What This Book Covers

After discussing self-service BI and the motivation for creating PowerPivot, the book presents a quick, end-to-end tutorial showing how to create and publish a simple PowerPivot application. It then drilsl into the features of PowerPivot for Excel in detail and, in the process, builds a more complex PowerPivot application based on a real-world case study. Finally, it discusses the server side of PowerPivot (PowerPivot for SharePoint) and provides detailed information about its installation and maintenance.

Chapter 1, "Self-Service Business Intelligence and Microsoft PowerPivot," begins Part I of the book. This chapter describes self-service BI and introduces PowerPivot, Microsoft's first self-service BI tool. It provides a high-level look at the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint.

Chapter 2, "A First Look at PowerPivot," walks you through a simple example of creating a PowerPivot application from end to end. In the process, it shows how to set up the two components of PowerPivot, and describes the normal workflow of creating a simple PowerPivot application.

Chapter 3, "Assembling Data," starts off Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces the extended example that you will build in this and subsequent chapters.

Chapter 4, "Enriching Data," shows how to enhance the data you brought into your application by creating relationships and using PowerPivot's expression language, Data Analysis Expressions (DAX).

Chapter 5, "Self-Service Analysis," describes how to use your PowerPivot data with various Excel features, such as PivotTables, PivotCharts, and slicers to do analysis. Chapter 5 also delves further into DAX, showing how to create and use DAX measures.

Chapter 6, "Self-Service Reporting," shows how to publish your PowerPivot workbook to the server side of PowerPivot (PowerPivot for SharePoint), and make use of its features to view and update PowerPivot reports. It also shows how to use the data in a PowerPivot workbook as a data source for reports created in other tools such as Report Builder 3.0 and Excel.

Chapter 7, "Preparing for SharePoint 2010," is the first chapter in Part III of the book. It describes the components of SharePoint 2010 that are relevant for PowerPivot, and looks at how PowerPivot for SharePoint interacts with those components.

Chapter 8, "PowerPivot for SharePoint Setup and Configuration," provides instructions on how to set up and configure a multi-machine SharePoint farm that contains PowerPivot for SharePoint.

Chapter 9, "Troubleshooting, Monitoring, and Securing PowerPivot Services," gives tips on how to troubleshoot PowerPivot for SharePoint issues. It also shows how to monitor the health of your PowerPivot for SharePoint environment, and discusses relevant security issues.

Chapter 10, "Diving into the PowerPivot Architecture," describes at a deeper level the architecture of PowerPivot, both client and server. It also explains the Windows Identity Foundation and discusses the use of Kerberos in the context of PowerPivot for SharePoint.

Chapter 11, "Enterprise Considerations," talks about common PowerPivot for SharePoint enterprise considerations: capacity planning, optimizing the environment, upgrade considerations, and uploading performance.

Appendix A provides instructions for setting up the data sources that are used to build the SDR Healthcare extended example in Chapters 3 through 6.

Additionally, two "bonus" elements are available online at this book's companion Web site:

• Appendix B is a comprehensive DAX reference that describes all the DAX functions and provides code snippets that show how to use them.
• A special chapter describes real-world scenarios in which PowerPivot is used to solve common problems.

Discover how to take advantage of the many new features in SharePoint 2010

SharePoint 2010 is a significant leap forward from the 2007 release, and 'you will find that there are a ton of features built into the platform for you to leverage in your solution development. Because SharePoint is a broad platform that covers a lot, this book also covers quite a bit of ground. As a Wrox Beginning book, the goal of Beginning SharePoint 2010 Development is to get you started with many of the fundamentals so that you can continue on to advanced programming beyond this book.

The book's goal is to quickly take you from the basics of SharePoint, to installing and configuring a development environment, and then into how you can develop for SharePoint. The book is heavy on coding exercises, but tries to stick to a common set of .NET patterns to ensure you walk away with understanding the different ways in which you can code for SharePoint. Moving from beginning to advanced means that you can expect the walkthroughs and chapters to become increasingly more complex within each chapter and throughout the book. The walkthroughs have been created to be concise and to guide you through all of the steps you must accomplish to complete a coding task.

Beginning SharePoint 2010 Development is aimed at the developer who is new to SharePoint. The book assumes you have some programming experience and a passion to learn how to develop for SharePoint. But this book does not assume that you've programmed against SharePoint before. With regard to your general development background, the two assumptions in this book are that you have some familiarity with Web development, and you have an understanding of .NET programming. With regard to Web development, this book assumes that you understand HTML, and may have an understanding of Cascading Style Sheets (CSS), Extensible Markup Language/Extensible Stylesheet Language (XML/XSL), and dynamic languages such as JavaScript. You may have a light understanding of ASP.NET and are looking to apply this knowledge to the SharePoint space. In any case, you have some understanding of the fundamentals of Web and .NET development, and are looking to apply those to the SharePoint space.

Increase your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible. Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook® Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

• Introduction to Microsoft Access 2010
• New Features
• Upgrading and Converting to Access 2010
• Macros in Access 2010
• Using the VBA Editor
• VBA Basics
• Using VBA in Access
• Creating Classes in VBA
• Extending VBA with APIs
• Working with the Windows Registry
• Using DAO to Access Data
• Using ADO to Access Data
• Using SQL with VBA
• Using VBA to Enhance Forms
• Enhancing Reports with VBA
• Customizing the Ribbon
• Customizing the Office Backstage
• Working with Office 2010
• Working with SharePoint
• Working with .NET
• Building Client-Server Applications with Access
• The Access 2010 Templates
• Access Runtime Deployment
• Database Security
• Access 2010 Security Features

Create cross-platform mobile apps without having to learn a new language! PhoneGap is an open source solution, ideal for web developers wanting to build cross-platform mobile apps without having to learn a new language. Using HTML, CSS, and Javascript, PhoneGap allows you to jump into the mobile world and develop apps for iPhone, Android, and the BlackBerry. Walks you through installing the development software Covers the basics of each of PhoneGap's functional units Introduces various projects you can build with the framework Discusses using HTML, CSS, JavaScript Explores the features accelerameter and compass Examines media, storage and files, camera, contacts, geolocation, and more Within Beginning PhoneGap, each new chapter builds on the lessons taught in the previous so that by the end of the book, you can have mobile apps up and running!'NOTE: Several significant changes to the PhoneGap software occurred shortly after this book was published. The author has written extra pages to address these and other changes. You can download the updates to this book from the book's support page on the Wrox website.' Create Cross-platform Mobile Apps Without Having To Learn A New Language! Phonegap Is An Open Source Solution, Ideal For Web Developers Wanting To Build Cross-platform Mobile Apps Without Having To Learn A New Language. Using Html, Css, And Javascript, Phonegap Allows You To Jump Into The Mobile World And Develop Apps For Iphone, Android, And The Blackberry. Walks You Through Installing The Development Software Covers The Basics Of Each Of Phonegap's Functional Units Introduces Various Projects You Can Build With The Framework Discusses Using Html, Css, Javascript Explores The Features Accelerameter And Compass Examines Media, Storage And Files, Camera, Contacts, Geolocation, And More Within Beginning Phonegap, Each New Chapter Builds On The Lessons Taught In The Previous So That By The End Of The Book, You Can Have Mobile Apps Up And Running! Note: Several Significant Changes To The Phonegap Software Occurred Shortly After This Book Was Published. The Author Has Written Extra Pages To Address These And Other Changes. You Can Download The Updates To This Book From The Book's Support Page On The Wrox Website. Introduction to Microsoft Access 2010 New features Upgrading and converting to Access 2010 Macros in Access 2010 Using the VBA editor VBA basics Using VBA in Access Creating classes in VBA Extending VBA with APIS Working with the Windows registry Using DAO to access data Using ADO to Access data Using SQL with VBA Using VBA to enhance forms Enhancing reports with VBA Customizing the ribbon Customizing the office backstage Working with Office 2010 Working with Sharepoint Working with .NET Building client-server applications with Access The Access 2010 templates Access runtime deployment Database security Access 2010 security features Appendix. The Access object model ; DAO object method and property descriptions ; ADO object model reference ; 64-bit Access ; Reference for projects ; Reserved words and special characters ; Naming conventions ; The access source code control ; Tips and tricks. "PhoneGap is an open source solution, ideal for web developers wanting to build cross-platform mobile apps without having to learn a new language. Using HTML, CSS, and Javascript, PhoneGap allows you to jump into the mobile world and develop apps for iPhone, Android, and the BlackBerry. This book: walks you through installing the development software; covers the basics of each of PhoneGap's functional units; introduces various projects you can build with the framework; discusses using HTML, CSS, JavaScript; explores the features accelerameter and compass; examines media, storage and files, camera, contacts, geolocation, and more. Within Beginning PhoneGap, each new chapter builds on the lessons taught in the previous so that by the end of the book, you can have mobile apps up and running!"--Publisher's description A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Reference is a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: The next wave of business intelligence, Self-Service BI, seeks to meet the demands of powerful hardware and shorter decision time frames. This book introduces PowerPivot for Excel and SharePoint, showing you how to use this innovative software for self-service analytics and reporting. Authored by key members of the Microsoft team that built the product, this book will guide you through the use of in-memory BI server technology, data analytics eXpressions, and report gallery. The book also discusses how to deploy and manage sandbox servers, and a companion website provides sample reports and applications. Discover how to take advantage of the features in SharePoint 2010. This introductory-level book walks you through the process of learning, developing, and deploying SharePoint 2010 solutions. You'll leverage your existing skills and tools to grasp the fundamental programming concepts and practices of the package Presents Information On Using Microsoft's Visual Basic For Applications (vba) Programming Language To Customize The Spreadsheet Program Excel. Tom Urtis. Wrox Programmer To Programmer. --cover. Includes Index. A guide to developing applications using SharePoint 2010 covers the fundamentals of programming, describes the developer toolset, and offers code examples.