Skip to content

Mastering IDEAscript The Definitive Guide

ISBN-10: 1118004485

ISBN-13: 9781118004487

Edition: 2011

Authors: IDEA, John Paul Mueller

List price: $180.00
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

With approximately 44,000 users in the U.S. and Canada, as well as 42,000 in Europe, IDEA software has become a leading provider of data analysis software for use by auditors and accountants. Written to provide users with a quick access guide for optimal use of IDEAScript, Mastering IDEAScript: The Definitive Guide is IDEA's official guide to mastering IDEAScript, covering essential topics such as Introducing IDEAScript, Understanding the Basics of IDEAScript Editor, Designing Structured Applications, Understanding IDEA Databases and much more. For auditors, accountants and controllers.
Customers also bought

Book details

List price: $180.00
Copyright year: 2011
Publisher: John Wiley & Sons, Limited
Publication date: 4/15/2011
Binding: Paperback
Pages: 504
Size: 7.25" wide x 9.00" long x 1.00" tall
Weight: 1.628
Language: English

John Paul Mueller is a freelance writer and technical editor who has written over 300 articles and 65 books. He's contributed articles to such magazines as DevSource, asp.netPro, InformIT, SQL Server Professional, Visual C++ Developer, Hard Core Visual Basic, and Visual Basic Developer.

Preface
Acknowledgments
Introducing IDEAScript
Understanding Automation
Understanding How You Use Macros
Having Things Your Way
Considering Your Skills
Summary
Creating Your First IDEAScript Application
Understanding the Macro Types
Opening the Visual Script Editor
Writing a Hello World Application
Building Your Application
Summary
Understanding the Basics of the IDEAScript Editor
Working with Windows
Hiding and Viewing Windows
Working with Menus and Toolbars
Summary
Designing Structured Applications
Understanding the Parts of an Application
Methods You Use to Create an Application
Using the Macro Recorder
Working with Subs and Functions
Making Your Code Easy to Read
Adding Your Application to a Toolbar or Menu
Summary
Working with Data
Understanding Variables and Constants
Choosing a Data Type
Employing Operators
Formatting Data
Creating Custom Data Types
Summary
Using Conditional Statements and Loops
Making Decisions Using the If…Then…Else Statement
Choosing between Options Using Select Case
Performing Tasks a Specific Number of Times with For…Next
Performing Tasks Using Conditions with Do Loop
Adding Error Trapping to Your Application
Redirecting Macro Flow Using GoTo
Summary
Understanding IDEA Databases
Considering the Parts of a Database
An Overview of the IDEA Database System
Opening a Database for Use
Checking the Database History
Obtaining Field Statistics
Setting Database Criteria
Indexing a Database
Sorting a Database
Modifying Database Comments
Committing the Database
Closing a Database
Summary
Working with Databases
Adding One Database to Another Using Append Database
Comparing Two Databases Using CompareDB
Working with Keys
Exporting a Database Using ExportDatabase
Working with Fields Using Field
Working with Records
Working with Tables
Summary
Considering the CaseWare IDEA Object Model
Considering the IDEA Object Model
Working with the Task Object Model
Summary
Performing Mathematical Tasks
Performing Basic Math
Using Advanced Math
Employing Analysis
Summary
Interacting with Arrays
Understanding How Arrays Work
Creating and Using Arrays
Copying Data between Arrays
Summary
Creating Interactive Dialog Boxes
Creating Great Dialog Boxes
Using the Basic Controls
Obtaining the Visual Appearance You Want
Interacting with Dialog Boxes Using Code
Adding Pictures to Your Dialog Boxes
Summary
Locating Information in Databases
Performing Searches Efficiently
Using the Built-in Search Features
Creating a Custom Search
Summary
Importing and Exporting Data
Considering the Import/Export Features
Performing Data Extractions
Managing PDF Data
Managing Text Data
Managing Excel Data
Managing Access Data
Summary
Working with Files
Considering the File Format
Using the File IO Features
Using External Variables
Summary
Working with Other Applications
Considering IDEAScript and Visual Basic for Applications (VBA) Differences
Understanding the Word and Excel Object Models
Running Word from IDEA
Running IDEA from Excel
Summary
Performing Data Analysis Tasks
Performing Stratification
Performing Summarization
Creating a Pivot Table
Employing Random Record Sampling Using RandomSample
Performing Gap Detection
Checking Distribution Using SystematicSample
Merging Databases
Summary
Working with Charts and Graphs
Choosing the Correct Chart or Graph
Creating a Basic Graph
Defining Analytical Charts
Summary
Defining Reports
Defining a Report
Outputting Data in PDF Format
Outputting Data in Word Format
Summary
Considering Database Security
Considering Programmatic Data Security
Choosing the Correct Data Type
Validating Data
Protecting Dialog Boxes
Summary
Debugging Your Application
Understanding the Kinds of Application Errors
Running and Stopping the Application
Using Breakpoints
Stepping through the Application
Using the Watch Window
Relying on Message Boxes
Summary
Performing Project Management Tasks
Creating a Plan for Your Application
Keeping Track of Application Files
Working within a Group
Documenting Your Application
Summary
Converting Visual Script to IDEAScript
Considering the Benefits of Using IDEAScript
Performing the Conversion
Making Changes and Saving the Result
Summary
About the Author
About the Website
Index