Need answers quickly? Access 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Inside the Book • Create desktop databases or web apps for traditional and online users to gather, organize, and share data • Use professional templates to help you create desktop databases or web apps • Create web apps on SharePoint Team Services to collaborate and share information • Use tools for building a database or web app that makes information easier to find and use • Import data from other programs, HTML, XML files, and other databases • Use forms, filters, queries, and reports to capture and analyze data • Organize information and add impact with themes, pictures, tables, and charts • Add hyperlinks and web pages to forms and reports to use content on the Internet • Use macros and Visual Basic for Applications (VBA) to automate and add functionality to databases • Prepare for the Microsoft Office Specialist (MOS) exam Numbered Steps guide you through each task See Also points you to related information in the book Did You Know? alerts you to tips and techniques Illustrations with matching steps Tasks are presented on one or two pages Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts Visit the author site: perspection.com

This IBM® Redbooks® publication introduces a technical overview of the new features, functions, and enhancements available in IBM i 7.1. It provides a summary and brief explanation of new capabilities and what changed in the operating system. This publication also describes many of the licensed programs and application development tools that are associated with IBM i. This publication includes all the enhancements that were delivered with the Technology Refresh 4 and 5 that were made available in 2012. Many new and enhanced functions are described: IBM DB2® for i support for XML and column level encryption IBM PowerHA® for i asynchronous Geographic Mirroring and LUN-level switching Virtualization enhancements for IBM i hosted partitions and IBM PowerVM® Storage management enhancements for solid-state drives Systems management enhancements for Systems Director Navigator for i IBM Rational® software development product enhancements Zend PHP Enhancements Web Application Serving enhancements The information that is provided in this book is useful for clients, IBM Business Partners, and IBM service professionals that are involved with planning, supporting, upgrading, and implementing IBM i 7.1 solutions.

Discover the power of XML publishing with InDesign, and create content for multiple applications—including digital-first publishing workflows. With this book, XML evangelist Dorothy Hoskins teaches you several techniques for working with the built-in XML capabilities of InDesign CS6, using real examples from a college course-catalog project. Learn how to import database content into InDesign, and tag existing InDesign content as XML for export to other applications. InDesign also lets you apply attractive styling to XML content that can’t be done with XSL-FO. Through step-by-step instructions, code examples, and lots of screen shots, you’ll discover how using XML with InDesign increases the value of your content. Get an overview of structured (XML) content Learn InDesign’s XML import options, including XML image information Mingle XML and non-XML content in a text flow Use InDesign as an XML "skin" by making templates with new style definitions Put content in "XML order" for export to EPUB, with InDesign CS5.5 and CS6 Dive into advanced topics, such as how to transform XML with XSL Understand InDesign’s potential and limitations with complex content models such as DocBook and DITA

This book introduces the keyset technologies that are currently used to create applications on web. It explains the principal HTML concept, the client-side used JavaScript and the server-side used JSP with relevant coding examples. Emphasis is given on XML with examples including XML Transformations (XSTL). Apart from this, the book also dwells into the alternatives to XML such as the JSON.

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more. What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs. Provides practical and proven solutions towards creating resilient ETL environments Clearly answers the tough questions which professionals ask Goes beyond the tools to a thorough discussion of the underlying techniques Covers the gamut of data integration, beyond just SSIS Includes example databases and files to allow readers to test the recipes What you'll learn Import and export to and from CSV files, XML files, and other text-based sources. Move data between SQL databases, including SQL Server and others such as Oracle Database and MySQL. Discover and manage metadata held in various database systems. Remove duplicates and consolidate from multiple sources. Transform data to meet the needs of target systems. Profile source data as part of the discovery process. Log and manage errors and exceptions during an ETL process. Improve efficiency by detecting and processing only changed data. Who this book is for SQL Server 2012 Data Integration Recipes is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment.

