{"product_id":"mastering-ideascript-with-website-isbn-9781118004487","title":"Mastering IDEAScript, with Website","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, \u003ci\u003eMastering IDEAScript: The Definitive Guide\u003c\/i\u003e 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.  Preface.  \u003cp\u003eAcknowledgments.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introducing IDEAScript.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Automation.\u003c\/p\u003e \u003cp\u003eUnderstanding How You Use Macros.\u003c\/p\u003e \u003cp\u003eHaving Things Your Way.\u003c\/p\u003e \u003cp\u003eConsidering Your Skills.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Creating Your First IDEAScript Application.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Macro Types.\u003c\/p\u003e \u003cp\u003eOpening the Visual Script Editor.\u003c\/p\u003e \u003cp\u003eWriting a Hello World Application.\u003c\/p\u003e \u003cp\u003eBuilding Your Application.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Understanding the Basics of the IDEAScript Editor.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Windows.\u003c\/p\u003e \u003cp\u003eHiding and Viewing Windows.\u003c\/p\u003e \u003cp\u003eWorking with Menus and Toolbars.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Designing Structured Applications.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Parts of an Application.\u003c\/p\u003e \u003cp\u003eMethods You Use to Create an Application.\u003c\/p\u003e \u003cp\u003eUsing the Macro Recorder.\u003c\/p\u003e \u003cp\u003eWorking with Subs and Functions.\u003c\/p\u003e \u003cp\u003eMaking Your Code Easy to Read.\u003c\/p\u003e \u003cp\u003eAdding Your Application to a Toolbar or Menu.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Working with Data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Variables and Constants.\u003c\/p\u003e \u003cp\u003eChoosing a Data Type.\u003c\/p\u003e \u003cp\u003eEmploying Operators.\u003c\/p\u003e \u003cp\u003eFormatting Data.\u003c\/p\u003e \u003cp\u003eCreating Custom Data Types.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Using Conditional Statements and Loops.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaking Decisions Using the If…Then…Else Statement.\u003c\/p\u003e \u003cp\u003eChoosing between Options Using Select Case.\u003c\/p\u003e \u003cp\u003ePerforming Tasks a Specific Number of Times with For…Next.\u003c\/p\u003e \u003cp\u003ePerforming Tasks Using Conditions with Do Loop.\u003c\/p\u003e \u003cp\u003eAdding Error Trapping to Your Application.\u003c\/p\u003e \u003cp\u003eRedirecting Macro Flow Using GoTo.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Understanding IDEA Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Parts of a Database.\u003c\/p\u003e \u003cp\u003eAn Overview of the IDEA Database System.\u003c\/p\u003e \u003cp\u003eOpening a Database for Use.\u003c\/p\u003e \u003cp\u003eChecking the Database History.\u003c\/p\u003e \u003cp\u003eObtaining Field Statistics.\u003c\/p\u003e \u003cp\u003eSetting Database Criteria.\u003c\/p\u003e \u003cp\u003eIndexing a Database.\u003c\/p\u003e \u003cp\u003eSorting a Database.\u003c\/p\u003e \u003cp\u003eModifying Database Comments.\u003c\/p\u003e \u003cp\u003eCommitting the Database.\u003c\/p\u003e \u003cp\u003eClosing a Database.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Working with Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding One Database to Another Using Append Database.\u003c\/p\u003e \u003cp\u003eComparing Two Databases Using CompareDB.\u003c\/p\u003e \u003cp\u003eWorking with Keys.\u003c\/p\u003e \u003cp\u003eExporting a Database Using ExportDatabase.\u003c\/p\u003e \u003cp\u003eWorking with Fields Using Field.\u003c\/p\u003e \u003cp\u003eWorking with Records.\u003c\/p\u003e \u003cp\u003eWorking with Tables.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Considering the CaseWare IDEA Object Model.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the IDEA Object Model.\u003c\/p\u003e \u003cp\u003eWorking with the Task Object Model.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Performing Mathematical Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Basic Math.\u003c\/p\u003e \u003cp\u003eUsing Advanced Math.\u003c\/p\u003e \u003cp\u003eEmploying Analysis.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Interacting with Arrays.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding How Arrays Work.\u003c\/p\u003e \u003cp\u003eCreating and Using Arrays.\u003c\/p\u003e \u003cp\u003eCopying Data between Arrays.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Creating Interactive Dialog Boxes.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Great Dialog Boxes.\u003c\/p\u003e \u003cp\u003eUsing the Basic Controls.\u003c\/p\u003e \u003cp\u003eObtaining the Visual Appearance You Want.\u003c\/p\u003e \u003cp\u003eInteracting with Dialog Boxes Using Code.\u003c\/p\u003e \u003cp\u003eAdding Pictures to Your Dialog Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Locating Information in Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Searches Efficiently.\u003c\/p\u003e \u003cp\u003eUsing the Built-in Search Features.\u003c\/p\u003e \u003cp\u003eCreating a Custom Search.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: Importing and Exporting Data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Import\/Export Features.\u003c\/p\u003e \u003cp\u003ePerforming Data Extractions.\u003c\/p\u003e \u003cp\u003eManaging PDF Data.\u003c\/p\u003e \u003cp\u003eManaging Text Data.\u003c\/p\u003e \u003cp\u003eManaging Excel Data.\u003c\/p\u003e \u003cp\u003eManaging Access Data.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Working with Files.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the File Format.\u003c\/p\u003e \u003cp\u003eUsing the File IO Features.\u003c\/p\u003e \u003cp\u003eUsing External Variables\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Working with Other Applications.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering IDEAScript and Visual Basic for Applications (VBA) Differences.\u003c\/p\u003e \u003cp\u003eUnderstanding the Word and Excel Object Models.\u003c\/p\u003e \u003cp\u003eRunning Word from IDEA.\u003c\/p\u003e \u003cp\u003eRunning IDEA from Excel.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Performing Data Analysis Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Stratification.\u003c\/p\u003e \u003cp\u003ePerforming Summarization.\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table.\u003c\/p\u003e \u003cp\u003eEmploying Random Record Sampling Using RandomSample.\u003c\/p\u003e \u003cp\u003ePerforming Gap Detection.\u003c\/p\u003e \u003cp\u003eChecking Distribution Using SystematicSample.\u003c\/p\u003e \u003cp\u003eMerging Databases.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Working with Charts and Graphs.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChoosing the Correct Chart or Graph.\u003c\/p\u003e \u003cp\u003eCreating a Basic Graph.\u003c\/p\u003e \u003cp\u003eDefining Analytical Charts.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Defining Reports.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining a Report.\u003c\/p\u003e \u003cp\u003eOutputting Data in PDF Format.\u003c\/p\u003e \u003cp\u003eOutputting Data in Word Format.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Considering Database Security.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering Programmatic Data Security.\u003c\/p\u003e \u003cp\u003eChoosing the Correct Data Type.\u003c\/p\u003e \u003cp\u003eValidating Data.\u003c\/p\u003e \u003cp\u003eProtecting Dialog Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Debugging Your Application.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Kinds of Application Errors.\u003c\/p\u003e \u003cp\u003eRunning and Stopping the Application.\u003c\/p\u003e \u003cp\u003eUsing Breakpoints.\u003c\/p\u003e \u003cp\u003eStepping through the Application.\u003c\/p\u003e \u003cp\u003eUsing the Watch Window.\u003c\/p\u003e \u003cp\u003eRelying on Message Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Performing Project Management Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Plan for Your Application.\u003c\/p\u003e \u003cp\u003eKeeping Track of Application Files.\u003c\/p\u003e \u003cp\u003eWorking within a Group.\u003c\/p\u003e \u003cp\u003eDocumenting Your Application.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Converting Visual Script to IDEAScript.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Benefits of Using IDEAScript.\u003c\/p\u003e \u003cp\u003ePerforming the Conversion.\u003c\/p\u003e \u003cp\u003eMaking Changes and Saving the Result.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003eAbout the Author.\u003c\/p\u003e \u003cp\u003eAbout the Website.\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJohn Paul Mueller\u003c\/b\u003e is a freelance author and technical editor. He has writing in his blood, having produced eighty-seven books and over 300 articles to date. The topics range from networking to artificial intelligence and from database management to heads-down programming. Some of his current books include a Windows command line reference, books on VBA and Visio 2007, a C# design and development manual, and an IronPython programmer's guide. His technical editing skills have helped over sixty-three authors refine the content of their manuscripts. John has provided technical editing services to both Data Based Advisor and Coast Compute magazines. He's also contributed articles to magazines like \u003ci\u003eDevSource\u003c\/i\u003e, \u003ci\u003eInformIT\u003c\/i\u003e, \u003ci\u003eSQL Server Professional\u003c\/i\u003e, \u003ci\u003eVisual C++ Developer\u003c\/i\u003e, \u003ci\u003eHard Core Visual Basic\u003c\/i\u003e, \u003ci\u003easp.netPRO\u003c\/i\u003e, \u003ci\u003eSoftware Test and Performance\u003c\/i\u003e, and \u003ci\u003eVisual Basic Developer\u003c\/i\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eImprove your audit results and extend your capabilities with Mastering IDEAScript: The Definitive Guide\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRun audit programs and data analysis projects with ease. Create a local automated audit system. Meet current audit standards. Do it all with Mastering IDEAScript, the official guide from CaseWare IDEA.\u003c\/p\u003e \u003cp\u003eDesigned to help the complete novice develop the skills required to write applications using IDEAScript, this resource starts with simple topics, progressively working up to more complex areas. It helps you understand what automation can help you do and set reasonable goals for working with IDEAScript.\u003c\/p\u003e \u003cp\u003eAlthough basic familiarity with the IDEA program is helpful in the use of this book's concepts, neither programming skills nor special equipment is required. Here, you'll find plain-English, easy-to-follow explanations for:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eCreating your first IDEAScript application\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eUsing the IDEAScript Editor\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eWriting code quickly and efficiently\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eBuilding complete applications without any code at all, using the Macro Recorder\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTroubleshooting errors that occur in your application\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003ePerforming basic tasks, such as indexing, sorting, and closing your database\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eFinding information easily within databases\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eAnd much more!\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAlong with a companion website containing all of the scripts found in this book, Mastering IDEAScript: The Definitive Guide is packed with practical techniques and rules of thumb to help you understand the workings of IDEAScript. The days of filling in forms and answering countless questions when running audit programs are over. From now on, let IDEAScript do the work!\u003c\/p\u003e \u003cp\u003eIDEA is a leading provider of data analysis software targeted to auditors to use as a tool for fraud detection and internal control assessment. IDEA® software is used in sixteen languages in more than ninety countries, by major accounting firms, governments, and corporations in all industry sectors, as well as by universities as a teaching tool.\u003c\/p\u003e \u003cp\u003eIDEA is a registered trademark of CaseWare International Inc.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989581185253,"sku":"NP9781118004487","price":220.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118004487.jpg?v=1761784685","url":"https:\/\/k12savings.com\/es\/products\/mastering-ideascript-with-website-isbn-9781118004487","provider":"K12savings","version":"1.0","type":"link"}