About DB MASTER ONE... If you are new to computerized filing, whether for your home or business, DB Master One was designed especially for you. It is exceptionally Easy to learn, Easy to use, and Quick. Use it to store, find and print any information you want. DB MASTER ONE is divided into two programs: 1) MAKEONE.PRG is used for creating the FORM i.e. the screen layout of the information to be stored. 2) USEONE.PRG is used to fill in the FORM with information (DATA) to create a FILE (Data Base). With DB MASTER ONE you can manage and display your information in many different ways. About DB Master One Capacities... MAX. FILE - available ram to 320k MAX. FIELD SIZE - 3,000 characters MAX. RECORD SIZE - 3,000 characters WAYS TO FIND RECORDS - equals, between, contains REPORT FORMS - column, page, screen, mailing list REPORT DESIGNS STORED - 10 SORT LEVELS FOR REPORTS - 3 Instructions for MAKEONE.PRG About BASIC TERMS... A FILE is a collection of related information. The FORM is the screen layout of the information to be stored. A filled-in FORM is a RECORD. All RECORDS in a FILE have the same FORM. Each item of information in the FORM is called a FIELD. FIELDS have LABELS to identify the contents and DATA BOXES to hold the information. If 'Name' were the LABEL then the DATA BOX, would be the 'blank' you would later fill in with a particular name. About FIELD LABELS... A FIELD may be missing either its LABEL or its DATA BOX. FIELDS have a black Move Box on the left (for moving the FIELD, or for duplicating the FIELD) and a black Size Box on the right. How to PLACE FIELDS... Place the pointer where you want the FIELD to start. Click the mouse. Type a LABEL to identify the FIELD's contents. Press the 'Return' key. If you instead press the 'Delete' key the FIELD is removed from the FORM. How to CHANGE DATA BOX SIZES... Place the pointer in the small black box at the right edge of the FIELD (Size Box). Hold down left mouse button and stretch or shorten the Data Box to the size you want. The numbers tell you about how many characters will fit in the Data Box. How to MOVE FIELDS... Place the pointer in the small black box on the left side of the FIELD (Move Box). Hold down left mouse button and drag FIELD to its new location. Release the mouse button. How to COPY FIELDS... Hold the [Shift] key while you press and hold the mouse button in the Move Box of the FIELD you want to duplicate. Drag the FIELD to where you want to place the copy. (This can also be done from the EDIT menu with Copy & Paste Field.) Finishing your FORM... When you have placed all of the FIELD's on your form, choose 'Save' from the FILE menu. You will then be asked to name your file. We suggest that you use .ONE as the last part of your file name. This will make using your file easier. About Changing an old Design... If you want to change a design that you have already created, choose 'Redesign' from the FILE menu. Make whatever changes you would like to make. You may add fields, remove fields, move fields around, change style, lengthen or shorten the Data Boxes. When you Save your new design, all of the information and reports in your original file will be changed to the new design for you. No data will be lost unless you shorten a field so that the data will not fit, then the extra data will be cut off. About the MENU BAR... Menu options appear when you point at each of the menu headings: DESK - perform ST desktop functions. FILE - Save the file, Redesign (change) a file, or Quit. EDIT - change or remove fields or field labels. SPLAT - shortcut forms. OPTIONS - set label and data style. About the FILE menu... New - start a new file design. Redesign - change the form of an already created file without losing data or reports. Save - store the current design. Quit - exit the program and return to the desktop. About the EDIT menu... Cut Text - remove and store darkened portion of label for later recall. Copy Text - store darkened portion of label for later recall with Paste Text. Paste Text - return most recent Cut or Copied text to field at cursor location. Cut Field - remove and store entire field for later recall. (equivalent to the Delete key). Copy Field - store entire field for later recall with Paste. Paste Field - return most recent Cut or Copied field in place of the current field. How to darken LABEL Text... Place the pointer over the first character and click. Then either hold down left mouse button and drag pointer to last character or hold down 'Shift' key and click on last character. About SPLAT... SPLAT holds pieces of files that may be used as a part of your file. For example, if you want to have a date as a part of your file, just SPLAT Date into your design. Click where you want the splat form to start. Next, choose the splat you would like to use. To print mailing labels, you must splat MAILING LIST. You may move, change, lengthen, or modify the fields in the mailing list, but YOU MAY NOT DELETE ANY OF THE FIELDS. About the OPTIONS menu... Use Label Style and Data Style to set the color, size, and style of the field labels and data. When a style is chosen, that style will remain in effect until you change it again, or click in a field that has a different style. How to SET LABEL and DATA STYLE... Click in the field to change. From the OPTIONS menu, click on Label Style or Data Style. Click in the boxes to change color, size, and style of text. The word "Sample" changes with each choice to show its effect. If you click in a field, then the style used for the label and data of that field will be used in making new fields. (Unless you change it.) About the KEYBOARD... There are several special keys that are used with this program: CONTROL- Used with another key for menu items in place of the mouse. Shown as ^ in the menu. Press CONTROL with the key to choose a menu item: ^ S - Save. Store current design. ^ Q - Quit. Return to desktop. ^ X - Cut Text. Cut darkened part of Label. ^ C - Copy Text. Copy darkened part of Label. ^ V - Paste Text. Return Cut or Copied Label Text at cursor location. SHIFT - used together with the left mouse button to either copy a Field or to darken a Label Text. BACKSPACE - Used to erase the previous character. DELETE - Used to remove a Field from the Form. HELP - For onscreen help. -O-O-O-O-O-O-O-O-O- Instructions for USEONE.PRG Getting Started... To fill in the FORM with DATA, just click in the FIELD where you would like to type,and type. If you see any errors, just click after them, backspace and type the correct data. You may choose any menu option at any time. About the MENU BAR... These menu options are available: DESK - About DB ONE, perform ST desktop funktions. FILE - Switch (Load) files, Save the file or Quit. EDIT - Cut (remove), Copy (duplicate), Paste (restore) data. REPORT - Design & Print Reports. RECORD - Enter, review & Edit Data. About the FILE MENU... # Records, % Full - the size of your file. Switch Files - open a different DB Master One file. Save - store the file on the disk and continue. Quit - leave DB Master & return to the desktop. About the EDIT MENU... Cut - remove darkened text for later recall with Paste. Copy - store darkened text for later recall with Paste. Paste - return most recent Cut or Copied data to data box at the cursor. Clear - erase all of the data in the field. To erase darkened text, press the 'Delete' key. About the REPORT MENU... Design New - start a new report design. Choose report form, fields, records and the order in which records will be printed. Edit - change an existing report. Print - print a report to the screen, printer, or disk. About DARKENING TEXT... To darken (select) a large area of text, click on one side, then hold down the 'Shift' key and click on the other side. Or hold down left mouse button on first character and drag pointer to last character. About the RECORD MENU... Add - add the record that is on the screen to the file. Find All - display every record. Find Some - display certain records. Next - display the next record. Previous - display previous record. Delete - remove the current record from the file. About ADDING RECORDS... To begin adding records, choose Add from the Record Menu. Fill in the form for the new record. Choose Add again to prepare another blank form. About FINDING & EDITING RECORDS... Records will be displayed on the screen if they match the information you have asked for. You may ask for up to 3 conditions to be satisfied before a record is shown. Three types of matches are: EQUALS - will find records that start with the match data you asked for. State equals Ca will find Ca, Calif, and California. BETWEEN - will find records where data falls within the range. CONTAINS - will find records that include the match data anywhere within the field. If you ask for records where Name equals Fred, Name equals Dan, and State equals Ca, you will get records of anyone named Fred or Dan that live in California. Name equals Joe, Name equals John, Name equals Kim, will find those with the names Joe, John, or Kim. CONTAINS is especially useful if you have a large field of names of songs, poems, or words of any kind. If you had a record collection file you would use something like Song Titles CONTAINS Jingle Bells to get a list of records that had that song on it. About Next and Previous... 'Next' will display the next record in the file. If you began looking at your records by choosing 'Find Some' instead of 'Find All', 'Next' will find the next matching record. In the same way, 'Previous' will find the preceding record. About Editing Records... To edit a record: 1. Find the record. 2. Click in the fields you would like to change. 3. Make the changes. 4. Go on with your work. How to DESIGN A REPORT... Under REPORT choose 'Design New..'. From the FORM FIELDS FIND SORT, choose: * the appearance of the report * the fields to appear in order * the records to appear * the order of those records About REPORT FORMS... COLUMN - prints data lined up in columns with one line per record. RECORD - prints records as they are displayed on the screen. PAGE - prints the field label & its data in paragraph form. MAILING LIST - prints only the Splat fields of the MAIL LIST file in a mailing label form. How to choose FIELDS... You may choose fields for COLUMN or PAGE reports. Just click in the fields that you want printed, in the order that you would like them printed. Click a field a second time to remove it from the report. How to FIND records for your report... Choose the information that you would like all of the records on report to match in the same way you would to 'Find Some' records. You may choose Erase to remove an unwanted match value entirely. How to SORT DATA for reports... 1. Click the first sort field. 2. Choose whatever options apply: * 0-9, A-Z is low to high (an ascending sort) * Print Subtotals * Start New Page 3. Click "2" for a second sort (a sort within the first sort.) 4. If desired, click "3". Help about SORT... If you sort on State, and say YES to Subtotals, and YES to New Page -> After all of the Alaska records are printed, the subtotals for Alaska will be printed, and the Alabama records will begin at the top of the next page. About Naming your report... After you have designed your report ,Save it. You will be asked for its name. This name will be used in the report title. All of your report names must be different. Help Choosing Reports... When you edit or print reports, you are given a list of all of the names of the reports you have created. Choose the one you would like, then choose: Edit/Delete - (when editing) to change or remove the report. Screen/Printer/Disk - (when printing) to direct the report. About EDIT a report... To edit a report, choose the report and click EDIT. Then from the FORM FIELDS FIND SORT box, choose what you would like to change and make the changes. The changed report may: Replace the Old Report, or be Saved as a New Report. About PRINT a report... Choose the report you would like to PRINT. Then choose the destination of the report: SCREEN, PRINTER, or DISK. Any report that is in RECORD Form may be sent to the PRINTER only, not to DISK or to the SCREEN. About Disk Reports... You will be asked to name the file that the report will be written to. The format on the disk is exactly the same on disk as it is to the printer -- after each report line, a carriage return (hex 0D) and a line feed (hex 0A) is "printed." About the KEYBOARD... BACKSPACE - used to erase the previous character. SHIFT - Used together with the left mouse button to darken (select) an area of text. DELETE - Used to erase a darkened area of text. HELP - Will give you onscreen help. CONTROL - The symbol ^ means control. Any menu option with such a symbol may be chosen by pressing the letter while holding down the control key: ^ S - Save. Save the File. ^ Q - Quit. Return to the Desktop. ^ X - Cut. Cut darkened text. ^ C - Copy. Store darkened text. ^ V - Paste. Return Cut or Copied text at cursor. ^ P - Print. Print a report. ^ A - Add. Add record to the file. ^ F - Find Some. Display certain records. ^ N - Next. Display next record. ^ B - Previous. Display previous record. ^ D - Delete. Remove current record from file. -O-O-O-O-O-O-O-O-O-O-O-O-O-O-O-O-O-O-