“Jeremy builds real apps for real customers. That’s why I can heartily recommend this book. Go out and write some great apps…and keep this book handy.” —From the Foreword by Jeff Prosise Build Exceptionally Immersive and Responsive Touch-Based Windows Store Apps for Windows 8 with C# and XAML This is the first practical guide to building breakthrough applications for Windows 8 from project templates through publication to the new Windows Store. Microsoft “MVP of the Year” Jeremy Likness helps you combine your existing developer skills with new Visual Studio 2012 tools and best practices to create apps that are intuitive and innovative. His guidance and insight will help you dive into Windows 8 development—and gain a powerful competitive advantage for years to come. Likness illuminates the entire apps lifecycle, from planning and Model-View-View Model (MVVM) based design through coding, testing, packaging, and deployment. He covers both business and consumer apps, showing how Windows 8/WinRT development builds upon and contrasts with older WPF and Silverlight approaches. Using carefully crafted downloadable code examples and sample projects, Likness shows how to make the most of new platform features, including integrated social networking, search, contracts, charms, and tiles. Throughout, he addresses crucial development challenges that have only been discussed on MSDN, blog posts, and Twitter feeds—and never with this depth and clarity before. Coverage includes • Mastering real-world Windows 8 development for all devices and form factors • Understanding the new WinRT framework and the unique characteristics of Windows 8 apps • Designing apps that are faster, more responsive, do more with less, and maximize battery life • Creating exceptionally fluid interfaces with VS 2012 templates, built-in animations, and XAML • Building apps that respond consistently to multiple forms of input, including complex touch manipulations • Using contracts and charms to expose services or enable users to do so • Providing information to users through Live Tiles even when your app isn’t running • Connecting your app seamlessly to multiple data sources, including social networks and cloud storage • Syndicating rich, network-based content • Using Model-View-ViewModel (MVVM) • Securing Windows 8 apps through authentication and authorization • Efficiently testing, debugging, packaging, and deploying apps

Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Transact-SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks. What you'll learn Take full advantage of window functions and other new features in T-SQL 2012 Move business logic into the database via procedures and functions Develop using advanced features such as encryption and full-text search Store and retrieve XML data using XQuery and XPath Debug and Optimize T-SQL Execution Build ADO.NET Client Applications Who this book is for Pro T-SQL 2012 Programmer's Guide is written for SQL Server and Transact-SQL developers who want to implement best-practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains What you'll learn Create databases, tables, and indexes Query and manipulate data Store and manage XML inside the database Move business logic into the database Resolve common performance problems. Build reports that matter to your business. Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back-end database, and the database administrators who create, manage, and secure those databases.

This book introduces XML to scientists and engineers in a way that illustrates the similarities and differences with traditional programming languages and suggests new ways of saving and sharing the results of scientific calculations. The author discusses XML in the context of scientific computing, demonstrates how XSL can be used to perform various calculations, and explains how to create and navigate through XML documents using traditional languages such as Fortran, C++, and MATLAB. A suite of computer programs are available on the author's website.

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services. Takes you through solutions to several common data integration challenges Demonstrates new features in SQL Server 2012 Integration Services Teaches SSIS using practical examples What you'll learn Load data from flat file formats Explore patterns for executing SSIS packages Discover a pattern for loading XML data Migrate SSIS packages through your application lifecycle without editing connections Take advantage of SSIS 2012 Dependency Services Build an SSIS Framework to support your application needs Who this book is for SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It's for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It's an excellent choice for business intelligence and data warehouse developers.

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine. Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic. Provides best practices for using Reporting Services Covers the very latest in new features for SQL Server 2012 Your key to delivering business intelligence across the enterprise

