You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery! Enhance your application with VBA built-in functions and SQL code Use the Access Object Model to work with data in forms and reports Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO) Create classes for handling form and control events Connect your Access database to different sources of data Effectively plan how to upsize an existing Access database to Microsoft SQL Server Dynamically update Microsoft Excel spreadsheets from the database Migrate your Access database directly to the cloud using SQL Azure

Most people recognize that Arthur Andersen was a great Firm. For the authors, it was perhaps the greatest. Its fulminating, unexpected and shameful collapse, with the Enron case and ensuing disappearance from the market, leaving a cloud of local professional firms, has left in the collective memory a totally negative image, erasing any earlier merits as if they never existed. After an introductory chapter, that goes briefly through the Arthur Andersen history, the book is organized in three main parts: I. The Seven Columns or Basic Principles of the Andersen Model, II. Turning Principles into Practice and III. The Decomposition of the Model.

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication. The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You'll learn methods for tuning Oracle GoldenGate performance. You'll discover GoldenGate's utility as a migration and ETL tool. You'll learn to configure highly-available environments involving GoldenGate, RAC, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment. Explains all aspects of using GoldenGate for replication Covers homogeneous, heterogeneous, and bidirectional replication Shows the use of GoldenGate for data migration and extract, transform, load (ETL) What you'll learn Install Oracle GoldenGate quickly and painlessly Design single- and bi-directional replication solutions Apply GoldenGate to high-availability solutions Troubleshoot and tune GoldenGate for performance Verify data synchronization using GoldenGate Veridata Manage and monitor GoldenGate environments using GoldenGate Director Who this book is for Expert Oracle GoldenGate is for database professionals needing to master the latest in replication technology from Oracle. It is for the Oracle database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software.

With numerous examples and exercises throughout, this book describes the control behavior of mechanical objects, such as wave equations, plates, and shells. It presents a complete and up-to-date account of many important advances in the modeling and control of vibrational and structural dynamics. The text applies the differential geometric approach to waves, plates, shells, and quasilinear systems and describes differential geometric energy methods that are generalizations of classical energy methods. To make the book self-contained, the author gives an introduction to Riemannian geometry.

This IBM® Redbooks® publication examines the IBM Tivoli® Directory Server for z/OS®. IBM Tivoli Directory Server is a powerful Lightweight Directory Access Protocol (LDAP) infrastructure that provides a foundation for deploying comprehensive identity management applications and advanced software architectures. This publication provides an introduction to the IBM Tivoli Directory Server for z/OS that provides a brief summary of its features and a examination of the possible deployment topologies. It discusses planning a deployment of IBM Tivoli Directory Server for z/OS, which includes prerequisites, planning considerations, and data stores, and provides a brief overview of the configuration process. Additional chapters provide a detailed discussion of the IBM Tivoli Directory Server for z/OS architecture that examines the supported back ends, discusses in what scenarios they are best used, and provides usage examples for each back end. The discussion of schemas breaks down the schema and provides guidance on extending it. A broad discussion of authentication, authorization, and security examines the various access protections, bind mechanisms, and transport security available with IBM Tivoli Directory Server for z/OS. This chapter also provides an examination of the new Password Policy feature. Basic and advanced replication topologies are also covered. A discussion on plug-ins provides details on the various types of plug-ins, the plug-in architecture, and creating a plug-in, and provides an example plug-in. Integration of IBM Tivoli Directory Server for z/OS into the IBM Workload Manager environment is also covered. This publication also provides detailed information about the configuration of IBM Tivoli Directory Server for z/OS. It discusses deploying IBM Tivoli Directory Server for z/OS on a single system, with examples of configuring the available back ends. Configuration examples are also provided for deploying the server in a Sysplex, and for both basic and advanced replication topologies. Finally it provides guidance on monitoring and debugging IBM Tivoli Directory Server for z/OS.

