Atnaujinkite slapukų nuostatas

El. knyga: Mastering IDEAScript - The Definitive Guide plus Website: The Definitive Guide with Website [Wiley Online]

,
  • Formatas: 504 pages, Screen captures: 198 B&W, 0 Color
  • Išleidimo metai: 15-Apr-2011
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 1119202345
  • ISBN-13: 9781119202349
Kitos knygos pagal šią temą:
  • Wiley Online
  • Kaina: 232,61 €*
  • * this price gives unlimited concurrent access for unlimited time
Mastering IDEAScript - The Definitive Guide plus Website: The Definitive Guide with WebsiteDidesnis paveikslėlis
  • Formatas: 504 pages, Screen captures: 198 B&W, 0 Color
  • Išleidimo metai: 15-Apr-2011
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 1119202345
  • ISBN-13: 9781119202349
Kitos knygos pagal šią temą:
Wiley Online E-booksMore info about Wiley Online
Partnerių interneto svetainė: https://onlinelibrary.wiley.com/doi/book/10.1002/9781119202349
"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."--

Provided by publisher.

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.

Preface xvii
Acknowledgments xxiii
Chapter 1 Introducing IDEAScript
1(8)
Understanding Automation
1(2)
How Does Automation Benefit You?
2(1)
How Does Automation Benefit Others?
2(1)
Best Practices for Using Automation
3(1)
Understanding How You Use Macros
3(3)
Interacting with Databases
4(1)
Customizing the IDEA Interface
4(1)
Performing Calculations
4(1)
Designing New Application Features
5(1)
Importing and Exporting Data
5(1)
Controlling Other Applications
5(1)
Having Things Your Way
6(1)
Considering Your Skills
7(1)
Summary
8(1)
Chapter 2 Creating Your First IDEAScript Application
9(12)
Understanding the Macro Types
9(2)
Considering IDEAScript
10(1)
Considering Visual Script
10(1)
Opening the Visual Script Editor
11(4)
Writing a Hello World Application
15(4)
Typing in the Editor Window
16(1)
Saving Your Macro
17(1)
Understanding .iss Versus .ise Files
17(2)
Sending Your Macro to Someone Else
19(1)
Building Your Application
19(1)
Creating the Executable File
19(1)
Executing Your Application from Windows Explorer
20(1)
Summary
20(1)
Chapter 3 Understanding the Basics of the IDEAScript Editor
21(18)
Working with Windows
21(6)
Editor
22(1)
Project
23(1)
Properties
24(1)
Dialog Tools
25(1)
Dialog Box Editor
25(1)
Watch
26(1)
Hiding and Viewing Windows
27(2)
Working with Menus and Toolbars
29(8)
Menu Bar
31(3)
Standard Toolbar
34(3)
Summary
37(2)
Chapter 4 Designing Structured Applications
39(24)
Understanding the Parts of an Application
40(1)
Understanding the Methods Used to Create an Application
41(4)
Recording a Series of IDEA Tasks
41(1)
Copying from History
42(1)
Typing into the Editor Window
43(1)
Copying from Help
43(2)
Copying from Other Macros
45(1)
Using the Macro Recorder
45(7)
Starting a Macro
46(1)
Stopping a Macro
47(1)
Viewing the Results
47(2)
Editing the Code
49(2)
Testing the Results
51(1)
Working with Subroutines and Functions
52(4)
Creating a Subroutine
52(2)
Calling a Function from a Subroutine
54(2)
Understanding Scope
56(1)
Making Your Code Easy to Read
56(1)
Adding Your Application to a Toolbar or Menu
57(3)
Best Practices for Binding an Application
57(1)
Binding the Application to a Menu
58(1)
Binding the Application to a Toolbar
59(1)
Summary
60(3)
Chapter 5 Working with Data
63(30)
Understanding Variables and Constants
63(4)
Defining a Variable
64(1)
Defining a Constant
65(1)
Using Option Explicit
66(1)
Choosing a Data Type
67(15)
Understanding How Data Type Affects Code
67(1)
Working with Strings
68(5)
Working with Numbers
73(1)
Working with Boolean Values
74(1)
Working with Scientific Values
75(1)
Working with Currency Values
75(1)
Working with Date/Time Values
76(2)
Working with Variant Data
78(1)
Performing Data Conversion
79(3)
Employing Operators
82(3)
Formatting Data
85(4)
Creating Custom Data Types
89(2)
Summary
91(2)
Chapter 6 Using Conditional Statements and Loops
93(22)
Making Decisions Using the If... Then... Else Statement
93(2)
Using If... Then Alone
93(1)
Using the If... Then... Else Combination
94(1)
Using the If... Then... Elself Combination
94(1)
Choosing between Options Using Select Case
95(4)
Using Select Case
96(1)
Defining a Default Action Using Case Else
97(1)
Using a Select Case Alternative, Choose
98(1)
Performing Tasks a Specific Number of Times with For... Next
99(3)
Using For... Next
99(1)
Using For Each... Next
100(2)
Performing Tasks Using Conditions with Do Loop
102(4)
Using Do While... Loop
103(1)
Using Do... Loop While
104(1)
Using Do Until... Loop
105(1)
Using Do... Loop Until
106(1)
Adding Error Trapping to Your Application
106(6)
Avoiding Errors
107(1)
Using On Error
107(2)
Raising Your Own Errors
109(3)
Redirecting Macro Flow Using GoTo
112(1)
Standard Uses for GoTo
112(1)
GoTo Uses That Cause Problems
112(1)
Summary
112(3)
Chapter 7 Understanding IDEA Databases
115(20)
Considering the Parts of a Database
115(3)
Tables
116(1)
Fields
116(1)
Records
117(1)
Indexes
117(1)
Introducing the IDEA Database System
118(1)
Opening a Database for Use
119(1)
Checking the Database History
120(2)
Obtaining Field Statistics
122(3)
Setting Database Criteria
125(1)
Indexing a Database
125(2)
Sorting a Database
127(2)
Modifying Database Comments
129(2)
Committing the Database
131(2)
Closing a Database
133(1)
Summary
133(2)
Chapter 8 Working with Databases
135(30)
Adding One Database to Another Using Append Database
135(3)
Comparing Two Databases Using CompareDB
138(2)
Working with Keys
140(5)
Locating Duplicate Keys with DupKeyDetection
141(3)
Locating Exclusive Records Based on Key Using DupKeyExclusion
144(1)
Exporting a Database Using ExportDatabase
145(5)
Working with Fields Using Field
150(2)
Working with Records
152(5)
Obtaining a Record Set
153(2)
Interacting with an Individual Record
155(2)
Working with Tables
157(7)
Copying Databases Using TableDef
157(4)
Creating New Tables Using TableManagement
161(3)
Summary
164(1)
Chapter 9 Considering the CaseWare IDEA Object Model
165(30)
Considering the IDEA Object Model
165(5)
Understanding Objects
166(2)
Working with the Client Elements
168(2)
Working with the Task Object Model
170(23)
AdvancedFindTask
171(2)
Aging
173(1)
AppendDatabase
173(1)
BenfordsLaw
173(1)
ChartData
174(1)
CompareDB
175(1)
Correlation
175(1)
DupKeyDetection
176(1)
DupKeyExclusion
176(1)
ExportDatabase
176(1)
Extraction
177(1)
Gaps
177(2)
History
179(1)
ImportAccess
179(1)
ImportAS400
180(1)
ImportExcel and ImportExcel2007
180(1)
ImportXML
181(1)
Index
182(1)
IndexedExtraction
182(1)
JoinDatabase
182(1)
KeyValueExtraction
183(1)
MUSCombinedEvaluate
184(1)
MUSEvaluate
185(1)
MUSExtraction
186(1)
PivotTable
186(1)
RandomSample
187(1)
Sort
187(1)
Stratification
188(1)
StratifyRndSample
188(1)
Summarization
189(1)
SystematicSample
190(1)
TableManagement
190(1)
TopRecordsExtraction
191(1)
TrendAnalysis
191(1)
VisualConnector
192(1)
Summary
193(2)
Chapter 10 Performing Mathematical Tasks
195(12)
Performing Basic Math
195(3)
Using Advanced Math
198(2)
Considering the Advanced Math Functions
199(1)
Using Advanced Math in an Application
200(1)
Employing Analysis
200(5)
Performing Aging
201(2)
Using BenfordsLaw
203(2)
Summary
205(2)
Chapter 11 Interacting with Arrays
207(8)
Understanding How Arrays Work
207(1)
Creating and Using Arrays
208(4)
Copying Data between Arrays
212(1)
Summary
213(2)
Chapter 12 Creating Interactive Dialog Boxes
215(34)
Creating Great Dialog Boxes
216(2)
Best Practices for Using Dialog Boxes
216(2)
Designing a Good Dialog Box Layout
218(1)
Using the Basic Controls
218(14)
Considering the Select Tool
219(2)
Adding Clicks Using the Generic Button
221(1)
Adding Clicks Using the OKButton
222(1)
Adding Clicks Using the CancelButton
222(1)
Providing Options Using the RadioButton
222(3)
Providing Options Using the CheckBox
225(1)
Displaying Prompts Using StaticText
225(1)
Getting User Input Using the EditBox
226(2)
Grouping Related Items Using the GroupBox
228(1)
Providing Options Using the ListBox
228(2)
Providing Options Using the ComboBox
230(1)
Providing Options Using the DropDownComboBox
231(1)
Obtaining the Visual Appearance You Want
232(3)
Aligning Controls
233(1)
Making Controls the Same Size
233(1)
Defining the Horizontal and Vertical Spacing
234(1)
Centering Controls on a Dialog Box
235(1)
Using the Grid for Alignment
235(1)
Interacting with Dialog Boxes Using Code
235(9)
Creating a Basic Dialog Box
236(2)
Working with the Dialog Box Function Using Beep
238(4)
Selecting a Control Using DlgFocus
242(1)
Changing Control Values Using DlgValue, DlgVisible, and DlgEnable
243(1)
Adding Pictures to Your Dialog Boxes
244(3)
Summary
247(2)
Chapter 13 Locating Information in Databases
249(22)
Performing Searches Efficiently
249(2)
Using the Built-in Search Features
251(17)
Creating a Basic Search
251(7)
Using Boolean Operators
258(4)
Using Wildcards
262(2)
Performing Proximity Searches
264(4)
Creating a Custom Search
268(1)
Summary
269(2)
Chapter 14 Importing and Exporting Data
271(46)
Considering the Import and Export Features
271(12)
ImportAccess
272(1)
ImportAS400
272(1)
ImportdBASE
272(3)
ImportExcel
275(1)
ImportXML
275(1)
PublishToMicrosoftWord
275(7)
PublishToPDF
282(1)
Performing Data Extractions
283(7)
Using Extraction
283(2)
Using KeyValueExtraction
285(3)
Using TopRecordsExtraction
288(2)
Managing PDF Data
290(4)
Importing PDF Data
290(2)
Exporting PDF Data
292(2)
Managing Text Data
294(12)
Considering the Text Data Types
295(3)
Creating a Definition File
298(1)
Importing Text Data
299(3)
Exporting Text Data
302(4)
Managing Excel Data
306(4)
Importing Excel Data
306(2)
Exporting Excel Data
308(2)
Managing Access Data
310(5)
Importing Access Data
310(3)
Exporting Access Data
313(2)
Summary
315(2)
Chapter 15 Working with Files
317(32)
Considering the File Format
317(1)
Using the File IO Features
318(28)
ChDir
318(3)
ChDrive
321(1)
Close
322(4)
CurDir and CurDir
326(1)
Dir
326(1)
EOF
327(3)
FileCopy
330(1)
FileLen
331(2)
FreeFile
333(1)
Get
334(2)
GetAttr
336(5)
Input and Input
341(1)
Kill
342(1)
Line Input #
342(1)
LOF
342(1)
MkDir
342(1)
Name
343(1)
Open
343(1)
Print
344(1)
Print #
345(1)
Put
345(1)
RmDir
345(1)
Seek
346(1)
SetAttr
346(1)
Write #
346(1)
Using External Variables
346(2)
Summary
348(1)
Chapter 16 Working with Other Applications
349(12)
Considering IDEAScript and Visual Basic for Applications (VBA) Differences
349(1)
Understanding the Word and Excel Object Models
350(1)
Running Word from IDEA
351(4)
Running IDEA from Excel
355(5)
Summary
360(1)
Chapter 17 Performing Data Analysis Tasks
361(30)
Performing Stratification
361(6)
Using Stratification
362(3)
Using StratifyRndSample
365(2)
Performing Summarization
367(4)
Creating a Pivot Table
371(3)
Employing Random Record Sampling Using RandomSample
374(2)
Performing Gap Detection
376(2)
Checking Distribution Using SystematicSample
378(2)
Merging Databases
380(9)
Using JoinDatabase
381(4)
Using VisualConnector
385(4)
Summary
389(2)
Chapter 18 Working with Charts and Graphs
391(16)
Choosing the Correct Chart or Graph
391(2)
Creating a Basic Graph
393(6)
Defining Analytical Charts
399(6)
Using Correlation
399(2)
Performing Trend Analysis
401(4)
Summary
405(2)
Chapter 19 Defining Reports
407(12)
Defining a Report
407(5)
Outputting Data in PDF Format
412(2)
Outputting Data in Word Format
414(4)
Summary
418(1)
Chapter 20 Considering Database Security
419(10)
Considering Programmatic Data Security
419(2)
Choosing the Correct Data Type
421(1)
Validating Data
421(6)
Verifying the Data Range
422(3)
Checking Data Length
425(1)
Methods for Checking Data Content
426(1)
Protecting Dialog Boxes
427(1)
Summary
428(1)
Chapter 21 Debugging Your Application
429(18)
Understanding the Kinds of Application Errors
429(4)
Considering Syntax Errors
429(1)
Considering Compile Errors
430(1)
Considering Run-Time Errors
431(1)
Considering Semantic Errors
432(1)
Running and Stopping the Application
433(1)
Using Breakpoints
434(1)
Setting Breakpoints
434(1)
Removing Individual Breakpoints
434(1)
Removing All Breakpoints
435(1)
Stepping through the Application
435(3)
Stepping into a Call
436(1)
Stepping over a Call
437(1)
Using the Watch Window
438(6)
Understanding the Problem
439(1)
Creating a Quick Watch
440(2)
Typing a Variable into the Watch Window
442(2)
Relying on Message Boxes
444(1)
Summary
445(2)
Chapter 22 Performing Project Management Tasks
447(8)
Creating a Plan for Your Application
448(1)
Defining the Basics
448(1)
Developing the Application Shell
448(1)
Adding Bells and Whistles
448(1)
Keeping Track of Application Files
449(1)
Working within a Group
450(1)
Documenting Your Application
451(2)
Considering the Importance of Comments
451(1)
Providing Written Documentation
452(1)
Creating a User Guide
453(1)
Summary
453(2)
Chapter 23 Converting Visual Script to IDEAScript
455(8)
Considering the Benefits of Using IDEAScript
455(1)
Performing the Conversion
456(2)
Making Changes and Saving the Result
458(3)
Summary
461(2)
About the Author 463(2)
About the Website 465(2)
Index 467
John Paul Mueller 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 DevSource, InformIT, SQL Server Professional, Visual C++ Developer, Hard Core Visual Basic, asp.netPRO, Software Test and Performance, and Visual Basic Developer.
Pastovi nuoroda: https://www.kriso.lt/db/9781119202349_pe.html
Raktažodžiai: