GS-Base

  1. Introducing GS-Base
  2. Notational conventions (numbers, formulas, dates)
  3. Creating new databases
  4. Using table, form and binary views
  5. GS-Base zip database file format
  6. Managing database fields and tables
  7. Editing field contents
  8. Entering unicode characters
  9. Selecting fields and records, scrolling, shortcut keys
  10. Inserting images/files vs inserting links to images/files
  11. Loading images/files form entire folders
  12. Calculated fields and entering formulas and entering formulas
  13. Improving performance when using large files
  14. Using the Increment, Decrement and Operations commands
  15. "Cross-table" calculation functions
  16. Using makeUnique() and isUnique() functions
  17. Using objectStats() functions to obtain file/image data
  18. Using textStats() functions to obtain LongText and Code fields statistics
  19. Using fileStats() functions to obtain EXIF tags and metadata from multimedia files
  20. Scanning and Verifying File (Path) Lists in Tables
  21. Searching for file duplicates in folders and on disks
  22. Default field values
  23. Running totals and moving averages
  24. Inserting series
  25. Using drop-down lists
  26. Generating passwords
  27. Encrypting field contents
  28. Using the Copy-With-Options command
  29. Using dual views
  30. Linking tables in dual views by the 1-n relation
  31. Joining and splitting tables
  32. Merging records from other tables and "Unmerging" records based on other tables
  33. Spell-checking and adding Hunspell dictionaries
  34. Using pivot tables
  35. Pivot table functions
  36. Creating pivot table reports
  37. Formatting - General Styles
  38. Formatting - Hyperlinks
  39. Formatting - Images
  40. Formatting - Charts
  41. Searching - Field filters
  42. Searching - Saving Current Filters As Named Search Keys
  43. Searching - Duplicates
  44. Searching - Unique values
  45. Searching - Values from quartiles, above or below mean
  46. Searching - Random records
  47. Searching - Selected records
  48. Full text searches and replacing
  49. Find-As-You-Type and Find-In-Current-Results searching options
  50. Sorting
  51. Sending e-mail messages
  52. Verifying URLs entered in database fields
  53. Printing tables, forms and labels
  54. Password protection and encrypting entire files
  55. Saving to PDF
  56. Opening and saving text files
  57. Opening and saving MySQL *.sql files
  58. Opening and saving SQLite *.db files
  59. Opening and saving html files
  60. Opening and saving dBase/FoxPro/Clipper files
  61. Opening and saving Excel files
  62. Settings
  63. Managing the list of RU files
  64. COM programming: Samples
  65. COM programming: methods and properties
  66. Contacting technical support