Skip to content

Mastering IDEAscript The Definitive Guide

Spend $50 to get a free DVD!

ISBN-10: 1118004485

ISBN-13: 9781118004487

Edition: 2011

Authors: IDEA, John Paul Mueller

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!


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

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.

Introducing IDEAScript
Understanding Automation
Understanding How You Use Macros
Having Things Your Way
Considering Your Skills
Creating Your First IDEAScript Application
Understanding the Macro Types
Opening the Visual Script Editor
Writing a Hello World Application
Building Your Application
Understanding the Basics of the IDEAScript Editor
Working with Windows
Hiding and Viewing Windows
Working with Menus and Toolbars
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
Working with Data
Understanding Variables and Constants
Choosing a Data Type
Employing Operators
Formatting Data
Creating Custom Data Types
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
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
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
Considering the CaseWare IDEA Object Model
Considering the IDEA Object Model
Working with the Task Object Model
Performing Mathematical Tasks
Performing Basic Math
Using Advanced Math
Employing Analysis
Interacting with Arrays
Understanding How Arrays Work
Creating and Using Arrays
Copying Data between Arrays
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
Locating Information in Databases
Performing Searches Efficiently
Using the Built-in Search Features
Creating a Custom Search
Importing and Exporting Data
Considering the Import/Export Features
Performing Data Extractions
Managing PDF Data
Managing Text Data
Managing Excel Data
Managing Access Data
Working with Files
Considering the File Format
Using the File IO Features
Using External Variables
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
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
Working with Charts and Graphs
Choosing the Correct Chart or Graph
Creating a Basic Graph
Defining Analytical Charts
Defining Reports
Defining a Report
Outputting Data in PDF Format
Outputting Data in Word Format
Considering Database Security
Considering Programmatic Data Security
Choosing the Correct Data Type
Validating Data
Protecting Dialog Boxes
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
Performing Project Management Tasks
Creating a Plan for Your Application
Keeping Track of Application Files
Working within a Group
Documenting Your Application
Converting Visual Script to IDEAScript
Considering the Benefits of Using IDEAScript
Performing the Conversion
Making Changes and Saving the Result
About the Author
About the Website