Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Databases & Reporting Tools


61. 

Access-VBA: 600 Top-Makrolösungen von Access 2000 bis 2010

Access-VBA: 600 Top-Makrolösungen von Access 2000 bis 2010

By: Bernd Held

Publisher: Markt+Technik Verlag

Publication Date: 30-SEP-2010

Insert Date: 02-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

So lernen Sie, Makros mit VBA zu bauen, so setzen Sie diese Makros in Microsoft Access ein (Versionen 2000 bis 2010)! Das Kompendium listet auf, erklärt und realisiert an zahllosen kleinen Beispielen, was Sie alles mit Access und VBA anfangen können. Noch der erfahrenste Access-Nutzer erzielt so beachtliche Ergebnisse. Sie wollen die VBA-Programmierung lernen und in Access Makros einsetzen, nicht erst Theorie pauken. Dem entspricht der Buchaufbau: Zunächst finden Sie das Problem, dann das Listing mit Erklärungen und Varianten – insgesamt 600 professionelle Makros für alle Einsatzbereiche in...

62. 

Das große Excel-Handbuch für Controller, komplett in Farbe: Professionelle Lösungen für Excel 2010, 2007, 2003, komplett in Farbe

Das große Excel-Handbuch für Controller, komplett in Farbe: Professionelle Lösungen für Excel 2010, 2007, 2003, komplett in Farbe

By: Ignatz Schels; Uwe M. Seidel

Publisher: Markt+Technik Verlag

Publication Date: 10-NOV-2010

Insert Date: 15-JAN-2012

Slots: 1.0

Table of Contents • Start Reading

Der Bestseller für Controller. Professionelle Excel-Lösungen zu den vielschichtigen Aufgaben in Controlling und Finanzwesen. Dieses Handbuch geht dabei nicht von den unzähligen Excel-Funktionen aus, sondern stellt die Controlling-Themen in den Mittelpunkt und ist auch danach gegliedert.Die Entwicklung einer Lösung wird Schritt für Schritt aufgezeigt, so dass sie leicht nachvollziehbar ist. Die Themen reichen von einfachen Formularen und Arbeitshilfen bis hin zu komplexen, makrounterstützten Prozess-Steuerungen (z. B. Kennzahlen für Balanced Scorecard). Das Buch ist für alle Excelversionen...

63. 

GNU Octave

GNU Octave

By: Jesper Schmidt Hansen;

Publisher: Packt Publishing

Publication Date: 21-JUN-2011

Insert Date: 30-DEC-2011

Slots: 1.0

Table of Contents • Start Reading

"Become a proficient Octave user by learning this high-level scientific numerical tool from the ground up The easiest way to use GNU Octave's power and flexibility for data analysis Work with GNU Octave's interpreter – declare and control mathematical objects like vectors and matrices Rationalize your scripts and control program flow Extend GNU Octave and implement your own functionality Get to know the vast built-in functionality that GNU Octave has to offer Build your own GNU Octave toolbox package to solve complex problems Learn Octave the simple way, with...

64. 

JIRA Development Cookbook

JIRA Development Cookbook

By: Jobin Kuruvilla;

Publisher: Packt Publishing

Publication Date: 24-NOV-2011

Insert Date: 19-DEC-2011

Slots: 1.0

Table of Contents • Start Reading

"Develop and customize plugins, program workflows, work on custom fields, master JQL functions, and more - to effectively customize, manage, and extend JIRA with this book and ebookExtend and Customize JIRA--Work with custom fields, workflows, Reports & Gadgets, JQL functions, plugins, and moreCustomize the look and feel of your JIRA User Interface by adding new tabs, web items and sections, drop down menus, and moreMaster JQL - JIRA Query Language that enables advanced searching capabilities through which users can search for issues in their JIRA instance and then exploit all the...

65. 

Data Analysis Microsoft® with Access® 2010: From Simple Queries to Business Intelligence

