GS-Base 22.7

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 from entire folders
6. Using the increment, decrement and operations commands
7. Inserting running totals and moving averages
8. Inserting series
9. Entering data: drop-down lists
10. Generating passwords
11. Encrypting field contents
12. Default field values
13. Using the copy with options command
5. Optimizing performance
1. Improving performance when using large files
6. Calculated fields
1. Calculated fields and entering formulas
2. Using makeUnique() and isUnique() functions
3. Using objectStats() functions to obtain file/image data
4. Using textStats() functions to obtain LongText and code field statistics
5. Using fileStats() functions to obtain EXIF tags and metadata from multimedia files
7. Calculation functions by category
1. Roll-up functions
2. Mathematical functions
3. Textual functions
4. Date/time functions
5. Informational functions
6. Statistical functions
7. Financial functions
8. Lookup functions
9. Logical functions
10. Engineering functions
11. Solver functions
12. Matrix functions

8. Using Python in GS-Base

   1. Using Python functions as UDF() functions
   2. Installing Python and integrating it with GS-Base
9. Pivot tables
1. Using pivot tables
2. Pivot table functions
3. Creating pivot table reports
10. Finding file duplicates, photo/MP3/MP4 duplicates, listing files and their history of changes
1. Verifying file (path) lists in tables
2. Mass-renaming, copying and deleting files
3. Searching for photo/image/media file duplicates in folders and on disks
11. Displaying two tables from the same database and setting up a relation between them
1. Using dual views
2. Linking tables in dual views by the 1-N relation
12. Joining, splitting, merging and comparing tables and records
1. Joining and splitting (normalizing) tables
2. Merging and unmerging records
3. Comparing records in two tables
13. Spell-checking
1. Spell-checking and adding Hunspell dictionaries
14. Formatting: styles, hyperlinks, background images and in-cell charts
1. Formatting - general styles
2. Formatting - hyperlinks
3. Formatting - images
4. Formatting - charts
15. Searching, filtering, sorting
1. Searching / filtering records
2. Searching / saving current filters as named search keys
3. Searching - duplicates
4. Searching - unique field values
5. Searching - quartiles, mean values
6. Searching - random records
7. Searching - selected records
8. Full text searches and replacing
9. Find-as-you-type and find-similar searching options
10. Sorting
16. Sending emails and verifying URLs
1. Sending email messages
2. Verifying URLs entered in database fields
17. Printing tables, forms, letters and labels, mail-merge
1. Printing tables, forms, letters and labels
18. File-level password protection and encryption
1. Password protection and encryption
19. 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 workbooks
20. Settings and recently used database lists
1. Modifying program settings
2. Managing the list of recently-used files
21. Using scripts within GS-Base and COM programming with external tools
1. JScript / VBScript scripting: samples
2. C++ COM programming: samples
3. COM programming: methods and properties
22. Contacting technical support