To Print this Manual: Press M (Mark) at the beginning of the Manual. Go to the end of the Manual and press M (Mark) again. Select the Print option to print the Manual. A PRINTED MANUAL WITH MUCH MORE DETAILED INSTRUCTIONS IS PROVIDED WITH THE REGISTERED VERSION. Due to disk space limitations, these shareware version instructions are somewhat abbreviated. --------------------------------------------------------------- Data Master Version 3.3 Copyright 1990-96 Robert K. Summers - All Rights Reserved. Distributor: RKS Software, Inc., Arlington, VA 22207-4565 703-534-1726 703-534-4358 (FAX) e-mail: rkssoft@gnn.com Internet World Wide Web: http://members.gnn.com/rkssoft Data Master is a program which allows you to use, create, and modify industry standard dBase .DBF files. It uses and creates standard dBase .DBT memo fields. It does not use standard dBase .NDX files. They are too slow. Instead, it uses FoxPro style .CDX compound index files. You can easily add, edit, search, analyze, and print reports on your data. Data Master is extremely powerful and easy to use. It handles dBase files of unlimited size. This shareware version is not crippled or limited in any way. It does have a number of 'nag' screens and messages to remind you that it is the sharware version and to 'bug' you enough so that you will pay us $39 for a nag-free registered version. DISCLAIMER Data Master is provided "AS IS". It is licensed without any warranty of merchantability, fitness of particular purpose, performance, or otherwise; all warranties are disclaimed. By using Data Master, you agree that Robert K. Summers and RKS Software, Inc., will not be liable to you or any third party for any use of (or inability to use) this software, or for any damages (direct or indirect) whatsoever, even if RKS Software, Inc. or Robert K. Summers are apprised of the possibility of such damages occurring. In no event shall Robert K. Summers or RKS Software, Inc. be liable for any loss of profit or any other commercial damage, including but not limited to special, incidental, consequential or other damages. The entire risk related to the quality and performance of the program is on you. LICENSE STATEMENT Registered owners are licensed to use their registered copy on a single machine and to make archival copies for the sole purpose of backing up the program. Data Master may be moved from one computer location to another, so long as there is no possibility of it being used at one location while it is being used at another. PC user groups, shareware distributors, BBS operators, and CD ROM vendors may add Data Master to their libraries. SHAREWARE TRIAL You may have procured this software from another source such as the libraries on Compuserve, a BBS, a shareware disk vendor, or from a friend. That's fine!. We encourage registered users to introduce new users to Data Master by providing them with an unregistered copy. Try it out for up to 30 days, and if you decide to continue using it, pay the license fee of US $39 You'll receive a registered copy and other benefits described below. Shareware gives users a legal but limited trial period to test the software before purchase. Data Master in shareware form is fully functional and completely documented. HOW TO REGISTER By phone: call 1-703-534-1726. By mail: mail us the registration form found at the end of this documentation. By fax: fax the registration form found at the end of this documentation to 703-534-4358. By Compuserve: GO SWREG, and select registration ID 368. The $39 registration fee will be charged to your COMPUSERVE account. COMPUSERVE will notify us immediately of your registration and we will mail you your registered copy of the program the same day. By e-mail: send an e-mail message with your mailing information, credit card number and expiration date, to: rkssoft@gnn.com BENEFITS OF REGISTRATION: 1. FREE LICENSED COPY OF THE MOST RECENT VERSION OF DATA MASTER, sent to you immediately by first class mail. 2. PRINTED USER MANUAL, containing complete information on Data Master operations. 3. FREE U.S., Canadian, and Australian zip/postal codes databases, included with your registered version. 4. FREE TECHNICAL SUPPORT by fax, e-mail, or regular mail. 5. DISCOUNT on upgrades of future versions of Data Master. If you have received Data Master through a user group, a shareware distributor, or an electronic bulletin board, please remember that you are still obligated to register if you decide to use Data Master after the 30 day trial period. If you have received Data Master on a distribution disk from RKS Software, a shareware vendor, or computer club, there will be an installation program on the disk. To install: 1. place the working disk in drive A. 2. at the A:> prompt, type A:INSTALL and follow the on-screen instructions. The default installation directory is C:\DM. 3. to start Data Master any time in the future, type \DM\DM at any C:\> prompt. If you place the \DM directory in your path statement, just type DM at any C:\> prompt. DOS uses the CONFIG.SYS file to set certain defaults for your computer. It must be in the root directory of your fixed disk. If you do not already have a CONFIG.SYS file you must create one that has this line, and place it in your PC's root directory: FILES=21 If you already use a CONFIG.SYS file that does not include a FILES setting, you must add this FILES=21 line to the file. You can do it with any text editor. If your CONFIG.SYS file already contains a FILES setting greater than 21, you can leave it as is. DEFINITIONS Database: A database is an organized collection of information or data. A simple example of a database is a mailing list. Dbase database files always have a file extension of .DBF. Record: All the data for a particular entry is called a record. In a mailing list, each record contains all the name & address data for one person. Field: Each item of information within a record is called a field. In each mailing list record, for example, there may be fields for last name, first name, street, city, state, and zip code. A database can contain one or more of five types of fields. These five are: 1. Character - This type of field allows entry of all the letters, numbers and symbols you see on your keyboard. In a typical mailing list, all the fields would probably be character type fields. 2. Numeric - This type of field allows only entry of numbers. Use it only for numbers you want to calculate. Put zip codes or phone numbers in a character field, not a numeric field. 3. Date - This type of field allows only date entries. 4. Logical - This type of field allows only a true/false entry. 5. Memo - This type of field is an elastic character field. Whereas character fields must be defined as a fixed length, e.g., 20 characters long, memo fields have no fixed length. Instead, memo field data is stored in a companion file, with a .DBT (DataBase Text) extension, and takes up no disk space unless data is entered into it. Indexes: An index is a file which sorts your records the way you want. Persons working with a mailing list database, for example, might create indexes based on last name and zip code. Index files created and used by Data Master have a file extension of .CDX. Creation and use of index files is explained below. USING DATA MASTER Type DM at the DOS prompt of the DM directory to start Data Master, or type \DM\DM if you are not in the DM directory. In most cases, Data Master will be able to detect whether you have a color or monochrome monitor. If you have a monochrome monitor and the Data Master screen is not clear, type DM M to start Data Master. The extra M tells Data Master to use monochrome, not color. When the program starts, you will see that the Main Menu presents five options. These are discussed in turn below. You may select any main menu option by pressing ALT plus the first letter of the option. Example: press ALT S to select the Services option. Main menu sub-options may be selected by pressing the highlighted letter for that option. You may press ALT X to quit the program. You may also select main menu and sub-options by using the arrow keys to highlight the option and then press Enter to select the highlighted option. Files Use this option to display a menu of eight sub-options. Open: Select this option to open a database file in the current directory. Data Master will load this file and display it on the screen in browse mode where you may add, edit, delete, etc. records. Select the Quit option to return to the main menu. IMPORTANT TIP: ONCE A FILE IS LOADED, YOU MAY JUMP INTO BROWSE MODE AT ANY TIME FROM THE MAIN MENU BY PRESSING THE F2 KEY. The Status box at the bottom of the screen will always display the currently loaded database. Note: Data Master is installed with one example database called NAMES.DBF which you can use to build a name and address file. Modify/Create: Use this feature to modify the structure of an existing database, or to create a new database. You can add, edit, or delete fields of the five types described above. Instructions for use are provided on the screen. Once created, you cannot modify a field name. Instead, create a new database with the field name(s) you want, and use the Append File option to move records from the old file to the new file. Change Directory: Use this feature to select another hard disk directory, e.g., C:\ELVIS. Close Database: Use this feature to close the currently active database. The Status box will show that no database is active. Append File: Use this feature to append (merge) records from another database or ASCII file into the currently active database. When appending ASCII records, the fields in the ASCII file must be in exactly the same sequence as the fields in the active dbase file. Save As: Use this feature to save the currently active database to a new dbase file or to an ASCII text file. Print Structure: Use this feature to print the database structure. eXit: Select this option to quit the program. You may also press ALT X to quit the program. Indexes A index lets you sort your records any way you want. When you select this option, you will be presented with four choices: Create New Index: Use this feature to create a new index. Data Master will prompt you to select the field(s) to index on. Data Master will then ask you to name the index file, and create it. Select Controlling Index: When using more than one index, use this option to tell Data Master which index is the controlling index. For example, if you have created a last name index and a zip code index using the Select Index(es) option above, and you want to work with the records in last name order, use this option to tell Data Master that the last name index is the controlling index. Data Master will display the records in last name order. Delete Index: Use this option to delete an index. Rebuild Open Index(es): Use this feature to rebuild all active indexes. This means that Data Master will make sure that there is a correct entry in each index file for each record in the database file. This feature also reclaims any empty space from deleted indexes. Data Master stores your indexes in a single file which has the same name as the database file, but with a .CDX extension. For example, if your database file is called CLIENTS.DBF, Data Master will store all your indexes in a file called CLIENTS.CDX. You never have to bother about the .CDX file. Data Master creates it and manages it automatically for you. If there is a .CDX file, Data Master knows it and uses it automatically. Use Use this feature to display a menu of options for using the data in the database. Browse Records: Select this option to browse the currently active database. You may add,edit, delete, locate, and view all the records in the database. NOTE: a shortcut for displaying records in browse mode is to PRESS THE F2 KEY. Sum/Average Data: Use this option to sum or average data in numeric fields. Replace Data: Use this option to replace the data in a specified field in ALL the records in the currently active database. Be sure you have a backup copy of your records in case you make a mistake using this option. Check for Duplicates: Use this option to find duplicate records in the currently active database. Frequency Analysis: Use this option to see what the frequency of data is in a specified field. Delete Records: Use this option to delete all the records in your database. If a filter/query is active, only those records meeting the filter/query condition will be deleted. Pack Records: use this option to physically purge records 'deleted' in the browse mode. Records deleted in browse mode still occupy disk space. This pack recovers the disk space. sTatistics: use this option to display a variety of stistical information about your database. Mailing Labels: use this option to print mailing labels from the currently active database. Form Letters: use this option to compose and print letters or memos. You can merge database data into your letters and memos. Query Builder Use this feature to create a query condition, or filter, so you can work with any subset of records you want to. When a query condition is active, Data Master will only display or print records meeting the query condition. The Status box will display any query condition. To turn off the query, select the Turn Query Off option. Services This feature presents a menu of support services: Report Writer: Select this option to use the Report Writer. The Report Writer allows you to create custom reports, output the reports to printer or disk, and save the report specifications for future use. Read a Text File: Use this option to read any text file which may be on your disk. Erase a File: Use this option to erase any file on your disk. Change Directory: Use this feature to change to any other directory on your hard disk. The currently active database will be closed when you select this option. Format Dates: Use this option to select the date format you want to be used in your database fields. Weights and Measures: use this handy conversion utility to convert a variety of weights and measures. Create Mailmerge File: use this option to create a mailmerge file for your favorite word processor. Time Period Anaylsis: use this option to conduct a time period analysis of your records. FUNCTION KEYS F1- Use this to read the Users Manual on-line F2- Use this to invoke the browse mode. F3- Use this to temporarily exit to DOS. You could use this feature to temporarily leave Data Master and, for example, run your favorite spreadsheet program or word processing program. To return to Data Master, type EXIT at the DOS prompt and press the Enter key. F6- Use this to display a pop-up printing calculator. F7- Use this to display a current record count. F8- Use this to display a calendar. TECHNICAL SUPPORT We do not charge a fee for normal technical support. You may reach us via: 1. Phone:..: 703-534-1726 1. FAX.....: 703-534-4358 2. e-mail..: rkssoft@gnn.com -- DATA MASTER REGISTRATION -- To order Data Master and the printed User Manual: - call 703-534-1726, or - fax the form below to 703-534-4358, or - send Internet e-mail to rkssoft@gnn.com - mail the form below to RKS Software, Inc. 3820 N. Dittmar Road Arlington, VA 22207-4565 To order by mail, please complete the form below, enclose your check for $39.00, plus $4.00 shipping/handling for U.S. and Canada, and $6.00 shipping/handling for other international orders. We accept all U.S. and foreign Postal Money Orders, and will also accept checks drawn on foreign banks. PLEASE RUSH MY COPY OF DATA MASTER AND PRINTED USER MANUAL TO: Name: _________________________________________________________ Address: ______________________________________________________ City: _______________________ State: ________ ZIP: ___________ Phone:_________________________________________________________ Visa ____ MasterCard _____ American Express ___ Discover ___ Credit Card No: __________________________ Exp. Date:__________ Signature for credit card order: _______________________________________________________________ ====================================================================