Data Analysis Microsoft® with Access® 2010: From Simple Queries to Business Intelligence

By: Larry Rockoff

Publisher: Course Technology PTR

Publication Date: 01-NOV-2011

Insert Date: 06-NOV-2011

Slots: 1.0

Table of Contents • Start Reading

DATA ANALYSIS WITH MICROSOFT ACCESS 2010 is an introduction to Access with an emphasis on topics relevant to data analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. Access queries are covered in detail, both in terms of the mechanics of their design, and how they can be used for typical data analysis tasks. The book is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won't need to sit with a computer as you read the book. The...

66. 

Access 2010: Advanced, Student Manual

Access 2010: Advanced, Student Manual

By: Axzo Press

Publisher: Axzo Press

Publication Date: 15-APR-2011

Insert Date: 19-OCT-2011

Slots: 1.0

Table of Contents • Start Reading

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For...

67. 

Access 2010: Intermediate, Student Manual

Access 2010: Intermediate, Student Manual

By: Axzo Press

Publisher: Axzo Press

Publication Date: 15-APR-2011

Insert Date: 19-OCT-2011

Slots: 1.0

Table of Contents • Start Reading

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam...

68. 

Access 2010: Basic, Instructor's Edition

Access 2010: Basic, Instructor's Edition

By: Axzo Press

Publisher: Axzo Press

Publication Date: 22-APR-2011

Insert Date: 19-OCT-2011

Slots: 1.0

Table of Contents • Start Reading

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive...

69. 

Access 2010: Basic, Student Manual

Access 2010: Basic, Student Manual

By: Axzo Press

Publisher: Axzo Press

Publication Date: 22-APR-2011

Insert Date: 19-OCT-2011

Slots: 1.0

Table of Contents • Start Reading

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive...

70. 

Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

By: Jacek Artymiak

Publisher: Apress

Publication Date: 05-SEP-2011

Insert Date: 06-SEP-2011

Slots: 1.0

Table of Contents • Start Reading

OpenOffice Calc is the most powerful and widespread open source spreadsheet application in existence. It is the only real alternative to Excel. Jacek Artymiak is widely regarded as the authority on OpenOffice Calc. He takes you, step by step, from the interface and handling Calc files to working with data sources small and large. Artymiak then extends the reader's skillset to data visualization, writing complex formulas and performing statistical analysis. Beginning OpenOffice Calc allows you to gain confidence in the considered use of statistical formulas, but does not assume familiarity...

71. 

Microsoft® Access® 2010 24-Hour Trainer

Microsoft® Access® 2010 24-Hour Trainer

By: 

Publisher: Wrox

Publication Date: 21-JUN-2011

Insert Date: 28-JUL-2011

Slots: 1.0

Table of Contents • Start Reading

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...

72. 

Practical JIRA Plugins

Practical JIRA Plugins

By: ; Jonathan Doklovic

Publisher: O'Reilly Media, Inc.

Publication Date: 26-JUL-2011

Insert Date: 23-JUL-2011

Slots: 1.0

Table of Contents • Start Reading

JIRA is widely used as a product and bug tracking system, particularly in the Java world, but also in many other environment. However, it's a large open source project, for which setup and management can be tricky. This book shows you how to develop plugins that extend JIRA's functionality....

73. 

Practical JIRA Administration

Practical JIRA Administration

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 03-JUN-2011

Insert Date: 27-MAY-2011

Slots: 1.0

Table of Contents • Start Reading

If you're familiar with JIRA for issue tracking, bug tracking, and other uses, you know it can sometimes be tricky to set up and manage. In this concise book, software toolsmith Matt Doar answers difficult and frequently-asked questions about JIRA administration, and shows you how JIRA is intended to be used....

74. 

QuickBooks 2011: The Missing Manual

QuickBooks 2011: The Missing Manual

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 01-NOV-2010

Insert Date: 30-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

With QuickBooks 2011: The Missing Manual, you don't just learn how to use this popular program, you learn why and when to use specific features. You also get basic accounting advice so that everything makes sense along the way. Get more out of QuickBooks 2011, whether you're a beginner or an old pro....

75. 

Analyzing Social Media Networks with NodeXL: Insights from a Connected World

Analyzing Social Media Networks with NodeXL: Insights from a Connected World

By: Derek Hansen; Ben Shneiderman; Marc A. Smith

Publisher: Morgan Kaufmann

Publication Date: 27-AUG-2010

Insert Date: 27-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

Businesses, entrepreneurs, individuals, and government agencies alike are looking to social network analysis (SNA) tools for insight into trends, connections, and fluctuations in social media. Microsoft's NodeXL is a free, open-source SNA plug-in for use with Excel. It provides instant graphical representation of relationships of complex networked data. But it goes further than other SNA tools -- NodeXL was developed by a multidisciplinary team of experts that bring together information studies, computer science, sociology, human-computer interaction, and over 20 years of visual analytic...

76. 

Access 2007 Programming by Example with VBA, XML, and ASP

Access 2007 Programming by Example with VBA, XML, and ASP

By: Julitta Korol

Publisher: Jones & Bartlett Learning

Publication Date: 25-OCT-2010

Insert Date: 26-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can be created, managed, and customized with Visual Basic for Applications (VBA) — a powerful programming language built into Access. Hundreds of hands-on examples and projects throughout the book show users how to take charge of their Access databases with programming. Learn how to Write and debug your programming code with the Visual Basic Editor; access and manipulate databases with Data Access Objects (DAO) and ActiveX Data Objects (ADO); use the Data Definition Language (DDL) to enforce...

77. 

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

By: Julitta Korol

Publisher: Jones & Bartlett Learning

Publication Date: 25-OCT-2010

Insert Date: 26-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions. Learn how to write and debug your programming code with the Visual Basic Editor, and understand and use common VBA programming structures such as conditions, loops, arrays, and collections. Learn how to create and...

78. 

Learn FileMaker Pro 10

Learn FileMaker Pro 10

By: Jonathan Stars

Publisher: Jones & Bartlett Learning

Publication Date: 23-JUN-2009

Insert Date: 21-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

Learn FileMaker? Pro 10 provides an excellent reference to FileMaker Inc.’s award-winning database program for both beginners and advanced developers. From converting files created with previous versions of FileMaker Pro and sharing data on the web to creating reports and sorting data, this book offers a hands-on approach to getting the most out of your FileMaker Pro databases. Learn how to use the completely redesigned Status area, now known as the Status toolbar; send e-mail right from FileMaker with the SMTP-based Send Mail option; build reports quickly and easily with the Saved Finds...

79. 

FileMaker Web Publishing: A Complete Guide to Using the API for PHP

FileMaker Web Publishing: A Complete Guide to Using the API for PHP

By: Allyson Olm; Stephen Knight; Michael Petrov

Publisher: Jones & Bartlett Learning

Publication Date: 25-OCT-2010

Insert Date: 10-OCT-2010

Slots: 1.0

Table of Contents • Start Reading

FileMaker Web Publishing offers an unparalleled development strategy for database managers, web designers, and programmers who are interested in getting the most out of FileMaker databases on the web. The book introduces the basics of HTML, cascading style sheets, and PHP, then moves on to specific concepts such as database portals, value lists, and complex navigation systems. Advanced topics include uploading and referencing files within the database and sending dynamically formatted emails....

80. 

John Walkenbach's Favorite Excel 2010 Tips and Tricks

John Walkenbach's Favorite Excel 2010 Tips and Tricks

By: 

Publisher: John Wiley & Sons

Publication Date: 13-JUL-2010

Insert Date: 12-AUG-2010

Slots: 1.0

Table of Contents • Start Reading

Build robust Excel 2010 apps quickly and efficiently Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined. Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications. Addresses the extensive...