This IBM® Redbooks® publication will help you to better understand the effective use of the WebSphere® DataPower® family of appliances. It provides guidance on the best methods identified to date for building the various components that implement solutions, such as handling MQ-based message flows or creating authentication and authorization policies. The information and recommendations in this publication are the result of real world experiences using the appliances. Such experience shows that taking the time to plan a solution implementation before beginning the work yields the greatest savings in time and energy and the highest quality outcome. This publication begins with a checklist of items to consider when planning a DataPower solution. This publication is intended to provide answers or guidance to implementation problems often encountered by users of the appliance. This book is not intended to present complete solutions or templates because experience shows that every customer uses the appliance in their own unique environment with unique requirements. Thus, this publication provides a compendium of information about particular aspects of a solution. Use the Table of Contents or Index to find your current issue, and return to this publication when the next issue or question arises. Refer to the related IBM Redbooks publication entitled DataPower SOA Appliance Administration, Deployment, and Best Practices, SG24-7901 for more information.

This IBM® Redbooks® publication provides a documented deployment model for IBM GPFS™ in a cross-platform environment with IBM Power Systems™, Linux, and Windows servers. With IBM GPFS, customers can have a planned foundation for file systems management for cross-platform access solutions. This book examines the functional, integration, simplification, and usability changes with GPFS v3.4. It can help the technical teams provide file system management solutions and technical support with GPFS, based on Power Systems virtualized environments for cross-platform file systems management. The book provides answers to your complex file systems management requirements, helps you maximize file system availability, and provides expert-level documentation to transfer the how-to skills to the worldwide support teams. The audience for this book is the technical professional (IT consultants, technical support staff, IT architects, and IT specialists) who is responsible for providing file system management solutions and support for cross-platform environments that are based primarily on Power Systems.

Oracle Application Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application development platform included with every Oracle Database license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction. The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create data entry screens, visualize data in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy, problem/solution format from which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges. Teaches Application Express via an example-based format Takes you from beginner to intermediate level Shows how to build a fully-functional web store in just one hour What you'll learn Create web application forms and tables Customize application look and feel Visualize data via reports, calendars, maps, and charts Globalize applications in support of language and regional differences Implement complex business logic Optimize the performance of Application Express Protect applications from security threats Who this book is for Oracle Application Express 4 Recipes is aimed at web application developers, PL/SQL developers, and database administrators wishing to learn and use Oracle's groundbreaking tool for rapid development—Application Express. The book is a quick-study and is perfect for the reader who wants only a good example to work from, customize, and adapt.

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and VBA tools for Access applications, integrate Access with SharePoint and other business systems, and much more. Using a practical, hands-on approach, this book will take you through all the facets of developing Access-based solutions, such as data modeling, complex form development, and UI customizations. You'll then deploy your solution to the web and integrate it with other external data sources. This book is full of handy tricks to help you get the most out of what Access has to offer, including its comprehensive set of features and tools for collecting, using, and acting on business data, whether your data is in Access or stored on another platform. You'll also see how to smoothly integrate your applications with SQL Server databases and other Office programs, such as Outlook. What you'll learn How to build business applications that integrate local data, web-generated data, and data available from SQL Server and other sources How to develop VBA routines and macros to enhance the automation of your database How to deploy databases to your users and "web-ify" your application for access from anywhere How to secure access to your data and maintain its integrity How to integrate Access with SharePoint and other business applications Who this book is for This book is for intermediate to advanced Access developers who want to get up to speed with the new features available in Access 2010. Experienced Access users who want to begin developing code-based applications and project solutions in Access will also find this book useful.

Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out Oracle in years. Application Express, termed APEX for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users. Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle's new plug-in architecture. You'll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the "hard problems" are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer. Focuses on high-end, enterprise-level development Covers new features such as plug-ins and Websheets Introduces the new interface released with APEX 4.0 What you'll learn Design APEX solutions that conform to your corporate look-and-feel Create compelling reports, charts, navigation, and layout Create your own components based upon APEX's new plug-in architecture Authenticate users and manage their access to your applications Develop and deploy web services using APEX Scale APEX applications to thousands of users Secure your applications and data from intrusion Who this book is for Pro Oracle Application Express 4 is aimed at application developers looking for a rapid application development environment harnessing the full power of the Oracle Database, including SQL and PL/SQL. The book meets the needs of developers working at both the departmental and the enterprise level, with an emphasis on high-end, enterprise deployment.

