| Welcome |
 | Activating the Software |
| End-User Licensing Agreement |
| Using Projects |
| Using the Project Manager |
| Creating a New Project |
| Managing Existing Projects |
| Sharing Projects |
| Backing Up Projects |
| Using the Project Panel |
| Browsing the Web |
| Navigating the Web |
| Using the Bookmarks Toolbar |
| Changing your Proxy and Privacy Settings |
| Accessing and Saving Data |
| Opening Data |
| Opening Local Data Files |
| Opening Data from the Web |
| Saving Data and Bookmarks |
| Using Save |
| Using Save As |
| Using Save As External |
| Saving Bookmarks |
| Creating Connections to Data Sources |
| Importing and Exporting Data |
| Importing Data Sets |
| Exporting Data Sets |
| Importing Data Using Scripts |
| Viewing Data Sets |
| Using the Table View |
| Using the Design View |
| Using the Source View |
| Performing Standard Data Operations |
| Adding and Removing Data |
| Creating a New Data Table |
| Adding Individual Records to a Table |
| Deleting Records from a Table |
| Appending Records to a Table |
| Editing and Replacing Data |
| Editing Values in a Cell |
| Updating and Replacing Records in a Table |
| Merging and Dividing Tables |
| Merging Tables Together |
| Dividing/Splitting Tables |
| Copying Data |
| Sorting/Ordering Fields |
| Filtering Data |
| Using the Quick Filter Utility |
| Filtering Records in a Table |
| Finding/Searching for Data |
| Marking/Highlighting Records |
| Creating Calculations |
| Creating and Managing Calculated Fields |
| Defining the Contents of a Calculated Field |
| Using Formulas to Create Calculations |
| Grouping and Summarizing Data |
| Grouping Data |
| Inserting and Removing Group Breaks |
| Summarizing Data |
| Using Quick Sum |
| Creating Queries |
| Creating Relationships |
| Designing and Printing Reports |
| Using Report Settings |
| Working with Sorts and Groups |
| Working in the Design View |
| Working in the Layout View |
| Formatting a Report |
| Printing, Saving and Sharing a Report |
| Viewing and Scheduling Jobs |
| Using Scripts, SQL and Extensions |
| Opening, Saving and Running Scripts |
| Using Structured Query Language (SQL) |
| Installing Extensions |
| Working with Formulas |
| Types of Formulas |
| Rules for Creating Formulas |
| Using the Formula Builder |
| Functions Used in Formulas |
| Index of Functions |
| Conversion Functions |
| Date() |
| Str() |
| Val() |
| Date/Time Functions |
| Curdate() |
| Day() |
| Dayname() |
| Dayofweek() |
| Hour() |
| Minute() |
| Month() |
| Monthname() |
| Second() |
| Week() |
| Year() |
| Numeric Functions |
| Abs() |
| Acos() |
| Asin() |
| Atan() |
| Ceiling() |
| Cos() |
| Exp() |
| Floor() |
| Ln() |
| Log() |
| Mod() |
| Pi() |
| Power() |
| Rand() |
| Round() |
| Sign() |
| Sin() |
| Tan() |
| Trunc() |
| Text Functions |
| Chr() |
| Contains() |
| Instr() |
| Left() |
| Length() |
| Lfind() |
| Lower() |
| Lpad() |
| Ltrim() |
| Proper() |
| Regexp() |
| Repeat() |
| Replace() |
| Reverse() |
| Rfind() |
| Right() |
| Rpad() |
| Rtrim() |
| Soundex() |
| Strpart() |
| Substr() |
| Translate() |
| Trim() |
| Upper() |
| List Functions |
| Avg() |
| Max() |
| Min() |
| Stddev() |
| Sum() |
| Variance() |
| Other Functions |
| Empty() |
| IIf() |
| Isnull() |
| Recid() |
| Recno() |
| Menu Reference |
| File Menu |
| Edit Menu |
| View Menu |
| Data Menu |
| Tools Menu |
| Help Menu |
| Keyboard Shortcut Reference |
| Video Tutorial Library |
© 2002-2022 Kirix Research LLC. All rights reserved.