Free Trial

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

Help

Databases & Reporting Tools


61. 

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

62. 

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

63. 

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

64. 

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

65. 

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

66. 

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

67. 

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

68. 

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

69. 

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

70. 

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

71. 

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

72. 

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

73. 

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

74. 

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

75. 

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

76. 

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

77. 

Using Microsoft® Access® 2010

Using Microsoft® Access® 2010

By: 

Publisher: Que

Publication Date: 27-JUL-2010

Insert Date: 27-JUL-2010

Slots: 1.0

Table of Contents • Start Reading

Get comfortable with Access 2010. Don’t just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need...where you want, when you want! Learn fast, learn easy, using web, video, and audio: Show Me video walks through tasks you’ve just got to...

78. 

The Excel® Analyst's Guide to Access®

The Excel® Analyst's Guide to Access®

By: 

Publisher: John Wiley & Sons

Publication Date: 05-APR-2010

Insert Date: 16-JUL-2010

Slots: 1.0

Table of Contents • Start Reading

The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how. Coverage includes: Data Analysis in Access & the Basics of Access Beyond...

79. 

Access® 2010 Bible

Access® 2010 Bible

By: Michael R. Groh

Publisher: John Wiley & Sons

Publication Date: 28-JUN-2010

Insert Date: 12-JUL-2010

Slots: 1.0

Table of Contents • Start Reading

The expert guidance you need to get the most out of Access 2010 Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services. Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010 Explores the latest...

80. 

FileMaker® Pro 10 Bible

FileMaker® Pro 10 Bible

By: 

Publisher: John Wiley & Sons

Publication Date: 04-MAY-2009

Insert Date: 05-JUL-2010

Slots: 1.0

Table of Contents • Start Reading

FileMaker Pro 10 Bible provides information that grows with you no matter what your level when you start. Topics range from the general (how databases fit into real life and your business needs; comparisons with other database development tools; a broad discussion of integration with existing systems and software) through the building-blocks of FileMaker solutions, and on up to state-of-the-art advice on concepts of optimization, modularization, innovative and sophisticated user-interface design, dynamic elements, logic, cutting-edge calculations, publishing your database to the Web, and...