Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • English  (39)
  • 2005-2009  (39)
  • 1940-1944
  • Boston, Mass. :Safari Books Online  (39)
  • Database management  (39)
Datasource
Material
Language
  • English  (39)
Years
Year
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    SQL Server 2005 management and administration (2008)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780672329562 , 0672329565
    Language: English
    Pages: xxvii, 906 p , ill. , 21 cm
    Keywords: SQL server ; Database management ; Client/server computing ; Electronic books ; local
    Abstract: Microsoft SQL Server 2005 Management and Administration , based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators-from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more. Understand how to... Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services Harden a SQL Server implementation Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication Monitor a SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure the SQL Server Management Pack and install Operations Manager 2007 Automate SQL Server routine maintenance Encrypt SQL Server data and communications, including setting up a Certificate Authority Performance tune and troubleshoot a SQL Server environment Create Integration Services packages and transfer data On the Web: Download bonus chapters from www.informit.com/title/9780672329562 Introduction 1 Part I Administering SQL Server Components 1 Administering SQL Server 2005 Database Engine 11 2 Administering SQL Server 2005 Analysis Services 67 3 Administering SQL Server 2005 Reporting Services 99 4 Administering SQL Server 2005 Notification Services 149 5 Administering SQL Server 2005 Integration Services 183 6 Administering SQL Server Replication 209 Part II Managing SQL Server 2005 7 Conducting a SQL Server 2005 Health Check 261 8 SQL Server 2005 Maintenance Practices 289 9 Managing and Optimizing SQL Server 2005 Indexes 317 10 ...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780672329562/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    FileMaker 9 developer reference : functions, scripts, commands, and grammars, with extensive custom function examples (2007)
    Indianapolis, Ind. : Que Pub. | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780789737083 , 0789737086
    Language: English
    Keywords: FileMaker (Computer file) ; Database management ; Electronic books ; local
    Abstract: Maybe you know FileMaker, and you have used it for years, but need a quick reference, immediately accessible while not interrupting your work on screen. This is the only book on the market expressly focused on describing each calculation formula and how and when to use each! Filled with real-world, concrete examples, this book is an invaluable companion to readers working to develop solutions to their every day software problems. Contains hundreds of calculation functions, script steps, and operations that will appeal to every FileMaker user, new and old.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780789737083/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Microsoft Office Access 2007 security (2007)
    [Indianapolis, Ind.] : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780768668544 , 0768668549
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Web Online Copy Access 2007 security is extremely different than that of its predecessors. For example, Access 2007 security eliminates user-level security. These changes to security have major implications for the applications built by an organization's employees. This Short Cut covers new topics such as using an Access 2007 database in a trusted location, encrypting in Access 2007, and packaging, signing, and distributing an Access 2007 database. It also covers how security works with databases created in other versions of Access. Finally, it covers the process of running unsafe expressions. All of these topics are vital for securing and successfully working with an Access 2007 database. Learn what's new in Access 2007 security Find out how security applies to databases stored in one of the older file formats Get to know the Trust Center Learn how to package and sign a database Discover how easy it is to place a database in a Trusted Location Explore the new encryption feature in Access 2007 Table of Contents Why This Short Cut Is Important What's New in Access 2007 Security? What Happened to User-Level Security? Trusting a Database Using a Database Password to Encrypt an Office Access 2007 Database Packaging, Signing, and Distributing an Access Database Using the Trust Center Understanding How Databases Behave When Trusted and Untrusted Working in Sandbox Mode Removing User-Level Security Enabling or Disabling ActiveX Controls Enabling or Disabling Add-ins Adding a Trusted Publisher Practice Examples: Securing an Access 2007 Database
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768668544/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Understanding Oracle Clinical (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596550059 , 0596550057
    Language: English
    Keywords: Oracle (Computer file) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: This Short Cut is written to assist you, an Oracle Clinical Developer, with many of the tasks and decisions you may encounter on an occasional basis. These tasks involve study setup and maintenance, account maintenance, handling discrepancies, preparing data sets for analysis, batch-loading data, altering system-level settings and defining standard processes. A working knowledge of screen setup and procedure coding is assumed. Remote Data Capture (RDC), which moves data entry from the CRO or pharmaceutical company to the sites, is fast becoming the preferred way to gather and clean data for clinical trails. Thus, RDC, in either Classic or PDF form is frequently discussed here; however, occasionally traditional OC data entry methods will be noted. Ideally, you will have a general programming background as well as a strong knowledge of clinical trials and PL/SQL.
    URL: https://learning.oreilly.com/library/view/-/9780596550059/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    Filemaker Pro 9 : the missing manual (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596514136 , 0596514131
    Language: English
    Pages: xx, 778 p , ill. , 24 cm
    Edition: 1st ed.
    Keywords: FileMaker pro ; Database management ; Electronic books ; local
    Abstract: FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto. The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual , you can: Get your first database running in minutes and perform basic tasks right away. Catalog people, processes and things with streamlined data entry and sorting tools. Learn to use layout tools to organize the appearance of your database. Use your data to generate reports, correspondence and other documents with ease. Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need. Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas. Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language. Protect your database with passwords and set up privileges to determine what others can do once they gain entry. Outfit your database for the Web and import and export data to other formats. Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596514136/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Microsoft Office Access 2007 step by step (2007)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780735623033 , 0735623031
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Build databases from scratch or from templates Exchange data with other databases and Office documents Create forms to simplify data entry Use filters and queries to find and analyze information Design rich reports that help make your data meaningful Help prevent data corruption and unauthorized access Your all-in-one learning experience includes: Files for building skills and practicing the book's lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference-plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735623033/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Alison Balter's mastering Microsoft Office Access 2007 development (2007)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780672329326 , 0672329328
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well. Introduction Part I The Basics of Access Development 1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75 3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137 5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189 6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269 7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315 8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345 9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401 10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493 12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . ...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780672329326/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    MySQL pocket reference (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596514266 , 0596514263
    Language: English
    Edition: 2nd ed.
    Keywords: MySQL (Electronic resource) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: How to configure MySQL, such as setting the root password MySQL data types, including numerics, strings, dates, and complex types SQL syntax, commands, data types, operators, and functions Arithmetic, comparison and logical operators Aggregate and general functions Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596514266/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    SQL server integration services (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596513757 , 0596513755
    Language: English
    Keywords: SQL server ; Database management ; Data warehousing ; Electronic books ; local
    Abstract: SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources. This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS). Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios. Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.
    URL: https://learning.oreilly.com/library/view/-/9780596513757/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    Microsoft SQL server 2005 unleashed (2007)
    Indianapolis, Ind. : Sams Pub. | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0672328240 , 9780672328244
    Language: English
    Keywords: SQL server ; Database management ; Electronic books ; local
    Abstract: Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you'll find in the product manuals, providing in-depth information derived from the authors' real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services. Detailed information on... Installing, upgrading, and administering SQL Server 2005 Database maintenance, backup, and recovery Creating and managing tables, views, stored procedures, triggers, and user-defined functions Database and index design SQL Server query optimization, and performance monitoring and tuning Transactions, transaction management, and distributed transactions SQL Server Management Studio-NEW! SQL Server Notification Services; Integration Services-NEW!; Analysis Services; Reporting Services-NEW!; Web Services-NEW! SQL Server Service Broker-NEW! SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers-NEW! SQL Server high availability and SQL Server clustering and replication Database Mirroring-NEW! Database Snapshots-NEW! Using XML in SQL Server 2005 SQL Server tools and utilities CD-ROM includes 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search Code samples, scripts, and sample databases A PDF version of the entire book Introduction Part I Welcome to Microsoft SQL Server 1 SQL Server 2005 Overview 2 What's New in SQL Server 2005 Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 4 SQL Server Command-Line Utilities 5 SQL Server Profiler Part III SQL Server Administration 6 SQL Server System and Database Administration 7 Installing SQL Server 2005 8 Upgrading to SQL Server 2005 9 Client Installation and Configuration 10 Security and User Administration 11 Database Backup and Restore 12 Database Mail 13 SQL Server Scheduling and Notification 14 SQL Server High Availability. 15 Replication 16 Database Mirroring 17 SQL Server Clustering Part IV...
    URL: https://learning.oreilly.com/library/view/-/0672328240/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 11
    Online Resource
    Online Resource
    Microsoft Office Access 2007 inside out (2007)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780735623255 , 0735623252
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2007-and challenge yourself to new levels of mastery! Create tables that support your database design strategy Import and link to data from spreadsheets, text files, databases, and other ODBC data sources Build simple to complex queries to manipulate data Learn advanced techniques for building and customizing user interface forms Design attractive reports to calculate and analyze large sets of data Automate your application with Microsoft Visual Basic(R) for Applications Customize the Office Fluent Ribbon Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications CD includes: Fully searchable eBook-plus bonus chapters Sample database applications-including query, form, and report examples Articles from the experts: designing databases, understanding SQL, exporting data, and more Links to demos, blogs, and user communities References for finding Access 2003 commands in Access 2007 Windows Vista(R) Product Guide eReference and other eBooks For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735623255/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 12
    Online Resource
    Online Resource
    Microsoft Office Access 2007 plain & simple (2007)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780735622920 , 0735622922
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Get the fast facts that make learning Microsoft Office Access 2007 plain and simple! This no-nonsense guide uses easy numbered steps and concise, straightforward language that show the most expedient ways to learn a skill or solve a problem.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735622920/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 13
    Online Resource
    Online Resource
    Microsoft SQL server 2005 integration services step by step (2007)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780735624054 , 0735624054
    Language: English
    Keywords: SQL server ; Database management ; Application software ; Information resources management ; Systems integration ; Electronic books ; local
    Abstract: Teach yourself the fundamentals of SQL Server Integration Services-one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data-and build solutions that support your business intelligence needs. Discover how to: Design and execute packages that transform data between files and relational databases Configure connection managers to access other data sources Create data flows that alter, split, match, and merge data Develop event-handlers and monitor package performance Encrypt sensitive information and control access to packages Customize script code to automate Control Flow and Data Flow tasks Debug, troubleshoot, and optimize packages CD features: All practice exercises Sample databases Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/9780735624054/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 14
    Online Resource
    Online Resource
    SQL injection defenses (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596529642 , 0596529643
    Language: English
    Keywords: SQL server ; Database management ; Data transmission systems ; Client/server computing ; Electronic books ; local
    Abstract: This Short Cut introduces you to how SQL injection vulnerabilities work, what makes applications vulnerable, and how to protect them. It helps you find your vulnerabilities with analysis and testing tools and describes simple approaches for fixing them in the most popular web-programming languages. This Short Cut also helps you protect your live applications by describing how to monitor for and block attacks before your data is stolen. Hacking is an increasingly criminal enterprise, and web applications are an attractive path to identity theft. If the applications you build, manage, or guard are a path to sensitive data, you must protect your applications and their users from this growing threat.
    URL: https://learning.oreilly.com/library/view/-/9780596529642/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 15
    Online Resource
    Online Resource
    Microsoft Office Access 2007 : forms, reports, and queries (2007)
    Indianapolis, Ind. : Que Pub. | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780789736697 , 0789736691
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: "Everything you need to master Access 2007 forms, reports, and queries." -Charles Carr, Reviews Editor, ComputorEdge Magazine Create Forms for Business Ensure Data Entry Accuracy Build Elegant Form Interfaces Collect Data Via Email Design Effective Business Reports Make an Invoice Report Create Mailing Labels Extract Data Work with Multiple Tables Calculate Discounts Analyze Data Develop your Microsoft Access expertise instantly with proven techniques Let's face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you're forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions. This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power. · Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries. · Avoids database theory in favor of practical know-how that you can put to use right away. · Packed full of real-world examples and techniques to help you learn and understand the importance of each section. · Covers what's new and changed in Microsoft Access 2007. Introduction Part I: Creating Forms Chapter 1 Creating and Using a Form Chapter 2 Working with Form Controls Chapter 3 Designing Forms for Efficient and Accurate Data Entry Chapter 4 Designing Forms for Business Use Chapter 5 Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6 Creating and Publishing a Report Chapter 7 Designing Effective Business Reports Chapter 8 Designing Advanced Reports Chapter 9 Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10 Creating a Basic Query Chapter 11 Building Criteria Expressions Chapter 12...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780789736697/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 16
    Online Resource
    Online Resource
    Microsoft SQL server 2005 compact edition (2007)
    Indianapolis, Ind. : Sams Pub. | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780672329227 , 0672329220
    Language: English
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: SQL Server Compact Edition is a slimmed down version of SQL Server that you can use on Pocket PCs, Smart phones, Tablet PCs, and Desktops. With this book, you will learn how to build applications for resource constrained devices. You'll discover how the SQL Server Compact Edition database can also be used as an embedded in-proc database for desktop-based applications. You'll learn how to manage the SQL Server Compact Edition database using SQL Server Management Studio, Visual Studio, and Query Analyzer. Laptops, Tablet PCs, and mobile devices enable information workers to access enterprise data from remote locations. With the step-by-step exercises provided in this book, you'll learn how to synchronize data between SQL Server and SQL Server Compact Edition. You'll also learn Remote Data Access-a lightweight method to exchange data between SQL Server and SQL Server Compact Edition. Also in this book are code samples to help you write database applications for mobile devices and for desktop PCs. Throughout the book you'll find expert tips for building and deploying enterprise applications. Understand how to... Build mobile and desktop applications using SQL Server Compact Edition Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition Optimize performance and plan for security Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access Introduction 1 1 Getting Started with SQL Server 2005 Compact Edition 7 2 Platform Support and Installation35 3 Getting to Know the Tools 63 4 Managing the SQL Server 2005 Compact Edition Database 109 5 Defining Database Structure 131 6 Manipulating the Database 175 7 Programming SQL Server 2005 Compact Edition with ADO.NET 205 8 Introducing Native Access 247 9 Using Operators in SQL Server 2005 Compact Edition 279 10 Using the Built-In Functions 295...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780672329227/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 17
    Online Resource
    Online Resource
    Microsoft Office Access 2007 on demand (2006)
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0789736411 , 9780789736413
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Microsoft Office Access 2007 For those who would rather be shown how than told how See How To Create databases more efficiently using a new results-oriented interface Use tools for building a database 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 Discover ways to prevent data corruption and unauthorized access Share your data with others through interactive web pages Put your newly acquired skills to work using the online workshops Organize information and add impact with clip art, SmartArt diagrams, tables, and charts Use Groove and SharePoint Team Services to collaborate and share documents and information Prepare for the Microsoft Certified Application Specialist (MCAS) exam On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com Author Bio Perspection has written and produced books on a variety of computer software-including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks-and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com. Category Database Covers Microsoft Office Access 2007 User Level Beginning-Intermediate 1 Getting Started with Access 2 Touring Access Databases 3 Planning and Creating a Custom Database 4 Working with Fields 5 Working with Tables 6 Locating Specific Information Using a Query 7 Simplifying Data Entry with Forms 8 Creating Reports to Convey Information 9 Improving the Appearance of Forms and Reports 10 Working on the Web 11 Importing and Exporting Information 12 Managing a Database 13 Prote...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0789736411/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 18
    Online Resource
    Online Resource
    FileMaker 8 functions and scripts desk reference (2006)
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0789735113
    Language: English
    Pages: 456 p
    Keywords: FileMaker pro ; Database management ; Electronic books ; local
    Abstract: FileMaker 8 Functions and Scripts Desk Reference is the only book on the market expressly focused on describing each calculation formula and how and when to use each one. With this book's real-world, concrete examples of how to use each function, you will go far beyond FileMaker 8's help system. Just as a dictionary helps supplement one's memory, this book is an invaluable companion to users working to develop solutions to their every day software problems.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0789735113/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 19
    Online Resource
    Online Resource
    Creating a database in Filemaker Pro 8.5 (2006)
    Berkeley, Calif. : Peachpit Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780321502902 , 0321502906
    Language: English
    Keywords: FileMaker pro ; Database management ; Electronic books ; local
    Abstract: If you want to make a great-looking, practical database fast but don't want to get bogged down with the details, then you need a Visual Quic kProject Guide! If you've never created a database before, the task can be daunting. Recognizing that you don't necessarily want or need to know about every FileMaker Pro 8.5 feature, this low-priced, compact guide is the quickest route to creating a functional, organized database. Whether you're a small business owner looking for a better way to track inventory and invoices, someone just looking for a streamlined way to keep track of your contacts, or your boss simply needs a project database, this book covers the FileMaker Pro 8.5 basics, including the new Web Viewer, with full-color illustrations and step-by-step instructions to help you get your project done quickly.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780321502902/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 20
    Online Resource
    Online Resource
    MySQL stored procedure programming (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596100892
    Language: English
    Pages: 636 p , ill.
    Keywords: SQL (Computer program language) ; Database management ; Electronic books ; local
    Abstract: The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without. In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use. MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise. In MySQL Stored Procedure Programming , they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET) Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices A companion web site contains many thousands of lines of code, that youcan put to use immediately. Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming , the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database develo...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596100892/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 21
    Online Resource
    Online Resource
    SQL server 2005 distilled (2006)
    Upper Saddle River, N.J. : Addison Wesley Professional | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0321349792
    Language: English
    Pages: 336 p
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using, or administering Microsoft's latest enterprise database? Need to understand what's new in SQL Server 2005, and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you need-quickly, clearly, and objectively. Former SQL Server team member Eric L. Brown offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more. Brown draws on his extensive experience consulting with enterprise users, outlining realistic usage scenarios that leverage SQL Server 2005's strengths and minimize its limitations. Coverage includes Architectural overview: how SQL Server 2005's features work together and what it means to you Security management, policies, and permissions: gaining tighter control over your data SQL Server Management Studio: Microsoft's new, unified tool suite for authoring, management, and operations Availability enhancements: online restoration, improved replication, shorter maintenance/recovery windows, and more Scalability improvements, including a practical explanation of SQL Server 2005's complex table partitioning feature Data access enhancements, from ADO.NET 2.0 to XML SQL Server 2005's built-in .NET CLR: how to use it, when to use it, and when to stay with T-SQL Business Intelligence Development Studio: leveraging major improvements in reporting and analytics Visual Studio integration: improving efficiency throughout the coding and debugging process Simple code examples demonstrating SQL Server 2005's most significant new features
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0321349792/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 22
    Online Resource
    Online Resource
    SQL pocket guide (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596526887 , 0596526881
    Language: English
    Edition: 2nd. ed.
    Keywords: SQL (Computer program language) ; Relational databases ; Database management ; Electronic books ; local
    Abstract: SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596526887/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 23
    Online Resource
    Online Resource
    Backup & recovery (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596102461 , 9780596102463
    Language: English
    Keywords: Electronic data processing ; Backup processing alternatives ; Data recovery (Computer science) ; Database management ; Electronic books ; local
    Abstract: Packed with practical, freely available backup and recoverysolutions for Unix, Linux, Windows, and Mac OS X systems -- as wellas various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revisedand expanded with over 75% new material. Backup & Recovery starts with a complete overview ofbackup philosophy and design, including the basic backup utilitiesof tar, dump, cpio, ntbackup, ditto, and rsync. It then explainsseveral open source backup products that automate backups usingthose utilities, including AMANDA, Bacula, BackupPC, rdiff-backup,and rsnapshot. Backup & Recovery then explains how toperform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris,VMWare, & Windows systems using freely-available utilities. Thebook also provides overviews of the current state of the commercialbackup software and hardware market, including overviews of CDP,Data De-duplication, D2D2T, and VTL technology. Finally, it covershow to automate the backups of DB2, Exchange, MySQL, Oracle,PostgreSQL, SQL-Server, and Sybase databases - without purchasing acommercial backup product to do so. For environments of all sizes and budgets, this unique bookshows you how to ensure data protection without resorting toexpensive commercial solutions. You will soon learn to: Automate the backup of popular databases without a commercialutility Perform bare metal recovery of any popular open systemsplatform, including your PC or laptop Utilize valuable but often unknown open source backupproducts Understand the state of commercial backup software, includingexplanations of CDP and data de-duplication software Access the current state of backup hardware, including VirtualTape Libraries (VTLs)
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596102461/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 24
    Online Resource
    Online Resource
    Learning SQL on SQL Server 2005 (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596102151
    Language: English
    Pages: 342 p
    Keywords: SQL server ; SQL (Computer program language) ; Database design ; Database management ; Electronic books ; local
    Abstract: Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005's settings and about SQL Server 2005's functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596102151/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 25
    Online Resource
    Online Resource
    FileMaker Pro design & scripting for dummies (2006)
    Hoboken, N.J. : Wiley | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780471786481 , 0471786489
    Language: English
    Pages: xvi, 360 p , ill. , 24 cm
    Keywords: FileMaker pro ; Database design ; Database management ; Electronic books ; local
    Abstract: Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to Build a layout that works Create custom triggers and calculated fields Generate reports automatically Manage security Publish your database on the Web Embed pictures, sound, and video
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780471786481/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 26
    Online Resource
    Online Resource
    Integrating Microsoft Office Access 2007 and Microsoft Sharepoint Server 2007 (2006)
    [Indianapolis, Ind.] : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780768668513 , 0768668514
    Language: English
    Keywords: Microsoft Access ; Microsoft SharePoint (Computer file) ; Database management ; Intranets (Computer networks) ; Web servers ; Electronic books ; local
    Abstract: Access 2007 is tightly integrated with SharePoint. This Short Cut provides readers with everything that they need to know about working with Access 2007 and SharePoint. Topics covered include why SharePoint is important to an Access 2007 developer, how to move your database to a SharePoint site, and how to open and work with SharePoint lists from within Access 2007. It also covers how to integrate with the SharePoint workflow, how to work with SharePoint services off-line, and how to map Access data to SharePoint data. All of these topics are necessary when integrating Access 2007 and SharePoint. Alison Balter has been writing about Access since Access 95. She has written eight books, co-authored two books on Access, and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95 , Alison Balter's Mastering Access 95 Development , Alison Balter's Mastering Access 97 Development , Access 97 Unleashed , Alison Balter's Mastering Access 2000 Development , Alison Balter's Mastering Access 2002 Desktop Development , Alison Balter's Mastering Access 2002 Enterprise Development , Alison Balter's Mastering Office Access 2003 Development , Access 2003 In-a-Snap , Access 2003 in 24 Hours , SQL Server Express in 24 Hours . Alison has over 13 years of practical experience working with Access and Access applications. Her clients' projects range from small end-user projects through enterprise-wide applications. Clients include Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild. Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada. Table of Contents Section 1: What is SharePoint Server 2007 and Why Integrate It With Your Access Applications? Section 2: The Access 2007 (accdb) File Format and SharePoint Section 3: Exporting Data to a SharePoint Site Section 4: Publishing Data to a SharePoint Site Section 5: Opening Access Forms and Reports from a SharePoint Site Section 6: Linking to and Importing from SharePoint Lists Section 7: Taking SharePoint Lists Offline with Access Section 8: The Basics of Working with SharePoint Section 9: Re-establishing Links When a SharePoint Site has been Moved Section 10: Modifying the Design of ...
    URL: https://learning.oreilly.com/library/view/-/9780768668513/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 27
    Online Resource
    Online Resource
    What's new in Microsoft Office Access 2007? (2006)
    [Indianapolis, Ind.] : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0768668506 , 9780768668506
    Language: English
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Microsoft Office Access 2007 includes a plethora of new features that could prove difficult to find for even seasoned users of previous versions of Access. Alison Balter's What's New in Microsoft Office Access 2007? includes a discussion of all the new features in Access 2007, providing details and practical examples on the use of each feature. Her teaching style is clear and succinct, providing you with a great jump-start to working with Access 2007. The topics covered include what's new with tables, the new and improved embedded macros, and what's new with importing and exporting. Table of Contents Section 1 What's New with the User Interface? Section 2 Exploring the New Database Templates Section 3 What's New with Tables? Section 4 What's New in Datasheet View? Section 5 What's New in Forms? Section 6 What's New in Reports? Section 7 The New and Improved Embedded Macros Section 8 The New and Improved Help Viewer Section 9 What's New in Importing and Exporting? Section 10 Access 2007 and Outlook 2007 Integration Section 11 What Else Is New with Microsoft Office Access 2007? Section 12 Additional Tips and Tricks Alison Balter has been writing about Access since Access 95. She has written eight books and co-authored two books on Access and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95 , Alison Balter's Mastering Access 95 Development , Alison Balter's Mastering Access 97 Development , Access 97 Unleashed , Alison Balter's Mastering Access 2000 Development , Alison Balter's Mastering Access 2002 Desktop Development , Alison Balter's Mastering Access 2002 Enterprise Development , Alison Balter's Mastering Office Access 2003 Development , Access 2003 In-a-Snap , Access 2003 in 24 Hours , and SQL Server Express in 24 Hours . Alison has more than 13 years of practical experience working with Access and Access applications. Her clients' projects range from small end-user projects through enterprisewide applications. Clients include the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild. Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada.
    URL: https://learning.oreilly.com/library/view/-/0768668506/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 28
    Online Resource
    Online Resource
    MySQL cookbook (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 059652708X , 9780596527082
    Language: English
    Edition: 2nd ed.
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well. Other recipes in the book teach you to: Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.
    Note: "Includes Ruby examples.". - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/059652708X/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 29
    Online Resource
    Online Resource
    Essential CVS (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596527039 , 9780596527037
    Language: English
    Edition: 2nd ed.
    Keywords: CVS ; Database management ; Computer software ; Development ; Electronic books ; local
    Abstract: This easy-to-follow reference shows a variety of professionals how to use the Concurrent Versions System (CVS), the open source tool that lets you manage versions of anything stored in files. Ideal for software developers tracking different versions of the same code, this new edition has been expanded to explain common usages of CVS for system administrators, project managers, software architects, user-interface (UI) specialists, graphic designers and others. Current for version 1.12, Essential CVS , 2nd Edition offers an overview of CVS, explains the core concepts, and describes the commands that most people use on a day-to-day basis. For those who need to get up to speed rapidly, the book's Quickstart Guide shows you how to build and use a basic CVS repository with the default settings and a minimum of extras. You'll also find: A full command reference that details all aspects of customizing CVS for automation, logging, branching, merging documents, and creating alerts Examples and descriptions of the most commonly used options for each command Why and when to tag or branch your project, tagging before releases, and using branching to create a bugfix version of a project Details on the systems used in CVS to permit multiple developers to work on the same project without loss of data An entire section devoted to document version management and project management includes ways to import and export projects, work with remote repositories, and shows how to fix things that can go wrong when using CVS. You'll find more screenshots in this edition as well as examples of using graphical CVS clients to run CVS commands. Essential CVS also includes a FAQ that answers common queries in the CVS mailing list to get you up and running with this system quickly and painlessly.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596527039/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 30
    Online Resource
    Online Resource
    Essential Microsoft Operations Manager (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009534
    Language: English
    Pages: 380 p
    Keywords: Client/server computing ; Database management ; Computer networks ; Electronic books ; local
    Abstract: For system administrators, ensuring that all Windows servers are performing optimally is a tall order. The larger the enterprise, the greater the chance for irritating, time-consuming configuration problems. Sometimes, you can determine the root cause of the problem yourself-but that's only if you're lucky. With Microsoft Operations Manager (MOM), the diagnosis is done for you. MOM monitors server operations and automatically notifies you of problems by sending an immediate alert to your console, email address, or pager. To help you better understand how MOM works, O'Reilly presents Essential Microsoft Operations Manager . The goal of this comprehensive tutorial is to give first-time MOM administrators a solid foundation for planning, implementing, and administering MOM 2005. Author Chris Fox, a renowned MOM expert, offers the type of practical, real-world advice that you need to improve the performance of your IT infrastructure. After taking you through the entire process of setting up MOM on the network, the book moves on to more advanced administration issues. It carefully instructs you how to program and automate MOM and the agents that reside on the servers themselves. You'll also learn how to manage the scripts that determine which server agents are relevant to report. By capturing system data, intelligently analyzing it, and then notifying you with a suggested course of action, MOM makes extinguishing fires a breeze. And now, thanks to Essential Microsoft Operations Manager , learning how to use MOM is a breeze, too.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596009534/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 31
    Online Resource
    Online Resource
    Learning MySQL (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596008643 , 9780596008642
    Language: English
    Keywords: MySQL (Electronic resource) ; PHP (Computer program language) ; SQL (Computer program language) ; Database management ; Web databases ; Electronic books ; local
    Abstract: Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season? MySQL, the most popular open-source database, offers the power ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data. After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security. Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using thePHP and Perl programming languages The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies. Whether you've never touched a database or have already completedsome MySQL projects, you'll find insights in Learning MySQL that will last a career.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 32
    Online Resource
    Online Resource
    SQL server 2005 practical troubleshooting : the database engine (2006)
    Boston, Mass. : Pearson | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0321447743 , 9780321447746
    Language: English
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: Never-Before-Published Insiders' Information for Troubleshooting SQL Server 2005. This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru's Guides to SQL Server, has assembled a "dream team" of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft's own source code. From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You'll find comprehensive, in-depth chapters on • Waiting and blocking • Data corruption and recovery • Memory • Procedure cache issues • Query processing • Server crashes and other critical failures • Service Broker • SQLOS and scheduling • tempdb • Clustering This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Web developers alike. Contents About the Authors ix Preface xii Acknowledgments xiv 1 Waiting and Blocking Issues 1 2 Data Corruption and Recovery Issues 47 3 Memory Issues 137 4 Procedure Cache Issues 183 5 Query Processor Issues 225 6 Server Crashes and Other Critical Failures 273 7 Service Broker Issues 331 8 SQLOS and Scheduling Issues 369 9 Tempdb Issues 411 10 Clustering Issues 425 The Aging Champion 441 Index 445
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0321447743/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 33
    Online Resource
    Online Resource
    Understanding DB2 9 security (2006)
    Upper Saddle River, N.J. : IBM Press | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0131345907 , 9780131345904
    Language: English
    Keywords: IBM Database 2 ; Database security ; Database management ; Electronic books ; local
    Abstract: Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security. This book's material is organized to support you through every step of securing DB2 in Windows®, Linux®, or UNIX® environments. You'll start by exploring the regulatory and business issues driving your security efforts, and then master the technological and managerial knowledge crucial to effective implementation. Next, the authors offer practical guidance on post-implementation auditing, and show how to systematically maintain security on an ongoing basis. Coverage includes Establishing effective security processes, teams, plans, and policies Implementing identification and authentication controls, your first lines of defense DB2 in Windows environments: managing the unique risks, leveraging the unique opportunities Using the new Label Based Access Control (LBAC) of DB2 9 to gain finer-grained control over data protection Encrypting DB2 connections, data "in flight," and data on disk: step-by-step guidance Auditing and intrusion detection: crucial technical implementation details Using SSH to secure machine-to-machine communication in DB2 9 multi-partitioned environments Staying current with the latest DB2 security patches and fixes
    Note: "DB2, information management software.". - Includes index
    URL: https://learning.oreilly.com/library/view/-/0131345907/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 34
    Online Resource
    Online Resource
    Oracle PL/SQL programming (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009771
    Language: English
    Pages: 1198 p
    Edition: 4th ed.
    Keywords: Oracle (Computer file) ; SQL/ORACLE (Computer program language) ; Database management ; Electronic books ; local
    Abstract: For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10 g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
    Note: Includes index and errata
    URL: https://learning.oreilly.com/library/view/-/0596009771/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 35
    Online Resource
    Online Resource
    Integrating Excel and Access (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009739
    Language: English
    Pages: 232 p , ill.
    Keywords: Microsoft Excel (Computer file) ; Microsoft Access ; Database management ; Electronic books ; local
    Abstract: In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing Integrating Excel and Access , the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to: Utilize the built in features of Access and Excel to access data Use VBA within Access or Excel to access data Build connection strings using ADO and DAO Automate Excel reports including formatting, functions, and page setup Write complex functions and queries with VBA Write simple and advanced queries with the Access GUI Produce pivot tables and charts with your data With Integrating Excel and Access , you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596009739/?ar
    URL: Inhaltstext
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 36
    Online Resource
    Online Resource
    SQL cookbook (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009763
    Language: English
    Pages: 628 p
    Keywords: SQL (Computer program language) ; Database management ; Electronic books ; local
    Abstract: You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook , experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set Bucketization , and why you should never use that term in Brooklyn. How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques The technique of walking a string , which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 37
    Online Resource
    Online Resource
    Learning SQL (2005)
    Sebastopol, Calif. : O'Reilly Media | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596007272
    Language: English
    Pages: xiii, 289 p
    Keywords: SQL (Computer program language) ; Database design ; Database management ; Electronic books ; local
    Abstract: SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL , an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized database SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints How data sets can interact with queries The importance of subqueries Data conversion and manipulation via SQL's built-in functions How conditional logic can be used in Data Statements Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL. Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0596007272/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 38
    Online Resource
    Online Resource
    Access for starters : the missing manual (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596006659
    Language: English
    Pages: 396 p
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet--but not get in over your head--and Access 2003 for Starters: The Missing Manual is the book to make it happen. Far more than a skimpy introduction but much less daunting than a weighty tech book, Access 2003 for Starters: The Missing Manual demystifies databases and explains how to design and create them with ease. It delivers everything you need--and nothing you don't--to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers. Access is sophisticated and powerful enough for professional developers but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports. Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly. Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
    Note: Includes index and errata
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 39
    Online Resource
    Online Resource
    MySQL crash course (2005)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0672327120
    Language: English
    Pages: 336 p
    Keywords: MySQL (Electronic resource) ; Database management ; Electronic books ; local
    Abstract: MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, full text search, and much more Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and Cursors Manage transactional processing Create user accounts and manage security via access control Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit , and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes , as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672327120/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...