In this IBM® Redbooks® publication, we focus on, and provide an overview of, the high availability and Enterprise Replication features of IBM Informix® 11.70. Informix provides solutions for making data highly available in the MACH11 cluster. The components of the MACH11 cluster include High Availability Data Replication (HDR), Shared Disk Secondary (SDS), and Remote Secondary Standby (RSS) servers. Enterprise Replication (ER) provides a means of selectively replicating data between systems in near real time. The Informix Flexible Grid eliminates the administrative complexity of ER. Flexible Grid provides the ability to automatically create database objects, such as tables, indexes, and stored procedures, on all nodes within the grid as a single operation. These enhanced Enterprise Replication features provide solutions for those customers requiring reliable and quick dissemination of data across a global organization. There is also enhanced capability for customers requiring High Availability Disaster Recovery, in the form of the ability to resend primary server indexes to secondary servers without requiring a rebuild of the index on the primary server. Capabilities such as these enable faster, easier, and more reliable distribution and high availability of data, resulting in improved access and use throughout the enterprise.

This book, "Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation," serves as a comprehensive guide for understanding PeopleSoft Financials applications. It delves into core concepts, configurations, and business processes, providing practical, real-world scenarios to bridge theory and application. By mastering the content, readers will be prepared to successfully implement PeopleSoft Financials in complex organizational environments. What this Book will help me do Grasp the core principles of financial ERP systems and PeopleSoft's approach to effective financial application management. Learn to configure security settings to control access to system features, ensuring proper user management. Understand and implement crucial financial modules such as Billing, Accounts Payable, Accounts Receivable, and Asset Management. Develop strategies for budgeting and expense management through Commitment Control and the Expenses module. Gain hands-on experience with PeopleSoft's Setup Manager to navigate and complete implementation tasks efficiently. Author(s) Ranjeet Yadav brings extensive experience in implementing and working with PeopleSoft Financials across various industries. With an in-depth understanding of both the technical and functional aspects of PeopleSoft systems, he has crafted this book to be both accessible and informative for practitioners. Ranjeet's teaching approach focuses on practical knowledge, equipping his readers to tackle real-world challenges confidently. Who is it for? This book is well-suited for functional implementation analysts, business analysts, and business users starting with PeopleSoft applications. It is ideal for individuals aiming to enhance their PeopleSoft Financials skills and gain a comprehensive understanding of its implementation. If you're looking to build a strong foundation in PeopleSoft systems and improve your organization's financial operations, this book is tailored to your needs.

Master All Aspects of Oracle Fusion Middleware Management Govern a unified platform for agile, intelligent business applications using the detailed information contained in this Oracle Press book. Oracle Fusion Middleware 11g Architecture and Management explains the entire suite of Oracle Fusion Middleware components and lays out core use cases, best practices, and step-by-step administrative instructions. Discover how to provision servers and clusters, configure Web services, manage portals, and optimize the performance of the full stack of Oracle Fusion Middleware components. Monitoring, diagnosing, and security are also covered in this definitive resource. Understand key architectural concepts behind Oracle Fusion Middleware 11 g Create and deploy Oracle WebLogic Server domains and clusters Set up and manage applications built using Oracle Application Development Framework Maximize the value of your Oracle SOA Suite environments Manage portals and Enterprise 2.0 services from Oracle WebCenter Secure deployments with Oracle Platform Security Services and Oracle Identity Management Understand Oracle Exalogic and Oracle Virtual Assembly Builder