A complete update covering the many advances to the XML language The XML language has become the standard for writing documents on the Internet and is constantly improving and evolving. This new edition covers all the many new XML-based technologies that have appeared since the previous edition four years ago, providing you with an up-to-date introductory guide and reference. Packed with real-world code examples, best practices, and in-depth coverage of the most important and relevant topics, this authoritative resource explores both the advantages and disadvantages of XML and addresses the most current standards and uses of XML. Features the most updated content built on audience feedback from the previous edition as well as the vast knowledge from XML developer teams Boasts new chapters on RELAX NG and Schematron, XML functionality in databases, LINQ to XML, Jabber and XMLPP, XHTML, HTML5, and more Offers in-depth coverage on extracting data from XML and updated material on Web Services Beginning XML, Fifth Edition delivers the most important aspects of XML in regard to what it is, how it works, what technologies surround it, and how it can best be used in a variety of situations.

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals. What you'll learn from Expert Performance Indexing for SQL Server 2012 will help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database. Defines indexes and provides an understanding of their role Uncovers and explains the statistics that are kept in indexes Teaches strategies and approaches for indexing databases What you'll learn Fully understand the index types at your disposal Recognize and remove unnecessary indexes Review statistics to understand indexing choices made by the optimizer Properly apply strategies such as covering indexes, included columns, index intersections, and more Write queries to make good use of the indexes already in place Design effective indexes for full-text, spatial, and XML data types Manage the big picture: Encompassing all indexes in a database, and all database instances on a server Who this book is for Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes.

Pixel shaders are some of the more powerful graphic tools available for XAML programmers, but shader development bears little resemblance to traditional .NET programming. With this hands-on book, you’ll not only discover how to use existing shaders in your Windows Presentation Foundation (WPF) and Silverlight applications, you’ll also learn how create your own effects with XAML and Microsoft’s HLSL shading language. In the process, you’ll write, compile, and test custom XAML shaders with the Shazzam Shader Editor, a free utility developed by author Walt Ritscher. The book includes XAML and C# sample code, and Shazzam contains all of the sample shaders discussed. Learn how shaders help you extend the GPU’s rendering capabilities Explore prevailing shader types, such as color modification, blurring, and spatial transformation Get a quick tour of the shader features, and use pre-built effects on image elements in your application Examine the XAML ShaderEffect class to understand how WPF and Silverlight use shaders Learn about the shader-specific tools available in Visual Studio and Expression Blend Get up to speed on HLSL basics and learn how to create a variety of graphics effects

FileMaker® 12 In Depth Do more in less time! FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features. • Use themes to build solutions for FileMaker Pro on Windows and OS X, FileMaker Go on iOS, and Instant Web Publishing • Get the most out of new container field technology • Quickly become a FileMaker 12 power user • Make the most of FileMaker fields, tables, layouts, and parts • Iteratively design reliable, high-performance FileMaker relational databases • Work with relationships, including self-joins and cross-product relationships • Write calculation formulas and use functions • Use event-driven scripts to make databases more interactive • Build clear and usable reports, publish them, and incorporate them into workflows • Secure applications with user accounts, privileges, file-level access, network security, and authentication • Use FileMaker’s Web Viewer to access live web-based data • Convert systems from older versions of FileMaker, and troubleshoot successfully • Share, exchange, export, and publish data via SQL and XML • Instantly publish databases on the web, and use advanced Custom Web Publishing techniques • Trigger automated behaviors whenever specific events occur • Extend FileMaker’s functionality with plug-ins • Set up, configure, tune, and secure FileMaker Server All In Depth books offer • Comprehensive coverage with detailed solutions • Troubleshooting help for tough problems you can’t fix on your own • Outstanding authors recognized worldwide for their expertise and teaching style Learning, reference, problem-solving... the only FileMaker 12 book you need!

This book is your go-to guide for mastering Oracle Data Integrator 11g through practical, hands-on instructions. You will learn the foundational concepts of data integration using ODI, empowering you to build efficient workflows and handle complex data scenarios confidently. What this Book will help me do Understand the components and architecture of Oracle Data Integrator (ODI). Install and configure ODI using best practices. Design complex workflows and perform data integration tasks with ease. Handle error processing and monitoring with ODI's tools and techniques. Leverage ODI to connect to various data sources like Oracle DB, SQL Server, and XML. Author(s) The authors have extensive experience in data integration and Oracle technologies, bringing over 15 years of combined real-world expertise. Their practical teaching approach focuses on empowering readers to solve real-life data challenges effectively. Who is it for? This book is tailored for software developers, ETL specialists, and database administrators who wish to get hands-on experience with Oracle Data Integrator. Whether you're starting with intermediate database knowledge or transitioning from other ETL tools, this book provides the foundations and advanced topics to enhance your proficiency in data integration.

