GS-Base

  1. Introducing GS-Base
  2. Notational conventions (numbers, formulas, dates)
  3. Creating tables, records and database notes
    1. Creating new databases
    2. GS-Base zip database file format
    3. Managing database fields and tables
    4. Using table, form and binary views
    5. Adding text notes, images/files and code snippets outside of records
  4. Editing data fields
    1. Editing field contents
    2. Entering unicode characters
    3. Selecting fields and records, scrolling, shortcut keys
    4. Inserting images/files vs inserting links to images/files
    5. Loading images/files form entire folders
    6. Using the Increment, Decrement and Operations commands
    7. Inserting series
    8. Using drop-down lists
    9. Generating passwords
    10. Encrypting field contents
    11. Default field values
    12. Using the Copy-With-Options command
  5. Optimizing performance
    1. Improving performance when using large files
  6. Calculation functions
    1. Calculated fields and entering formulas and entering formulas
    2. "Cross-table" calculation functions
    3. Using makeUnique() and isUnique() functions
    4. Using objectStats() functions to obtain file/image data
    5. Using textStats() functions to obtain LongText and Code fields statistics
    6. Using fileStats() functions to obtain EXIF tags and metadata from multimedia files
    7. Running totals and moving averages

  7. Using Python in GS-Base

    1. Using Python functions as UDF()
    2. Installing Python and GS-Base integration
  8. Pivot tables
    1. Using pivot tables
    2. Pivot table functions
    3. Creating pivot table reports
  9. Finding file duplicates, photo/mp3/mp4 duplicates, listing files and their history of changes
    1. Scanning and Verifying File (Path) Lists in Tables
    2. Mass- Rename, Copy, Delete files
    3. Searching for file duplicates in folders and on disks
  10. Displaying two tables from the same database and setting up relation between them
    1. Using dual views
    2. Linking tables in dual views by the 1-n relation
  11. Joning, splitting and merging tables and records
    1. Joining and splitting tables
    2. Merging records from other tables and "Unmerging" records based on other tables
  12. Spell-checking
    1. Spell-checking and adding Hunspell dictionaries
  13. Formatting: styles, hyperlinks, background images and in-cell charts
    1. Formatting - General Styles
    2. Formatting - Hyperlinks
    3. Formatting - Images
    4. Formatting - Charts
  14. Searching, filtering, sorting
    1. Searching - Field filters
    2. Searching - Saving Current Filters As Named Search Keys
    3. Searching - Duplicates
    4. Searching - Unique values
    5. Searching - Values from quartiles, above or below mean
    6. Searching - Random records
    7. Searching - Selected records
    8. Full text searches and replacing
    9. Find-As-You-Type and Find-In-Current-Results searching options
    10. Sorting
  15. Sending emails and verifying URLs
    1. Sending e-mail messages
    2. Verifying URLs entered in database fields
  16. Printing tables, forms and labels, mail-merge
    1. Printing tables, forms and labels
  17. File-level password protection and encryption
    1. Password protection and encrypting entire files
  18. Loading, editing and saving files in various file formats
    1. Opening and saving text files
    2. Saving to PDF
    3. Opening and saving MySQL *.sql files
    4. Opening and saving SQLite *.db files
    5. Opening and saving html files
    6. Opening and saving dBase/FoxPro/Clipper files
    7. Opening and saving Excel files
  19. Settings and Recently Used database lists
    1. Settings
    2. Managing the list of RU files
  20. Using scripts within GS-Base and COM programming with external tools
    1. COM programming: Samples
    2. COM programming: methods and properties
  21. Contacting technical support