A unique book-and-video package for Microsoft® Access® 2010 24-Hour Trainer Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples showing you exactly how each feature can be implemented in a real world Access database application. The accompanying video provides clear, easy-to-follow videos of the authors demonstrating each of the examples discussed in the book, as well as extra commentary, so that no reader is left behind! Provides examples of building Access database applications from scratch or from existing database templates. Discusses how to use Access 2010 and the major components it provides, such as the Navigation Pane, Ribbon, and the many database object designers. Teaches the basics of building and working with each of the major Access database object types: tables, queries, forms, reports, macros, and VBA code modules. Introduces exciting new Access 2010 features, such as the new macro designer, the new Ribbon designer, and even how to customize the Access Backstage. Teaches the basics of writing VBA code and provides specific examples about how and when to use it. Each lesson includes a step-by-step video showing exactly how to accomplish the tasks discussed in the lesson. Even if you have no experience with Access 2010, this guide will have you building robust Access applications with the best of them! If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start.

A Proven Development Methodology That Delivers On the Promise of Model-Based Approaches Software continues to grow increasingly complex, while software consumers’ expectations for performance, reliability, functionality, and speed-to-market are also growing exponentially. H. S. Lahman shows how to address all these challenges by integrating object-oriented techniques with a powerful new methodology, Model-Based Software Engineering (MBSE). represents Lahman’s half-century of experience as a pioneering software innovator. Building on Shlaer-Mellor’s work, MBSE fully delivers on the promise of models, and is firmly grounded in the realities of contemporary development, design, and architecture. Model-Based Development Lahman introduces the methodology’s core principles, showing how it separates each of a project’s concerns, enabling practitioners to optimize each domain for its unique needs and characteristics. Next, he demonstrates how to perform more effective object-oriented analysis, emphasizing abstraction, disciplined partitioning, modeling invariants, finite state machines, and efficient communications among program units. Coverage includes How we got here: a historical perspective and pragmatic review of object principles Problem space versus computing space: reflecting crucial distinctions between customer and computer environments in your designs Application partitioning: why it matters and how do it well Building static models that distinguish knowledge from behavior Modeling classes, class responsibilities, associations, and both referential and knowledge integrity Creating dynamic models that describe behavior via finite state machines Successfully using abstract action languages (AALs) and action data flow diagrams (ADFDs) Throughout, Lahman illuminates theoretical issues in practical terms, explaining why things are done as they are, without demanding rigorous math. His focus is on creating implementation-independent models that specify functional requirements completely, precisely, and unambiguously. Whether you’re a developer, team leader, architect, or designer, Lahman’s techniques will help you build software that’s more robust, easier to maintain, and supports larger-scale reuse.

&> The Complete Guide to Managing Work Items and Workflow with IBM Rational ClearQuest 7, IBM Rational Team Concert, and Jazz Work items are the lifeblood of software and hardware development. They tell development teams exactly who is doing what, which issues are resolved, which remain unresolved, and which products are impacted. In large team-based projects, however, managing work items can be difficult. Now, two IBM Rational experts show how to simplify and improve every aspect of work item management with IBM Rational ClearQuest and the powerful and collaborative Jazz-based products: IBM Rational Team Concert (RTC) and IBM Rational Quality Manager. Drawing on extensive experience with IBM customers, the authors tightly link theory with proven best practices, offering implementation guidance, detailed examples, and complete schemas. They present innovative solutions, introduce advanced customization techniques, and walk step-by-step through every phase of workflow development, from requirements through maintenance. They conclude with a full chapter of sample applications and solutions, ranging from Collaborative Application Lifecycle Management to SLAs. Coverage includes Understanding work items and their elements Using work items for changes, tasks, activities, test plans, test cases, risks, builds, and promotion Implementing best practices for work item application planning, analysis, design, development, testing, deployment, and maintenance Describing workflows, including advanced dynamic workflows Incorporating roles in work items and using them to meet business needs Using ClearQuest packages and custom integrations, and making the most of Jazz platform integration technology Getting the most of out the CQ-ALM schema Implementing effective quality and performance metrics, SLAs, and governance Improving test management with IBM Rational Quality Manager work items Creating effective workflows for Scrum and other Agile projects will be an indispensable resource for all change management administrators, systems analysts, designers, project managers, and quality engineers who are already using IBM Rational ClearQuest, Rational Team Concert, or Rational Quality Manager; and for all IT professionals who want to understand enterprise-class work item and workflow management. Work Item Management with IBM Rational ClearQuest and Jazz

