Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/!Tutorial
!AWApr94/Goodies/PowerBase/PBaseDoc/!Tutorial
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
Tape/disk: | Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 |
Filename: | !AWApr94/Goodies/PowerBase/PBaseDoc/!Tutorial |
Read OK: | ✔ |
File size: | 5FE4 bytes |
Load address: | 0000 |
Exec address: | 0000 |
File contents
Tutorial ======== This document is intended to acquaint the new user as painlessly as possible with the most commonly-used facilities of Powerbase. It does not explain how to create a database from scratch (the file 'Create' does that) but it does explain how to:- (a) Start up Powerbase and open an existing database. (b) Browse through the database and search for individual records. (d) Add new records and alter or delete existing ones. (d) Query the database to create simple reports. (e) Close the database. The supplied sample database 'Elements' is used to illustrate most of these activities. If you have a hard disc you should copy 'Elements' and Powerbase itself onto it before proceeding further. It is possible to use Powerbase using floppy discs only but some operations, such as creating reports, will be quite slow. Unless memory is very tight therefore, users of floppy discs are recommended to allocate at least 112K to the RAM disc and copy 'Elements' onto it. Everything will then run much faster. Powerbase can provide context-sensitive help via Acorn's !Help application and you are advised to load this, resizing the help window and placing it at the top right of the screen. Further help can be had by choosing the Help entry on Powerbase's main menu or on the icon-bar menu. Starting Powerbase ================== Double-click on the Powerbase icon. After a few seconds it will appear on the icon-bar with the words "No data" beneath it to show that no database is open. Dragging the 'Elements' icon onto the Powerbase icon on the icon-bar will open 'Elements' for use and the words "No data" will be replaced by the name of the database. Double-clicking on the 'Elements' icon has the same effect, in fact if Powerbase isn't already on the icon-bar a double-click on 'Elements' will install it for you provided that the Powerbase icon has been seen by the filer. Two windows will open. One is the RECORD WINDOW and displays the first record in the database. The other is the KEYPAD which allows you to control the browsing, searching and editing functions of Powerbase. The keypad is rather large and obscures quite a big area of the record window. The most-used buttons, however, are on the top two rows and the keypad can be moved part way off screen to get it out of the way. Browsing through the Records ============================ The top row of buttons on the keypad allows you to browse through the file. If you have !Help running, as previously suggested, it will tell you what each button does. Once you get the general idea you will find the symbols on the buttons logical and self-explanatory. The most commonly used ones act as follows: * Single arrows move you one record at a time. From ACTINIUM, clicking the right arrow takes you to ALUMINIUM. The left arrow takes you back to ACTINIUM. * Double arrows move you through the file by long hops. Thus the right double arrow takes you from ACTINIUM to BISMUTH and the left one back to ACTINIUM again. The "fast forward/rewind" value is shown in the little box between the "fast wind" buttons. It is initially set to 10 records but can be altered by clicking in it with SELECT and entering a new value. * The buttons at the far left and right take you to the beginning and end of the file. The rightmost button therefore takes you to ZIRCONIUM and the leftmost one to ACTINIUM. One further feature of these buttons should be noted; the file wraps around. If you are at the last record (ZIRCONIUM) one record "forward" takes you to ACTINIUM again. Similarly, one record "back" from ACTINIUM gives ZIRCONIUM. The second row has buttons marked like the 'play' and 'stop' controls of a cassette player. 'Play' allows an automatic 'flip-through' of the records without the need to touch any other buttons. When you get to the place you want, click on 'stop'. If the records go past too quickly you can slow the process down by increasing the number in the central icon of the top row of buttons. (This is normally used to set the 'fast-wind' interval; see above.) Key fields, Keys and Indices ============================ When using the six buttons on the top row of the keypad you will have noticed that the records appear to be arranged alphabetically by the name of the element. The actual order in which records occur in the file is in fact nothing like alphabetical, but the order in which they are ACCESSED is determined by an INDEX which forces them to appear in alphabetical order. Every database must have at least one index, but you can have as many extra ones as you wish (subject to memory and disc limitations). Changing index -------------- The second row of the keypad has two buttons featuring a blue arrow with a key symbol. Click on the right one and the record for HYDROGEN is displayed! If you now experiment with the top row of buttons as before you will find that the records no longer appear in alphabetical order of name but in order of ATOMIC NUMBER instead. What we have done is change to a different index. If a database has multiple indices the "key" buttons allow you to cycle through them in opposite directions. (Since Elements has only two indices the two buttons have exactly the same effect.) When you change to a different index the screen always displays the first record as determined by that index. Keys and key fields ------------------- An index is built from KEYS which are derived from a particular KEY FIELD. The two indices used by Elements are based on the NAME and ATOMIC NUMBER fields. The way in which the key stored in the index is derived from the key field is different in the two cases. For the NAME index the first four letters of the name are used. Since no two elements have names beginning with the same four letters this gives a unique "value" for the key. (Two letters would not have been enough because of such names as CHLORINE and CHROMIUM.) The ATOMIC NUMBER index is based on the whole 3-digit maximum length and the ordering is NUMERIC. Whenever a record is displayed the key is shown in the window title (# characters are for padding and should be ignored.) The record screen clearly shows which fields are keyfields and which are not. The descriptors, or labels, of fields are normally black. Where the fields are keyfields they are shown in dark blue instead and the field used by the current index has its descriptor in red. Note also that the background colour of the NAME field is pale yellow whereas the rest are white . This indicates that NAME is the PRIMARY KEY field. The primary key and the index based on it is more important than the others. It is the one index which a database MUST have and is the one selected when a database is first opened. Searching for a record ====================== The rightmost button on the third row of the keypad shows a question mark followed by a "record card" icon We will call it the Search button. When clicked with SELECT the keypad window grows an extension on the right-hand side. This new area contains a writable icon in which to enter the key of the record you wish to display. Suppose you want to see the record for the element NITROGEN. If the current index is the NAME then type in NITR and either type RETURN or click the 'OK' button. The required record quickly appears. If you enter the key of a non-existent record an error box is displayed. You don't necessarily need to type the whole key; NIT would do in this case, but NI would be ambiguous (there are elements called NICKEL and NIOBIUM). To find NITROGEN when the ATOMIC NUMBER index is active you would need to know that the atomic number of nitrogen is 7. Type this in and type RETURN or click on 'OK' and the record appears. Abbreviated keys are NOT allowed in this case for obvious reasons; if you want element 103 (LAWRENCIUM) it's no good entering 10 (NEON)! Editing the Database ==================== This part of the tutorial involves changes to the data records. Make a working copy of the disc and put the original in a safe place. If you are using a copy of Elements on the RAM disc then the floppy disc won't be altered, but it's still not a good idea to work with the original disc. Modifying records ----------------- Pointing the mouse at any field and clicking SELECT places the caret in that field. The contents of the field may then be edited in the standard way for RISC OS writable icons. i.e. CTRL U clears the field. DELETE removes the character to the left of the caret. COPY removes the character to the right of the caret. SHIFT/COPY deletes the word to the right of the caret. CTRL/COPY deletes everything from the caret to the end of the line. � and � move the caret left/right by one character. SHIFT � and SHIFT � move the caret left/right by one word. CRTL � and CTRL � move the caret to start and end of the field. Changes made to a record cause the record to be written back to the database whenever you display a different record or close the database. There is a button on the keypad called 'Force update' but you don't normally need to use it. At the ends of the third row of keypad buttons are two which contain a vertical blue arrow. Clicking on the left button stores the contents of the field which has the caret in a scratchpad. Moving the caret to another field and clicking the right button copies the data from the scratchpad into that field, over-writing its previous contents. This provides a quick method of copying data from one field to another, or from one record to another. You may continue to "paste" the data into new fields as often as you like. Only when you click the left button again are the contents of the scratchpad changed. Data "pasted" into a field cannot "overflow"; if too long for the field it will be cut to the permitted length. As an added precaution you can't "paste" a null string into a field. Recovering data after a mistake ------------------------------- You will sometimes edit the wrong field by mistake and want to restore the previous contents. Click MENU over the field. The second entry on the main menu contains the "tag" of the field. Follow the right-pointing arrow to the 'Field' sub-menu and choose the last entry: 'Restore field'. Similarly, if you make a mess of a complete record and want to go back to the way it was you can choose 'Restore record' from the main menu. It is important to realise that these 'restore' facilities will not work if you have looked at another record before using them (or clicked on 'Force update'). In other words you can recover data which has been altered in or removed from the currently-displayed record only. Adding new records ------------------ First we will add a new record for a fictitious element as described below:- NAME TASMANIUM SYMBOL Ts ATOMIC NUMBER 108 We could invent a lot more, but this will be enough to get the idea across. At the far left of the second row on the keypad is a button with a plus sign and a "record card" icon. This is the 'Insert' button. A blank record will be displayed with the caret in the NAME field. Enter TASMANIUM here and press RETURN. The caret will jump to the SYMBOL field. Enter Ts. You will now need to press RETURN twice to get to ATOMIC NUMBER (One press takes you to the un-named field after NAME where the origin of the element's name is given.) Alternatively you could point the mouse at the ATOMIC NUMBER box and click SELECT. There is no need to press RETURN after entering a field in order to "accept" the data; it's simply the most convenient way of getting to the next field if that's what you want to do. When entering data into widely- scattered fields it is more convenient to use the mouse. Having entered your data click any of the first row of buttons so that a different record is displayed. Now use 'Search' to find TASMANIUM by name. Change to the other index and find it by atomic number. In both cases try moving to the record just before and just after the new one, noting that it has been placed in its correct position in both indices: between TANTALUM and TECHNETIUM in the NAME index and at the very end of the ATOMIC NUMBER index. Data Input Validation --------------------- When entering the above data you may have noticed that the NAME field will only accept capital letters and the ATOMIC NUMBER field will only accept numerals. This is because the fields have an associated TYPE which restricts the characters which the field will accept. Any others are simply ignored. We will call this feature TYPE VALIDATION. Another level of data validation, which we will now illustrate, is called TABLE VALIDATION Make an entry in the GROUP field. Type X, for example, then try to move to another field by either pressing RETURN or clicking the mouse. You'll find that you can't do so - you get an error message instead. This is because the GROUP field is linked to a VALIDATION TABLE which means that only entries which appear in the table may be used in that field. Fields linked to validation tables are distinguished by using dark green, instead of black, as the foreground colour. To see what the validation table contains, place the caret in the GROUP field then click on the List values button on the keypad. The validation table will then be displayed in its own window. Only those items in the left column of the table may be entered in the GROUP field. Element 108 would be a transition metal, so enter T. You will now find that Powerbase accepts your data. Both type validation and table validation may be turned off and on by means of an option on the Validation submenu. The item is normally ticked, showing that validation is turned on. Deleting records ---------------- Since "tasmanium" isn't a real element we want to remove it from our database. There is a "dustbin" button which will do just that: but don't use it yet. Make sure that the unwanted record is on the screen and click the button to the RIGHT of the bin. You will now find that "tasmanium" has vanished; the names run straight from TANTALUM to TECHNETIUM and the atomic numbers end with 103, just as they did before you added the extra record. Wasn't that rather TOO easy? Suppose you clicked the button by mistake and deleted an important record! Powerbase handles this very nicely. The record hasn't really been deleted at all. To prove this, click the button above the one you used for "deleting". The button shows a green right-pointing arrow and a "card index" icon. There's TASMANIUM again! You will soon find that it appears to be the ONLY record in the file! Don't worry; nothing has been lost. A Powerbase database is treated as six separate SUBFILES numbered 0-5. When you first open the database you are looking at Subfile 0 and the heading of the record window shows this. If you look at the heading now you will see that it has changed to Subfile 1. The buttons on either side of the bin carry pictures which suggest their true functions. They do NOT delete records; they merely MOVE records from one subfile to another. The right button moves the displayed record to the next subfile in sequence. Thus, in the above case the TASMANIUM record has been moved from subfile 0 to subfile 1. A record in subfile 1 would be moved to subfile 2 and so on. What happens when it gets to 5? The next click shoves it into subfile 0 where it was originally. As you might have guessed, the left button moves records in the opposite direction, i.e. from subfile 1 to 0 or from subfile 0 to 5. What happens when you DO want to lose a record for good? That's when you consign it to the dustbin! Since this button's action is more drastic than that of the other two you are asked for confirmation before deletion occurs. Printing Lists ============== Before Powerbase can produce a list it must be told: * which FIELDS should appear on the list * which RECORDS should appear on the list. Making the field selection -------------------------- Specifying the fields you want is extremely easy. To include a field simply point the mouse at it and click with ADJUST. The selected field will then appear in inverse video (i.e. normally white on black). If you change your mind about a field you can de-select it by clicking on it again with ADJUST. The order in which the fields will appear in the printed list is the order in which you select them. Take care with this since there is nothing on the screen to indicate what order the fields will be in. The fields chosen for inclusion in a printout make up a SELECTION which may be saved and reloaded for future use. Just for now select NAME, SYMBOL and GROUP. Choosing which records to print ------------------------------- Specifying which records to print is somewhat more complex, although efforts have been made to render it as simple as possible. With the mouse pointer in the record window click MENU. This displays the main Powerbase menu from which you should choose Print. A small window appears in which you can specify the criteria which must be met by records for inclusion in the list. If you just click OK (or press RETURN) without entering anything here you will obtain a list of the whole database (or, more accurately, of the the whole of the current subfile ). Try this first. Nothing will be printed until the search is complete. If the mouse pointer is over the main window the hourglass will tell you how far things have progressed. Pressing Escape causes the process to be aborted. When the process is complete the list will be displayed in a window. It may be saved as a text file and printed using the usual RISC OS drivers . If you point to a record in the displayed list and double-click with SELECT Powerbase will display the chosen record in the main record window. Note that the caret is placed in the field you were pointing to on the list. This is very useful if you spot errors in the data whilst examining a list. A double click on the offending item offers the record with the caret correctly positioned for editing. Most database queries, however, don't involve printing all the records! You will usually need to enter a SEARCH FORMULA before clicking OK. Search formulae can be quite complex and a more detailed treatment is given in a later section. Only a couple of simple examples will be shown here. Suppose we want a list of all the transitional elements. i.e. all those which have T in the GROUP field. We can do this by entering the search formula GP=T. Why GP? Shouldn't it be GROUP=T? The latter seems more obvious, but what happens if the field has no descriptor? The record screen of !Elements contains many such fields such as the one on the first line which gives the origin of the element's name. Every field which can hold data has to have a "handle" by which we can refer to it and that handle is called the field TAG. Tags are very short; never more than four characters. You have seen some tags already. Look at the list you printed earlier. The three columns are headed NAME, SYM and GP not NAME, SYMBOL and GROUP. The user therefore meets tags in two contexts: * They are used to specify fields in search formulae * They are the default column headings in lists. The Print options window allows you to change the column headings to the field descriptors if you so wish. Type GP=T in the space provided and click OK. This time the list will be a much shorter one and you will see that the GP column contains T in every case. Our second example involves printing all elements whose names end in "IUM". What we need to specify is that "NAME contains IUM" and we do this by entering the search formula NAME{IUM. Finally we will combine the previous two examples into a two-pronged search for all the TRANSITIONAL elements whose names end in "IUM". The search formula this time is NAME{IUM AND GP=T. Note the spaces before and after AND. These are essential. You might like to try an alternative way of entering this search formula. Proceed as follows: * Click the "toggle size" icon of the matching records window. This makes it expand to show more controls. * NAME should already be visible as the required field, but you need to select the radio button for Contains. * Click in the space next to Value: and enter IUM. * Click the AND button to select it. * Click Add to formula. The search formula should now read NAME{IUM AND. * Click on the field tag (currently NAME) until it reads GP * Select Is equal to. * Enter T in the Value field. * Click Add to formula. The complete search formula should now be visible so click OK and the list will be produced. The above takes far longer to describe than it does to do and can be a great help to the infrequent Powerbase user who has trouble remembering the syntax of search formulae. If you use certain complex queries often you may find it convenient to save them for future use . The biggest problem you are likely to encounter is not knowing the tags for the various fields. The method just described gets round the problem by letting you cycle through the tags by clicking on an icon rather than typing them directly. You will also find that clicking with SELECT on a field while holding down ALT causes the tag of that field to appear in the search formula icon. Closing down ============ A database may be closed down by choosing the Close database entry from the icon bar menu. When you do so, all the indices stored in memory are saved to disc (the Save indices button on the keypad gives a clear indication of this) and the database is closed. You do not have to do anything to save the database itself to disc since it has been there all along. Only the current record is in memory at any one time and this is automatically written back to disc when it has been changed in any way. Also saved automatically is the link file which holds the relational links between the main database and the validation tables. The tables themselves are NOT saved automatically. If you have edited a table, or created a new one, you will need to click MENU over the displayed table and choose the Save option from it. If you are going to use another database straight away just double click on it or drag it to the Powerbase icon on the icon bar. In fact you don't even need to close the previous database before doing this; Powerbase will do it for you. When working with a database on the RAM disc Powerbase will issue a warning that the data is not secure and that you need to drag it from the RAM disc to a floppy or hard disc before switching off. To terminate Powerbase itself use the Quit option on the icon bar menu. Merging data into an Impression document ======================================== The distribution disc contains a simple Impression document called 'MergeTest'. It will be used in conjunction with the 'Elements' database to illustrate direct data-merging with Impression. (1) Make sure that Impression has been "seen" by the filer. (You need not actually load it.) (2) Open the 'Elements' database and drop 'MergeTest' onto the record window. (3) Click on 'Merge' in the 'Merge data' dialogue box. You will see that data relating to the record for ACTINIUM has been inserted into the Impression document. (4) The arrow and double-arrow buttons (identical to those on the keypad) may be used to move through the database causing different records to be merged into the document. (5) A search formula may be used to restrict the operation to records matching certain criteria. (6) 'Print' may be used to print the document with the currently-merged data. To print a set of documents, one for each matching element, select the 'Print all' switch then click on 'Merge'. During data-merging Impression editing is disabled - you can't place the caret in the document and the mouse pointer appears as a red and blue cross. Clicking on 'Cancel' or closing the 'Merge data' dialogue box restores normal editing. For more information on data-merging, including instructions on how to prepare the Impression document, see 'MailMerge'.
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | * 00000020 54 75 74 6f 72 69 61 6c 0a 20 20 20 20 20 20 20 |Tutorial. | 00000030 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000040 20 20 20 20 20 20 20 20 20 3d 3d 3d 3d 3d 3d 3d | =======| 00000050 3d 0a 0a 54 68 69 73 20 64 6f 63 75 6d 65 6e 74 |=..This document| 00000060 20 69 73 20 69 6e 74 65 6e 64 65 64 20 74 6f 20 | is intended to | 00000070 61 63 71 75 61 69 6e 74 20 74 68 65 20 6e 65 77 |acquaint the new| 00000080 20 75 73 65 72 20 61 73 20 70 61 69 6e 6c 65 73 | user as painles| 00000090 73 6c 79 20 61 73 20 70 6f 73 73 69 62 6c 65 0a |sly as possible.| 000000a0 77 69 74 68 20 74 68 65 20 6d 6f 73 74 20 63 6f |with the most co| 000000b0 6d 6d 6f 6e 6c 79 2d 75 73 65 64 20 66 61 63 69 |mmonly-used faci| 000000c0 6c 69 74 69 65 73 20 6f 66 20 50 6f 77 65 72 62 |lities of Powerb| 000000d0 61 73 65 2e 20 49 74 20 64 6f 65 73 20 6e 6f 74 |ase. It does not| 000000e0 20 65 78 70 6c 61 69 6e 20 68 6f 77 0a 74 6f 20 | explain how.to | 000000f0 63 72 65 61 74 65 20 61 20 64 61 74 61 62 61 73 |create a databas| 00000100 65 20 66 72 6f 6d 20 73 63 72 61 74 63 68 20 28 |e from scratch (| 00000110 74 68 65 20 66 69 6c 65 20 27 43 72 65 61 74 65 |the file 'Create| 00000120 27 20 64 6f 65 73 20 74 68 61 74 29 20 62 75 74 |' does that) but| 00000130 20 69 74 20 64 6f 65 73 0a 65 78 70 6c 61 69 6e | it does.explain| 00000140 20 68 6f 77 20 74 6f 3a 2d 0a 0a 20 20 20 20 20 | how to:-.. | 00000150 20 20 20 28 61 29 20 53 74 61 72 74 20 75 70 20 | (a) Start up | 00000160 50 6f 77 65 72 62 61 73 65 20 61 6e 64 20 6f 70 |Powerbase and op| 00000170 65 6e 20 61 6e 20 65 78 69 73 74 69 6e 67 20 64 |en an existing d| 00000180 61 74 61 62 61 73 65 2e 0a 20 20 20 20 20 20 20 |atabase.. | 00000190 20 28 62 29 20 42 72 6f 77 73 65 20 74 68 72 6f | (b) Browse thro| 000001a0 75 67 68 20 74 68 65 20 64 61 74 61 62 61 73 65 |ugh the database| 000001b0 20 61 6e 64 20 73 65 61 72 63 68 20 66 6f 72 20 | and search for | 000001c0 69 6e 64 69 76 69 64 75 61 6c 20 72 65 63 6f 72 |individual recor| 000001d0 64 73 2e 0a 20 20 20 20 20 20 20 20 28 64 29 20 |ds.. (d) | 000001e0 41 64 64 20 6e 65 77 20 72 65 63 6f 72 64 73 20 |Add new records | 000001f0 61 6e 64 20 61 6c 74 65 72 20 6f 72 20 64 65 6c |and alter or del| 00000200 65 74 65 20 65 78 69 73 74 69 6e 67 20 6f 6e 65 |ete existing one| 00000210 73 2e 0a 20 20 20 20 20 20 20 20 28 64 29 20 51 |s.. (d) Q| 00000220 75 65 72 79 20 74 68 65 20 64 61 74 61 62 61 73 |uery the databas| 00000230 65 20 74 6f 20 63 72 65 61 74 65 20 73 69 6d 70 |e to create simp| 00000240 6c 65 20 72 65 70 6f 72 74 73 2e 0a 20 20 20 20 |le reports.. | 00000250 20 20 20 20 28 65 29 20 43 6c 6f 73 65 20 74 68 | (e) Close th| 00000260 65 20 64 61 74 61 62 61 73 65 2e 0a 0a 54 68 65 |e database...The| 00000270 20 73 75 70 70 6c 69 65 64 20 73 61 6d 70 6c 65 | supplied sample| 00000280 20 64 61 74 61 62 61 73 65 20 27 45 6c 65 6d 65 | database 'Eleme| 00000290 6e 74 73 27 20 69 73 20 75 73 65 64 20 74 6f 20 |nts' is used to | 000002a0 69 6c 6c 75 73 74 72 61 74 65 20 6d 6f 73 74 20 |illustrate most | 000002b0 6f 66 20 74 68 65 73 65 0a 61 63 74 69 76 69 74 |of these.activit| 000002c0 69 65 73 2e 20 49 66 20 79 6f 75 20 68 61 76 65 |ies. If you have| 000002d0 20 61 20 68 61 72 64 20 64 69 73 63 20 79 6f 75 | a hard disc you| 000002e0 20 73 68 6f 75 6c 64 20 63 6f 70 79 20 27 45 6c | should copy 'El| 000002f0 65 6d 65 6e 74 73 27 20 61 6e 64 20 50 6f 77 65 |ements' and Powe| 00000300 72 62 61 73 65 0a 69 74 73 65 6c 66 20 6f 6e 74 |rbase.itself ont| 00000310 6f 20 69 74 20 62 65 66 6f 72 65 20 70 72 6f 63 |o it before proc| 00000320 65 65 64 69 6e 67 20 66 75 72 74 68 65 72 2e 20 |eeding further. | 00000330 49 74 20 69 73 20 70 6f 73 73 69 62 6c 65 20 74 |It is possible t| 00000340 6f 20 75 73 65 20 50 6f 77 65 72 62 61 73 65 0a |o use Powerbase.| 00000350 75 73 69 6e 67 20 66 6c 6f 70 70 79 20 64 69 73 |using floppy dis| 00000360 63 73 20 6f 6e 6c 79 20 62 75 74 20 73 6f 6d 65 |cs only but some| 00000370 20 6f 70 65 72 61 74 69 6f 6e 73 2c 20 73 75 63 | operations, suc| 00000380 68 20 61 73 20 63 72 65 61 74 69 6e 67 20 72 65 |h as creating re| 00000390 70 6f 72 74 73 2c 20 77 69 6c 6c 0a 62 65 20 71 |ports, will.be q| 000003a0 75 69 74 65 20 73 6c 6f 77 2e 20 55 6e 6c 65 73 |uite slow. Unles| 000003b0 73 20 6d 65 6d 6f 72 79 20 69 73 20 76 65 72 79 |s memory is very| 000003c0 20 74 69 67 68 74 20 74 68 65 72 65 66 6f 72 65 | tight therefore| 000003d0 2c 20 75 73 65 72 73 20 6f 66 20 66 6c 6f 70 70 |, users of flopp| 000003e0 79 20 64 69 73 63 73 0a 61 72 65 20 72 65 63 6f |y discs.are reco| 000003f0 6d 6d 65 6e 64 65 64 20 74 6f 20 61 6c 6c 6f 63 |mmended to alloc| 00000400 61 74 65 20 61 74 20 6c 65 61 73 74 20 31 31 32 |ate at least 112| 00000410 4b 20 74 6f 20 74 68 65 20 52 41 4d 20 64 69 73 |K to the RAM dis| 00000420 63 20 61 6e 64 20 63 6f 70 79 0a 27 45 6c 65 6d |c and copy.'Elem| 00000430 65 6e 74 73 27 20 6f 6e 74 6f 20 69 74 2e 20 45 |ents' onto it. E| 00000440 76 65 72 79 74 68 69 6e 67 20 77 69 6c 6c 20 74 |verything will t| 00000450 68 65 6e 20 72 75 6e 20 6d 75 63 68 20 66 61 73 |hen run much fas| 00000460 74 65 72 2e 20 50 6f 77 65 72 62 61 73 65 20 63 |ter. Powerbase c| 00000470 61 6e 0a 70 72 6f 76 69 64 65 20 63 6f 6e 74 65 |an.provide conte| 00000480 78 74 2d 73 65 6e 73 69 74 69 76 65 20 68 65 6c |xt-sensitive hel| 00000490 70 20 76 69 61 20 41 63 6f 72 6e 27 73 20 21 48 |p via Acorn's !H| 000004a0 65 6c 70 20 61 70 70 6c 69 63 61 74 69 6f 6e 20 |elp application | 000004b0 61 6e 64 20 79 6f 75 20 61 72 65 0a 61 64 76 69 |and you are.advi| 000004c0 73 65 64 20 74 6f 20 6c 6f 61 64 20 74 68 69 73 |sed to load this| 000004d0 2c 20 72 65 73 69 7a 69 6e 67 20 74 68 65 20 68 |, resizing the h| 000004e0 65 6c 70 20 77 69 6e 64 6f 77 20 61 6e 64 20 70 |elp window and p| 000004f0 6c 61 63 69 6e 67 20 69 74 20 61 74 20 74 68 65 |lacing it at the| 00000500 20 74 6f 70 0a 72 69 67 68 74 20 6f 66 20 74 68 | top.right of th| 00000510 65 20 73 63 72 65 65 6e 2e 20 46 75 72 74 68 65 |e screen. Furthe| 00000520 72 20 68 65 6c 70 20 63 61 6e 20 62 65 20 68 61 |r help can be ha| 00000530 64 20 62 79 20 63 68 6f 6f 73 69 6e 67 20 74 68 |d by choosing th| 00000540 65 20 48 65 6c 70 20 65 6e 74 72 79 20 6f 6e 0a |e Help entry on.| 00000550 50 6f 77 65 72 62 61 73 65 27 73 20 6d 61 69 6e |Powerbase's main| 00000560 20 6d 65 6e 75 20 6f 72 20 6f 6e 20 74 68 65 20 | menu or on the | 00000570 69 63 6f 6e 2d 62 61 72 20 6d 65 6e 75 2e 0a 0a |icon-bar menu...| 00000580 53 74 61 72 74 69 6e 67 20 50 6f 77 65 72 62 61 |Starting Powerba| 00000590 73 65 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |se.=============| 000005a0 3d 3d 3d 3d 3d 0a 44 6f 75 62 6c 65 2d 63 6c 69 |=====.Double-cli| 000005b0 63 6b 20 6f 6e 20 74 68 65 20 50 6f 77 65 72 62 |ck on the Powerb| 000005c0 61 73 65 20 69 63 6f 6e 2e 20 41 66 74 65 72 20 |ase icon. After | 000005d0 61 20 66 65 77 20 73 65 63 6f 6e 64 73 20 69 74 |a few seconds it| 000005e0 20 77 69 6c 6c 20 61 70 70 65 61 72 20 6f 6e 0a | will appear on.| 000005f0 74 68 65 20 69 63 6f 6e 2d 62 61 72 20 77 69 74 |the icon-bar wit| 00000600 68 20 74 68 65 20 77 6f 72 64 73 20 22 4e 6f 20 |h the words "No | 00000610 64 61 74 61 22 20 62 65 6e 65 61 74 68 20 69 74 |data" beneath it| 00000620 20 74 6f 20 73 68 6f 77 20 74 68 61 74 20 6e 6f | to show that no| 00000630 20 64 61 74 61 62 61 73 65 20 69 73 0a 6f 70 65 | database is.ope| 00000640 6e 2e 20 44 72 61 67 67 69 6e 67 20 74 68 65 20 |n. Dragging the | 00000650 27 45 6c 65 6d 65 6e 74 73 27 20 69 63 6f 6e 20 |'Elements' icon | 00000660 6f 6e 74 6f 20 74 68 65 20 50 6f 77 65 72 62 61 |onto the Powerba| 00000670 73 65 20 69 63 6f 6e 20 6f 6e 20 74 68 65 20 69 |se icon on the i| 00000680 63 6f 6e 2d 62 61 72 0a 77 69 6c 6c 20 6f 70 65 |con-bar.will ope| 00000690 6e 20 27 45 6c 65 6d 65 6e 74 73 27 20 66 6f 72 |n 'Elements' for| 000006a0 20 75 73 65 20 61 6e 64 20 74 68 65 20 77 6f 72 | use and the wor| 000006b0 64 73 20 22 4e 6f 20 64 61 74 61 22 20 77 69 6c |ds "No data" wil| 000006c0 6c 20 62 65 20 72 65 70 6c 61 63 65 64 20 62 79 |l be replaced by| 000006d0 20 74 68 65 0a 6e 61 6d 65 20 6f 66 20 74 68 65 | the.name of the| 000006e0 20 64 61 74 61 62 61 73 65 2e 20 44 6f 75 62 6c | database. Doubl| 000006f0 65 2d 63 6c 69 63 6b 69 6e 67 20 6f 6e 20 74 68 |e-clicking on th| 00000700 65 20 27 45 6c 65 6d 65 6e 74 73 27 20 69 63 6f |e 'Elements' ico| 00000710 6e 20 68 61 73 20 74 68 65 20 73 61 6d 65 0a 65 |n has the same.e| 00000720 66 66 65 63 74 2c 20 69 6e 20 66 61 63 74 20 69 |ffect, in fact i| 00000730 66 20 50 6f 77 65 72 62 61 73 65 20 69 73 6e 27 |f Powerbase isn'| 00000740 74 20 61 6c 72 65 61 64 79 20 6f 6e 20 74 68 65 |t already on the| 00000750 20 69 63 6f 6e 2d 62 61 72 20 61 20 64 6f 75 62 | icon-bar a doub| 00000760 6c 65 2d 63 6c 69 63 6b 20 6f 6e 0a 27 45 6c 65 |le-click on.'Ele| 00000770 6d 65 6e 74 73 27 20 77 69 6c 6c 20 69 6e 73 74 |ments' will inst| 00000780 61 6c 6c 20 69 74 20 66 6f 72 20 79 6f 75 20 70 |all it for you p| 00000790 72 6f 76 69 64 65 64 20 74 68 61 74 20 74 68 65 |rovided that the| 000007a0 20 50 6f 77 65 72 62 61 73 65 20 69 63 6f 6e 20 | Powerbase icon | 000007b0 68 61 73 20 62 65 65 6e 0a 73 65 65 6e 20 62 79 |has been.seen by| 000007c0 20 74 68 65 20 66 69 6c 65 72 2e 20 0a 0a 54 77 | the filer. ..Tw| 000007d0 6f 20 77 69 6e 64 6f 77 73 20 77 69 6c 6c 20 6f |o windows will o| 000007e0 70 65 6e 2e 20 4f 6e 65 20 69 73 20 74 68 65 20 |pen. One is the | 000007f0 52 45 43 4f 52 44 20 57 49 4e 44 4f 57 20 61 6e |RECORD WINDOW an| 00000800 64 20 64 69 73 70 6c 61 79 73 20 74 68 65 20 66 |d displays the f| 00000810 69 72 73 74 0a 72 65 63 6f 72 64 20 69 6e 20 74 |irst.record in t| 00000820 68 65 20 64 61 74 61 62 61 73 65 2e 20 54 68 65 |he database. The| 00000830 20 6f 74 68 65 72 20 69 73 20 74 68 65 20 4b 45 | other is the KE| 00000840 59 50 41 44 20 77 68 69 63 68 20 61 6c 6c 6f 77 |YPAD which allow| 00000850 73 20 79 6f 75 20 74 6f 20 63 6f 6e 74 72 6f 6c |s you to control| 00000860 0a 74 68 65 20 62 72 6f 77 73 69 6e 67 2c 20 73 |.the browsing, s| 00000870 65 61 72 63 68 69 6e 67 20 61 6e 64 20 65 64 69 |earching and edi| 00000880 74 69 6e 67 20 66 75 6e 63 74 69 6f 6e 73 20 6f |ting functions o| 00000890 66 20 50 6f 77 65 72 62 61 73 65 2e 20 54 68 65 |f Powerbase. The| 000008a0 20 6b 65 79 70 61 64 20 69 73 0a 72 61 74 68 65 | keypad is.rathe| 000008b0 72 20 6c 61 72 67 65 20 61 6e 64 20 6f 62 73 63 |r large and obsc| 000008c0 75 72 65 73 20 71 75 69 74 65 20 61 20 62 69 67 |ures quite a big| 000008d0 20 61 72 65 61 20 6f 66 20 74 68 65 20 72 65 63 | area of the rec| 000008e0 6f 72 64 20 77 69 6e 64 6f 77 2e 20 54 68 65 0a |ord window. The.| 000008f0 6d 6f 73 74 2d 75 73 65 64 20 62 75 74 74 6f 6e |most-used button| 00000900 73 2c 20 68 6f 77 65 76 65 72 2c 20 61 72 65 20 |s, however, are | 00000910 6f 6e 20 74 68 65 20 74 6f 70 20 74 77 6f 20 72 |on the top two r| 00000920 6f 77 73 20 61 6e 64 20 74 68 65 20 6b 65 79 70 |ows and the keyp| 00000930 61 64 20 63 61 6e 20 62 65 0a 6d 6f 76 65 64 20 |ad can be.moved | 00000940 70 61 72 74 20 77 61 79 20 6f 66 66 20 73 63 72 |part way off scr| 00000950 65 65 6e 20 74 6f 20 67 65 74 20 69 74 20 6f 75 |een to get it ou| 00000960 74 20 6f 66 20 74 68 65 20 77 61 79 2e 0a 0a 42 |t of the way...B| 00000970 72 6f 77 73 69 6e 67 20 74 68 72 6f 75 67 68 20 |rowsing through | 00000980 74 68 65 20 52 65 63 6f 72 64 73 0a 3d 3d 3d 3d |the Records.====| 00000990 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 000009a0 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 68 65 20 74 6f 70 |========.The top| 000009b0 20 72 6f 77 20 6f 66 20 62 75 74 74 6f 6e 73 20 | row of buttons | 000009c0 6f 6e 20 74 68 65 20 6b 65 79 70 61 64 20 61 6c |on the keypad al| 000009d0 6c 6f 77 73 20 79 6f 75 20 74 6f 20 62 72 6f 77 |lows you to brow| 000009e0 73 65 20 74 68 72 6f 75 67 68 20 74 68 65 20 66 |se through the f| 000009f0 69 6c 65 2e 0a 49 66 20 79 6f 75 20 68 61 76 65 |ile..If you have| 00000a00 20 21 48 65 6c 70 20 72 75 6e 6e 69 6e 67 2c 20 | !Help running, | 00000a10 61 73 20 70 72 65 76 69 6f 75 73 6c 79 20 73 75 |as previously su| 00000a20 67 67 65 73 74 65 64 2c 20 69 74 20 77 69 6c 6c |ggested, it will| 00000a30 20 74 65 6c 6c 20 79 6f 75 20 77 68 61 74 0a 65 | tell you what.e| 00000a40 61 63 68 20 62 75 74 74 6f 6e 20 64 6f 65 73 2e |ach button does.| 00000a50 20 4f 6e 63 65 20 79 6f 75 20 67 65 74 20 74 68 | Once you get th| 00000a60 65 20 67 65 6e 65 72 61 6c 20 69 64 65 61 20 79 |e general idea y| 00000a70 6f 75 20 77 69 6c 6c 20 66 69 6e 64 20 74 68 65 |ou will find the| 00000a80 20 73 79 6d 62 6f 6c 73 20 6f 6e 0a 74 68 65 20 | symbols on.the | 00000a90 62 75 74 74 6f 6e 73 20 6c 6f 67 69 63 61 6c 20 |buttons logical | 00000aa0 61 6e 64 20 73 65 6c 66 2d 65 78 70 6c 61 6e 61 |and self-explana| 00000ab0 74 6f 72 79 2e 20 54 68 65 20 6d 6f 73 74 20 63 |tory. The most c| 00000ac0 6f 6d 6d 6f 6e 6c 79 20 75 73 65 64 20 6f 6e 65 |ommonly used one| 00000ad0 73 20 61 63 74 20 61 73 0a 66 6f 6c 6c 6f 77 73 |s act as.follows| 00000ae0 3a 0a 0a 20 2a 20 53 69 6e 67 6c 65 20 61 72 72 |:.. * Single arr| 00000af0 6f 77 73 20 6d 6f 76 65 20 79 6f 75 20 6f 6e 65 |ows move you one| 00000b00 20 72 65 63 6f 72 64 20 61 74 20 61 20 74 69 6d | record at a tim| 00000b10 65 2e 20 46 72 6f 6d 20 41 43 54 49 4e 49 55 4d |e. From ACTINIUM| 00000b20 2c 20 63 6c 69 63 6b 69 6e 67 20 74 68 65 0a 20 |, clicking the. | 00000b30 20 20 72 69 67 68 74 20 61 72 72 6f 77 20 74 61 | right arrow ta| 00000b40 6b 65 73 20 79 6f 75 20 74 6f 20 41 4c 55 4d 49 |kes you to ALUMI| 00000b50 4e 49 55 4d 2e 20 54 68 65 20 6c 65 66 74 20 61 |NIUM. The left a| 00000b60 72 72 6f 77 20 74 61 6b 65 73 20 79 6f 75 20 62 |rrow takes you b| 00000b70 61 63 6b 20 74 6f 0a 20 20 20 41 43 54 49 4e 49 |ack to. ACTINI| 00000b80 55 4d 2e 0a 0a 20 2a 20 44 6f 75 62 6c 65 20 61 |UM... * Double a| 00000b90 72 72 6f 77 73 20 6d 6f 76 65 20 79 6f 75 20 74 |rrows move you t| 00000ba0 68 72 6f 75 67 68 20 74 68 65 20 66 69 6c 65 20 |hrough the file | 00000bb0 62 79 20 6c 6f 6e 67 20 68 6f 70 73 2e 20 54 68 |by long hops. Th| 00000bc0 75 73 20 74 68 65 20 72 69 67 68 74 0a 20 20 20 |us the right. | 00000bd0 64 6f 75 62 6c 65 20 61 72 72 6f 77 20 74 61 6b |double arrow tak| 00000be0 65 73 20 79 6f 75 20 66 72 6f 6d 20 41 43 54 49 |es you from ACTI| 00000bf0 4e 49 55 4d 20 74 6f 20 42 49 53 4d 55 54 48 20 |NIUM to BISMUTH | 00000c00 61 6e 64 20 74 68 65 20 6c 65 66 74 20 6f 6e 65 |and the left one| 00000c10 20 62 61 63 6b 20 74 6f 0a 20 20 20 41 43 54 49 | back to. ACTI| 00000c20 4e 49 55 4d 20 61 67 61 69 6e 2e 20 54 68 65 20 |NIUM again. The | 00000c30 22 66 61 73 74 20 66 6f 72 77 61 72 64 2f 72 65 |"fast forward/re| 00000c40 77 69 6e 64 22 20 76 61 6c 75 65 20 69 73 20 73 |wind" value is s| 00000c50 68 6f 77 6e 20 69 6e 20 74 68 65 20 6c 69 74 74 |hown in the litt| 00000c60 6c 65 0a 20 20 20 62 6f 78 20 62 65 74 77 65 65 |le. box betwee| 00000c70 6e 20 74 68 65 20 22 66 61 73 74 20 77 69 6e 64 |n the "fast wind| 00000c80 22 20 62 75 74 74 6f 6e 73 2e 20 49 74 20 69 73 |" buttons. It is| 00000c90 20 69 6e 69 74 69 61 6c 6c 79 20 73 65 74 20 74 | initially set t| 00000ca0 6f 20 31 30 20 72 65 63 6f 72 64 73 0a 20 20 20 |o 10 records. | 00000cb0 62 75 74 20 63 61 6e 20 62 65 20 61 6c 74 65 72 |but can be alter| 00000cc0 65 64 20 62 79 20 20 63 6c 69 63 6b 69 6e 67 20 |ed by clicking | 00000cd0 69 6e 20 69 74 20 77 69 74 68 20 53 45 4c 45 43 |in it with SELEC| 00000ce0 54 20 61 6e 64 20 65 6e 74 65 72 69 6e 67 20 61 |T and entering a| 00000cf0 20 6e 65 77 0a 20 20 20 76 61 6c 75 65 2e 0a 0a | new. value...| 00000d00 20 2a 20 54 68 65 20 62 75 74 74 6f 6e 73 20 61 | * The buttons a| 00000d10 74 20 74 68 65 20 66 61 72 20 6c 65 66 74 20 61 |t the far left a| 00000d20 6e 64 20 72 69 67 68 74 20 74 61 6b 65 20 79 6f |nd right take yo| 00000d30 75 20 74 6f 20 74 68 65 20 62 65 67 69 6e 6e 69 |u to the beginni| 00000d40 6e 67 20 61 6e 64 20 65 6e 64 20 6f 66 0a 20 20 |ng and end of. | 00000d50 20 74 68 65 20 66 69 6c 65 2e 20 54 68 65 20 72 | the file. The r| 00000d60 69 67 68 74 6d 6f 73 74 20 62 75 74 74 6f 6e 20 |ightmost button | 00000d70 74 68 65 72 65 66 6f 72 65 20 74 61 6b 65 73 20 |therefore takes | 00000d80 79 6f 75 20 74 6f 20 5a 49 52 43 4f 4e 49 55 4d |you to ZIRCONIUM| 00000d90 20 61 6e 64 20 74 68 65 0a 20 20 20 6c 65 66 74 | and the. left| 00000da0 6d 6f 73 74 20 6f 6e 65 20 74 6f 20 41 43 54 49 |most one to ACTI| 00000db0 4e 49 55 4d 2e 0a 0a 4f 6e 65 20 66 75 72 74 68 |NIUM...One furth| 00000dc0 65 72 20 66 65 61 74 75 72 65 20 6f 66 20 74 68 |er feature of th| 00000dd0 65 73 65 20 62 75 74 74 6f 6e 73 20 73 68 6f 75 |ese buttons shou| 00000de0 6c 64 20 62 65 20 6e 6f 74 65 64 3b 20 74 68 65 |ld be noted; the| 00000df0 20 66 69 6c 65 20 77 72 61 70 73 20 61 72 6f 75 | file wraps arou| 00000e00 6e 64 2e 20 0a 49 66 20 79 6f 75 20 61 72 65 20 |nd. .If you are | 00000e10 61 74 20 74 68 65 20 6c 61 73 74 20 72 65 63 6f |at the last reco| 00000e20 72 64 20 28 5a 49 52 43 4f 4e 49 55 4d 29 20 6f |rd (ZIRCONIUM) o| 00000e30 6e 65 20 72 65 63 6f 72 64 20 22 66 6f 72 77 61 |ne record "forwa| 00000e40 72 64 22 20 74 61 6b 65 73 20 79 6f 75 20 74 6f |rd" takes you to| 00000e50 0a 41 43 54 49 4e 49 55 4d 20 61 67 61 69 6e 2e |.ACTINIUM again.| 00000e60 20 53 69 6d 69 6c 61 72 6c 79 2c 20 6f 6e 65 20 | Similarly, one | 00000e70 72 65 63 6f 72 64 20 22 62 61 63 6b 22 20 66 72 |record "back" fr| 00000e80 6f 6d 20 41 43 54 49 4e 49 55 4d 20 67 69 76 65 |om ACTINIUM give| 00000e90 73 20 5a 49 52 43 4f 4e 49 55 4d 2e 0a 0a 54 68 |s ZIRCONIUM...Th| 00000ea0 65 20 73 65 63 6f 6e 64 20 72 6f 77 20 68 61 73 |e second row has| 00000eb0 20 62 75 74 74 6f 6e 73 20 6d 61 72 6b 65 64 20 | buttons marked | 00000ec0 6c 69 6b 65 20 74 68 65 20 27 70 6c 61 79 27 20 |like the 'play' | 00000ed0 61 6e 64 20 27 73 74 6f 70 27 20 63 6f 6e 74 72 |and 'stop' contr| 00000ee0 6f 6c 73 20 6f 66 20 61 0a 63 61 73 73 65 74 74 |ols of a.cassett| 00000ef0 65 20 70 6c 61 79 65 72 2e 20 27 50 6c 61 79 27 |e player. 'Play'| 00000f00 20 61 6c 6c 6f 77 73 20 61 6e 20 61 75 74 6f 6d | allows an autom| 00000f10 61 74 69 63 20 27 66 6c 69 70 2d 74 68 72 6f 75 |atic 'flip-throu| 00000f20 67 68 27 20 6f 66 20 74 68 65 20 72 65 63 6f 72 |gh' of the recor| 00000f30 64 73 0a 77 69 74 68 6f 75 74 20 74 68 65 20 6e |ds.without the n| 00000f40 65 65 64 20 74 6f 20 74 6f 75 63 68 20 61 6e 79 |eed to touch any| 00000f50 20 6f 74 68 65 72 20 62 75 74 74 6f 6e 73 2e 20 | other buttons. | 00000f60 57 68 65 6e 20 79 6f 75 20 67 65 74 20 74 6f 20 |When you get to | 00000f70 74 68 65 20 70 6c 61 63 65 20 79 6f 75 0a 77 61 |the place you.wa| 00000f80 6e 74 2c 20 63 6c 69 63 6b 20 6f 6e 20 27 73 74 |nt, click on 'st| 00000f90 6f 70 27 2e 20 49 66 20 74 68 65 20 72 65 63 6f |op'. If the reco| 00000fa0 72 64 73 20 67 6f 20 70 61 73 74 20 74 6f 6f 20 |rds go past too | 00000fb0 71 75 69 63 6b 6c 79 20 79 6f 75 20 63 61 6e 20 |quickly you can | 00000fc0 73 6c 6f 77 20 74 68 65 0a 70 72 6f 63 65 73 73 |slow the.process| 00000fd0 20 64 6f 77 6e 20 62 79 20 69 6e 63 72 65 61 73 | down by increas| 00000fe0 69 6e 67 20 74 68 65 20 6e 75 6d 62 65 72 20 69 |ing the number i| 00000ff0 6e 20 74 68 65 20 63 65 6e 74 72 61 6c 20 69 63 |n the central ic| 00001000 6f 6e 20 6f 66 20 74 68 65 20 74 6f 70 20 72 6f |on of the top ro| 00001010 77 20 6f 66 0a 62 75 74 74 6f 6e 73 2e 20 28 54 |w of.buttons. (T| 00001020 68 69 73 20 69 73 20 6e 6f 72 6d 61 6c 6c 79 20 |his is normally | 00001030 75 73 65 64 20 74 6f 20 73 65 74 20 74 68 65 20 |used to set the | 00001040 27 66 61 73 74 2d 77 69 6e 64 27 20 69 6e 74 65 |'fast-wind' inte| 00001050 72 76 61 6c 3b 20 73 65 65 20 61 62 6f 76 65 2e |rval; see above.| 00001060 29 0a 0a 4b 65 79 20 66 69 65 6c 64 73 2c 20 4b |)..Key fields, K| 00001070 65 79 73 20 61 6e 64 20 49 6e 64 69 63 65 73 0a |eys and Indices.| 00001080 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 00001090 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 57 68 65 |============.Whe| 000010a0 6e 20 75 73 69 6e 67 20 74 68 65 20 73 69 78 20 |n using the six | 000010b0 62 75 74 74 6f 6e 73 20 6f 6e 20 74 68 65 20 74 |buttons on the t| 000010c0 6f 70 20 72 6f 77 20 6f 66 20 74 68 65 20 6b 65 |op row of the ke| 000010d0 79 70 61 64 20 79 6f 75 20 77 69 6c 6c 20 68 61 |ypad you will ha| 000010e0 76 65 20 0a 6e 6f 74 69 63 65 64 20 74 68 61 74 |ve .noticed that| 000010f0 20 74 68 65 20 72 65 63 6f 72 64 73 20 61 70 70 | the records app| 00001100 65 61 72 20 74 6f 20 62 65 20 61 72 72 61 6e 67 |ear to be arrang| 00001110 65 64 20 61 6c 70 68 61 62 65 74 69 63 61 6c 6c |ed alphabeticall| 00001120 79 20 62 79 20 74 68 65 20 6e 61 6d 65 20 6f 66 |y by the name of| 00001130 0a 74 68 65 20 65 6c 65 6d 65 6e 74 2e 20 54 68 |.the element. Th| 00001140 65 20 61 63 74 75 61 6c 20 6f 72 64 65 72 20 69 |e actual order i| 00001150 6e 20 77 68 69 63 68 20 72 65 63 6f 72 64 73 20 |n which records | 00001160 6f 63 63 75 72 20 69 6e 20 74 68 65 20 66 69 6c |occur in the fil| 00001170 65 20 69 73 20 69 6e 20 66 61 63 74 0a 6e 6f 74 |e is in fact.not| 00001180 68 69 6e 67 20 6c 69 6b 65 20 61 6c 70 68 61 62 |hing like alphab| 00001190 65 74 69 63 61 6c 2c 20 62 75 74 20 74 68 65 20 |etical, but the | 000011a0 6f 72 64 65 72 20 69 6e 20 77 68 69 63 68 20 74 |order in which t| 000011b0 68 65 79 20 61 72 65 20 41 43 43 45 53 53 45 44 |hey are ACCESSED| 000011c0 20 69 73 0a 64 65 74 65 72 6d 69 6e 65 64 20 62 | is.determined b| 000011d0 79 20 61 6e 20 49 4e 44 45 58 20 77 68 69 63 68 |y an INDEX which| 000011e0 20 66 6f 72 63 65 73 20 74 68 65 6d 20 74 6f 20 | forces them to | 000011f0 61 70 70 65 61 72 20 69 6e 20 61 6c 70 68 61 62 |appear in alphab| 00001200 65 74 69 63 61 6c 20 6f 72 64 65 72 2e 0a 45 76 |etical order..Ev| 00001210 65 72 79 20 64 61 74 61 62 61 73 65 20 6d 75 73 |ery database mus| 00001220 74 20 68 61 76 65 20 61 74 20 6c 65 61 73 74 20 |t have at least | 00001230 6f 6e 65 20 69 6e 64 65 78 2c 20 62 75 74 20 79 |one index, but y| 00001240 6f 75 20 63 61 6e 20 68 61 76 65 20 61 73 20 6d |ou can have as m| 00001250 61 6e 79 20 65 78 74 72 61 0a 6f 6e 65 73 20 61 |any extra.ones a| 00001260 73 20 79 6f 75 20 77 69 73 68 20 28 73 75 62 6a |s you wish (subj| 00001270 65 63 74 20 74 6f 20 6d 65 6d 6f 72 79 20 61 6e |ect to memory an| 00001280 64 20 64 69 73 63 20 6c 69 6d 69 74 61 74 69 6f |d disc limitatio| 00001290 6e 73 29 2e 0a 20 20 20 20 20 20 20 20 20 20 20 |ns).. | 000012a0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 000012b0 0a 43 68 61 6e 67 69 6e 67 20 69 6e 64 65 78 0a |.Changing index.| 000012c0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 54 |--------------.T| 000012d0 68 65 20 73 65 63 6f 6e 64 20 72 6f 77 20 6f 66 |he second row of| 000012e0 20 74 68 65 20 6b 65 79 70 61 64 20 68 61 73 20 | the keypad has | 000012f0 74 77 6f 20 62 75 74 74 6f 6e 73 20 66 65 61 74 |two buttons feat| 00001300 75 72 69 6e 67 20 61 20 62 6c 75 65 20 61 72 72 |uring a blue arr| 00001310 6f 77 20 77 69 74 68 20 61 0a 6b 65 79 20 73 79 |ow with a.key sy| 00001320 6d 62 6f 6c 2e 20 43 6c 69 63 6b 20 6f 6e 20 74 |mbol. Click on t| 00001330 68 65 20 72 69 67 68 74 20 6f 6e 65 20 61 6e 64 |he right one and| 00001340 20 74 68 65 20 72 65 63 6f 72 64 20 66 6f 72 20 | the record for | 00001350 48 59 44 52 4f 47 45 4e 20 69 73 20 64 69 73 70 |HYDROGEN is disp| 00001360 6c 61 79 65 64 21 0a 49 66 20 79 6f 75 20 6e 6f |layed!.If you no| 00001370 77 20 65 78 70 65 72 69 6d 65 6e 74 20 77 69 74 |w experiment wit| 00001380 68 20 74 68 65 20 74 6f 70 20 72 6f 77 20 6f 66 |h the top row of| 00001390 20 62 75 74 74 6f 6e 73 20 61 73 20 62 65 66 6f | buttons as befo| 000013a0 72 65 20 79 6f 75 20 77 69 6c 6c 20 66 69 6e 64 |re you will find| 000013b0 0a 74 68 61 74 20 74 68 65 20 72 65 63 6f 72 64 |.that the record| 000013c0 73 20 6e 6f 20 6c 6f 6e 67 65 72 20 61 70 70 65 |s no longer appe| 000013d0 61 72 20 69 6e 20 61 6c 70 68 61 62 65 74 69 63 |ar in alphabetic| 000013e0 61 6c 20 6f 72 64 65 72 20 6f 66 20 6e 61 6d 65 |al order of name| 000013f0 20 62 75 74 20 69 6e 20 6f 72 64 65 72 0a 6f 66 | but in order.of| 00001400 20 41 54 4f 4d 49 43 20 4e 55 4d 42 45 52 20 69 | ATOMIC NUMBER i| 00001410 6e 73 74 65 61 64 2e 20 57 68 61 74 20 77 65 20 |nstead. What we | 00001420 68 61 76 65 20 64 6f 6e 65 20 69 73 20 63 68 61 |have done is cha| 00001430 6e 67 65 20 74 6f 20 61 20 64 69 66 66 65 72 65 |nge to a differe| 00001440 6e 74 20 69 6e 64 65 78 2e 0a 49 66 20 61 20 64 |nt index..If a d| 00001450 61 74 61 62 61 73 65 20 68 61 73 20 6d 75 6c 74 |atabase has mult| 00001460 69 70 6c 65 20 69 6e 64 69 63 65 73 20 74 68 65 |iple indices the| 00001470 20 22 6b 65 79 22 20 62 75 74 74 6f 6e 73 20 61 | "key" buttons a| 00001480 6c 6c 6f 77 20 79 6f 75 20 74 6f 20 63 79 63 6c |llow you to cycl| 00001490 65 0a 74 68 72 6f 75 67 68 20 74 68 65 6d 20 69 |e.through them i| 000014a0 6e 20 6f 70 70 6f 73 69 74 65 20 64 69 72 65 63 |n opposite direc| 000014b0 74 69 6f 6e 73 2e 20 28 53 69 6e 63 65 20 45 6c |tions. (Since El| 000014c0 65 6d 65 6e 74 73 20 68 61 73 20 6f 6e 6c 79 20 |ements has only | 000014d0 74 77 6f 20 69 6e 64 69 63 65 73 0a 74 68 65 20 |two indices.the | 000014e0 74 77 6f 20 62 75 74 74 6f 6e 73 20 68 61 76 65 |two buttons have| 000014f0 20 65 78 61 63 74 6c 79 20 74 68 65 20 73 61 6d | exactly the sam| 00001500 65 20 65 66 66 65 63 74 2e 29 20 57 68 65 6e 20 |e effect.) When | 00001510 79 6f 75 20 63 68 61 6e 67 65 20 74 6f 20 61 0a |you change to a.| 00001520 64 69 66 66 65 72 65 6e 74 20 69 6e 64 65 78 20 |different index | 00001530 74 68 65 20 73 63 72 65 65 6e 20 61 6c 77 61 79 |the screen alway| 00001540 73 20 64 69 73 70 6c 61 79 73 20 74 68 65 20 66 |s displays the f| 00001550 69 72 73 74 20 72 65 63 6f 72 64 20 61 73 20 64 |irst record as d| 00001560 65 74 65 72 6d 69 6e 65 64 20 62 79 0a 74 68 61 |etermined by.tha| 00001570 74 20 69 6e 64 65 78 2e 0a 0a 4b 65 79 73 20 61 |t index...Keys a| 00001580 6e 64 20 6b 65 79 20 66 69 65 6c 64 73 0a 2d 2d |nd key fields.--| 00001590 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 000015a0 2d 0a 41 6e 20 69 6e 64 65 78 20 69 73 20 62 75 |-.An index is bu| 000015b0 69 6c 74 20 66 72 6f 6d 20 4b 45 59 53 20 77 68 |ilt from KEYS wh| 000015c0 69 63 68 20 61 72 65 20 64 65 72 69 76 65 64 20 |ich are derived | 000015d0 66 72 6f 6d 20 61 20 70 61 72 74 69 63 75 6c 61 |from a particula| 000015e0 72 20 4b 45 59 20 46 49 45 4c 44 2e 0a 54 68 65 |r KEY FIELD..The| 000015f0 20 74 77 6f 20 69 6e 64 69 63 65 73 20 75 73 65 | two indices use| 00001600 64 20 62 79 20 45 6c 65 6d 65 6e 74 73 20 61 72 |d by Elements ar| 00001610 65 20 62 61 73 65 64 20 6f 6e 20 74 68 65 20 4e |e based on the N| 00001620 41 4d 45 20 61 6e 64 20 41 54 4f 4d 49 43 20 4e |AME and ATOMIC N| 00001630 55 4d 42 45 52 0a 66 69 65 6c 64 73 2e 20 54 68 |UMBER.fields. Th| 00001640 65 20 77 61 79 20 69 6e 20 77 68 69 63 68 20 74 |e way in which t| 00001650 68 65 20 6b 65 79 20 73 74 6f 72 65 64 20 69 6e |he key stored in| 00001660 20 74 68 65 20 69 6e 64 65 78 20 69 73 20 64 65 | the index is de| 00001670 72 69 76 65 64 20 66 72 6f 6d 20 74 68 65 20 6b |rived from the k| 00001680 65 79 0a 66 69 65 6c 64 20 69 73 20 64 69 66 66 |ey.field is diff| 00001690 65 72 65 6e 74 20 69 6e 20 74 68 65 20 74 77 6f |erent in the two| 000016a0 20 63 61 73 65 73 2e 20 46 6f 72 20 74 68 65 20 | cases. For the | 000016b0 4e 41 4d 45 20 69 6e 64 65 78 20 74 68 65 20 66 |NAME index the f| 000016c0 69 72 73 74 20 66 6f 75 72 0a 6c 65 74 74 65 72 |irst four.letter| 000016d0 73 20 6f 66 20 74 68 65 20 6e 61 6d 65 20 61 72 |s of the name ar| 000016e0 65 20 75 73 65 64 2e 20 53 69 6e 63 65 20 6e 6f |e used. Since no| 000016f0 20 74 77 6f 20 65 6c 65 6d 65 6e 74 73 20 68 61 | two elements ha| 00001700 76 65 20 6e 61 6d 65 73 20 62 65 67 69 6e 6e 69 |ve names beginni| 00001710 6e 67 0a 77 69 74 68 20 74 68 65 20 73 61 6d 65 |ng.with the same| 00001720 20 66 6f 75 72 20 6c 65 74 74 65 72 73 20 74 68 | four letters th| 00001730 69 73 20 67 69 76 65 73 20 61 20 75 6e 69 71 75 |is gives a uniqu| 00001740 65 20 22 76 61 6c 75 65 22 20 66 6f 72 20 74 68 |e "value" for th| 00001750 65 20 6b 65 79 2e 20 28 54 77 6f 0a 6c 65 74 74 |e key. (Two.lett| 00001760 65 72 73 20 77 6f 75 6c 64 20 6e 6f 74 20 68 61 |ers would not ha| 00001770 76 65 20 62 65 65 6e 20 65 6e 6f 75 67 68 20 62 |ve been enough b| 00001780 65 63 61 75 73 65 20 6f 66 20 73 75 63 68 20 6e |ecause of such n| 00001790 61 6d 65 73 20 61 73 20 43 48 4c 4f 52 49 4e 45 |ames as CHLORINE| 000017a0 20 61 6e 64 0a 43 48 52 4f 4d 49 55 4d 2e 29 20 | and.CHROMIUM.) | 000017b0 54 68 65 20 41 54 4f 4d 49 43 20 4e 55 4d 42 45 |The ATOMIC NUMBE| 000017c0 52 20 69 6e 64 65 78 20 69 73 20 62 61 73 65 64 |R index is based| 000017d0 20 6f 6e 20 74 68 65 20 77 68 6f 6c 65 20 33 2d | on the whole 3-| 000017e0 64 69 67 69 74 20 6d 61 78 69 6d 75 6d 0a 6c 65 |digit maximum.le| 000017f0 6e 67 74 68 20 61 6e 64 20 74 68 65 20 6f 72 64 |ngth and the ord| 00001800 65 72 69 6e 67 20 69 73 20 4e 55 4d 45 52 49 43 |ering is NUMERIC| 00001810 2e 20 57 68 65 6e 65 76 65 72 20 61 20 72 65 63 |. Whenever a rec| 00001820 6f 72 64 20 69 73 20 64 69 73 70 6c 61 79 65 64 |ord is displayed| 00001830 20 74 68 65 20 6b 65 79 0a 69 73 20 73 68 6f 77 | the key.is show| 00001840 6e 20 69 6e 20 74 68 65 20 77 69 6e 64 6f 77 20 |n in the window | 00001850 74 69 74 6c 65 20 28 23 20 63 68 61 72 61 63 74 |title (# charact| 00001860 65 72 73 20 61 72 65 20 66 6f 72 20 70 61 64 64 |ers are for padd| 00001870 69 6e 67 20 61 6e 64 20 73 68 6f 75 6c 64 20 62 |ing and should b| 00001880 65 0a 69 67 6e 6f 72 65 64 2e 29 0a 0a 54 68 65 |e.ignored.)..The| 00001890 20 72 65 63 6f 72 64 20 73 63 72 65 65 6e 20 63 | record screen c| 000018a0 6c 65 61 72 6c 79 20 73 68 6f 77 73 20 77 68 69 |learly shows whi| 000018b0 63 68 20 66 69 65 6c 64 73 20 61 72 65 20 6b 65 |ch fields are ke| 000018c0 79 66 69 65 6c 64 73 20 61 6e 64 20 77 68 69 63 |yfields and whic| 000018d0 68 20 61 72 65 0a 6e 6f 74 2e 20 54 68 65 20 64 |h are.not. The d| 000018e0 65 73 63 72 69 70 74 6f 72 73 2c 20 6f 72 20 6c |escriptors, or l| 000018f0 61 62 65 6c 73 2c 20 6f 66 20 66 69 65 6c 64 73 |abels, of fields| 00001900 20 61 72 65 20 6e 6f 72 6d 61 6c 6c 79 20 62 6c | are normally bl| 00001910 61 63 6b 2e 20 57 68 65 72 65 20 74 68 65 0a 66 |ack. Where the.f| 00001920 69 65 6c 64 73 20 61 72 65 20 6b 65 79 66 69 65 |ields are keyfie| 00001930 6c 64 73 20 74 68 65 79 20 61 72 65 20 73 68 6f |lds they are sho| 00001940 77 6e 20 69 6e 20 64 61 72 6b 20 62 6c 75 65 20 |wn in dark blue | 00001950 69 6e 73 74 65 61 64 20 61 6e 64 20 74 68 65 20 |instead and the | 00001960 66 69 65 6c 64 20 75 73 65 64 0a 62 79 20 74 68 |field used.by th| 00001970 65 20 63 75 72 72 65 6e 74 20 69 6e 64 65 78 20 |e current index | 00001980 68 61 73 20 69 74 73 20 64 65 73 63 72 69 70 74 |has its descript| 00001990 6f 72 20 69 6e 20 72 65 64 2e 20 4e 6f 74 65 20 |or in red. Note | 000019a0 61 6c 73 6f 20 74 68 61 74 20 74 68 65 0a 62 61 |also that the.ba| 000019b0 63 6b 67 72 6f 75 6e 64 20 63 6f 6c 6f 75 72 20 |ckground colour | 000019c0 6f 66 20 74 68 65 20 4e 41 4d 45 20 66 69 65 6c |of the NAME fiel| 000019d0 64 20 69 73 20 70 61 6c 65 20 79 65 6c 6c 6f 77 |d is pale yellow| 000019e0 20 77 68 65 72 65 61 73 20 74 68 65 20 72 65 73 | whereas the res| 000019f0 74 20 61 72 65 0a 77 68 69 74 65 20 2e 20 54 68 |t are.white . Th| 00001a00 69 73 20 69 6e 64 69 63 61 74 65 73 20 74 68 61 |is indicates tha| 00001a10 74 20 4e 41 4d 45 20 69 73 20 74 68 65 20 50 52 |t NAME is the PR| 00001a20 49 4d 41 52 59 20 4b 45 59 20 66 69 65 6c 64 2e |IMARY KEY field.| 00001a30 20 54 68 65 20 70 72 69 6d 61 72 79 20 6b 65 79 | The primary key| 00001a40 0a 61 6e 64 20 74 68 65 20 69 6e 64 65 78 20 62 |.and the index b| 00001a50 61 73 65 64 20 6f 6e 20 69 74 20 69 73 20 6d 6f |ased on it is mo| 00001a60 72 65 20 69 6d 70 6f 72 74 61 6e 74 20 74 68 61 |re important tha| 00001a70 6e 20 74 68 65 20 6f 74 68 65 72 73 2e 20 49 74 |n the others. It| 00001a80 20 69 73 20 74 68 65 20 6f 6e 65 0a 69 6e 64 65 | is the one.inde| 00001a90 78 20 77 68 69 63 68 20 61 20 64 61 74 61 62 61 |x which a databa| 00001aa0 73 65 20 4d 55 53 54 20 68 61 76 65 20 61 6e 64 |se MUST have and| 00001ab0 20 69 73 20 74 68 65 20 6f 6e 65 20 73 65 6c 65 | is the one sele| 00001ac0 63 74 65 64 20 77 68 65 6e 20 61 20 64 61 74 61 |cted when a data| 00001ad0 62 61 73 65 20 69 73 0a 66 69 72 73 74 20 6f 70 |base is.first op| 00001ae0 65 6e 65 64 2e 0a 0a 53 65 61 72 63 68 69 6e 67 |ened...Searching| 00001af0 20 66 6f 72 20 61 20 72 65 63 6f 72 64 0a 3d 3d | for a record.==| 00001b00 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 00001b10 3d 3d 3d 3d 0a 54 68 65 20 72 69 67 68 74 6d 6f |====.The rightmo| 00001b20 73 74 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 |st button on the| 00001b30 20 74 68 69 72 64 20 72 6f 77 20 6f 66 20 74 68 | third row of th| 00001b40 65 20 6b 65 79 70 61 64 20 73 68 6f 77 73 20 61 |e keypad shows a| 00001b50 20 71 75 65 73 74 69 6f 6e 20 6d 61 72 6b 0a 66 | question mark.f| 00001b60 6f 6c 6c 6f 77 65 64 20 62 79 20 61 20 22 72 65 |ollowed by a "re| 00001b70 63 6f 72 64 20 63 61 72 64 22 20 69 63 6f 6e 20 |cord card" icon | 00001b80 20 57 65 20 77 69 6c 6c 20 63 61 6c 6c 20 69 74 | We will call it| 00001b90 20 74 68 65 20 53 65 61 72 63 68 20 62 75 74 74 | the Search butt| 00001ba0 6f 6e 2e 0a 57 68 65 6e 20 63 6c 69 63 6b 65 64 |on..When clicked| 00001bb0 20 77 69 74 68 20 53 45 4c 45 43 54 20 74 68 65 | with SELECT the| 00001bc0 20 6b 65 79 70 61 64 20 77 69 6e 64 6f 77 20 67 | keypad window g| 00001bd0 72 6f 77 73 20 61 6e 20 65 78 74 65 6e 73 69 6f |rows an extensio| 00001be0 6e 20 6f 6e 20 74 68 65 0a 72 69 67 68 74 2d 68 |n on the.right-h| 00001bf0 61 6e 64 20 73 69 64 65 2e 20 54 68 69 73 20 6e |and side. This n| 00001c00 65 77 20 61 72 65 61 20 63 6f 6e 74 61 69 6e 73 |ew area contains| 00001c10 20 61 20 77 72 69 74 61 62 6c 65 20 69 63 6f 6e | a writable icon| 00001c20 20 69 6e 20 77 68 69 63 68 20 74 6f 20 65 6e 74 | in which to ent| 00001c30 65 72 0a 74 68 65 20 6b 65 79 20 6f 66 20 74 68 |er.the key of th| 00001c40 65 20 72 65 63 6f 72 64 20 79 6f 75 20 77 69 73 |e record you wis| 00001c50 68 20 74 6f 20 64 69 73 70 6c 61 79 2e 20 53 75 |h to display. Su| 00001c60 70 70 6f 73 65 20 79 6f 75 20 77 61 6e 74 20 74 |ppose you want t| 00001c70 6f 20 73 65 65 20 74 68 65 0a 72 65 63 6f 72 64 |o see the.record| 00001c80 20 66 6f 72 20 74 68 65 20 65 6c 65 6d 65 6e 74 | for the element| 00001c90 20 4e 49 54 52 4f 47 45 4e 2e 20 49 66 20 74 68 | NITROGEN. If th| 00001ca0 65 20 63 75 72 72 65 6e 74 20 69 6e 64 65 78 20 |e current index | 00001cb0 69 73 20 74 68 65 20 4e 41 4d 45 20 74 68 65 6e |is the NAME then| 00001cc0 20 74 79 70 65 0a 69 6e 20 4e 49 54 52 20 61 6e | type.in NITR an| 00001cd0 64 20 65 69 74 68 65 72 20 74 79 70 65 20 52 45 |d either type RE| 00001ce0 54 55 52 4e 20 6f 72 20 63 6c 69 63 6b 20 74 68 |TURN or click th| 00001cf0 65 20 27 4f 4b 27 20 62 75 74 74 6f 6e 2e 20 54 |e 'OK' button. T| 00001d00 68 65 20 72 65 71 75 69 72 65 64 20 72 65 63 6f |he required reco| 00001d10 72 64 0a 71 75 69 63 6b 6c 79 20 61 70 70 65 61 |rd.quickly appea| 00001d20 72 73 2e 20 49 66 20 79 6f 75 20 65 6e 74 65 72 |rs. If you enter| 00001d30 20 74 68 65 20 6b 65 79 20 6f 66 20 61 20 6e 6f | the key of a no| 00001d40 6e 2d 65 78 69 73 74 65 6e 74 20 72 65 63 6f 72 |n-existent recor| 00001d50 64 20 61 6e 20 65 72 72 6f 72 20 62 6f 78 0a 69 |d an error box.i| 00001d60 73 20 64 69 73 70 6c 61 79 65 64 2e 20 59 6f 75 |s displayed. You| 00001d70 20 64 6f 6e 27 74 20 6e 65 63 65 73 73 61 72 69 | don't necessari| 00001d80 6c 79 20 6e 65 65 64 20 74 6f 20 74 79 70 65 20 |ly need to type | 00001d90 74 68 65 20 77 68 6f 6c 65 20 6b 65 79 3b 20 4e |the whole key; N| 00001da0 49 54 20 77 6f 75 6c 64 20 64 6f 0a 69 6e 20 74 |IT would do.in t| 00001db0 68 69 73 20 63 61 73 65 2c 20 62 75 74 20 4e 49 |his case, but NI| 00001dc0 20 77 6f 75 6c 64 20 62 65 20 61 6d 62 69 67 75 | would be ambigu| 00001dd0 6f 75 73 20 28 74 68 65 72 65 20 61 72 65 20 65 |ous (there are e| 00001de0 6c 65 6d 65 6e 74 73 20 63 61 6c 6c 65 64 20 4e |lements called N| 00001df0 49 43 4b 45 4c 0a 61 6e 64 20 4e 49 4f 42 49 55 |ICKEL.and NIOBIU| 00001e00 4d 29 2e 0a 0a 54 6f 20 66 69 6e 64 20 4e 49 54 |M)...To find NIT| 00001e10 52 4f 47 45 4e 20 77 68 65 6e 20 74 68 65 20 41 |ROGEN when the A| 00001e20 54 4f 4d 49 43 20 4e 55 4d 42 45 52 20 69 6e 64 |TOMIC NUMBER ind| 00001e30 65 78 20 69 73 20 61 63 74 69 76 65 20 79 6f 75 |ex is active you| 00001e40 20 77 6f 75 6c 64 20 6e 65 65 64 20 74 6f 0a 6b | would need to.k| 00001e50 6e 6f 77 20 74 68 61 74 20 74 68 65 20 61 74 6f |now that the ato| 00001e60 6d 69 63 20 6e 75 6d 62 65 72 20 6f 66 20 6e 69 |mic number of ni| 00001e70 74 72 6f 67 65 6e 20 69 73 20 37 2e 20 54 79 70 |trogen is 7. Typ| 00001e80 65 20 74 68 69 73 20 69 6e 20 61 6e 64 20 74 79 |e this in and ty| 00001e90 70 65 20 52 45 54 55 52 4e 0a 6f 72 20 63 6c 69 |pe RETURN.or cli| 00001ea0 63 6b 20 6f 6e 20 27 4f 4b 27 20 61 6e 64 20 74 |ck on 'OK' and t| 00001eb0 68 65 20 72 65 63 6f 72 64 20 61 70 70 65 61 72 |he record appear| 00001ec0 73 2e 20 41 62 62 72 65 76 69 61 74 65 64 20 6b |s. Abbreviated k| 00001ed0 65 79 73 20 61 72 65 20 4e 4f 54 20 61 6c 6c 6f |eys are NOT allo| 00001ee0 77 65 64 20 69 6e 0a 74 68 69 73 20 63 61 73 65 |wed in.this case| 00001ef0 20 66 6f 72 20 6f 62 76 69 6f 75 73 20 72 65 61 | for obvious rea| 00001f00 73 6f 6e 73 3b 20 69 66 20 79 6f 75 20 77 61 6e |sons; if you wan| 00001f10 74 20 65 6c 65 6d 65 6e 74 20 31 30 33 20 28 4c |t element 103 (L| 00001f20 41 57 52 45 4e 43 49 55 4d 29 20 69 74 27 73 20 |AWRENCIUM) it's | 00001f30 6e 6f 0a 67 6f 6f 64 20 65 6e 74 65 72 69 6e 67 |no.good entering| 00001f40 20 31 30 20 28 4e 45 4f 4e 29 21 0a 0a 45 64 69 | 10 (NEON)!..Edi| 00001f50 74 69 6e 67 20 74 68 65 20 44 61 74 61 62 61 73 |ting the Databas| 00001f60 65 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |e.==============| 00001f70 3d 3d 3d 3d 3d 3d 0a 54 68 69 73 20 70 61 72 74 |======.This part| 00001f80 20 6f 66 20 74 68 65 20 74 75 74 6f 72 69 61 6c | of the tutorial| 00001f90 20 69 6e 76 6f 6c 76 65 73 20 63 68 61 6e 67 65 | involves change| 00001fa0 73 20 74 6f 20 74 68 65 20 64 61 74 61 20 72 65 |s to the data re| 00001fb0 63 6f 72 64 73 2e 20 4d 61 6b 65 20 61 0a 77 6f |cords. Make a.wo| 00001fc0 72 6b 69 6e 67 20 63 6f 70 79 20 6f 66 20 74 68 |rking copy of th| 00001fd0 65 20 64 69 73 63 20 61 6e 64 20 70 75 74 20 74 |e disc and put t| 00001fe0 68 65 20 6f 72 69 67 69 6e 61 6c 20 69 6e 20 61 |he original in a| 00001ff0 20 73 61 66 65 20 70 6c 61 63 65 2e 20 49 66 20 | safe place. If | 00002000 79 6f 75 20 61 72 65 0a 75 73 69 6e 67 20 61 20 |you are.using a | 00002010 63 6f 70 79 20 6f 66 20 45 6c 65 6d 65 6e 74 73 |copy of Elements| 00002020 20 6f 6e 20 74 68 65 20 52 41 4d 20 64 69 73 63 | on the RAM disc| 00002030 20 74 68 65 6e 20 74 68 65 20 66 6c 6f 70 70 79 | then the floppy| 00002040 20 64 69 73 63 20 77 6f 6e 27 74 20 62 65 0a 61 | disc won't be.a| 00002050 6c 74 65 72 65 64 2c 20 62 75 74 20 69 74 27 73 |ltered, but it's| 00002060 20 73 74 69 6c 6c 20 6e 6f 74 20 61 20 67 6f 6f | still not a goo| 00002070 64 20 69 64 65 61 20 74 6f 20 77 6f 72 6b 20 77 |d idea to work w| 00002080 69 74 68 20 74 68 65 20 6f 72 69 67 69 6e 61 6c |ith the original| 00002090 20 64 69 73 63 2e 0a 0a 4d 6f 64 69 66 79 69 6e | disc...Modifyin| 000020a0 67 20 72 65 63 6f 72 64 73 0a 2d 2d 2d 2d 2d 2d |g records.------| 000020b0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 50 6f 69 6e |-----------.Poin| 000020c0 74 69 6e 67 20 74 68 65 20 6d 6f 75 73 65 20 61 |ting the mouse a| 000020d0 74 20 61 6e 79 20 66 69 65 6c 64 20 61 6e 64 20 |t any field and | 000020e0 63 6c 69 63 6b 69 6e 67 20 53 45 4c 45 43 54 20 |clicking SELECT | 000020f0 70 6c 61 63 65 73 20 74 68 65 20 63 61 72 65 74 |places the caret| 00002100 20 69 6e 20 74 68 61 74 0a 66 69 65 6c 64 2e 20 | in that.field. | 00002110 54 68 65 20 63 6f 6e 74 65 6e 74 73 20 6f 66 20 |The contents of | 00002120 74 68 65 20 66 69 65 6c 64 20 6d 61 79 20 74 68 |the field may th| 00002130 65 6e 20 62 65 20 65 64 69 74 65 64 20 69 6e 20 |en be edited in | 00002140 74 68 65 20 73 74 61 6e 64 61 72 64 20 77 61 79 |the standard way| 00002150 20 66 6f 72 0a 52 49 53 43 20 4f 53 20 77 72 69 | for.RISC OS wri| 00002160 74 61 62 6c 65 20 69 63 6f 6e 73 2e 20 69 2e 65 |table icons. i.e| 00002170 2e 0a 0a 20 20 20 20 20 20 20 43 54 52 4c 20 55 |... CTRL U| 00002180 20 63 6c 65 61 72 73 20 74 68 65 20 66 69 65 6c | clears the fiel| 00002190 64 2e 0a 20 20 20 20 20 20 20 44 45 4c 45 54 45 |d.. DELETE| 000021a0 20 72 65 6d 6f 76 65 73 20 74 68 65 20 63 68 61 | removes the cha| 000021b0 72 61 63 74 65 72 20 74 6f 20 74 68 65 20 6c 65 |racter to the le| 000021c0 66 74 20 6f 66 20 74 68 65 20 63 61 72 65 74 2e |ft of the caret.| 000021d0 0a 20 20 20 20 20 20 20 43 4f 50 59 20 72 65 6d |. COPY rem| 000021e0 6f 76 65 73 20 74 68 65 20 63 68 61 72 61 63 74 |oves the charact| 000021f0 65 72 20 74 6f 20 74 68 65 20 72 69 67 68 74 20 |er to the right | 00002200 6f 66 20 74 68 65 20 63 61 72 65 74 2e 0a 20 20 |of the caret.. | 00002210 20 20 20 20 20 53 48 49 46 54 2f 43 4f 50 59 20 | SHIFT/COPY | 00002220 64 65 6c 65 74 65 73 20 74 68 65 20 77 6f 72 64 |deletes the word| 00002230 20 74 6f 20 74 68 65 20 72 69 67 68 74 20 6f 66 | to the right of| 00002240 20 74 68 65 20 63 61 72 65 74 2e 0a 20 20 20 20 | the caret.. | 00002250 20 20 20 43 54 52 4c 2f 43 4f 50 59 20 64 65 6c | CTRL/COPY del| 00002260 65 74 65 73 20 65 76 65 72 79 74 68 69 6e 67 20 |etes everything | 00002270 66 72 6f 6d 20 74 68 65 20 63 61 72 65 74 20 74 |from the caret t| 00002280 6f 20 74 68 65 20 65 6e 64 20 6f 66 20 74 68 65 |o the end of the| 00002290 20 6c 69 6e 65 2e 0a 20 20 20 20 20 20 20 88 20 | line.. . | 000022a0 61 6e 64 20 89 20 6d 6f 76 65 20 74 68 65 20 63 |and . move the c| 000022b0 61 72 65 74 20 6c 65 66 74 2f 72 69 67 68 74 20 |aret left/right | 000022c0 62 79 20 6f 6e 65 20 63 68 61 72 61 63 74 65 72 |by one character| 000022d0 2e 0a 20 20 20 20 20 20 20 53 48 49 46 54 20 88 |.. SHIFT .| 000022e0 20 61 6e 64 20 53 48 49 46 54 20 89 20 6d 6f 76 | and SHIFT . mov| 000022f0 65 20 74 68 65 20 63 61 72 65 74 20 6c 65 66 74 |e the caret left| 00002300 2f 72 69 67 68 74 20 62 79 20 6f 6e 65 20 77 6f |/right by one wo| 00002310 72 64 2e 0a 20 20 20 20 20 20 20 43 52 54 4c 20 |rd.. CRTL | 00002320 88 20 61 6e 64 20 43 54 52 4c 20 89 20 6d 6f 76 |. and CTRL . mov| 00002330 65 20 74 68 65 20 63 61 72 65 74 20 74 6f 20 73 |e the caret to s| 00002340 74 61 72 74 20 61 6e 64 20 65 6e 64 20 6f 66 20 |tart and end of | 00002350 74 68 65 20 66 69 65 6c 64 2e 0a 20 20 20 20 20 |the field.. | 00002360 20 20 20 20 20 0a 43 68 61 6e 67 65 73 20 6d 61 | .Changes ma| 00002370 64 65 20 74 6f 20 61 20 72 65 63 6f 72 64 20 63 |de to a record c| 00002380 61 75 73 65 20 74 68 65 20 72 65 63 6f 72 64 20 |ause the record | 00002390 74 6f 20 62 65 20 77 72 69 74 74 65 6e 20 62 61 |to be written ba| 000023a0 63 6b 20 74 6f 20 74 68 65 20 64 61 74 61 62 61 |ck to the databa| 000023b0 73 65 0a 77 68 65 6e 65 76 65 72 20 79 6f 75 20 |se.whenever you | 000023c0 64 69 73 70 6c 61 79 20 61 20 64 69 66 66 65 72 |display a differ| 000023d0 65 6e 74 20 72 65 63 6f 72 64 20 6f 72 20 63 6c |ent record or cl| 000023e0 6f 73 65 20 74 68 65 20 64 61 74 61 62 61 73 65 |ose the database| 000023f0 2e 20 54 68 65 72 65 20 69 73 20 61 0a 62 75 74 |. There is a.but| 00002400 74 6f 6e 20 6f 6e 20 74 68 65 20 6b 65 79 70 61 |ton on the keypa| 00002410 64 20 63 61 6c 6c 65 64 20 27 46 6f 72 63 65 20 |d called 'Force | 00002420 75 70 64 61 74 65 27 20 62 75 74 20 79 6f 75 20 |update' but you | 00002430 64 6f 6e 27 74 20 6e 6f 72 6d 61 6c 6c 79 20 6e |don't normally n| 00002440 65 65 64 20 74 6f 0a 75 73 65 20 69 74 2e 0a 0a |eed to.use it...| 00002450 41 74 20 74 68 65 20 65 6e 64 73 20 6f 66 20 74 |At the ends of t| 00002460 68 65 20 74 68 69 72 64 20 72 6f 77 20 6f 66 20 |he third row of | 00002470 6b 65 79 70 61 64 20 62 75 74 74 6f 6e 73 20 61 |keypad buttons a| 00002480 72 65 20 74 77 6f 20 77 68 69 63 68 20 63 6f 6e |re two which con| 00002490 74 61 69 6e 20 61 20 0a 76 65 72 74 69 63 61 6c |tain a .vertical| 000024a0 20 62 6c 75 65 20 61 72 72 6f 77 2e 20 43 6c 69 | blue arrow. Cli| 000024b0 63 6b 69 6e 67 20 6f 6e 20 74 68 65 20 6c 65 66 |cking on the lef| 000024c0 74 20 62 75 74 74 6f 6e 20 73 74 6f 72 65 73 20 |t button stores | 000024d0 74 68 65 20 63 6f 6e 74 65 6e 74 73 20 6f 66 20 |the contents of | 000024e0 74 68 65 0a 66 69 65 6c 64 20 77 68 69 63 68 20 |the.field which | 000024f0 68 61 73 20 74 68 65 20 63 61 72 65 74 20 69 6e |has the caret in| 00002500 20 61 20 73 63 72 61 74 63 68 70 61 64 2e 20 4d | a scratchpad. M| 00002510 6f 76 69 6e 67 20 74 68 65 20 63 61 72 65 74 20 |oving the caret | 00002520 74 6f 20 61 6e 6f 74 68 65 72 0a 66 69 65 6c 64 |to another.field| 00002530 20 61 6e 64 20 63 6c 69 63 6b 69 6e 67 20 74 68 | and clicking th| 00002540 65 20 72 69 67 68 74 20 62 75 74 74 6f 6e 20 63 |e right button c| 00002550 6f 70 69 65 73 20 74 68 65 20 64 61 74 61 20 66 |opies the data f| 00002560 72 6f 6d 20 74 68 65 20 73 63 72 61 74 63 68 70 |rom the scratchp| 00002570 61 64 0a 69 6e 74 6f 20 74 68 61 74 20 66 69 65 |ad.into that fie| 00002580 6c 64 2c 20 6f 76 65 72 2d 77 72 69 74 69 6e 67 |ld, over-writing| 00002590 20 69 74 73 20 70 72 65 76 69 6f 75 73 20 63 6f | its previous co| 000025a0 6e 74 65 6e 74 73 2e 20 54 68 69 73 20 70 72 6f |ntents. This pro| 000025b0 76 69 64 65 73 20 61 20 71 75 69 63 6b 0a 6d 65 |vides a quick.me| 000025c0 74 68 6f 64 20 6f 66 20 63 6f 70 79 69 6e 67 20 |thod of copying | 000025d0 64 61 74 61 20 66 72 6f 6d 20 6f 6e 65 20 66 69 |data from one fi| 000025e0 65 6c 64 20 74 6f 20 61 6e 6f 74 68 65 72 2c 20 |eld to another, | 000025f0 6f 72 20 66 72 6f 6d 20 6f 6e 65 20 72 65 63 6f |or from one reco| 00002600 72 64 20 74 6f 0a 61 6e 6f 74 68 65 72 2e 20 59 |rd to.another. Y| 00002610 6f 75 20 6d 61 79 20 63 6f 6e 74 69 6e 75 65 20 |ou may continue | 00002620 74 6f 20 22 70 61 73 74 65 22 20 74 68 65 20 64 |to "paste" the d| 00002630 61 74 61 20 69 6e 74 6f 20 6e 65 77 20 66 69 65 |ata into new fie| 00002640 6c 64 73 20 61 73 20 6f 66 74 65 6e 20 61 73 0a |lds as often as.| 00002650 79 6f 75 20 6c 69 6b 65 2e 20 4f 6e 6c 79 20 77 |you like. Only w| 00002660 68 65 6e 20 79 6f 75 20 63 6c 69 63 6b 20 74 68 |hen you click th| 00002670 65 20 6c 65 66 74 20 62 75 74 74 6f 6e 20 61 67 |e left button ag| 00002680 61 69 6e 20 61 72 65 20 74 68 65 20 63 6f 6e 74 |ain are the cont| 00002690 65 6e 74 73 20 6f 66 20 74 68 65 0a 73 63 72 61 |ents of the.scra| 000026a0 74 63 68 70 61 64 20 63 68 61 6e 67 65 64 2e 20 |tchpad changed. | 000026b0 44 61 74 61 20 22 70 61 73 74 65 64 22 20 69 6e |Data "pasted" in| 000026c0 74 6f 20 61 20 66 69 65 6c 64 20 63 61 6e 6e 6f |to a field canno| 000026d0 74 20 22 6f 76 65 72 66 6c 6f 77 22 3b 20 69 66 |t "overflow"; if| 000026e0 20 74 6f 6f 0a 6c 6f 6e 67 20 66 6f 72 20 74 68 | too.long for th| 000026f0 65 20 66 69 65 6c 64 20 69 74 20 77 69 6c 6c 20 |e field it will | 00002700 62 65 20 63 75 74 20 74 6f 20 74 68 65 20 70 65 |be cut to the pe| 00002710 72 6d 69 74 74 65 64 20 6c 65 6e 67 74 68 2e 20 |rmitted length. | 00002720 41 73 20 61 6e 20 61 64 64 65 64 0a 70 72 65 63 |As an added.prec| 00002730 61 75 74 69 6f 6e 20 79 6f 75 20 63 61 6e 27 74 |aution you can't| 00002740 20 22 70 61 73 74 65 22 20 61 20 6e 75 6c 6c 20 | "paste" a null | 00002750 73 74 72 69 6e 67 20 69 6e 74 6f 20 61 20 66 69 |string into a fi| 00002760 65 6c 64 2e 0a 0a 52 65 63 6f 76 65 72 69 6e 67 |eld...Recovering| 00002770 20 64 61 74 61 20 61 66 74 65 72 20 61 20 6d 69 | data after a mi| 00002780 73 74 61 6b 65 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |stake.----------| 00002790 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 000027a0 2d 2d 2d 2d 2d 0a 59 6f 75 20 77 69 6c 6c 20 73 |-----.You will s| 000027b0 6f 6d 65 74 69 6d 65 73 20 65 64 69 74 20 74 68 |ometimes edit th| 000027c0 65 20 77 72 6f 6e 67 20 66 69 65 6c 64 20 62 79 |e wrong field by| 000027d0 20 6d 69 73 74 61 6b 65 20 61 6e 64 20 77 61 6e | mistake and wan| 000027e0 74 20 74 6f 20 72 65 73 74 6f 72 65 20 74 68 65 |t to restore the| 000027f0 0a 70 72 65 76 69 6f 75 73 20 63 6f 6e 74 65 6e |.previous conten| 00002800 74 73 2e 20 43 6c 69 63 6b 20 4d 45 4e 55 20 6f |ts. Click MENU o| 00002810 76 65 72 20 74 68 65 20 66 69 65 6c 64 2e 20 54 |ver the field. T| 00002820 68 65 20 73 65 63 6f 6e 64 20 65 6e 74 72 79 20 |he second entry | 00002830 6f 6e 20 74 68 65 20 6d 61 69 6e 0a 6d 65 6e 75 |on the main.menu| 00002840 20 63 6f 6e 74 61 69 6e 73 20 74 68 65 20 22 74 | contains the "t| 00002850 61 67 22 20 6f 66 20 74 68 65 20 66 69 65 6c 64 |ag" of the field| 00002860 2e 20 46 6f 6c 6c 6f 77 20 74 68 65 20 72 69 67 |. Follow the rig| 00002870 68 74 2d 70 6f 69 6e 74 69 6e 67 20 61 72 72 6f |ht-pointing arro| 00002880 77 20 74 6f 20 74 68 65 0a 27 46 69 65 6c 64 27 |w to the.'Field'| 00002890 20 73 75 62 2d 6d 65 6e 75 20 61 6e 64 20 63 68 | sub-menu and ch| 000028a0 6f 6f 73 65 20 74 68 65 20 6c 61 73 74 20 65 6e |oose the last en| 000028b0 74 72 79 3a 20 27 52 65 73 74 6f 72 65 20 66 69 |try: 'Restore fi| 000028c0 65 6c 64 27 2e 20 53 69 6d 69 6c 61 72 6c 79 2c |eld'. Similarly,| 000028d0 20 69 66 0a 79 6f 75 20 6d 61 6b 65 20 61 20 6d | if.you make a m| 000028e0 65 73 73 20 6f 66 20 61 20 63 6f 6d 70 6c 65 74 |ess of a complet| 000028f0 65 20 72 65 63 6f 72 64 20 61 6e 64 20 77 61 6e |e record and wan| 00002900 74 20 74 6f 20 67 6f 20 62 61 63 6b 20 74 6f 20 |t to go back to | 00002910 74 68 65 20 77 61 79 20 69 74 20 77 61 73 0a 79 |the way it was.y| 00002920 6f 75 20 63 61 6e 20 63 68 6f 6f 73 65 20 27 52 |ou can choose 'R| 00002930 65 73 74 6f 72 65 20 72 65 63 6f 72 64 27 20 66 |estore record' f| 00002940 72 6f 6d 20 74 68 65 20 6d 61 69 6e 20 6d 65 6e |rom the main men| 00002950 75 2e 0a 0a 49 74 20 69 73 20 69 6d 70 6f 72 74 |u...It is import| 00002960 61 6e 74 20 74 6f 20 72 65 61 6c 69 73 65 20 74 |ant to realise t| 00002970 68 61 74 20 74 68 65 73 65 20 27 72 65 73 74 6f |hat these 'resto| 00002980 72 65 27 20 66 61 63 69 6c 69 74 69 65 73 20 77 |re' facilities w| 00002990 69 6c 6c 20 6e 6f 74 20 77 6f 72 6b 20 69 66 0a |ill not work if.| 000029a0 79 6f 75 20 68 61 76 65 20 6c 6f 6f 6b 65 64 20 |you have looked | 000029b0 61 74 20 61 6e 6f 74 68 65 72 20 72 65 63 6f 72 |at another recor| 000029c0 64 20 62 65 66 6f 72 65 20 75 73 69 6e 67 20 74 |d before using t| 000029d0 68 65 6d 20 28 6f 72 20 63 6c 69 63 6b 65 64 20 |hem (or clicked | 000029e0 6f 6e 20 27 46 6f 72 63 65 0a 75 70 64 61 74 65 |on 'Force.update| 000029f0 27 29 2e 20 49 6e 20 6f 74 68 65 72 20 77 6f 72 |'). In other wor| 00002a00 64 73 20 79 6f 75 20 63 61 6e 20 72 65 63 6f 76 |ds you can recov| 00002a10 65 72 20 64 61 74 61 20 77 68 69 63 68 20 68 61 |er data which ha| 00002a20 73 20 62 65 65 6e 20 61 6c 74 65 72 65 64 20 69 |s been altered i| 00002a30 6e 20 6f 72 0a 72 65 6d 6f 76 65 64 20 66 72 6f |n or.removed fro| 00002a40 6d 20 74 68 65 20 63 75 72 72 65 6e 74 6c 79 2d |m the currently-| 00002a50 64 69 73 70 6c 61 79 65 64 20 72 65 63 6f 72 64 |displayed record| 00002a60 20 6f 6e 6c 79 2e 0a 0a 41 64 64 69 6e 67 20 6e | only...Adding n| 00002a70 65 77 20 72 65 63 6f 72 64 73 0a 2d 2d 2d 2d 2d |ew records.-----| 00002a80 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 46 69 |-------------.Fi| 00002a90 72 73 74 20 77 65 20 77 69 6c 6c 20 61 64 64 20 |rst we will add | 00002aa0 61 20 6e 65 77 20 72 65 63 6f 72 64 20 66 6f 72 |a new record for| 00002ab0 20 61 20 66 69 63 74 69 74 69 6f 75 73 20 65 6c | a fictitious el| 00002ac0 65 6d 65 6e 74 20 61 73 20 64 65 73 63 72 69 62 |ement as describ| 00002ad0 65 64 20 62 65 6c 6f 77 3a 2d 0a 0a 20 20 20 20 |ed below:-.. | 00002ae0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 4e | N| 00002af0 41 4d 45 20 20 20 20 20 20 20 20 20 20 20 20 20 |AME | 00002b00 54 41 53 4d 41 4e 49 55 4d 0a 20 20 20 20 20 20 |TASMANIUM. | 00002b10 20 20 20 20 20 20 20 20 20 20 20 20 20 53 59 4d | SYM| 00002b20 42 4f 4c 20 20 20 20 20 20 20 20 20 20 20 54 73 |BOL Ts| 00002b30 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |. | 00002b40 20 20 20 20 41 54 4f 4d 49 43 20 4e 55 4d 42 45 | ATOMIC NUMBE| 00002b50 52 20 20 20 20 31 30 38 0a 0a 57 65 20 63 6f 75 |R 108..We cou| 00002b60 6c 64 20 69 6e 76 65 6e 74 20 61 20 6c 6f 74 20 |ld invent a lot | 00002b70 6d 6f 72 65 2c 20 62 75 74 20 74 68 69 73 20 77 |more, but this w| 00002b80 69 6c 6c 20 62 65 20 65 6e 6f 75 67 68 20 74 6f |ill be enough to| 00002b90 20 67 65 74 20 74 68 65 20 69 64 65 61 20 61 63 | get the idea ac| 00002ba0 72 6f 73 73 2e 0a 0a 41 74 20 74 68 65 20 66 61 |ross...At the fa| 00002bb0 72 20 6c 65 66 74 20 6f 66 20 74 68 65 20 73 65 |r left of the se| 00002bc0 63 6f 6e 64 20 72 6f 77 20 6f 6e 20 74 68 65 20 |cond row on the | 00002bd0 6b 65 79 70 61 64 20 69 73 20 61 20 62 75 74 74 |keypad is a butt| 00002be0 6f 6e 20 77 69 74 68 20 61 20 70 6c 75 73 20 73 |on with a plus s| 00002bf0 69 67 6e 0a 61 6e 64 20 61 20 22 72 65 63 6f 72 |ign.and a "recor| 00002c00 64 20 63 61 72 64 22 20 69 63 6f 6e 2e 20 54 68 |d card" icon. Th| 00002c10 69 73 20 69 73 20 74 68 65 20 27 49 6e 73 65 72 |is is the 'Inser| 00002c20 74 27 20 62 75 74 74 6f 6e 2e 20 41 20 62 6c 61 |t' button. A bla| 00002c30 6e 6b 20 72 65 63 6f 72 64 20 77 69 6c 6c 0a 62 |nk record will.b| 00002c40 65 20 64 69 73 70 6c 61 79 65 64 20 77 69 74 68 |e displayed with| 00002c50 20 74 68 65 20 63 61 72 65 74 20 69 6e 20 74 68 | the caret in th| 00002c60 65 20 4e 41 4d 45 20 66 69 65 6c 64 2e 20 20 45 |e NAME field. E| 00002c70 6e 74 65 72 20 54 41 53 4d 41 4e 49 55 4d 20 68 |nter TASMANIUM h| 00002c80 65 72 65 20 61 6e 64 0a 70 72 65 73 73 20 52 45 |ere and.press RE| 00002c90 54 55 52 4e 2e 20 54 68 65 20 63 61 72 65 74 20 |TURN. The caret | 00002ca0 77 69 6c 6c 20 6a 75 6d 70 20 74 6f 20 74 68 65 |will jump to the| 00002cb0 20 53 59 4d 42 4f 4c 20 66 69 65 6c 64 2e 20 45 | SYMBOL field. E| 00002cc0 6e 74 65 72 20 54 73 2e 20 59 6f 75 20 77 69 6c |nter Ts. You wil| 00002cd0 6c 0a 6e 6f 77 20 6e 65 65 64 20 74 6f 20 70 72 |l.now need to pr| 00002ce0 65 73 73 20 52 45 54 55 52 4e 20 74 77 69 63 65 |ess RETURN twice| 00002cf0 20 74 6f 20 67 65 74 20 74 6f 20 41 54 4f 4d 49 | to get to ATOMI| 00002d00 43 20 4e 55 4d 42 45 52 20 28 4f 6e 65 20 70 72 |C NUMBER (One pr| 00002d10 65 73 73 20 74 61 6b 65 73 20 79 6f 75 0a 74 6f |ess takes you.to| 00002d20 20 74 68 65 20 75 6e 2d 6e 61 6d 65 64 20 66 69 | the un-named fi| 00002d30 65 6c 64 20 61 66 74 65 72 20 4e 41 4d 45 20 77 |eld after NAME w| 00002d40 68 65 72 65 20 74 68 65 20 6f 72 69 67 69 6e 20 |here the origin | 00002d50 6f 66 20 74 68 65 20 65 6c 65 6d 65 6e 74 27 73 |of the element's| 00002d60 20 6e 61 6d 65 20 69 73 0a 67 69 76 65 6e 2e 29 | name is.given.)| 00002d70 20 41 6c 74 65 72 6e 61 74 69 76 65 6c 79 20 79 | Alternatively y| 00002d80 6f 75 20 63 6f 75 6c 64 20 70 6f 69 6e 74 20 74 |ou could point t| 00002d90 68 65 20 6d 6f 75 73 65 20 61 74 20 74 68 65 20 |he mouse at the | 00002da0 41 54 4f 4d 49 43 20 4e 55 4d 42 45 52 20 62 6f |ATOMIC NUMBER bo| 00002db0 78 20 61 6e 64 0a 63 6c 69 63 6b 20 53 45 4c 45 |x and.click SELE| 00002dc0 43 54 2e 20 54 68 65 72 65 20 69 73 20 6e 6f 20 |CT. There is no | 00002dd0 6e 65 65 64 20 74 6f 20 70 72 65 73 73 20 52 45 |need to press RE| 00002de0 54 55 52 4e 20 61 66 74 65 72 20 65 6e 74 65 72 |TURN after enter| 00002df0 69 6e 67 20 61 20 66 69 65 6c 64 20 69 6e 0a 6f |ing a field in.o| 00002e00 72 64 65 72 20 74 6f 20 22 61 63 63 65 70 74 22 |rder to "accept"| 00002e10 20 74 68 65 20 64 61 74 61 3b 20 69 74 27 73 20 | the data; it's | 00002e20 73 69 6d 70 6c 79 20 74 68 65 20 6d 6f 73 74 20 |simply the most | 00002e30 63 6f 6e 76 65 6e 69 65 6e 74 20 77 61 79 20 6f |convenient way o| 00002e40 66 20 67 65 74 74 69 6e 67 0a 74 6f 20 74 68 65 |f getting.to the| 00002e50 20 6e 65 78 74 20 66 69 65 6c 64 20 69 66 20 74 | next field if t| 00002e60 68 61 74 27 73 20 77 68 61 74 20 79 6f 75 20 77 |hat's what you w| 00002e70 61 6e 74 20 74 6f 20 64 6f 2e 20 20 57 68 65 6e |ant to do. When| 00002e80 20 65 6e 74 65 72 69 6e 67 20 64 61 74 61 20 69 | entering data i| 00002e90 6e 74 6f 0a 77 69 64 65 6c 79 2d 20 73 63 61 74 |nto.widely- scat| 00002ea0 74 65 72 65 64 20 66 69 65 6c 64 73 20 69 74 20 |tered fields it | 00002eb0 69 73 20 6d 6f 72 65 20 63 6f 6e 76 65 6e 69 65 |is more convenie| 00002ec0 6e 74 20 74 6f 20 75 73 65 20 74 68 65 20 6d 6f |nt to use the mo| 00002ed0 75 73 65 2e 0a 0a 48 61 76 69 6e 67 20 65 6e 74 |use...Having ent| 00002ee0 65 72 65 64 20 79 6f 75 72 20 64 61 74 61 20 63 |ered your data c| 00002ef0 6c 69 63 6b 20 61 6e 79 20 6f 66 20 74 68 65 20 |lick any of the | 00002f00 66 69 72 73 74 20 72 6f 77 20 6f 66 20 62 75 74 |first row of but| 00002f10 74 6f 6e 73 20 73 6f 20 74 68 61 74 20 61 0a 64 |tons so that a.d| 00002f20 69 66 66 65 72 65 6e 74 20 72 65 63 6f 72 64 20 |ifferent record | 00002f30 69 73 20 64 69 73 70 6c 61 79 65 64 2e 20 4e 6f |is displayed. No| 00002f40 77 20 75 73 65 20 27 53 65 61 72 63 68 27 20 74 |w use 'Search' t| 00002f50 6f 20 66 69 6e 64 20 54 41 53 4d 41 4e 49 55 4d |o find TASMANIUM| 00002f60 20 62 79 20 6e 61 6d 65 2e 0a 43 68 61 6e 67 65 | by name..Change| 00002f70 20 74 6f 20 74 68 65 20 6f 74 68 65 72 20 69 6e | to the other in| 00002f80 64 65 78 20 20 61 6e 64 20 66 69 6e 64 20 69 74 |dex and find it| 00002f90 20 62 79 20 61 74 6f 6d 69 63 20 6e 75 6d 62 65 | by atomic numbe| 00002fa0 72 2e 20 49 6e 20 62 6f 74 68 20 63 61 73 65 73 |r. In both cases| 00002fb0 20 74 72 79 20 0a 6d 6f 76 69 6e 67 20 74 6f 20 | try .moving to | 00002fc0 74 68 65 20 72 65 63 6f 72 64 20 6a 75 73 74 20 |the record just | 00002fd0 62 65 66 6f 72 65 20 61 6e 64 20 6a 75 73 74 20 |before and just | 00002fe0 61 66 74 65 72 20 74 68 65 20 6e 65 77 20 6f 6e |after the new on| 00002ff0 65 2c 20 6e 6f 74 69 6e 67 20 74 68 61 74 20 69 |e, noting that i| 00003000 74 0a 68 61 73 20 62 65 65 6e 20 70 6c 61 63 65 |t.has been place| 00003010 64 20 69 6e 20 69 74 73 20 63 6f 72 72 65 63 74 |d in its correct| 00003020 20 70 6f 73 69 74 69 6f 6e 20 69 6e 20 62 6f 74 | position in bot| 00003030 68 20 69 6e 64 69 63 65 73 3a 20 62 65 74 77 65 |h indices: betwe| 00003040 65 6e 20 54 41 4e 54 41 4c 55 4d 0a 61 6e 64 20 |en TANTALUM.and | 00003050 54 45 43 48 4e 45 54 49 55 4d 20 69 6e 20 74 68 |TECHNETIUM in th| 00003060 65 20 4e 41 4d 45 20 69 6e 64 65 78 20 61 6e 64 |e NAME index and| 00003070 20 61 74 20 74 68 65 20 76 65 72 79 20 65 6e 64 | at the very end| 00003080 20 6f 66 20 74 68 65 20 41 54 4f 4d 49 43 20 4e | of the ATOMIC N| 00003090 55 4d 42 45 52 0a 69 6e 64 65 78 2e 0a 0a 44 61 |UMBER.index...Da| 000030a0 74 61 20 49 6e 70 75 74 20 56 61 6c 69 64 61 74 |ta Input Validat| 000030b0 69 6f 6e 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |ion.------------| 000030c0 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 57 68 65 6e 20 65 |---------.When e| 000030d0 6e 74 65 72 69 6e 67 20 74 68 65 20 61 62 6f 76 |ntering the abov| 000030e0 65 20 64 61 74 61 20 79 6f 75 20 6d 61 79 20 68 |e data you may h| 000030f0 61 76 65 20 6e 6f 74 69 63 65 64 20 74 68 61 74 |ave noticed that| 00003100 20 74 68 65 20 4e 41 4d 45 20 66 69 65 6c 64 20 | the NAME field | 00003110 77 69 6c 6c 0a 6f 6e 6c 79 20 61 63 63 65 70 74 |will.only accept| 00003120 20 63 61 70 69 74 61 6c 20 6c 65 74 74 65 72 73 | capital letters| 00003130 20 61 6e 64 20 74 68 65 20 41 54 4f 4d 49 43 20 | and the ATOMIC | 00003140 4e 55 4d 42 45 52 20 66 69 65 6c 64 20 77 69 6c |NUMBER field wil| 00003150 6c 20 6f 6e 6c 79 20 61 63 63 65 70 74 0a 6e 75 |l only accept.nu| 00003160 6d 65 72 61 6c 73 2e 20 54 68 69 73 20 69 73 20 |merals. This is | 00003170 62 65 63 61 75 73 65 20 74 68 65 20 66 69 65 6c |because the fiel| 00003180 64 73 20 68 61 76 65 20 61 6e 20 61 73 73 6f 63 |ds have an assoc| 00003190 69 61 74 65 64 20 54 59 50 45 20 77 68 69 63 68 |iated TYPE which| 000031a0 20 72 65 73 74 72 69 63 74 73 0a 74 68 65 20 63 | restricts.the c| 000031b0 68 61 72 61 63 74 65 72 73 20 77 68 69 63 68 20 |haracters which | 000031c0 74 68 65 20 66 69 65 6c 64 20 77 69 6c 6c 20 61 |the field will a| 000031d0 63 63 65 70 74 2e 20 41 6e 79 20 6f 74 68 65 72 |ccept. Any other| 000031e0 73 20 61 72 65 20 73 69 6d 70 6c 79 20 69 67 6e |s are simply ign| 000031f0 6f 72 65 64 2e 0a 57 65 20 77 69 6c 6c 20 63 61 |ored..We will ca| 00003200 6c 6c 20 74 68 69 73 20 66 65 61 74 75 72 65 20 |ll this feature | 00003210 54 59 50 45 20 56 41 4c 49 44 41 54 49 4f 4e 2e |TYPE VALIDATION.| 00003220 20 0a 0a 41 6e 6f 74 68 65 72 20 6c 65 76 65 6c | ..Another level| 00003230 20 6f 66 20 64 61 74 61 20 76 61 6c 69 64 61 74 | of data validat| 00003240 69 6f 6e 2c 20 77 68 69 63 68 20 77 65 20 77 69 |ion, which we wi| 00003250 6c 6c 20 6e 6f 77 20 69 6c 6c 75 73 74 72 61 74 |ll now illustrat| 00003260 65 2c 20 69 73 20 63 61 6c 6c 65 64 0a 54 41 42 |e, is called.TAB| 00003270 4c 45 20 56 41 4c 49 44 41 54 49 4f 4e 20 20 4d |LE VALIDATION M| 00003280 61 6b 65 20 61 6e 20 65 6e 74 72 79 20 69 6e 20 |ake an entry in | 00003290 74 68 65 20 47 52 4f 55 50 20 66 69 65 6c 64 2e |the GROUP field.| 000032a0 20 54 79 70 65 20 58 2c 20 66 6f 72 20 65 78 61 | Type X, for exa| 000032b0 6d 70 6c 65 2c 0a 74 68 65 6e 20 74 72 79 20 74 |mple,.then try t| 000032c0 6f 20 6d 6f 76 65 20 74 6f 20 61 6e 6f 74 68 65 |o move to anothe| 000032d0 72 20 66 69 65 6c 64 20 62 79 20 65 69 74 68 65 |r field by eithe| 000032e0 72 20 70 72 65 73 73 69 6e 67 20 52 45 54 55 52 |r pressing RETUR| 000032f0 4e 20 6f 72 20 63 6c 69 63 6b 69 6e 67 20 74 68 |N or clicking th| 00003300 65 0a 6d 6f 75 73 65 2e 20 20 59 6f 75 27 6c 6c |e.mouse. You'll| 00003310 20 66 69 6e 64 20 74 68 61 74 20 79 6f 75 20 63 | find that you c| 00003320 61 6e 27 74 20 64 6f 20 73 6f 20 2d 20 79 6f 75 |an't do so - you| 00003330 20 67 65 74 20 61 6e 20 65 72 72 6f 72 20 6d 65 | get an error me| 00003340 73 73 61 67 65 20 69 6e 73 74 65 61 64 2e 0a 54 |ssage instead..T| 00003350 68 69 73 20 69 73 20 62 65 63 61 75 73 65 20 74 |his is because t| 00003360 68 65 20 47 52 4f 55 50 20 66 69 65 6c 64 20 69 |he GROUP field i| 00003370 73 20 6c 69 6e 6b 65 64 20 74 6f 20 61 20 56 41 |s linked to a VA| 00003380 4c 49 44 41 54 49 4f 4e 20 54 41 42 4c 45 20 77 |LIDATION TABLE w| 00003390 68 69 63 68 0a 6d 65 61 6e 73 20 74 68 61 74 20 |hich.means that | 000033a0 6f 6e 6c 79 20 65 6e 74 72 69 65 73 20 77 68 69 |only entries whi| 000033b0 63 68 20 61 70 70 65 61 72 20 69 6e 20 74 68 65 |ch appear in the| 000033c0 20 74 61 62 6c 65 20 6d 61 79 20 62 65 20 75 73 | table may be us| 000033d0 65 64 20 69 6e 20 74 68 61 74 20 66 69 65 6c 64 |ed in that field| 000033e0 2e 0a 46 69 65 6c 64 73 20 6c 69 6e 6b 65 64 20 |..Fields linked | 000033f0 74 6f 20 76 61 6c 69 64 61 74 69 6f 6e 20 74 61 |to validation ta| 00003400 62 6c 65 73 20 61 72 65 20 64 69 73 74 69 6e 67 |bles are disting| 00003410 75 69 73 68 65 64 20 62 79 20 75 73 69 6e 67 20 |uished by using | 00003420 64 61 72 6b 20 67 72 65 65 6e 2c 20 0a 69 6e 73 |dark green, .ins| 00003430 74 65 61 64 20 6f 66 20 62 6c 61 63 6b 2c 20 61 |tead of black, a| 00003440 73 20 74 68 65 20 66 6f 72 65 67 72 6f 75 6e 64 |s the foreground| 00003450 20 63 6f 6c 6f 75 72 2e 0a 0a 54 6f 20 73 65 65 | colour...To see| 00003460 20 77 68 61 74 20 74 68 65 20 76 61 6c 69 64 61 | what the valida| 00003470 74 69 6f 6e 20 74 61 62 6c 65 20 63 6f 6e 74 61 |tion table conta| 00003480 69 6e 73 2c 20 70 6c 61 63 65 20 74 68 65 20 63 |ins, place the c| 00003490 61 72 65 74 20 69 6e 20 74 68 65 20 47 52 4f 55 |aret in the GROU| 000034a0 50 0a 66 69 65 6c 64 20 74 68 65 6e 20 63 6c 69 |P.field then cli| 000034b0 63 6b 20 6f 6e 20 74 68 65 20 4c 69 73 74 20 76 |ck on the List v| 000034c0 61 6c 75 65 73 20 62 75 74 74 6f 6e 20 6f 6e 20 |alues button on | 000034d0 74 68 65 20 6b 65 79 70 61 64 2e 20 54 68 65 20 |the keypad. The | 000034e0 76 61 6c 69 64 61 74 69 6f 6e 0a 74 61 62 6c 65 |validation.table| 000034f0 20 77 69 6c 6c 20 74 68 65 6e 20 62 65 20 64 69 | will then be di| 00003500 73 70 6c 61 79 65 64 20 69 6e 20 69 74 73 20 6f |splayed in its o| 00003510 77 6e 20 77 69 6e 64 6f 77 2e 20 4f 6e 6c 79 20 |wn window. Only | 00003520 74 68 6f 73 65 20 69 74 65 6d 73 20 69 6e 20 74 |those items in t| 00003530 68 65 20 6c 65 66 74 0a 63 6f 6c 75 6d 6e 20 6f |he left.column o| 00003540 66 20 74 68 65 20 74 61 62 6c 65 20 6d 61 79 20 |f the table may | 00003550 62 65 20 65 6e 74 65 72 65 64 20 69 6e 20 74 68 |be entered in th| 00003560 65 20 47 52 4f 55 50 20 66 69 65 6c 64 2e 20 45 |e GROUP field. E| 00003570 6c 65 6d 65 6e 74 20 31 30 38 20 77 6f 75 6c 64 |lement 108 would| 00003580 20 62 65 0a 61 20 74 72 61 6e 73 69 74 69 6f 6e | be.a transition| 00003590 20 6d 65 74 61 6c 2c 20 73 6f 20 65 6e 74 65 72 | metal, so enter| 000035a0 20 54 2e 20 59 6f 75 20 77 69 6c 6c 20 6e 6f 77 | T. You will now| 000035b0 20 66 69 6e 64 20 74 68 61 74 20 50 6f 77 65 72 | find that Power| 000035c0 62 61 73 65 20 61 63 63 65 70 74 73 0a 79 6f 75 |base accepts.you| 000035d0 72 20 64 61 74 61 2e 0a 0a 42 6f 74 68 20 74 79 |r data...Both ty| 000035e0 70 65 20 76 61 6c 69 64 61 74 69 6f 6e 20 61 6e |pe validation an| 000035f0 64 20 74 61 62 6c 65 20 76 61 6c 69 64 61 74 69 |d table validati| 00003600 6f 6e 20 6d 61 79 20 62 65 20 74 75 72 6e 65 64 |on may be turned| 00003610 20 6f 66 66 20 61 6e 64 20 6f 6e 20 62 79 20 6d | off and on by m| 00003620 65 61 6e 73 0a 6f 66 20 61 6e 20 6f 70 74 69 6f |eans.of an optio| 00003630 6e 20 6f 6e 20 74 68 65 20 56 61 6c 69 64 61 74 |n on the Validat| 00003640 69 6f 6e 20 73 75 62 6d 65 6e 75 2e 20 54 68 65 |ion submenu. The| 00003650 20 69 74 65 6d 20 69 73 20 6e 6f 72 6d 61 6c 6c | item is normall| 00003660 79 20 74 69 63 6b 65 64 2c 20 73 68 6f 77 69 6e |y ticked, showin| 00003670 67 0a 74 68 61 74 20 76 61 6c 69 64 61 74 69 6f |g.that validatio| 00003680 6e 20 69 73 20 74 75 72 6e 65 64 20 6f 6e 2e 0a |n is turned on..| 00003690 0a 44 65 6c 65 74 69 6e 67 20 72 65 63 6f 72 64 |.Deleting record| 000036a0 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |s.--------------| 000036b0 2d 2d 0a 53 69 6e 63 65 20 22 74 61 73 6d 61 6e |--.Since "tasman| 000036c0 69 75 6d 22 20 69 73 6e 27 74 20 61 20 72 65 61 |ium" isn't a rea| 000036d0 6c 20 65 6c 65 6d 65 6e 74 20 77 65 20 77 61 6e |l element we wan| 000036e0 74 20 74 6f 20 72 65 6d 6f 76 65 20 69 74 20 66 |t to remove it f| 000036f0 72 6f 6d 20 6f 75 72 0a 64 61 74 61 62 61 73 65 |rom our.database| 00003700 2e 20 20 54 68 65 72 65 20 69 73 20 61 20 22 64 |. There is a "d| 00003710 75 73 74 62 69 6e 22 20 62 75 74 74 6f 6e 20 20 |ustbin" button | 00003720 77 68 69 63 68 20 77 69 6c 6c 20 64 6f 20 6a 75 |which will do ju| 00003730 73 74 20 74 68 61 74 3a 20 62 75 74 20 64 6f 6e |st that: but don| 00003740 27 74 0a 75 73 65 20 69 74 20 79 65 74 2e 20 20 |'t.use it yet. | 00003750 20 4d 61 6b 65 20 73 75 72 65 20 74 68 61 74 20 | Make sure that | 00003760 74 68 65 20 75 6e 77 61 6e 74 65 64 20 72 65 63 |the unwanted rec| 00003770 6f 72 64 20 69 73 20 6f 6e 20 74 68 65 20 73 63 |ord is on the sc| 00003780 72 65 65 6e 20 61 6e 64 20 63 6c 69 63 6b 0a 74 |reen and click.t| 00003790 68 65 20 62 75 74 74 6f 6e 20 74 6f 20 74 68 65 |he button to the| 000037a0 20 52 49 47 48 54 20 6f 66 20 74 68 65 20 62 69 | RIGHT of the bi| 000037b0 6e 2e 20 59 6f 75 20 77 69 6c 6c 20 6e 6f 77 20 |n. You will now | 000037c0 66 69 6e 64 20 74 68 61 74 20 22 74 61 73 6d 61 |find that "tasma| 000037d0 6e 69 75 6d 22 20 68 61 73 0a 76 61 6e 69 73 68 |nium" has.vanish| 000037e0 65 64 3b 20 74 68 65 20 6e 61 6d 65 73 20 72 75 |ed; the names ru| 000037f0 6e 20 73 74 72 61 69 67 68 74 20 66 72 6f 6d 20 |n straight from | 00003800 54 41 4e 54 41 4c 55 4d 20 74 6f 20 54 45 43 48 |TANTALUM to TECH| 00003810 4e 45 54 49 55 4d 20 61 6e 64 20 74 68 65 20 61 |NETIUM and the a| 00003820 74 6f 6d 69 63 0a 6e 75 6d 62 65 72 73 20 65 6e |tomic.numbers en| 00003830 64 20 77 69 74 68 20 31 30 33 2c 20 6a 75 73 74 |d with 103, just| 00003840 20 61 73 20 74 68 65 79 20 64 69 64 20 62 65 66 | as they did bef| 00003850 6f 72 65 20 79 6f 75 20 61 64 64 65 64 20 74 68 |ore you added th| 00003860 65 20 65 78 74 72 61 20 72 65 63 6f 72 64 2e 0a |e extra record..| 00003870 0a 57 61 73 6e 27 74 20 74 68 61 74 20 72 61 74 |.Wasn't that rat| 00003880 68 65 72 20 54 4f 4f 20 65 61 73 79 3f 20 53 75 |her TOO easy? Su| 00003890 70 70 6f 73 65 20 79 6f 75 20 63 6c 69 63 6b 65 |ppose you clicke| 000038a0 64 20 74 68 65 20 62 75 74 74 6f 6e 20 62 79 20 |d the button by | 000038b0 6d 69 73 74 61 6b 65 20 61 6e 64 0a 64 65 6c 65 |mistake and.dele| 000038c0 74 65 64 20 61 6e 20 69 6d 70 6f 72 74 61 6e 74 |ted an important| 000038d0 20 72 65 63 6f 72 64 21 20 50 6f 77 65 72 62 61 | record! Powerba| 000038e0 73 65 20 68 61 6e 64 6c 65 73 20 74 68 69 73 20 |se handles this | 000038f0 76 65 72 79 20 6e 69 63 65 6c 79 2e 20 54 68 65 |very nicely. The| 00003900 20 72 65 63 6f 72 64 0a 68 61 73 6e 27 74 20 72 | record.hasn't r| 00003910 65 61 6c 6c 79 20 62 65 65 6e 20 64 65 6c 65 74 |eally been delet| 00003920 65 64 20 61 74 20 61 6c 6c 2e 20 54 6f 20 70 72 |ed at all. To pr| 00003930 6f 76 65 20 74 68 69 73 2c 20 63 6c 69 63 6b 20 |ove this, click | 00003940 74 68 65 20 62 75 74 74 6f 6e 20 61 62 6f 76 65 |the button above| 00003950 20 74 68 65 0a 6f 6e 65 20 79 6f 75 20 75 73 65 | the.one you use| 00003960 64 20 66 6f 72 20 22 64 65 6c 65 74 69 6e 67 22 |d for "deleting"| 00003970 2e 20 54 68 65 20 62 75 74 74 6f 6e 20 73 68 6f |. The button sho| 00003980 77 73 20 61 20 67 72 65 65 6e 20 72 69 67 68 74 |ws a green right| 00003990 2d 70 6f 69 6e 74 69 6e 67 20 61 72 72 6f 77 0a |-pointing arrow.| 000039a0 61 6e 64 20 61 20 22 63 61 72 64 20 69 6e 64 65 |and a "card inde| 000039b0 78 22 20 69 63 6f 6e 2e 20 54 68 65 72 65 27 73 |x" icon. There's| 000039c0 20 54 41 53 4d 41 4e 49 55 4d 20 61 67 61 69 6e | TASMANIUM again| 000039d0 21 20 59 6f 75 20 77 69 6c 6c 20 73 6f 6f 6e 20 |! You will soon | 000039e0 66 69 6e 64 20 74 68 61 74 20 69 74 0a 61 70 70 |find that it.app| 000039f0 65 61 72 73 20 74 6f 20 62 65 20 74 68 65 20 4f |ears to be the O| 00003a00 4e 4c 59 20 72 65 63 6f 72 64 20 69 6e 20 74 68 |NLY record in th| 00003a10 65 20 66 69 6c 65 21 20 44 6f 6e 27 74 20 77 6f |e file! Don't wo| 00003a20 72 72 79 3b 20 6e 6f 74 68 69 6e 67 20 68 61 73 |rry; nothing has| 00003a30 20 62 65 65 6e 0a 6c 6f 73 74 2e 20 20 41 20 50 | been.lost. A P| 00003a40 6f 77 65 72 62 61 73 65 20 64 61 74 61 62 61 73 |owerbase databas| 00003a50 65 20 69 73 20 74 72 65 61 74 65 64 20 61 73 20 |e is treated as | 00003a60 73 69 78 20 73 65 70 61 72 61 74 65 20 53 55 42 |six separate SUB| 00003a70 46 49 4c 45 53 20 0a 6e 75 6d 62 65 72 65 64 20 |FILES .numbered | 00003a80 30 2d 35 2e 20 57 68 65 6e 20 79 6f 75 20 66 69 |0-5. When you fi| 00003a90 72 73 74 20 6f 70 65 6e 20 74 68 65 20 64 61 74 |rst open the dat| 00003aa0 61 62 61 73 65 20 79 6f 75 20 61 72 65 20 6c 6f |abase you are lo| 00003ab0 6f 6b 69 6e 67 20 61 74 20 53 75 62 66 69 6c 65 |oking at Subfile| 00003ac0 20 30 0a 61 6e 64 20 74 68 65 20 68 65 61 64 69 | 0.and the headi| 00003ad0 6e 67 20 6f 66 20 74 68 65 20 72 65 63 6f 72 64 |ng of the record| 00003ae0 20 77 69 6e 64 6f 77 20 73 68 6f 77 73 20 74 68 | window shows th| 00003af0 69 73 2e 20 49 66 20 79 6f 75 20 6c 6f 6f 6b 20 |is. If you look | 00003b00 61 74 20 74 68 65 20 68 65 61 64 69 6e 67 0a 6e |at the heading.n| 00003b10 6f 77 20 79 6f 75 20 77 69 6c 6c 20 73 65 65 20 |ow you will see | 00003b20 74 68 61 74 20 69 74 20 68 61 73 20 63 68 61 6e |that it has chan| 00003b30 67 65 64 20 74 6f 20 53 75 62 66 69 6c 65 20 31 |ged to Subfile 1| 00003b40 2e 0a 0a 54 68 65 20 62 75 74 74 6f 6e 73 20 6f |...The buttons o| 00003b50 6e 20 65 69 74 68 65 72 20 73 69 64 65 20 6f 66 |n either side of| 00003b60 20 74 68 65 20 62 69 6e 20 63 61 72 72 79 20 70 | the bin carry p| 00003b70 69 63 74 75 72 65 73 20 77 68 69 63 68 20 73 75 |ictures which su| 00003b80 67 67 65 73 74 20 74 68 65 69 72 0a 74 72 75 65 |ggest their.true| 00003b90 20 66 75 6e 63 74 69 6f 6e 73 2e 20 54 68 65 79 | functions. They| 00003ba0 20 64 6f 20 4e 4f 54 20 64 65 6c 65 74 65 20 72 | do NOT delete r| 00003bb0 65 63 6f 72 64 73 3b 20 74 68 65 79 20 6d 65 72 |ecords; they mer| 00003bc0 65 6c 79 20 4d 4f 56 45 20 72 65 63 6f 72 64 73 |ely MOVE records| 00003bd0 20 66 72 6f 6d 0a 6f 6e 65 20 73 75 62 66 69 6c | from.one subfil| 00003be0 65 20 74 6f 20 61 6e 6f 74 68 65 72 2e 20 54 68 |e to another. Th| 00003bf0 65 20 72 69 67 68 74 20 62 75 74 74 6f 6e 20 6d |e right button m| 00003c00 6f 76 65 73 20 74 68 65 20 64 69 73 70 6c 61 79 |oves the display| 00003c10 65 64 20 72 65 63 6f 72 64 20 74 6f 20 74 68 65 |ed record to the| 00003c20 0a 6e 65 78 74 20 73 75 62 66 69 6c 65 20 69 6e |.next subfile in| 00003c30 20 73 65 71 75 65 6e 63 65 2e 20 54 68 75 73 2c | sequence. Thus,| 00003c40 20 69 6e 20 74 68 65 20 61 62 6f 76 65 20 63 61 | in the above ca| 00003c50 73 65 20 74 68 65 20 54 41 53 4d 41 4e 49 55 4d |se the TASMANIUM| 00003c60 20 72 65 63 6f 72 64 20 68 61 73 0a 62 65 65 6e | record has.been| 00003c70 20 6d 6f 76 65 64 20 66 72 6f 6d 20 73 75 62 66 | moved from subf| 00003c80 69 6c 65 20 30 20 74 6f 20 73 75 62 66 69 6c 65 |ile 0 to subfile| 00003c90 20 31 2e 20 41 20 72 65 63 6f 72 64 20 69 6e 20 | 1. A record in | 00003ca0 73 75 62 66 69 6c 65 20 31 20 77 6f 75 6c 64 20 |subfile 1 would | 00003cb0 62 65 20 6d 6f 76 65 64 0a 74 6f 20 73 75 62 66 |be moved.to subf| 00003cc0 69 6c 65 20 32 20 61 6e 64 20 73 6f 20 6f 6e 2e |ile 2 and so on.| 00003cd0 20 20 57 68 61 74 20 68 61 70 70 65 6e 73 20 77 | What happens w| 00003ce0 68 65 6e 20 69 74 20 67 65 74 73 20 74 6f 20 35 |hen it gets to 5| 00003cf0 3f 20 54 68 65 20 6e 65 78 74 20 63 6c 69 63 6b |? The next click| 00003d00 0a 73 68 6f 76 65 73 20 69 74 20 69 6e 74 6f 20 |.shoves it into | 00003d10 73 75 62 66 69 6c 65 20 30 20 77 68 65 72 65 20 |subfile 0 where | 00003d20 69 74 20 77 61 73 20 6f 72 69 67 69 6e 61 6c 6c |it was originall| 00003d30 79 2e 20 41 73 20 79 6f 75 20 6d 69 67 68 74 20 |y. As you might | 00003d40 68 61 76 65 20 67 75 65 73 73 65 64 2c 0a 74 68 |have guessed,.th| 00003d50 65 20 6c 65 66 74 20 62 75 74 74 6f 6e 20 6d 6f |e left button mo| 00003d60 76 65 73 20 72 65 63 6f 72 64 73 20 69 6e 20 74 |ves records in t| 00003d70 68 65 20 6f 70 70 6f 73 69 74 65 20 64 69 72 65 |he opposite dire| 00003d80 63 74 69 6f 6e 2c 20 69 2e 65 2e 20 66 72 6f 6d |ction, i.e. from| 00003d90 20 73 75 62 66 69 6c 65 20 31 0a 74 6f 20 30 20 | subfile 1.to 0 | 00003da0 6f 72 20 66 72 6f 6d 20 73 75 62 66 69 6c 65 20 |or from subfile | 00003db0 30 20 74 6f 20 35 2e 0a 0a 57 68 61 74 20 68 61 |0 to 5...What ha| 00003dc0 70 70 65 6e 73 20 77 68 65 6e 20 79 6f 75 20 44 |ppens when you D| 00003dd0 4f 20 77 61 6e 74 20 74 6f 20 6c 6f 73 65 20 61 |O want to lose a| 00003de0 20 72 65 63 6f 72 64 20 66 6f 72 20 67 6f 6f 64 | record for good| 00003df0 3f 20 20 54 68 61 74 27 73 20 77 68 65 6e 20 79 |? That's when y| 00003e00 6f 75 0a 63 6f 6e 73 69 67 6e 20 69 74 20 74 6f |ou.consign it to| 00003e10 20 74 68 65 20 64 75 73 74 62 69 6e 21 20 20 53 | the dustbin! S| 00003e20 69 6e 63 65 20 74 68 69 73 20 62 75 74 74 6f 6e |ince this button| 00003e30 27 73 20 61 63 74 69 6f 6e 20 69 73 20 6d 6f 72 |'s action is mor| 00003e40 65 20 64 72 61 73 74 69 63 20 74 68 61 6e 0a 74 |e drastic than.t| 00003e50 68 61 74 20 6f 66 20 74 68 65 20 6f 74 68 65 72 |hat of the other| 00003e60 20 74 77 6f 20 79 6f 75 20 61 72 65 20 61 73 6b | two you are ask| 00003e70 65 64 20 66 6f 72 20 63 6f 6e 66 69 72 6d 61 74 |ed for confirmat| 00003e80 69 6f 6e 20 62 65 66 6f 72 65 20 64 65 6c 65 74 |ion before delet| 00003e90 69 6f 6e 20 6f 63 63 75 72 73 2e 0a 0a 50 72 69 |ion occurs...Pri| 00003ea0 6e 74 69 6e 67 20 4c 69 73 74 73 0a 3d 3d 3d 3d |nting Lists.====| 00003eb0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 42 65 66 6f 72 |==========.Befor| 00003ec0 65 20 50 6f 77 65 72 62 61 73 65 20 63 61 6e 20 |e Powerbase can | 00003ed0 70 72 6f 64 75 63 65 20 61 20 6c 69 73 74 20 69 |produce a list i| 00003ee0 74 20 6d 75 73 74 20 62 65 20 74 6f 6c 64 3a 0a |t must be told:.| 00003ef0 0a 20 20 20 20 20 20 20 20 20 20 20 2a 20 77 68 |. * wh| 00003f00 69 63 68 20 46 49 45 4c 44 53 20 73 68 6f 75 6c |ich FIELDS shoul| 00003f10 64 20 61 70 70 65 61 72 20 6f 6e 20 74 68 65 20 |d appear on the | 00003f20 6c 69 73 74 0a 20 20 20 20 20 20 20 20 20 20 20 |list. | 00003f30 2a 20 77 68 69 63 68 20 52 45 43 4f 52 44 53 20 |* which RECORDS | 00003f40 73 68 6f 75 6c 64 20 61 70 70 65 61 72 20 6f 6e |should appear on| 00003f50 20 74 68 65 20 6c 69 73 74 2e 0a 0a 4d 61 6b 69 | the list...Maki| 00003f60 6e 67 20 74 68 65 20 66 69 65 6c 64 20 73 65 6c |ng the field sel| 00003f70 65 63 74 69 6f 6e 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d |ection.---------| 00003f80 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00003f90 2d 0a 53 70 65 63 69 66 79 69 6e 67 20 74 68 65 |-.Specifying the| 00003fa0 20 66 69 65 6c 64 73 20 79 6f 75 20 77 61 6e 74 | fields you want| 00003fb0 20 69 73 20 65 78 74 72 65 6d 65 6c 79 20 65 61 | is extremely ea| 00003fc0 73 79 2e 20 54 6f 20 69 6e 63 6c 75 64 65 20 61 |sy. To include a| 00003fd0 20 66 69 65 6c 64 20 73 69 6d 70 6c 79 0a 70 6f | field simply.po| 00003fe0 69 6e 74 20 74 68 65 20 6d 6f 75 73 65 20 61 74 |int the mouse at| 00003ff0 20 69 74 20 61 6e 64 20 63 6c 69 63 6b 20 77 69 | it and click wi| 00004000 74 68 20 41 44 4a 55 53 54 2e 20 54 68 65 20 73 |th ADJUST. The s| 00004010 65 6c 65 63 74 65 64 20 66 69 65 6c 64 20 77 69 |elected field wi| 00004020 6c 6c 20 74 68 65 6e 0a 61 70 70 65 61 72 20 69 |ll then.appear i| 00004030 6e 20 69 6e 76 65 72 73 65 20 76 69 64 65 6f 20 |n inverse video | 00004040 28 69 2e 65 2e 20 6e 6f 72 6d 61 6c 6c 79 20 77 |(i.e. normally w| 00004050 68 69 74 65 20 6f 6e 20 62 6c 61 63 6b 29 2e 20 |hite on black). | 00004060 49 66 20 79 6f 75 20 63 68 61 6e 67 65 20 79 6f |If you change yo| 00004070 75 72 0a 6d 69 6e 64 20 61 62 6f 75 74 20 61 20 |ur.mind about a | 00004080 66 69 65 6c 64 20 79 6f 75 20 63 61 6e 20 64 65 |field you can de| 00004090 2d 73 65 6c 65 63 74 20 69 74 20 62 79 20 63 6c |-select it by cl| 000040a0 69 63 6b 69 6e 67 20 6f 6e 20 69 74 20 61 67 61 |icking on it aga| 000040b0 69 6e 20 77 69 74 68 20 41 44 4a 55 53 54 2e 0a |in with ADJUST..| 000040c0 54 68 65 20 6f 72 64 65 72 20 69 6e 20 77 68 69 |The order in whi| 000040d0 63 68 20 74 68 65 20 66 69 65 6c 64 73 20 77 69 |ch the fields wi| 000040e0 6c 6c 20 61 70 70 65 61 72 20 69 6e 20 74 68 65 |ll appear in the| 000040f0 20 70 72 69 6e 74 65 64 20 6c 69 73 74 20 69 73 | printed list is| 00004100 20 74 68 65 20 6f 72 64 65 72 0a 69 6e 20 77 68 | the order.in wh| 00004110 69 63 68 20 79 6f 75 20 73 65 6c 65 63 74 20 74 |ich you select t| 00004120 68 65 6d 2e 20 54 61 6b 65 20 63 61 72 65 20 77 |hem. Take care w| 00004130 69 74 68 20 74 68 69 73 20 73 69 6e 63 65 20 74 |ith this since t| 00004140 68 65 72 65 20 69 73 20 6e 6f 74 68 69 6e 67 20 |here is nothing | 00004150 6f 6e 20 74 68 65 0a 73 63 72 65 65 6e 20 74 6f |on the.screen to| 00004160 20 69 6e 64 69 63 61 74 65 20 77 68 61 74 20 6f | indicate what o| 00004170 72 64 65 72 20 74 68 65 20 66 69 65 6c 64 73 20 |rder the fields | 00004180 77 69 6c 6c 20 62 65 20 69 6e 2e 20 20 54 68 65 |will be in. The| 00004190 20 66 69 65 6c 64 73 20 63 68 6f 73 65 6e 20 66 | fields chosen f| 000041a0 6f 72 0a 69 6e 63 6c 75 73 69 6f 6e 20 69 6e 20 |or.inclusion in | 000041b0 61 20 70 72 69 6e 74 6f 75 74 20 6d 61 6b 65 20 |a printout make | 000041c0 75 70 20 61 20 53 45 4c 45 43 54 49 4f 4e 20 20 |up a SELECTION | 000041d0 77 68 69 63 68 20 6d 61 79 20 62 65 20 73 61 76 |which may be sav| 000041e0 65 64 20 61 6e 64 20 72 65 6c 6f 61 64 65 64 0a |ed and reloaded.| 000041f0 66 6f 72 20 66 75 74 75 72 65 20 75 73 65 2e 20 |for future use. | 00004200 4a 75 73 74 20 66 6f 72 20 6e 6f 77 20 73 65 6c |Just for now sel| 00004210 65 63 74 20 4e 41 4d 45 2c 20 53 59 4d 42 4f 4c |ect NAME, SYMBOL| 00004220 20 61 6e 64 20 47 52 4f 55 50 2e 0a 0a 43 68 6f | and GROUP...Cho| 00004230 6f 73 69 6e 67 20 77 68 69 63 68 20 72 65 63 6f |osing which reco| 00004240 72 64 73 20 74 6f 20 70 72 69 6e 74 0a 2d 2d 2d |rds to print.---| 00004250 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00004260 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 53 70 65 |------------.Spe| 00004270 63 69 66 79 69 6e 67 20 77 68 69 63 68 20 72 65 |cifying which re| 00004280 63 6f 72 64 73 20 74 6f 20 70 72 69 6e 74 20 69 |cords to print i| 00004290 73 20 73 6f 6d 65 77 68 61 74 20 6d 6f 72 65 20 |s somewhat more | 000042a0 63 6f 6d 70 6c 65 78 2c 20 61 6c 74 68 6f 75 67 |complex, althoug| 000042b0 68 20 65 66 66 6f 72 74 73 0a 68 61 76 65 20 62 |h efforts.have b| 000042c0 65 65 6e 20 6d 61 64 65 20 74 6f 20 72 65 6e 64 |een made to rend| 000042d0 65 72 20 69 74 20 61 73 20 73 69 6d 70 6c 65 20 |er it as simple | 000042e0 61 73 20 70 6f 73 73 69 62 6c 65 2e 20 57 69 74 |as possible. Wit| 000042f0 68 20 74 68 65 20 6d 6f 75 73 65 20 70 6f 69 6e |h the mouse poin| 00004300 74 65 72 20 69 6e 0a 74 68 65 20 72 65 63 6f 72 |ter in.the recor| 00004310 64 20 77 69 6e 64 6f 77 20 63 6c 69 63 6b 20 4d |d window click M| 00004320 45 4e 55 2e 20 54 68 69 73 20 64 69 73 70 6c 61 |ENU. This displa| 00004330 79 73 20 74 68 65 20 6d 61 69 6e 20 50 6f 77 65 |ys the main Powe| 00004340 72 62 61 73 65 20 6d 65 6e 75 20 66 72 6f 6d 0a |rbase menu from.| 00004350 77 68 69 63 68 20 79 6f 75 20 73 68 6f 75 6c 64 |which you should| 00004360 20 63 68 6f 6f 73 65 20 50 72 69 6e 74 2e 20 20 | choose Print. | 00004370 41 20 73 6d 61 6c 6c 20 77 69 6e 64 6f 77 20 61 |A small window a| 00004380 70 70 65 61 72 73 20 69 6e 20 77 68 69 63 68 20 |ppears in which | 00004390 79 6f 75 20 63 61 6e 0a 73 70 65 63 69 66 79 20 |you can.specify | 000043a0 74 68 65 20 63 72 69 74 65 72 69 61 20 77 68 69 |the criteria whi| 000043b0 63 68 20 6d 75 73 74 20 62 65 20 6d 65 74 20 62 |ch must be met b| 000043c0 79 20 72 65 63 6f 72 64 73 20 66 6f 72 20 69 6e |y records for in| 000043d0 63 6c 75 73 69 6f 6e 20 69 6e 20 74 68 65 20 6c |clusion in the l| 000043e0 69 73 74 2e 0a 49 66 20 79 6f 75 20 6a 75 73 74 |ist..If you just| 000043f0 20 63 6c 69 63 6b 20 4f 4b 20 28 6f 72 20 70 72 | click OK (or pr| 00004400 65 73 73 20 52 45 54 55 52 4e 29 20 77 69 74 68 |ess RETURN) with| 00004410 6f 75 74 20 65 6e 74 65 72 69 6e 67 20 61 6e 79 |out entering any| 00004420 74 68 69 6e 67 20 68 65 72 65 20 79 6f 75 0a 77 |thing here you.w| 00004430 69 6c 6c 20 6f 62 74 61 69 6e 20 61 20 6c 69 73 |ill obtain a lis| 00004440 74 20 6f 66 20 74 68 65 20 77 68 6f 6c 65 20 64 |t of the whole d| 00004450 61 74 61 62 61 73 65 20 28 6f 72 2c 20 6d 6f 72 |atabase (or, mor| 00004460 65 20 61 63 63 75 72 61 74 65 6c 79 2c 20 6f 66 |e accurately, of| 00004470 20 74 68 65 20 74 68 65 0a 77 68 6f 6c 65 20 6f | the the.whole o| 00004480 66 20 74 68 65 20 63 75 72 72 65 6e 74 20 73 75 |f the current su| 00004490 62 66 69 6c 65 20 29 2e 20 54 72 79 20 74 68 69 |bfile ). Try thi| 000044a0 73 20 66 69 72 73 74 2e 0a 0a 4e 6f 74 68 69 6e |s first...Nothin| 000044b0 67 20 77 69 6c 6c 20 62 65 20 70 72 69 6e 74 65 |g will be printe| 000044c0 64 20 75 6e 74 69 6c 20 74 68 65 20 73 65 61 72 |d until the sear| 000044d0 63 68 20 69 73 20 63 6f 6d 70 6c 65 74 65 2e 20 |ch is complete. | 000044e0 49 66 20 74 68 65 20 6d 6f 75 73 65 20 70 6f 69 |If the mouse poi| 000044f0 6e 74 65 72 0a 69 73 20 6f 76 65 72 20 74 68 65 |nter.is over the| 00004500 20 6d 61 69 6e 20 77 69 6e 64 6f 77 20 74 68 65 | main window the| 00004510 20 68 6f 75 72 67 6c 61 73 73 20 77 69 6c 6c 20 | hourglass will | 00004520 74 65 6c 6c 20 79 6f 75 20 68 6f 77 20 66 61 72 |tell you how far| 00004530 20 74 68 69 6e 67 73 20 68 61 76 65 0a 70 72 6f | things have.pro| 00004540 67 72 65 73 73 65 64 2e 20 50 72 65 73 73 69 6e |gressed. Pressin| 00004550 67 20 45 73 63 61 70 65 20 63 61 75 73 65 73 20 |g Escape causes | 00004560 74 68 65 20 70 72 6f 63 65 73 73 20 74 6f 20 62 |the process to b| 00004570 65 20 61 62 6f 72 74 65 64 2e 20 57 68 65 6e 20 |e aborted. When | 00004580 74 68 65 0a 70 72 6f 63 65 73 73 20 69 73 20 63 |the.process is c| 00004590 6f 6d 70 6c 65 74 65 20 74 68 65 20 6c 69 73 74 |omplete the list| 000045a0 20 77 69 6c 6c 20 62 65 20 64 69 73 70 6c 61 79 | will be display| 000045b0 65 64 20 69 6e 20 61 20 77 69 6e 64 6f 77 2e 20 |ed in a window. | 000045c0 49 74 20 6d 61 79 20 62 65 20 73 61 76 65 64 0a |It may be saved.| 000045d0 61 73 20 61 20 74 65 78 74 20 66 69 6c 65 20 61 |as a text file a| 000045e0 6e 64 20 70 72 69 6e 74 65 64 20 75 73 69 6e 67 |nd printed using| 000045f0 20 74 68 65 20 75 73 75 61 6c 20 52 49 53 43 20 | the usual RISC | 00004600 4f 53 20 64 72 69 76 65 72 73 20 2e 0a 0a 49 66 |OS drivers ...If| 00004610 20 79 6f 75 20 70 6f 69 6e 74 20 74 6f 20 61 20 | you point to a | 00004620 72 65 63 6f 72 64 20 69 6e 20 74 68 65 20 64 69 |record in the di| 00004630 73 70 6c 61 79 65 64 20 6c 69 73 74 20 61 6e 64 |splayed list and| 00004640 20 64 6f 75 62 6c 65 2d 63 6c 69 63 6b 20 77 69 | double-click wi| 00004650 74 68 20 53 45 4c 45 43 54 0a 50 6f 77 65 72 62 |th SELECT.Powerb| 00004660 61 73 65 20 77 69 6c 6c 20 64 69 73 70 6c 61 79 |ase will display| 00004670 20 74 68 65 20 63 68 6f 73 65 6e 20 72 65 63 6f | the chosen reco| 00004680 72 64 20 69 6e 20 74 68 65 20 6d 61 69 6e 20 72 |rd in the main r| 00004690 65 63 6f 72 64 20 77 69 6e 64 6f 77 2e 20 4e 6f |ecord window. No| 000046a0 74 65 0a 74 68 61 74 20 74 68 65 20 63 61 72 65 |te.that the care| 000046b0 74 20 69 73 20 70 6c 61 63 65 64 20 69 6e 20 74 |t is placed in t| 000046c0 68 65 20 66 69 65 6c 64 20 79 6f 75 20 77 65 72 |he field you wer| 000046d0 65 20 70 6f 69 6e 74 69 6e 67 20 74 6f 20 6f 6e |e pointing to on| 000046e0 20 74 68 65 20 6c 69 73 74 2e 20 54 68 69 73 0a | the list. This.| 000046f0 69 73 20 76 65 72 79 20 75 73 65 66 75 6c 20 69 |is very useful i| 00004700 66 20 79 6f 75 20 73 70 6f 74 20 65 72 72 6f 72 |f you spot error| 00004710 73 20 69 6e 20 74 68 65 20 64 61 74 61 20 77 68 |s in the data wh| 00004720 69 6c 73 74 20 65 78 61 6d 69 6e 69 6e 67 20 61 |ilst examining a| 00004730 20 6c 69 73 74 2e 20 41 0a 64 6f 75 62 6c 65 20 | list. A.double | 00004740 63 6c 69 63 6b 20 6f 6e 20 74 68 65 20 6f 66 66 |click on the off| 00004750 65 6e 64 69 6e 67 20 69 74 65 6d 20 6f 66 66 65 |ending item offe| 00004760 72 73 20 74 68 65 20 72 65 63 6f 72 64 20 77 69 |rs the record wi| 00004770 74 68 20 74 68 65 20 63 61 72 65 74 0a 63 6f 72 |th the caret.cor| 00004780 72 65 63 74 6c 79 20 70 6f 73 69 74 69 6f 6e 65 |rectly positione| 00004790 64 20 66 6f 72 20 65 64 69 74 69 6e 67 2e 0a 0a |d for editing...| 000047a0 4d 6f 73 74 20 64 61 74 61 62 61 73 65 20 71 75 |Most database qu| 000047b0 65 72 69 65 73 2c 20 68 6f 77 65 76 65 72 2c 20 |eries, however, | 000047c0 64 6f 6e 27 74 20 69 6e 76 6f 6c 76 65 20 70 72 |don't involve pr| 000047d0 69 6e 74 69 6e 67 20 61 6c 6c 20 74 68 65 20 72 |inting all the r| 000047e0 65 63 6f 72 64 73 21 20 59 6f 75 0a 77 69 6c 6c |ecords! You.will| 000047f0 20 75 73 75 61 6c 6c 79 20 6e 65 65 64 20 74 6f | usually need to| 00004800 20 65 6e 74 65 72 20 61 20 53 45 41 52 43 48 20 | enter a SEARCH | 00004810 46 4f 52 4d 55 4c 41 20 62 65 66 6f 72 65 20 63 |FORMULA before c| 00004820 6c 69 63 6b 69 6e 67 20 4f 4b 2e 20 53 65 61 72 |licking OK. Sear| 00004830 63 68 0a 66 6f 72 6d 75 6c 61 65 20 63 61 6e 20 |ch.formulae can | 00004840 62 65 20 71 75 69 74 65 20 63 6f 6d 70 6c 65 78 |be quite complex| 00004850 20 61 6e 64 20 61 20 6d 6f 72 65 20 64 65 74 61 | and a more deta| 00004860 69 6c 65 64 20 74 72 65 61 74 6d 65 6e 74 20 69 |iled treatment i| 00004870 73 20 67 69 76 65 6e 20 69 6e 20 61 0a 6c 61 74 |s given in a.lat| 00004880 65 72 20 73 65 63 74 69 6f 6e 2e 20 4f 6e 6c 79 |er section. Only| 00004890 20 61 20 63 6f 75 70 6c 65 20 6f 66 20 73 69 6d | a couple of sim| 000048a0 70 6c 65 20 65 78 61 6d 70 6c 65 73 20 77 69 6c |ple examples wil| 000048b0 6c 20 62 65 20 73 68 6f 77 6e 20 68 65 72 65 2e |l be shown here.| 000048c0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 000048d0 20 20 0a 53 75 70 70 6f 73 65 20 77 65 20 77 61 | .Suppose we wa| 000048e0 6e 74 20 61 20 6c 69 73 74 20 6f 66 20 61 6c 6c |nt a list of all| 000048f0 20 74 68 65 20 74 72 61 6e 73 69 74 69 6f 6e 61 | the transitiona| 00004900 6c 20 65 6c 65 6d 65 6e 74 73 2e 20 69 2e 65 2e |l elements. i.e.| 00004910 20 61 6c 6c 20 74 68 6f 73 65 0a 77 68 69 63 68 | all those.which| 00004920 20 68 61 76 65 20 54 20 69 6e 20 74 68 65 20 47 | have T in the G| 00004930 52 4f 55 50 20 66 69 65 6c 64 2e 20 57 65 20 63 |ROUP field. We c| 00004940 61 6e 20 64 6f 20 74 68 69 73 20 62 79 20 65 6e |an do this by en| 00004950 74 65 72 69 6e 67 20 74 68 65 20 73 65 61 72 63 |tering the searc| 00004960 68 0a 66 6f 72 6d 75 6c 61 20 47 50 3d 54 2e 20 |h.formula GP=T. | 00004970 20 57 68 79 20 47 50 3f 20 20 53 68 6f 75 6c 64 | Why GP? Should| 00004980 6e 27 74 20 69 74 20 62 65 20 47 52 4f 55 50 3d |n't it be GROUP=| 00004990 54 3f 20 20 54 68 65 20 6c 61 74 74 65 72 20 73 |T? The latter s| 000049a0 65 65 6d 73 20 6d 6f 72 65 0a 6f 62 76 69 6f 75 |eems more.obviou| 000049b0 73 2c 20 62 75 74 20 77 68 61 74 20 68 61 70 70 |s, but what happ| 000049c0 65 6e 73 20 69 66 20 74 68 65 20 66 69 65 6c 64 |ens if the field| 000049d0 20 68 61 73 20 6e 6f 20 64 65 73 63 72 69 70 74 | has no descript| 000049e0 6f 72 3f 20 54 68 65 20 72 65 63 6f 72 64 20 73 |or? The record s| 000049f0 63 72 65 65 6e 0a 6f 66 20 21 45 6c 65 6d 65 6e |creen.of !Elemen| 00004a00 74 73 20 63 6f 6e 74 61 69 6e 73 20 6d 61 6e 79 |ts contains many| 00004a10 20 73 75 63 68 20 66 69 65 6c 64 73 20 73 75 63 | such fields suc| 00004a20 68 20 61 73 20 74 68 65 20 6f 6e 65 20 6f 6e 20 |h as the one on | 00004a30 74 68 65 20 66 69 72 73 74 20 6c 69 6e 65 20 0a |the first line .| 00004a40 77 68 69 63 68 20 67 69 76 65 73 20 74 68 65 20 |which gives the | 00004a50 6f 72 69 67 69 6e 20 6f 66 20 74 68 65 20 65 6c |origin of the el| 00004a60 65 6d 65 6e 74 27 73 20 6e 61 6d 65 2e 20 20 45 |ement's name. E| 00004a70 76 65 72 79 20 66 69 65 6c 64 20 77 68 69 63 68 |very field which| 00004a80 20 63 61 6e 20 68 6f 6c 64 0a 64 61 74 61 20 68 | can hold.data h| 00004a90 61 73 20 74 6f 20 68 61 76 65 20 61 20 22 68 61 |as to have a "ha| 00004aa0 6e 64 6c 65 22 20 62 79 20 77 68 69 63 68 20 77 |ndle" by which w| 00004ab0 65 20 63 61 6e 20 72 65 66 65 72 20 74 6f 20 69 |e can refer to i| 00004ac0 74 20 61 6e 64 20 74 68 61 74 20 68 61 6e 64 6c |t and that handl| 00004ad0 65 20 69 73 0a 63 61 6c 6c 65 64 20 74 68 65 20 |e is.called the | 00004ae0 66 69 65 6c 64 20 54 41 47 2e 20 54 61 67 73 20 |field TAG. Tags | 00004af0 61 72 65 20 76 65 72 79 20 73 68 6f 72 74 3b 20 |are very short; | 00004b00 6e 65 76 65 72 20 6d 6f 72 65 20 74 68 61 6e 20 |never more than | 00004b10 66 6f 75 72 20 63 68 61 72 61 63 74 65 72 73 2e |four characters.| 00004b20 0a 59 6f 75 20 68 61 76 65 20 73 65 65 6e 20 73 |.You have seen s| 00004b30 6f 6d 65 20 74 61 67 73 20 61 6c 72 65 61 64 79 |ome tags already| 00004b40 2e 20 4c 6f 6f 6b 20 61 74 20 74 68 65 20 6c 69 |. Look at the li| 00004b50 73 74 20 79 6f 75 20 70 72 69 6e 74 65 64 20 65 |st you printed e| 00004b60 61 72 6c 69 65 72 2e 20 20 54 68 65 0a 74 68 72 |arlier. The.thr| 00004b70 65 65 20 63 6f 6c 75 6d 6e 73 20 61 72 65 20 68 |ee columns are h| 00004b80 65 61 64 65 64 20 4e 41 4d 45 2c 20 53 59 4d 20 |eaded NAME, SYM | 00004b90 61 6e 64 20 47 50 20 6e 6f 74 20 4e 41 4d 45 2c |and GP not NAME,| 00004ba0 20 53 59 4d 42 4f 4c 20 61 6e 64 20 47 52 4f 55 | SYMBOL and GROU| 00004bb0 50 2e 20 54 68 65 0a 75 73 65 72 20 74 68 65 72 |P. The.user ther| 00004bc0 65 66 6f 72 65 20 6d 65 65 74 73 20 74 61 67 73 |efore meets tags| 00004bd0 20 69 6e 20 74 77 6f 20 63 6f 6e 74 65 78 74 73 | in two contexts| 00004be0 3a 0a 0a 20 20 20 20 20 20 20 20 20 20 20 2a 20 |:.. * | 00004bf0 20 54 68 65 79 20 61 72 65 20 75 73 65 64 20 74 | They are used t| 00004c00 6f 20 73 70 65 63 69 66 79 20 66 69 65 6c 64 73 |o specify fields| 00004c10 20 69 6e 20 73 65 61 72 63 68 20 66 6f 72 6d 75 | in search formu| 00004c20 6c 61 65 0a 20 20 20 20 20 20 20 20 20 20 20 2a |lae. *| 00004c30 20 20 54 68 65 79 20 61 72 65 20 74 68 65 20 64 | They are the d| 00004c40 65 66 61 75 6c 74 20 63 6f 6c 75 6d 6e 20 68 65 |efault column he| 00004c50 61 64 69 6e 67 73 20 69 6e 20 6c 69 73 74 73 2e |adings in lists.| 00004c60 0a 0a 54 68 65 20 50 72 69 6e 74 20 6f 70 74 69 |..The Print opti| 00004c70 6f 6e 73 20 77 69 6e 64 6f 77 20 20 61 6c 6c 6f |ons window allo| 00004c80 77 73 20 79 6f 75 20 74 6f 20 63 68 61 6e 67 65 |ws you to change| 00004c90 20 74 68 65 20 63 6f 6c 75 6d 6e 20 68 65 61 64 | the column head| 00004ca0 69 6e 67 73 20 74 6f 20 74 68 65 0a 66 69 65 6c |ings to the.fiel| 00004cb0 64 20 64 65 73 63 72 69 70 74 6f 72 73 20 69 66 |d descriptors if| 00004cc0 20 79 6f 75 20 73 6f 20 77 69 73 68 2e 0a 0a 54 | you so wish...T| 00004cd0 79 70 65 20 47 50 3d 54 20 69 6e 20 74 68 65 20 |ype GP=T in the | 00004ce0 73 70 61 63 65 20 70 72 6f 76 69 64 65 64 20 61 |space provided a| 00004cf0 6e 64 20 63 6c 69 63 6b 20 4f 4b 2e 20 54 68 69 |nd click OK. Thi| 00004d00 73 20 74 69 6d 65 20 74 68 65 20 6c 69 73 74 20 |s time the list | 00004d10 77 69 6c 6c 20 62 65 20 61 0a 6d 75 63 68 20 73 |will be a.much s| 00004d20 68 6f 72 74 65 72 20 6f 6e 65 20 61 6e 64 20 79 |horter one and y| 00004d30 6f 75 20 77 69 6c 6c 20 73 65 65 20 74 68 61 74 |ou will see that| 00004d40 20 74 68 65 20 47 50 20 63 6f 6c 75 6d 6e 20 63 | the GP column c| 00004d50 6f 6e 74 61 69 6e 73 20 54 20 69 6e 20 65 76 65 |ontains T in eve| 00004d60 72 79 0a 63 61 73 65 2e 20 0a 0a 4f 75 72 20 73 |ry.case. ..Our s| 00004d70 65 63 6f 6e 64 20 65 78 61 6d 70 6c 65 20 69 6e |econd example in| 00004d80 76 6f 6c 76 65 73 20 70 72 69 6e 74 69 6e 67 20 |volves printing | 00004d90 61 6c 6c 20 65 6c 65 6d 65 6e 74 73 20 77 68 6f |all elements who| 00004da0 73 65 20 6e 61 6d 65 73 20 65 6e 64 20 69 6e 20 |se names end in | 00004db0 22 49 55 4d 22 2e 0a 57 68 61 74 20 77 65 20 6e |"IUM"..What we n| 00004dc0 65 65 64 20 74 6f 20 73 70 65 63 69 66 79 20 69 |eed to specify i| 00004dd0 73 20 74 68 61 74 20 22 4e 41 4d 45 20 63 6f 6e |s that "NAME con| 00004de0 74 61 69 6e 73 20 49 55 4d 22 20 61 6e 64 20 77 |tains IUM" and w| 00004df0 65 20 64 6f 20 74 68 69 73 20 62 79 0a 65 6e 74 |e do this by.ent| 00004e00 65 72 69 6e 67 20 74 68 65 20 73 65 61 72 63 68 |ering the search| 00004e10 20 66 6f 72 6d 75 6c 61 20 4e 41 4d 45 7b 49 55 | formula NAME{IU| 00004e20 4d 2e 20 46 69 6e 61 6c 6c 79 20 77 65 20 77 69 |M. Finally we wi| 00004e30 6c 6c 20 63 6f 6d 62 69 6e 65 20 74 68 65 20 70 |ll combine the p| 00004e40 72 65 76 69 6f 75 73 0a 74 77 6f 20 65 78 61 6d |revious.two exam| 00004e50 70 6c 65 73 20 69 6e 74 6f 20 20 61 20 74 77 6f |ples into a two| 00004e60 2d 70 72 6f 6e 67 65 64 20 73 65 61 72 63 68 20 |-pronged search | 00004e70 66 6f 72 20 61 6c 6c 20 74 68 65 20 54 52 41 4e |for all the TRAN| 00004e80 53 49 54 49 4f 4e 41 4c 20 65 6c 65 6d 65 6e 74 |SITIONAL element| 00004e90 73 0a 77 68 6f 73 65 20 6e 61 6d 65 73 20 65 6e |s.whose names en| 00004ea0 64 20 69 6e 20 22 49 55 4d 22 2e 20 54 68 65 20 |d in "IUM". The | 00004eb0 73 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 20 74 |search formula t| 00004ec0 68 69 73 20 74 69 6d 65 20 69 73 20 4e 41 4d 45 |his time is NAME| 00004ed0 7b 49 55 4d 20 41 4e 44 20 47 50 3d 54 2e 0a 4e |{IUM AND GP=T..N| 00004ee0 6f 74 65 20 74 68 65 20 73 70 61 63 65 73 20 62 |ote the spaces b| 00004ef0 65 66 6f 72 65 20 61 6e 64 20 61 66 74 65 72 20 |efore and after | 00004f00 41 4e 44 2e 20 20 54 68 65 73 65 20 61 72 65 20 |AND. These are | 00004f10 65 73 73 65 6e 74 69 61 6c 2e 20 20 59 6f 75 20 |essential. You | 00004f20 6d 69 67 68 74 20 6c 69 6b 65 0a 74 6f 20 74 72 |might like.to tr| 00004f30 79 20 61 6e 20 61 6c 74 65 72 6e 61 74 69 76 65 |y an alternative| 00004f40 20 77 61 79 20 6f 66 20 65 6e 74 65 72 69 6e 67 | way of entering| 00004f50 20 74 68 69 73 20 73 65 61 72 63 68 20 66 6f 72 | this search for| 00004f60 6d 75 6c 61 2e 20 50 72 6f 63 65 65 64 20 61 73 |mula. Proceed as| 00004f70 0a 66 6f 6c 6c 6f 77 73 3a 0a 0a 20 20 20 20 20 |.follows:.. | 00004f80 20 20 20 2a 20 43 6c 69 63 6b 20 74 68 65 20 22 | * Click the "| 00004f90 74 6f 67 67 6c 65 20 73 69 7a 65 22 20 69 63 6f |toggle size" ico| 00004fa0 6e 20 6f 66 20 74 68 65 20 6d 61 74 63 68 69 6e |n of the matchin| 00004fb0 67 20 72 65 63 6f 72 64 73 20 77 69 6e 64 6f 77 |g records window| 00004fc0 2e 20 54 68 69 73 0a 20 20 20 20 20 20 20 20 20 |. This. | 00004fd0 20 6d 61 6b 65 73 20 69 74 20 65 78 70 61 6e 64 | makes it expand| 00004fe0 20 74 6f 20 73 68 6f 77 20 6d 6f 72 65 20 63 6f | to show more co| 00004ff0 6e 74 72 6f 6c 73 2e 0a 20 20 20 20 20 20 20 20 |ntrols.. | 00005000 2a 20 4e 41 4d 45 20 73 68 6f 75 6c 64 20 61 6c |* NAME should al| 00005010 72 65 61 64 79 20 62 65 20 76 69 73 69 62 6c 65 |ready be visible| 00005020 20 61 73 20 74 68 65 20 72 65 71 75 69 72 65 64 | as the required| 00005030 20 66 69 65 6c 64 2c 20 62 75 74 20 79 6f 75 20 | field, but you | 00005040 6e 65 65 64 0a 20 20 20 20 20 20 20 20 20 20 74 |need. t| 00005050 6f 20 73 65 6c 65 63 74 20 74 68 65 20 72 61 64 |o select the rad| 00005060 69 6f 20 62 75 74 74 6f 6e 20 66 6f 72 20 43 6f |io button for Co| 00005070 6e 74 61 69 6e 73 2e 0a 20 20 20 20 20 20 20 20 |ntains.. | 00005080 2a 20 43 6c 69 63 6b 20 69 6e 20 74 68 65 20 73 |* Click in the s| 00005090 70 61 63 65 20 6e 65 78 74 20 74 6f 20 56 61 6c |pace next to Val| 000050a0 75 65 3a 20 61 6e 64 20 65 6e 74 65 72 20 49 55 |ue: and enter IU| 000050b0 4d 2e 0a 20 20 20 20 20 20 20 20 2a 20 43 6c 69 |M.. * Cli| 000050c0 63 6b 20 74 68 65 20 41 4e 44 20 62 75 74 74 6f |ck the AND butto| 000050d0 6e 20 74 6f 20 73 65 6c 65 63 74 20 69 74 2e 0a |n to select it..| 000050e0 20 20 20 20 20 20 20 20 2a 20 43 6c 69 63 6b 20 | * Click | 000050f0 41 64 64 20 74 6f 20 66 6f 72 6d 75 6c 61 2e 0a |Add to formula..| 00005100 0a 20 20 20 20 20 20 20 20 20 20 54 68 65 20 73 |. The s| 00005110 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 20 73 68 |earch formula sh| 00005120 6f 75 6c 64 20 6e 6f 77 20 72 65 61 64 20 4e 41 |ould now read NA| 00005130 4d 45 7b 49 55 4d 20 41 4e 44 2e 0a 0a 20 20 20 |ME{IUM AND... | 00005140 20 20 20 20 20 2a 20 43 6c 69 63 6b 20 6f 6e 20 | * Click on | 00005150 74 68 65 20 66 69 65 6c 64 20 74 61 67 20 28 63 |the field tag (c| 00005160 75 72 72 65 6e 74 6c 79 20 4e 41 4d 45 29 20 75 |urrently NAME) u| 00005170 6e 74 69 6c 20 69 74 20 72 65 61 64 73 20 47 50 |ntil it reads GP| 00005180 0a 20 20 20 20 20 20 20 20 2a 20 53 65 6c 65 63 |. * Selec| 00005190 74 20 49 73 20 65 71 75 61 6c 20 74 6f 2e 0a 20 |t Is equal to.. | 000051a0 20 20 20 20 20 20 20 2a 20 45 6e 74 65 72 20 54 | * Enter T| 000051b0 20 69 6e 20 74 68 65 20 56 61 6c 75 65 20 66 69 | in the Value fi| 000051c0 65 6c 64 2e 0a 20 20 20 20 20 20 20 20 2a 20 43 |eld.. * C| 000051d0 6c 69 63 6b 20 41 64 64 20 74 6f 20 66 6f 72 6d |lick Add to form| 000051e0 75 6c 61 2e 0a 0a 54 68 65 20 63 6f 6d 70 6c 65 |ula...The comple| 000051f0 74 65 20 73 65 61 72 63 68 20 66 6f 72 6d 75 6c |te search formul| 00005200 61 20 73 68 6f 75 6c 64 20 6e 6f 77 20 62 65 20 |a should now be | 00005210 76 69 73 69 62 6c 65 20 73 6f 20 63 6c 69 63 6b |visible so click| 00005220 20 4f 4b 20 61 6e 64 20 74 68 65 20 6c 69 73 74 | OK and the list| 00005230 0a 77 69 6c 6c 20 62 65 20 70 72 6f 64 75 63 65 |.will be produce| 00005240 64 2e 20 54 68 65 20 61 62 6f 76 65 20 74 61 6b |d. The above tak| 00005250 65 73 20 66 61 72 20 6c 6f 6e 67 65 72 20 74 6f |es far longer to| 00005260 20 64 65 73 63 72 69 62 65 20 74 68 61 6e 20 69 | describe than i| 00005270 74 20 64 6f 65 73 20 74 6f 20 64 6f 0a 61 6e 64 |t does to do.and| 00005280 20 63 61 6e 20 62 65 20 61 20 67 72 65 61 74 20 | can be a great | 00005290 68 65 6c 70 20 74 6f 20 74 68 65 20 69 6e 66 72 |help to the infr| 000052a0 65 71 75 65 6e 74 20 50 6f 77 65 72 62 61 73 65 |equent Powerbase| 000052b0 20 75 73 65 72 20 77 68 6f 20 68 61 73 20 74 72 | user who has tr| 000052c0 6f 75 62 6c 65 0a 72 65 6d 65 6d 62 65 72 69 6e |ouble.rememberin| 000052d0 67 20 74 68 65 20 73 79 6e 74 61 78 20 6f 66 20 |g the syntax of | 000052e0 73 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 65 2e |search formulae.| 000052f0 20 49 66 20 79 6f 75 20 75 73 65 20 63 65 72 74 | If you use cert| 00005300 61 69 6e 20 63 6f 6d 70 6c 65 78 0a 71 75 65 72 |ain complex.quer| 00005310 69 65 73 20 6f 66 74 65 6e 20 79 6f 75 20 6d 61 |ies often you ma| 00005320 79 20 66 69 6e 64 20 69 74 20 63 6f 6e 76 65 6e |y find it conven| 00005330 69 65 6e 74 20 74 6f 20 73 61 76 65 20 74 68 65 |ient to save the| 00005340 6d 20 66 6f 72 20 66 75 74 75 72 65 20 75 73 65 |m for future use| 00005350 20 2e 0a 0a 54 68 65 20 62 69 67 67 65 73 74 20 | ...The biggest | 00005360 70 72 6f 62 6c 65 6d 20 79 6f 75 20 61 72 65 20 |problem you are | 00005370 6c 69 6b 65 6c 79 20 74 6f 20 65 6e 63 6f 75 6e |likely to encoun| 00005380 74 65 72 20 69 73 20 6e 6f 74 20 6b 6e 6f 77 69 |ter is not knowi| 00005390 6e 67 20 74 68 65 20 74 61 67 73 20 66 6f 72 0a |ng the tags for.| 000053a0 74 68 65 20 76 61 72 69 6f 75 73 20 66 69 65 6c |the various fiel| 000053b0 64 73 2e 20 54 68 65 20 6d 65 74 68 6f 64 20 6a |ds. The method j| 000053c0 75 73 74 20 64 65 73 63 72 69 62 65 64 20 67 65 |ust described ge| 000053d0 74 73 20 72 6f 75 6e 64 20 74 68 65 20 70 72 6f |ts round the pro| 000053e0 62 6c 65 6d 20 62 79 0a 6c 65 74 74 69 6e 67 20 |blem by.letting | 000053f0 79 6f 75 20 63 79 63 6c 65 20 74 68 72 6f 75 67 |you cycle throug| 00005400 68 20 74 68 65 20 74 61 67 73 20 62 79 20 63 6c |h the tags by cl| 00005410 69 63 6b 69 6e 67 20 6f 6e 20 61 6e 20 69 63 6f |icking on an ico| 00005420 6e 20 72 61 74 68 65 72 20 74 68 61 6e 20 74 79 |n rather than ty| 00005430 70 69 6e 67 0a 74 68 65 6d 20 64 69 72 65 63 74 |ping.them direct| 00005440 6c 79 2e 20 59 6f 75 20 77 69 6c 6c 20 61 6c 73 |ly. You will als| 00005450 6f 20 66 69 6e 64 20 74 68 61 74 20 63 6c 69 63 |o find that clic| 00005460 6b 69 6e 67 20 77 69 74 68 20 53 45 4c 45 43 54 |king with SELECT| 00005470 20 6f 6e 20 61 20 66 69 65 6c 64 20 77 68 69 6c | on a field whil| 00005480 65 0a 68 6f 6c 64 69 6e 67 20 64 6f 77 6e 20 41 |e.holding down A| 00005490 4c 54 20 63 61 75 73 65 73 20 74 68 65 20 74 61 |LT causes the ta| 000054a0 67 20 6f 66 20 74 68 61 74 20 66 69 65 6c 64 20 |g of that field | 000054b0 74 6f 20 61 70 70 65 61 72 20 69 6e 20 74 68 65 |to appear in the| 000054c0 20 73 65 61 72 63 68 0a 66 6f 72 6d 75 6c 61 20 | search.formula | 000054d0 69 63 6f 6e 2e 0a 0a 43 6c 6f 73 69 6e 67 20 64 |icon...Closing d| 000054e0 6f 77 6e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |own.============| 000054f0 0a 41 20 64 61 74 61 62 61 73 65 20 6d 61 79 20 |.A database may | 00005500 62 65 20 63 6c 6f 73 65 64 20 64 6f 77 6e 20 62 |be closed down b| 00005510 79 20 63 68 6f 6f 73 69 6e 67 20 74 68 65 20 43 |y choosing the C| 00005520 6c 6f 73 65 20 64 61 74 61 62 61 73 65 20 65 6e |lose database en| 00005530 74 72 79 20 66 72 6f 6d 20 74 68 65 0a 69 63 6f |try from the.ico| 00005540 6e 20 62 61 72 20 6d 65 6e 75 2e 20 57 68 65 6e |n bar menu. When| 00005550 20 79 6f 75 20 64 6f 20 73 6f 2c 20 61 6c 6c 20 | you do so, all | 00005560 74 68 65 20 69 6e 64 69 63 65 73 20 20 73 74 6f |the indices sto| 00005570 72 65 64 20 69 6e 20 6d 65 6d 6f 72 79 20 61 72 |red in memory ar| 00005580 65 20 73 61 76 65 64 0a 74 6f 20 64 69 73 63 20 |e saved.to disc | 00005590 28 74 68 65 20 53 61 76 65 20 69 6e 64 69 63 65 |(the Save indice| 000055a0 73 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 20 |s button on the | 000055b0 6b 65 79 70 61 64 20 67 69 76 65 73 20 61 20 63 |keypad gives a c| 000055c0 6c 65 61 72 20 69 6e 64 69 63 61 74 69 6f 6e 20 |lear indication | 000055d0 6f 66 0a 74 68 69 73 29 20 61 6e 64 20 74 68 65 |of.this) and the| 000055e0 20 64 61 74 61 62 61 73 65 20 69 73 20 63 6c 6f | database is clo| 000055f0 73 65 64 2e 20 59 6f 75 20 64 6f 20 6e 6f 74 20 |sed. You do not | 00005600 68 61 76 65 20 74 6f 20 64 6f 20 61 6e 79 74 68 |have to do anyth| 00005610 69 6e 67 20 74 6f 20 73 61 76 65 20 74 68 65 0a |ing to save the.| 00005620 64 61 74 61 62 61 73 65 20 69 74 73 65 6c 66 20 |database itself | 00005630 74 6f 20 64 69 73 63 20 73 69 6e 63 65 20 69 74 |to disc since it| 00005640 20 68 61 73 20 62 65 65 6e 20 74 68 65 72 65 20 | has been there | 00005650 61 6c 6c 20 61 6c 6f 6e 67 2e 20 4f 6e 6c 79 20 |all along. Only | 00005660 74 68 65 20 63 75 72 72 65 6e 74 0a 72 65 63 6f |the current.reco| 00005670 72 64 20 69 73 20 69 6e 20 6d 65 6d 6f 72 79 20 |rd is in memory | 00005680 61 74 20 61 6e 79 20 6f 6e 65 20 74 69 6d 65 20 |at any one time | 00005690 61 6e 64 20 74 68 69 73 20 69 73 20 61 75 74 6f |and this is auto| 000056a0 6d 61 74 69 63 61 6c 6c 79 20 77 72 69 74 74 65 |matically writte| 000056b0 6e 20 62 61 63 6b 0a 74 6f 20 64 69 73 63 20 77 |n back.to disc w| 000056c0 68 65 6e 20 69 74 20 68 61 73 20 62 65 65 6e 20 |hen it has been | 000056d0 63 68 61 6e 67 65 64 20 69 6e 20 61 6e 79 20 77 |changed in any w| 000056e0 61 79 2e 0a 0a 41 6c 73 6f 20 73 61 76 65 64 20 |ay...Also saved | 000056f0 61 75 74 6f 6d 61 74 69 63 61 6c 6c 79 20 69 73 |automatically is| 00005700 20 74 68 65 20 6c 69 6e 6b 20 66 69 6c 65 20 77 | the link file w| 00005710 68 69 63 68 20 68 6f 6c 64 73 20 74 68 65 20 72 |hich holds the r| 00005720 65 6c 61 74 69 6f 6e 61 6c 20 6c 69 6e 6b 73 0a |elational links.| 00005730 62 65 74 77 65 65 6e 20 74 68 65 20 6d 61 69 6e |between the main| 00005740 20 64 61 74 61 62 61 73 65 20 61 6e 64 20 74 68 | database and th| 00005750 65 20 76 61 6c 69 64 61 74 69 6f 6e 20 74 61 62 |e validation tab| 00005760 6c 65 73 2e 20 54 68 65 20 74 61 62 6c 65 73 20 |les. The tables | 00005770 74 68 65 6d 73 65 6c 76 65 73 0a 61 72 65 20 4e |themselves.are N| 00005780 4f 54 20 73 61 76 65 64 20 61 75 74 6f 6d 61 74 |OT saved automat| 00005790 69 63 61 6c 6c 79 2e 20 49 66 20 79 6f 75 20 68 |ically. If you h| 000057a0 61 76 65 20 65 64 69 74 65 64 20 61 20 74 61 62 |ave edited a tab| 000057b0 6c 65 2c 20 6f 72 20 63 72 65 61 74 65 64 20 61 |le, or created a| 000057c0 20 6e 65 77 0a 6f 6e 65 2c 20 79 6f 75 20 77 69 | new.one, you wi| 000057d0 6c 6c 20 6e 65 65 64 20 74 6f 20 63 6c 69 63 6b |ll need to click| 000057e0 20 4d 45 4e 55 20 6f 76 65 72 20 74 68 65 20 64 | MENU over the d| 000057f0 69 73 70 6c 61 79 65 64 20 74 61 62 6c 65 20 61 |isplayed table a| 00005800 6e 64 20 63 68 6f 6f 73 65 20 74 68 65 0a 53 61 |nd choose the.Sa| 00005810 76 65 20 6f 70 74 69 6f 6e 20 66 72 6f 6d 20 69 |ve option from i| 00005820 74 2e 0a 0a 49 66 20 79 6f 75 20 61 72 65 20 67 |t...If you are g| 00005830 6f 69 6e 67 20 74 6f 20 75 73 65 20 61 6e 6f 74 |oing to use anot| 00005840 68 65 72 20 64 61 74 61 62 61 73 65 20 73 74 72 |her database str| 00005850 61 69 67 68 74 20 61 77 61 79 20 6a 75 73 74 20 |aight away just | 00005860 64 6f 75 62 6c 65 20 63 6c 69 63 6b 20 6f 6e 0a |double click on.| 00005870 69 74 20 6f 72 20 64 72 61 67 20 69 74 20 74 6f |it or drag it to| 00005880 20 74 68 65 20 50 6f 77 65 72 62 61 73 65 20 69 | the Powerbase i| 00005890 63 6f 6e 20 6f 6e 20 74 68 65 20 69 63 6f 6e 20 |con on the icon | 000058a0 62 61 72 2e 20 49 6e 20 66 61 63 74 20 79 6f 75 |bar. In fact you| 000058b0 20 64 6f 6e 27 74 20 65 76 65 6e 0a 6e 65 65 64 | don't even.need| 000058c0 20 74 6f 20 63 6c 6f 73 65 20 74 68 65 20 70 72 | to close the pr| 000058d0 65 76 69 6f 75 73 20 64 61 74 61 62 61 73 65 20 |evious database | 000058e0 62 65 66 6f 72 65 20 64 6f 69 6e 67 20 74 68 69 |before doing thi| 000058f0 73 3b 20 50 6f 77 65 72 62 61 73 65 20 77 69 6c |s; Powerbase wil| 00005900 6c 20 64 6f 20 69 74 0a 66 6f 72 20 79 6f 75 2e |l do it.for you.| 00005910 0a 0a 57 68 65 6e 20 77 6f 72 6b 69 6e 67 20 77 |..When working w| 00005920 69 74 68 20 61 20 64 61 74 61 62 61 73 65 20 6f |ith a database o| 00005930 6e 20 74 68 65 20 52 41 4d 20 64 69 73 63 20 50 |n the RAM disc P| 00005940 6f 77 65 72 62 61 73 65 20 77 69 6c 6c 20 69 73 |owerbase will is| 00005950 73 75 65 20 61 20 77 61 72 6e 69 6e 67 0a 74 68 |sue a warning.th| 00005960 61 74 20 74 68 65 20 64 61 74 61 20 69 73 20 6e |at the data is n| 00005970 6f 74 20 73 65 63 75 72 65 20 61 6e 64 20 74 68 |ot secure and th| 00005980 61 74 20 79 6f 75 20 6e 65 65 64 20 74 6f 20 64 |at you need to d| 00005990 72 61 67 20 69 74 20 66 72 6f 6d 20 74 68 65 20 |rag it from the | 000059a0 52 41 4d 20 64 69 73 63 0a 74 6f 20 61 20 66 6c |RAM disc.to a fl| 000059b0 6f 70 70 79 20 6f 72 20 68 61 72 64 20 64 69 73 |oppy or hard dis| 000059c0 63 20 62 65 66 6f 72 65 20 73 77 69 74 63 68 69 |c before switchi| 000059d0 6e 67 20 6f 66 66 2e 0a 0a 54 6f 20 74 65 72 6d |ng off...To term| 000059e0 69 6e 61 74 65 20 50 6f 77 65 72 62 61 73 65 20 |inate Powerbase | 000059f0 69 74 73 65 6c 66 20 75 73 65 20 74 68 65 20 51 |itself use the Q| 00005a00 75 69 74 20 6f 70 74 69 6f 6e 20 6f 6e 20 74 68 |uit option on th| 00005a10 65 20 69 63 6f 6e 20 62 61 72 20 6d 65 6e 75 2e |e icon bar menu.| 00005a20 0a 0a 4d 65 72 67 69 6e 67 20 64 61 74 61 20 69 |..Merging data i| 00005a30 6e 74 6f 20 61 6e 20 49 6d 70 72 65 73 73 69 6f |nto an Impressio| 00005a40 6e 20 64 6f 63 75 6d 65 6e 74 0a 3d 3d 3d 3d 3d |n document.=====| 00005a50 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| * 00005a70 3d 3d 3d 0a 54 68 65 20 64 69 73 74 72 69 62 75 |===.The distribu| 00005a80 74 69 6f 6e 20 64 69 73 63 20 63 6f 6e 74 61 69 |tion disc contai| 00005a90 6e 73 20 61 20 73 69 6d 70 6c 65 20 49 6d 70 72 |ns a simple Impr| 00005aa0 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e 74 20 |ession document | 00005ab0 63 61 6c 6c 65 64 0a 27 4d 65 72 67 65 54 65 73 |called.'MergeTes| 00005ac0 74 27 2e 20 49 74 20 77 69 6c 6c 20 62 65 20 75 |t'. It will be u| 00005ad0 73 65 64 20 69 6e 20 63 6f 6e 6a 75 6e 63 74 69 |sed in conjuncti| 00005ae0 6f 6e 20 77 69 74 68 20 74 68 65 20 27 45 6c 65 |on with the 'Ele| 00005af0 6d 65 6e 74 73 27 20 64 61 74 61 62 61 73 65 20 |ments' database | 00005b00 74 6f 0a 69 6c 6c 75 73 74 72 61 74 65 20 64 69 |to.illustrate di| 00005b10 72 65 63 74 20 64 61 74 61 2d 6d 65 72 67 69 6e |rect data-mergin| 00005b20 67 20 77 69 74 68 20 49 6d 70 72 65 73 73 69 6f |g with Impressio| 00005b30 6e 2e 20 0a 0a 28 31 29 20 4d 61 6b 65 20 73 75 |n. ..(1) Make su| 00005b40 72 65 20 74 68 61 74 20 49 6d 70 72 65 73 73 69 |re that Impressi| 00005b50 6f 6e 20 68 61 73 20 62 65 65 6e 20 22 73 65 65 |on has been "see| 00005b60 6e 22 20 62 79 20 74 68 65 20 66 69 6c 65 72 2e |n" by the filer.| 00005b70 20 28 59 6f 75 20 6e 65 65 64 20 6e 6f 74 0a 20 | (You need not. | 00005b80 20 20 20 61 63 74 75 61 6c 6c 79 20 6c 6f 61 64 | actually load| 00005b90 20 69 74 2e 29 0a 0a 28 32 29 20 4f 70 65 6e 20 | it.)..(2) Open | 00005ba0 74 68 65 20 27 45 6c 65 6d 65 6e 74 73 27 20 64 |the 'Elements' d| 00005bb0 61 74 61 62 61 73 65 20 61 6e 64 20 64 72 6f 70 |atabase and drop| 00005bc0 20 27 4d 65 72 67 65 54 65 73 74 27 20 6f 6e 74 | 'MergeTest' ont| 00005bd0 6f 20 74 68 65 20 72 65 63 6f 72 64 0a 20 20 20 |o the record. | 00005be0 20 77 69 6e 64 6f 77 2e 0a 0a 28 33 29 20 43 6c | window...(3) Cl| 00005bf0 69 63 6b 20 6f 6e 20 27 4d 65 72 67 65 27 20 69 |ick on 'Merge' i| 00005c00 6e 20 74 68 65 20 27 4d 65 72 67 65 20 64 61 74 |n the 'Merge dat| 00005c10 61 27 20 64 69 61 6c 6f 67 75 65 20 62 6f 78 2e |a' dialogue box.| 00005c20 20 59 6f 75 20 77 69 6c 6c 20 73 65 65 20 74 68 | You will see th| 00005c30 61 74 0a 20 20 20 20 64 61 74 61 20 72 65 6c 61 |at. data rela| 00005c40 74 69 6e 67 20 74 6f 20 74 68 65 20 72 65 63 6f |ting to the reco| 00005c50 72 64 20 66 6f 72 20 41 43 54 49 4e 49 55 4d 20 |rd for ACTINIUM | 00005c60 68 61 73 20 62 65 65 6e 20 69 6e 73 65 72 74 65 |has been inserte| 00005c70 64 20 69 6e 74 6f 20 74 68 65 0a 20 20 20 20 49 |d into the. I| 00005c80 6d 70 72 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 |mpression docume| 00005c90 6e 74 2e 0a 0a 28 34 29 20 54 68 65 20 61 72 72 |nt...(4) The arr| 00005ca0 6f 77 20 61 6e 64 20 64 6f 75 62 6c 65 2d 61 72 |ow and double-ar| 00005cb0 72 6f 77 20 62 75 74 74 6f 6e 73 20 28 69 64 65 |row buttons (ide| 00005cc0 6e 74 69 63 61 6c 20 74 6f 20 74 68 6f 73 65 20 |ntical to those | 00005cd0 6f 6e 20 74 68 65 20 6b 65 79 70 61 64 29 0a 20 |on the keypad). | 00005ce0 20 20 20 6d 61 79 20 62 65 20 75 73 65 64 20 74 | may be used t| 00005cf0 6f 20 6d 6f 76 65 20 74 68 72 6f 75 67 68 20 74 |o move through t| 00005d00 68 65 20 64 61 74 61 62 61 73 65 20 63 61 75 73 |he database caus| 00005d10 69 6e 67 20 64 69 66 66 65 72 65 6e 74 20 72 65 |ing different re| 00005d20 63 6f 72 64 73 20 74 6f 20 62 65 0a 20 20 20 20 |cords to be. | 00005d30 6d 65 72 67 65 64 20 69 6e 74 6f 20 74 68 65 20 |merged into the | 00005d40 64 6f 63 75 6d 65 6e 74 2e 0a 0a 28 35 29 20 41 |document...(5) A| 00005d50 20 73 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 20 | search formula | 00005d60 6d 61 79 20 62 65 20 75 73 65 64 20 74 6f 20 72 |may be used to r| 00005d70 65 73 74 72 69 63 74 20 74 68 65 20 6f 70 65 72 |estrict the oper| 00005d80 61 74 69 6f 6e 20 74 6f 20 72 65 63 6f 72 64 73 |ation to records| 00005d90 0a 20 20 20 20 6d 61 74 63 68 69 6e 67 20 63 65 |. matching ce| 00005da0 72 74 61 69 6e 20 63 72 69 74 65 72 69 61 2e 0a |rtain criteria..| 00005db0 0a 28 36 29 20 27 50 72 69 6e 74 27 20 6d 61 79 |.(6) 'Print' may| 00005dc0 20 62 65 20 75 73 65 64 20 74 6f 20 70 72 69 6e | be used to prin| 00005dd0 74 20 74 68 65 20 64 6f 63 75 6d 65 6e 74 20 77 |t the document w| 00005de0 69 74 68 20 74 68 65 20 63 75 72 72 65 6e 74 6c |ith the currentl| 00005df0 79 2d 6d 65 72 67 65 64 0a 20 20 20 20 20 64 61 |y-merged. da| 00005e00 74 61 2e 20 54 6f 20 70 72 69 6e 74 20 61 20 73 |ta. To print a s| 00005e10 65 74 20 6f 66 20 64 6f 63 75 6d 65 6e 74 73 2c |et of documents,| 00005e20 20 6f 6e 65 20 66 6f 72 20 65 61 63 68 20 6d 61 | one for each ma| 00005e30 74 63 68 69 6e 67 20 65 6c 65 6d 65 6e 74 2c 0a |tching element,.| 00005e40 20 20 20 20 20 73 65 6c 65 63 74 20 74 68 65 20 | select the | 00005e50 27 50 72 69 6e 74 20 61 6c 6c 27 20 73 77 69 74 |'Print all' swit| 00005e60 63 68 20 74 68 65 6e 20 63 6c 69 63 6b 20 6f 6e |ch then click on| 00005e70 20 27 4d 65 72 67 65 27 2e 0a 0a 44 75 72 69 6e | 'Merge'...Durin| 00005e80 67 20 64 61 74 61 2d 6d 65 72 67 69 6e 67 20 49 |g data-merging I| 00005e90 6d 70 72 65 73 73 69 6f 6e 20 65 64 69 74 69 6e |mpression editin| 00005ea0 67 20 69 73 20 64 69 73 61 62 6c 65 64 20 2d 20 |g is disabled - | 00005eb0 79 6f 75 20 63 61 6e 27 74 20 70 6c 61 63 65 20 |you can't place | 00005ec0 74 68 65 0a 63 61 72 65 74 20 69 6e 20 74 68 65 |the.caret in the| 00005ed0 20 64 6f 63 75 6d 65 6e 74 20 61 6e 64 20 74 68 | document and th| 00005ee0 65 20 6d 6f 75 73 65 20 70 6f 69 6e 74 65 72 20 |e mouse pointer | 00005ef0 61 70 70 65 61 72 73 20 61 73 20 61 20 72 65 64 |appears as a red| 00005f00 20 61 6e 64 20 62 6c 75 65 20 63 72 6f 73 73 2e | and blue cross.| 00005f10 0a 43 6c 69 63 6b 69 6e 67 20 6f 6e 20 27 43 61 |.Clicking on 'Ca| 00005f20 6e 63 65 6c 27 20 6f 72 20 63 6c 6f 73 69 6e 67 |ncel' or closing| 00005f30 20 74 68 65 20 27 4d 65 72 67 65 20 64 61 74 61 | the 'Merge data| 00005f40 27 20 64 69 61 6c 6f 67 75 65 20 62 6f 78 20 72 |' dialogue box r| 00005f50 65 73 74 6f 72 65 73 0a 6e 6f 72 6d 61 6c 20 65 |estores.normal e| 00005f60 64 69 74 69 6e 67 2e 0a 0a 46 6f 72 20 6d 6f 72 |diting...For mor| 00005f70 65 20 69 6e 66 6f 72 6d 61 74 69 6f 6e 20 6f 6e |e information on| 00005f80 20 64 61 74 61 2d 6d 65 72 67 69 6e 67 2c 20 69 | data-merging, i| 00005f90 6e 63 6c 75 64 69 6e 67 20 69 6e 73 74 72 75 63 |ncluding instruc| 00005fa0 74 69 6f 6e 73 20 6f 6e 20 68 6f 77 20 74 6f 0a |tions on how to.| 00005fb0 70 72 65 70 61 72 65 20 74 68 65 20 49 6d 70 72 |prepare the Impr| 00005fc0 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e 74 2c |ession document,| 00005fd0 20 73 65 65 20 27 4d 61 69 6c 4d 65 72 67 65 27 | see 'MailMerge'| 00005fe0 2e 0a 0a 0a |....| 00005fe4