Home list of chapters
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
@
@ in search formula to search all fields 3.5.1
@+Ctrl to set start field for editing 2.5.4
A
Absolute pathnames 4.2.9
Absolute pathnames, conversion to relative 4.2.9
Accented characters, replacement in keys 4.5.2 4.5.3
Accumulating records in one subfile 2.5.6
Adding new records 2.4.1 2.5.1
Adding special features to a database 15.1
AllOf (reserved word in search formulae) 3.5.1
Altering records 2.4.3
Analysing date field by months 3.12
AnyOf (reserved word in search formulae) 3.5.1
AND, use of in search formulae 3.5.1
Application shell for database, creating 4.1
Apply button 2.3.3
Arbitrary selection of records 3.8.1 14.8
Arrow keys, action of 2.4.1
Arrow keys, action of in scrollable lists 2.6.4
Automatic filename-assignment 14.8
Automatic linking to Referenced fields 4.2.9.2
B
Backing up a database 1.2.4
BackupDir file 14.1.8
Browsing buttons 2.2.1
Browsing on-screen reports 2.7
Button fields, creating 4.2.12
Button fields, types of 4.2.12
Button sprites on tool-pane, alternative set 14.1.1
Buttons, non-standard, creating on tool-pane or record window 15.5
Buttons, tool-pane (see Tool-pane buttons)
C
calc() function 3.5.5.4
Calculated fields, using with Numeric fields 6.1.1
Calculations for reports only 6.5
Calculations from an Evaluate button 6.2
Calculations involving dates 6.1.5
Calculations involving times 6.1.4
Calculations on scrollable lists 6.3
Calculations which don't use a Computed field 6.5.2
Calculations, making retrospective 6.1.2
Calculations, using with non-numeric fields 6.1.3
CaseExcept file 4.2.5
Changing many records at once 2.5.5
Changing record format 10.2 14.8
Character validation 5.1
chars() function 3.5.5.2
Check-box fields, creating 4.2.7
Check-box fields, size of icons 14.8
Check-box fields, types of 4.2.7
Choices files, for individual databases 14.1.8
Choices files, for individual users 14.1.8
Choices files, list and explanation of 14.1.8
Choices files, priority of use 14.1.9
Choices, locations for saving 14.1.8
Choices, preserving when upgrading 14.1.11
Closing a database 1.2.3
Colour, record window background 14.8
Colours in reports 3.2.1
Colours of special fields 2.1.3 2.4.1 14.5
Column calculations on reports 6.5.1
Columns format 3.2.1
Comparators for search elements, table of 3.5.1
Composite fields, use of 6.1.6
Computed fields 6.1
Concatenated fields in reports 3.2.2 3.2.4
Concatenated fields from scripts 12.2
Conditional validation 5.4.3
Config files 14.8
Copying a record 2.5.3
Copying a record to a different subfile 2.4.2.1
Copying fields 2.5.2
Cross-referencing records 2.2.2 4.2.5.5
CSV file for data export 8.3
CSV file for data import 8.4
CSV file, using to create working database from scratch 8.7
CSV file, using to import data to validation table 8.6
CSV files and Scrollable lists 8.3.1
CSV files, description of 8.1
CSV files, modifying existing records with 8.5
CSV import, data too long for field 8.4.5
CSV import, directing data to the correct fields 8.4.2
CSV import, importance of correct option settings 8.4.1
CSV options window 8.2
CSV options 14.2
CSV options, setting 8.2
CSVimport into a Scrollable list 8.4.3
CSVoptions file 14.1.8
Customisation demonstration 15.1
Customisation libraries, location of 15.3 15.4 14.8
Customisation libraries, maximum 14.8
Customisation, special functions 15.2
Customisation, things which must only happen once 15.6
Customised buttons on tool-pane or record window 15.5
Customising a database, first steps 15.2
D
Data entry 2.4.1 2.4.3 2.5.1
Data entry into fields linked to validation tables 14.8
Database, changing record format 10.2 14.8
Database, creating blank 4.6
Database, backing up 1.2.4
Database, closing 1.2.3
Database, creating wholly from CSV file 8.7
Database, default 4.3
Database, opening 1.2.3
Database, renaming without loss of sprite 4.7
Database, viewing details of 10.6
Database application shell, creating 4.1
Database length, changing 10.4
Database size 4.4
Date fields, calculations on 6.1.5
Date fields, flexibility of data entry into 6.1.5
Date fields, formats for 4.2.5
Date fields, omitting day from 4.2.5
Date fields, separator for 14.1.2
Date fields, short, century choice 6.1.5
Default selection 3.4.2
Defining the function keys 14.6
Deleting many records at once 2.5.6
Deleting records 2.4.2 2.5.6
Deleting, inserting and re-ordering fields 4.2.2
Designing record layout 4.2
Desktop font, fields adjusted to accommodate 14.8
Detecting events in a customisation library 15.7
Dialling phone numbers 4.2.5.4
Directory button, display options for opened directory 14.8
Displayed record as sole member of a report 3.9
Drag and drop, transferring data between applications 8.8
Drawfiles, displaying on the record window 4.2.11
Duplicate primary keys 11.2.1
E
Editable fields, creating 4.2.5
Editable fields, types of 4.2.5
Editing, start field for caret 14.1.6 2.5.4
Editing External fields 2.6.2
Editing on-screen reports 2.7 14.8
Editing scrollable lists 2.6.4
Email distribution lists 12.2
Emailing Powerbase Support 1.3.3
Empty database, creating 4.6
Entering data 2.4.1 2.4.3 2.5.1
Evaluate button, calculations using 6.2
Events in customised databases, enabling and detecting 15.7
Exact match button, effect of 5.4.2
Excluding randomly-selected records from report 3.8.1 14.8
Exporting data as a CSV file 8.3
Exporting data from records 8.8
Exporting data, prohibiting 11.1 11.2
External fields, attaching files to 2.6.1
External fields, clearing 2.6.3
External fields, creating 4.2.8
External fields, editing 2.6 2.6.2
External fields, effect of mouse clicks on 4.2.8.2
External fields, exporting field contents 2.6.3
External fields, types of 4.2.8
External files, auto-displaying of 4.2.10
Extra "fieldless" calculations 6.5.2
F
Field analysis reports 3.12
Field concatenation 3.2.2 3.2.4 12.2
Field-per-line format 3.2.2
Field selection for reports 3.4
Field selection, clear after reporting 14.8
field() function 3.5.5.3
FieldCols file 14.1.8
Fields, Button, types of 4.2.13
Fields, Check-box, types of 4.2.7
Fields, copying 2.5.2
Fields, creating (new or modified database) 4.2.1
Fields, deleting 4.2.2
Fields, Editable, types of 4.2.5
Fields, External, types of 4.2.8
Fields, inclusion in reports 3.3
Fields, inserting 4.2.2
Fields, mandatory 14.8
Fields, maximum number 4.2.14
Fields, moving and re-sizing bounding box of 4.2.3
Fields, re-sequencing 4.2.2
Fields, selecting for reports etc. 3.4
Fields, Stamp, types of 4.2.12
Filenames, auto-assignment of 14.8
Filenames in script commands 12.1.1
Filenames, maximum length 14.8
Filenames, printed under Directory and Run file buttons 14.8
Filter, restricting retrieved records with 2.3.3 9.2.2
Fkeys file 14.1.8
Fonts in printed reports, size of 3.11.1
Function keys, defining 14.6
Function keys, disabling 11.1 11.2
Functions for use in search formulae 3.5.5
G
Global changes 2.5.5
GridOpts file 14.1.8
H
Help, where to find 1.3
Help (PbaseDoc) 1.3.2
Help application (Acorn) 1.3.1
Help window for entering search formulae 3.7.1
Hiding sensitive data 2.5.7
I
Ignore lists for key definitions 4.5.3
Ignore lists, warning concerning invalid keys 4.5.4
Importing data from a CSV file 8.4
Importing data from plain text files to Scrollable lists 8.4.4
Impression, merging the data from Powerbase 9.2.2
Impression, preparing document for mail-merging 9.2.1
ImpulseII data-merging, application for 14.1.7
Including randomly-selected records in report 3.8.1 14.8
Index trees, balancing 10.5
Index trees, displaying 10.5
Indexes and speed of reporting 7.3
Indexes, auto-saving of 14.1.5 7.2
Indexes, maximum 14.8
Indexing a field 7.1
Individual I.D.s and passwords 11.1.1
Installing Powerbase 1.1.1
J
JPEGs, displaying on the record window 4.2.11
K
K file in PrintRes, purpose of 2.3.1
Key, inclusion in report 3.7.4
Key, searching for record with 2.3.1 2.3.1.1
Key, switching to different one 2.2.3
Keypad as alternative to tool-pane 14.1.1
Keys, explanation of 2.1.3
Keys, maximum 14.8
Keys, more than one field in 4.5.3
Keys, order in index files 4.5.5
L
Label format 3.2.4
Layout grid options 14.4
Libraries for customisation 10.8
Libraries for database customisation, location of 15.3 15.4
Limitations to list edit mode 2.7.3
Line length in printed output 3.11.1
Linking tables to fields 5.4
List-edit mode 2.7 14.8
List-edit mode, limitations 2.7.3
Load default button, action of 14.1.10
Loading Powerbase 1.2.1
Locking fields against deletion 2.5.8
Log files 11.3
Logging database changes 11.3
Looping in a script file 12.6
M
Mail-merging with Ovation 9.1
Mail-merging with EasiWriter/Techwriter 9.2
Mail-merging with Impression 9.3
Mail-merging with Ovation Pro 9.3
Mail-merging with other programs 9.4
Manager-level access 11.1 11.2 11.3 10
Mandatory fields 4.2.13
Margins in printed reports 3.11.2
Marking groups of records using a search formula 3.8.2 14.8
Marking records for inclusion or exclusion 3.8
Marking records from a report window 2.7.1
Match window, features 3.7
Menu, iconbar, disabling 11.1 11.2
Menu, main, disabling 11.1 11.2
Merging two databases 10.3
Messages file 14.9
Mistakes in data entry, correcting 2.4.4
Mouse, reversing SELECT/ADJUST actions 14.1.1
Moving many records at once 2.5.6
Moving a record to a different subfile 2.4.2.1 2.5.6
Multi-tasking 14.8
N
New database, quick setup 4.3
New records, adding to database 2.4.1 2.5.1
New, working database from a CSV file 8.7
NoneOf (reserved word in search formulae) 3.5.1
Numeric and other special fields in search formulae 3.5.2
O
Opening a database 1.2.3
Option buttons on Preferences window, explanation of 14.1.4
Output destination 3.1
Ovation Pro, merging the data from Powerbase 9.2.2
Ovation Pro, preparing document for mail-merging 9.2.1
Ovation, merging the data from Powerbase 9.1.2
Ovation, preparing document for mail-merging 9.1.1
P
Password entry, force to uppercase 14.8
Password protection, levels of 11.1
Password window 11.1
Password window, options controlling database use 14.7
Password window, options selectable from 11.2
Passwords and I.D.s, personal 11.1.1
Pathnames used in Referenced fields 4.2.9
Pathnames used in Referenced fields, maximum length 14.8
Pathnames, absolute 4.2.9
Pathnames, relative 4.2.9
Phone numbers, tone-dialling 4.2.5.4
Powerbase Support, emailing 1.3.3
Powerbase website, accessing 1.3.3
Powerbase, description and installation 1.1
Powerbase, quitting 1.2.5
Preference file 14.1.8
Preferences window 14.1
Preserving choices when upgrading 14.1.11
Primary key, "split" characters 4.5.4
Primary Key, altering structure of 10.1
Primary key, defining 4.5
Primary key, examples of 4.5.2 4.5.3 4.5.4
Primary key, list of words to be ignored 4.5.3
Primary key, more than one field in 4.5.3
Primary keys, repeated 11.2.1
Print margins in reports 3.11.2
Printer destination 3.1.5
Printer setup options 14.3
Printer setup window 3.11
Printing speed 3.11.3
!PrintOpts file 14.1.8
Protecting data against deletion 2.5.8
Q
Q file in PrintRes, purpose of 3.5
Query by example (QBE), explanation 3.6.1
Query by example, comparison with query by search formula 3.6.2
Query panel, features 2.3.3 3.13 3.7 7.3
Query panel, windows using Ch 2,Note 7
Querying a database 3.5
Querying scrollable lists 3.5.4
Querying validation tables 5.9
R
Read-only access 11.1
Read-write access 11.1
Record format, altering 10.2 14.8
Record layout, designing 4.2
Record number, inclusion in report 3.7.4
Record number, searching for record with 2.3.2
Record numbers, meaning of 2.1.2
Record window, margins 14.8
Record window, scroll-bars or not 14.8
Record, copying then editing 2.5.3
Record, retrieving from the report window 3.1.3
Records, global changes to 2.5.5
Record window background colour of 14.8
Relative pathnames 4.2.9
Relative pathnames, conversion to absolute 4.2.9
Reloading saved reports 3.1.2
Referenced fields 4.2.9
Referenced fields, rectifying invalid pathnames 4.2.9.1
Referenced fields, auto-linking to 4.2.9.3
Referenced fields, including text in reports 3.4
Referenced fields, locating a mislaid object 4.2.9.2
Renaming a database without loss of sprite 4.7
Repeated primary keys, listing 10.7
Repeated primary keys, prohibiting 11.1 11.2
Replace on entry feature 5.4.1
Report button 3.5
Report destination, Printer 3.1.5
Report destination, Text-file 3.1.4
Report destination, Window 3.1.1
Report formats 3.2
Report generation, prohibiting 11.1 11.2
Report options files, saving 3.10.3
Report options window 3.10
Report options 14.3
Report options, effect of option buttons 3.10.2
Report window, double-clicking on 3.1.3
Reporting only the displayed record 3.9
Reports (on-screen), browsing and searching 2.7.1
Reports (on-screen), discarding 3.1.1
Reports (on-screen), editing 2.7.2 14.8
Reports (on-screen), reloading after saving 3.1.2
Reports (on-screen), sorting 3.1.1 14.8
Reports from more than one subfile 3.7.3
Reports, calculations on column of 6.5.1
Reports, pre-sorting 3.2.1
Reports, saved, reloading 3.1.2
Reports, where sent 3.1
S
Saving choices 14.1.8
Saving selection files 3.4.1
Scaled image fields 4.2.8.1
Script file, auto-running 12.1.2
Script commands: full list, alphabetical
!BMARGIN 12.4
!BODYFONT 12.4
!CASE 12.2
!CHANGE 12.5
!CLEAR 12.2
!CLICK 12.7
!COMMENT 12.7
!COPIES 12.4
!CSV and !CSVM 12.2
!DATA 12.6
!DATE 12.3
!DELETE 12.5
!DESTINATION 12.3
!DISPLAY 12.7
!DUMP 12.2
!ENDLOOP 12.6
!EXCLUDE 12.2
!EXPAND 12.3
!FILE 12.2
!FILTER and !FILTERM 12.5
!FILTEROPEN 12.5
!FIND 12.5
!FIRST 12.5
!FIRSTPAGE 12.3
!FONTSIZE 12.4
!FOOTER 12.3
!GETNUMBER 12.3
!GETSTRING 12.3
!FORMAT 12.3
!HEADER 12.3
!HEADERFONT 12.4
!HEADINGS 12.3
!IMPRESSION 12.7
!INCLUDE 12.2
!INDEX 12.5
!INSERT 12.5
!KEY 12.2
!LABCOPIES 12.4
!LABEL 12.4
!LAST 12.5
!LINE, !LINED and !LINEC 12.2
!LINESPACE 12.4
!LMARGIN 12.4
!LOOP 12.6
!MAILMERGE 12.7
!MESSAGE 12.7
!MOVE 12.5
!NEXT 12.5
!OBEY 12.7
!ONCEONLY 12.2
!OPEN 12.7
!ORIENTATION 12.4
!PAGE 12.3
!PAUSE 12.6
!PDRIVER 12.4
!PMARGINS 12.4
!POINTER 12.7
!PREPROCESS 12.7
!PREVIOUS 12.5
!PRINT 12.2
!PRINTCOLUMNS 12.4
!PRINTOPTS 12.3
!QUERY and !QUERYM 12.2
!REVERSE 12.2
!RMARGIN 12.4
!RULES 12.3
!SAVE 12.2
!SAVESCRIPT 12.7
!SCRIPT 12.1
!SELECT or !SELECTION 12.2
!SHRINK 12.3
!SLIDESHOW, !SLIDESHOWS and !SLIDESHOWR 12.7
!SORT 12.3
!SPACER 12.3
!STARTAT 12.5
!SUBFILES 12.2
!TABLE 12.4
!TEXTWIDTH 12.3
!TITLE 12.3
!TMARGIN 12.4
!UPPER 12.3
!WAIT 12.6
Script files, editing commands 12.5
!CHANGE 12.5
!DELETE 12.5
!FILTER and !FILTERM 12.5
!FILTEROPEN 12.5
!FIND 12.5
!FIRST, !LAST, !NEXT, !PREVIOUS 12.5
!INDEX 12.5
!INSERT 12.5
!MOVE 12.5
!STARTAT 12.5
Script files, filenames in 12.1.1
Script files, miscellaneous commands 12.7
!CLICK 12.7
!SAVESCRIPT 12.7
!COMMENT 12.7
!DISPLAY 12.7
!SLIDESHOW, !SLIDESHOWS and !SLIDESHOWR 12.7
!POINTER 12.7
!PREPROCESS 12.7
!IMPRESSION 12.7
!MAILMERGE 12.7
!MESSAGE 12.7
!OBEY 12.7
!OPEN 12.7
Script files, reporting commands 12.2
!CASE 12.2
!CSV and !CSVM 12.2
!DUMP 12.2
!EXCLUDE, !INCLUDE, !CLEAR 12.2
!FILE 12.2
!KEY 12.2
!LINE, !LINED and !LINEC 12.2
!ONCEONLY 12.2
!PRINT 12.2
!QUERY and !QUERYM 12.2
!REVERSE 12.2
!SAVE 12.2
!SELECT or !SELECTION 12.2
!SUBFILES 12.2
Script files, requesting user input 12.8
Script files, setting print options 12.3
!DATE 12.3
!DESTINATION 12.3
!EXPAND 12.3
!FIRSTPAGE 12.3
!FOOTER 12.3
!FORMAT 12.3
!HEADER, !FOOTER 12.3
!HEADINGS 12.3
!PAGE 12.3
!PRINTOPTS 12.3
!RULES 12.3
!SHRINK 12.3
!SORT 12.3
!SPACER 12.3
!TEXTWIDTH 12.3
!TITLE 12.3
!UPPER 12.3
Script files, setting printer setup options 12.4
!BMARGIN, !LMARGIN, !RMARGIN, !TMARGIN, !PMARGINS 12.4
!BODYFONT, !HEADERFONT 12.4
!COPIES 12.4
!FONTSIZE 12.4
!LABCOPIES 12.4
!LABEL 12.4
!LINESPACE 12.4
!ORIENTATION 12.4
!PDRIVER 12.4
!PRINTCOLUMNS 12.4
!TABLE 12.4
Script files, using a loop 12.6
!DATA 12.6
!ENDLOOP 12.6
!LOOP 12.6
!PAUSE 12.6
!WAIT 12.6
Scrollable lists and CSV files 8.3.1
Scrollable lists, alternative formats 3.10.1
Scrollable lists, calculations on 6.3
Scrollable lists, creating 4.2.6
Scrollable lists, data import from text file 8.4.4
Scrollable lists, editing 2.6.4
Scrollable lists, maximum 14.8
Scrollable lists, maximum columns 14.8
Scrollable lists, querying with search formulae 3.5.4
Scrollable lists, report options for 3.10.1
Scrollable lists, sorting 2.6.4
Search formulae, construction of 3.5.1
Search formulae, entry via Help window 3.7.1
Search formulae, references to validation tables in 5.9
Search formulae, saving 3.5.6
Searching by filter 2.3.3
Searching by key 2.3.1
Searching by record number 2.3.2
Searching for complex keys 2.3.1.1
Selection file, default 3.4.2
Selection files, saving 3.4.1
Selection, clear after reporting 14.8
Selection of fields for reporting 3.4
Sensitive data, concealing from prying eyes 2.5.7
Separators in date and time fields 14.1.2
Short-cut to a working database 4.3
Size of fonts in printed reports 3.11.1
Sorting reports before displaying or printing 3.2.1
Sorting reports in a window 3.1.1
Sorting validation tables 5.6
Sorting scrollable lists 2.6.4
Split characters for key definitions 4.5.4
Sprites, displaying on the record window 4.2.11
Stamp fields, creating 4.2.12
Stamp fields, types of 4.2.12
Start fields for editing at 14.1.6 2.5.4
Starting and ending a work session 1.2
Startup banner, display time of 14.8
Subfile control window 2.2.6
Subfile number, inclusion in report 3.7.4
Subfile, changing 2.2.4
Subfiles, explanation of 2.1.1
Subfiles, naming 2.1.1
Subfiles, reports containing records from several 3.7.3
Subfiles, selection status saved with query 3.5.6
Subfiles, when to use more than one subfile 2.2.5
Submenus, left-opening 14.8
Subset database, exporting 13.1
Subset database, using to shorten a database 13.2
Subsidiary index, creating 7.1
Subsidiary indexes and speed of reporting 3.13
T
Table button 2.4.2
Table format 3.2.3
Table validation 5.2
Tag, purpose of 2
Tags, automatically assigned by Dup button 4.2.4
Tags, importance of 4.2.4
Tags, easy entry into search formulae etc. 3.7.2
Tags, where they can be duplicated 4.2.13
Tags, where they can be omitted 4.2.4
Tags and descriptors 4.2.4
Targetting records to includein report 3.5
Template for fixed data entries 2.5.1
Text file destination 3.1.4
Time fields 4.2.5 14.8 14.8
Time fields, calculations on 6.1.4
Time fields, separator for 14.1.2
Title screen for database 14.10
Tone-dialling phone numbers 4.2.5.4
TooBig file, use in CSV import 8.4.5
Tool-pane buttons:
Add record 2.4.1
Backup 1.2.4
Bookmarks 2.2.1
Change index 2.2.3
Change subfile 2.2.4
Copy to clipboard 2.5.2
Delete record 2.4.2
Single step 2.2.1
Ends 2.2.1
Fast forward/rewind 2.2.1
Filter 2.3.3
Move record 2.4.2
Paste from clipboard 2.5.2
Play 2.2.1
Report 3.5
Search 2.3.1
Stop 2.2.1
Table 2.4.2
Update 2.4.1
Tool-pane, description of 2.2
Tool-pane, disabling 11.1 11.2
Tool-pane, keypad as alternative 14.1.1
U
!Undo applications, directory for 14.8
Undoing mistakes 2.4.4
Update button (on tool-pane) 2.4.1
Update button (in List edit mode) 2.7.2
User functions 6.4
User menus, inputting data into fields from 4.2.13
User input from a script file 12.8
V
Validated field, action on "illegal" entries 14.8
Validation, character 5.1
Validation, conditional 5.4.3
Validation, disabling 5.4.3
Validation, table 5.2
Validation table, clearing 5.6
Validation table, colour of fields linked to 2.4.1 14.5
Validation table, creating 5.3
Validation table, displaying 5.5
Validation table, entering data into a record 5.10
Validation table, expanding entry codes with 3.10.2
Validation table, expanding report headers with 3.10.2
Validation table, exporting as CSV file 5.6
Validation table, importing data from CSV file 8.6
Validation table, including data in reports 5.8
Validation table, linking to field 5.4
Validation table menu 5.6
Validation table, modifying structure 5.6
Validation table, querying contents in search formulae 5.9
Validation table, replace on entry feature 5.4.1
Validation table, saving 5.6
Validation table, sorting 5.6
Validation table, undoing changes 5.6
Validation table, write back to records from 5.4.4
Validation table, write back via user function 5.4.5
Validation tables, loading 5.7
Validation tables, maximum 14.8
Validation tables, maximum columns 14.8
ValTables directory 5.6 5.7
W
White space, removal from reports 3.1.1 3.10.1 3.10.2
Wild-cards in search formulae 3.5.3
Wild-cards, choice of special characters for 14.1.3
Window destination 3.1.1
word() function 3.5.5.1
Y
Year (field-type) 4.2.12
Yellow background to field, meaning of 6.1 2.1.3
Yes/No/Maybe field type 4.2.5
Home list of chapters