This IBM® Redbooks® publication focuses on operational and managerial aspects for DataPower® appliance deployments. DataPower appliances provide functionality that crosses both functional and organizational boundaries, which introduces unique management and operational challenges. For example, a DataPower appliance can provide network functionality, such as load balancing, and at the same time, provide enterprise service bus (ESB) capabilities, such as transformation and intelligent content-based routing. This IBM Redbooks publication provides guidance at both a general and technical level for individuals who are responsible for planning, installation, development, and deployment. It is not intended to be a "how-to" guide, but rather to help educate you about the various options and methodologies that apply to DataPower appliances. In addition, many chapters provide a list of suggestions.

Search has been vital to artificial intelligence from the very beginning as a core technique in problem solving. The authors present a thorough overview of heuristic search with a balance of discussion between theoretical analysis and efficient implementation and application to real-world problems. Current developments in search such as pattern databases and search with efficient use of external memory and parallel processing units on main boards and graphics cards are detailed. Heuristic search as a problem solving tool is demonstrated in applications for puzzle solving, game playing, constraint satisfaction and machine learning. While no previous familiarity with heuristic search is necessary the reader should have a basic knowledge of algorithms, data structures, and calculus. Real-world case studies and chapter ending exercises help to create a full and realized picture of how search fits into the world of artificial intelligence and the one around us. Provides real-world success stories and case studies for heuristic search algorithms Includes many AI developments not yet covered in textbooks such as pattern databases, symbolic search, and parallel processing units

Truly revolutionary: now you can write geolocation applications directly in the browser, rather than develop native apps for particular devices. This concise book demonstrates the W3C Geolocation API in action, with code and examples to help you build HTML5 apps using the "write once, deploy everywhere" model. Along the way, you get a crash course in geolocation, browser support, and ways to integrate the API with common geo tools like Google Maps. Ideal for experienced JavaScript developers. Learn how geo information is gathered from different sources, depending on the device Discover how coordinate systems work, including geodetic systems and datums Use the API to collect location information from a user’s browser with JavaScript code Place geo information on a map using the Google Maps or ArcGIS JavaScript APIs Save geo data with databases, the Keyhole Markup Language, or the shapefile format Be familiar with several practical uses for geo data, such as geomarketing, geosocial, geotagging, and geo-applications

Continuing its commitment to developing and delivering industry-leading storage technologies, IBM® introduces the IBM Storwize® V7000, an innovative new storage offering that delivers essential storage efficiency technologies and exceptional ease of use and performance, all integrated into a compact, modular design that is offered at a competitive, midrange price. IBM Storwize V7000 incorporates some of the top IBM technologies typically found only in enterprise-class storage systems, raising the standard for storage efficiency in midrange disk systems. This cutting-edge storage system extends the comprehensive storage portfolio from IBM and can help change the way organizations address the ongoing information explosion. This IBM Redbooks® publication introduces the features and functions of the IBM Storwize V7000 through several examples. This book is aimed at pre- and post-sales technical support and marketing, storage administrators, and will help you understand the architecture of the Storwize V7000, how to implement it, and take advantage of the industry leading functions and features.