GS-Base
- Introducing GS-Base
- Notational conventions (numbers, formulas, dates)
- Creating tables, records and database notes
- Creating new databases
- GS-Base zip database file format
- Managing database fields and tables
- Using table, form and binary views
- Adding text notes, images/files and code snippets outside of records
- Editing data fields
- Editing field contents
- Entering unicode characters
- Selecting fields and records, scrolling, shortcut keys
- Inserting images/files vs inserting links to images/files
- Loading images/files form entire folders
- Using the Increment, Decrement and Operations commands
- Inserting series
- Using drop-down lists
- Generating passwords
- Encrypting field contents
- Default field values
- Using the Copy-With-Options command
- Optimizing performance
- Improving performance when using large files
- Calculation functions
- Calculated fields and entering formulas and entering formulas
- "Cross-table" calculation functions
- Using makeUnique() and isUnique() functions
- Using objectStats() functions to obtain file/image data
- Using textStats() functions to obtain LongText and Code fields statistics
- Using fileStats() functions to obtain EXIF tags and metadata from multimedia files
- Running totals and moving averages
Using Python in GS-Base
- Using Python functions as UDF()
- Installing Python and GS-Base integration
- Pivot tables
- Using pivot tables
- Pivot table functions
- Creating pivot table reports
- Finding file duplicates, photo/mp3/mp4 duplicates, listing files and their history of changes
- Scanning and Verifying File (Path) Lists in Tables
- Mass- Rename, Copy, Delete files
- Searching for file duplicates in folders and on disks
- Displaying two tables from the same database and setting up relation between them
- Using dual views
- Linking tables in dual views by the 1-n relation
- Joning, splitting and merging tables and records
- Joining and splitting tables
- Merging records from other tables and "Unmerging" records based on other tables
- Spell-checking
- Spell-checking and adding Hunspell dictionaries
- Formatting: styles, hyperlinks, background images and in-cell charts
- Formatting - General Styles
- Formatting - Hyperlinks
- Formatting - Images
- Formatting - Charts
- Searching, filtering, sorting
- Searching - Field filters
- Searching - Saving Current Filters As Named Search Keys
- Searching - Duplicates
- Searching - Unique values
- Searching - Values from quartiles, above or below mean
- Searching - Random records
- Searching - Selected records
- Full text searches and replacing
- Find-As-You-Type and Find-In-Current-Results searching options
- Sorting
- Sending emails and verifying URLs
- Sending e-mail messages
- Verifying URLs entered in database fields
- Printing tables, forms and labels, mail-merge
- Printing tables, forms and labels
- File-level password protection and encryption
- Password protection and encrypting entire files
- Loading, editing and saving files in various file formats
- Opening and saving text files
- Saving to PDF
- Opening and saving MySQL *.sql files
- Opening and saving SQLite *.db files
- Opening and saving html files
- Opening and saving dBase/FoxPro/Clipper files
- Opening and saving Excel files
- Settings and Recently Used database lists
- Settings
- Managing the list of RU files
- Using scripts within GS-Base and COM programming with external tools
- COM programming: Samples
- COM programming: methods and properties
- Contacting technical support
|