The XPages Extension Library’s next-generation XPages controls make application development far more efficient, effective, scalable, and rewarding. With IBM® Lotus® Notes®/Domino® 8.5.3 and Upgrade Pack 1, IBM has incorporated powerful new capabilities and support. These components and technologies are now fully ready for even the toughest production challenges. XPages Extension Library is the first and only complete guide to Domino development with this library; it’s the best manifestation yet of the underlying XPages Extensibility Framework. Complementing the popular Mastering XPages, it gives XPages developers complete information for taking full advantage of the new components from IBM. Combining reference material and practical use cases, the authors offer step-by- step guidance for installing and configuring the XPages Extension Library and using its state-of-the-art applications infrastructure to quickly create rich web applications with outstanding user experiences. Next, the authors provide detailed step-by-step guidance for leveraging the library’s powerful new support for REST services, mobile and social development, and relational data. The book concludes by showing how to include Java™ code in Domino XPages applications—a great way to make them even more powerful. Coverage includes Automating deployment of XPages Extension Library throughout your IBM Lotus Notes/Domino or IBM XWork environment Integrating modern design patterns and best practices into Lotus Domino applications with drag-and-drop ease Incorporating AJAX capabilities with Switch, In Place Form, and other dynamic content controls Extending applications with Dojo widgets, popups, Tooltips, Dialogs, and Pickers Implementing state-of-the-art navigation and outlines Using Layout and Dynamic Views controls to painlessly modernize most Domino applications to XPages Quickly building mobile interfaces for existing applications Using social enablers to connect with social platforms and incorporate social features Integrating SQL datasources into XPages data-driven applications

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

A Practical Primer for XPages Application Development, Debugging, and Performance Using XPages, Lotus® Notes® and Domino® developers can quickly create state-of-the-art web, mobile, and Notes client business applications using standard technologies like HTML, JavaScript, CSS, and XML. Now, there’s a perfect portable XPages quick reference for every working developer. Straight from the experts at IBM®, XPages Portable Command Guide offers fast access to working code, tested solutions, expert tips, and example-driven best practices. Drawing on their unsurpassed experience as IBM XPages lead developers and customer consultants, the authors explore many lesser known facets of the XPages runtime, illuminating these capabilities with dozens of examples that solve specific XPages development problems. Using their easy-to-adapt code examples, you can develop XPages solutions with outstanding performance, scalability, flexibility, efficiency, reliability, and value. Covers lots of commands and parameters related to XPages behavior modification through xsp.properties Notes/Domino configuration files XSP Command Manager and OSGi Console The XSP Client-Side JavaScript Object Server Side JavaScript scripting Server Side JavaScript debugging via global functions, simple programming constructs, and logging Instantly access all XPages commands: Use this book as your quick offline solutions resource Logical how-to topic groupings provide one-stop research Compact size makes it easy to carry with you—wherever you go “Create Your Own Journal” section with blank, lined pages makes it easy to personalize this book for your needs “What Do You Want to Do?” chart inside the front cover helps you quickly find specific tasks Designed for all Lotus and Domino developers with at least some XPages experience, XPages Portable Command Guide is the ideal companion and follow-up to Mastering XPages from IBM Press, the world’s #1 book on XPages technology.

Your expert guide to designing and building dynamic user interfaces Sharpen your application design and development skills using XAML—the declarative markup language used in Microsoft Silverlight and Windows Presentation Foundation (WPF). Led by two XAML experts, you’ll learn practical ways to build rich, interactive user interfaces with data integration capabilities and support for multimedia, graphics, and animation. This hands-on guide is ideal for Microsoft .NET developers and web designers alike. Discover how to: Control UI behavior and implement business logic with code-behind solutions Manage UI element positioning with the XAML layout system Use templates to customize UI elements—without affecting their functionality Apply different types of property and event systems in WPF and Silverlight Bind various kinds of data to your UI, and display them in the format you want Implement 2D and 3D vector graphics and animations Reuse control styles and properties to maintain consistency throughout your application