[{"TitleName":"MF-Print","Publisher":"Campbell Systems","Author":"","YearOfRelease":"1984","ZxDbId":"0011416","Reviews":[{"Issue":{"Name":"ZX Computing Issue 18, Apr 1985","Price":"£1.95","ReleaseDate":"1985-03-28","Editor":"Ray Elder","TotalPages":132,"HasCoverTape":false,"FlannelPanel":"Editor: Ray Elder\r\nEditorial Assistant: Cliff Joseph\r\nGroup Editor: Wendy J Palmer\r\nSales Executive: Jonathan McGary\r\nAdvertisement Manager: Barry Bingham\r\nDivisional Advertising Manager: Chris Northam\r\nCopy Controller: Sue Couchman\r\nPublishing Director: Peter Welham\r\nChief Executive: T J Connell\r\n\r\nOrigination and design by MM Design & Print, [redacted]\r\nPublished by Argus Specialist Publications Ltd, [redacted]\r\n\r\nZX Computing is published bi-monthly on the fourth Friday of the month. Distributed by: Argus Press Sales & Distribution Ltd. [redacted]. Printed by: Garnett Print, Rotherham and London.\r\n\r\nThe contents of this publication including all articles, designs, plans, drawings and programs and all copyright and other intellectual property rights therein belong to Argus Specialist Publications Limited. All rights conferred by the Law of Copyright and other intellectual property rights and by virtue of international copyright conventions are specifically reserved to Argus Specialist Publications Limited and any reproduction requires the prior written consent of Argus Specialist Publications Ltd.\r\n\r\n©Argus Specialist Publications Limited 1985"},"MainText":"MASTERFILE\r\nCampbell Systems\r\nS. Datoo\r\n\r\nAs far as business software for the ZX Spectrum is concerned, there are several database programs available on the market. Campbell Systems advertisement for their program \"MASTERFILE\" asks \"Can Your Database Handle This? MASTERFILE can!\". Having used both version 8 and version 9 of this program I can guarantee that their claim is no idle boast! The latest version gives one the option of formatting the data to be displayed on the screen as well as being printed onto a full sized printer, but more about that later.\r\n\r\nThe program loads in two parts, the first one being a BASIC program which one may manipulate to suit individual requirements provided that the default line numbers and relevant statements are not altered. The second part is fully machine coded, but even here the user can adapt the program to suit his or her taste. For example, the program as supplied will allow the user to format 26 data references for each record, but for those requiring more than this number, the manual which accompanies the tape instructs you on the method to increase the number to 43. However, with a little experimenting I discovered that this number can be further increased to 58! To verify that what I was doing to increase the number of data references was correct I telephoned John Campbell, the author of the program. I was completely bowled over by the helpfulness of Mr. Campbell, and in my experience there are not that many companies that could match his after sales customer service.\r\n\r\nLike all other database programs, \"MASTERFILE\" Also has a demonstration program which illustrates the versatility of the program. One is able to see the various layouts which can be designed for each file, and this is extremely useful for setting up formats that are sorted by different fields. For example, the demonstration program is a file of employees and the information held in each record gives the department that the individual works in, the salary, job title, home address, and other additional information in note form. The layouts which have been designed will sort and display the information by name, by department, or by salary, and most usefully in an address label format. The user can switch from one format to another quite literally at the touch of a button.\r\n\r\nTHE MENU\r\n\r\nAt each stage of the program there is a very helpful \"menu\" or \"mini-menu\" displayed which makes it very easy to use the program. The keyword throughout the program is \"user friendliness\". The main menu offers the following options:\r\n\r\nADDING A NEW RECORD\r\nThe number of records held in the file is displayed on line 23. The amount of space available (in bytes) is also constantly displayed on the same line.\r\n\r\nLISTING ALL THE REPORT REFERENCES\r\nThis shows the reference of the various layouts that have been created.\r\n\r\nDISPLAYING OR PRINTING THE FILE\r\nThe display option is also available via other \"mini-menus\".\r\n\r\nEDIT OR FORMAT A REPORT\r\nThis is used to either review or amend a display format.\r\n\r\nLOADING A FILE OR SAVING A FILE\r\nThe program is fully Microdrive compatible.\r\n\r\nSEARCHING THE FILE FOR SELECTED RECORDS\r\n\r\nINVERTING THE SELECT STATUS OF EVERY RECORD\r\n\r\nRESETTING THE SELECT STATUS OF EVERY RECORD\r\nThe above three options are used together when searching for a particular record or a group of records.\r\n\r\nERASING ALL THE RECORDS\r\nAs with all erasures there is a fail-safe built into the program which asks the user to confirm before execution.\r\n\r\nEXECUTING USER BASIC\r\nThis option is especially useful if one requires arithmetical functions to be carried out on numerical data held within the records. For example if one wished to express an item as a percentage of another then this is quite easily done by writing a short and fairly simple BASIC routine within the specified lines.\r\n\r\nWhen adding a record one may select the auto prompt option which does away with having to remember the various data references that have been named for each record. Each data item can be up to 128 characters long. When the data is displayed, \"MASTERFILE\" performs rudimentary word processing such that all leading blanks are ignored, a clean left margin is maintained, and word breaks are minimised. Numeric data is right justified. The vertical line character (i.e. ':' found under the S key on the SPECTRUM) has a special use in \"MASTERFILE\". It forces a line break so that text may be keyed in as a single line but with the vertical line characters (VLC) as line separators, so that when the data is displayed in a 4-line-deep paragraph, for example, each VLC forces a line change. This is very useful for address labels.\r\n\r\nThe amount of memory that is available for storage of data per file is approximately 32K but this is reduced slightly if the full sized printer option is used. I use \"MASTERFILE\" with a full sized printer almost on a daily basis at work and I have found the memory available to be quite ample.\r\n\r\ni stated earlier that the user could design various formats for displaying the records on screen. In addition to this the user has a choice of having the normal 32 characters per line or opting for 42 or 51 characters per line. As far as the print option is concerned, if one wished to print the file to a full sized printer then this is achieved with the aid of an additional program entitled \"MF PRINT\" which is available separately from CAMPBELL SYSTEMS. \"MF PRINT\" will enable the user to print up to 200 columns per line. Here again, one may design the layout according to requirement. When printing to a full sized printer it is possible to have all numeric data edited so that leading symbols (e.g. £ or $) will be automatically printed. In addition, columns of figures can be totaled and thousands' commas inserted automatically.\r\n\r\nI have been using \"MASTERFILE\" for just over 1 year now and at present I am using it at work almost every day. If anyone is considering buying a database program then I would say this to them; I have used three database programs on the SPECTRUM and none of them can beat \"MASTERFILE\".\r\n\r\n\"MASTERFILE\" is priced £15 and \"MF PRINT\" is priced £6.95. If the two are purchased together then the cost is reduced to £19.95. The programs are available from CAMPBELL SYSTEMS, [redacted].","ReviewerComments":[],"OverallSummary":"","Page":"15,16","Denied":false,"Award":"Not Awarded","Reviewers":[{"Name":"S. Datoo","Score":"","ScoreSuffix":""}],"ScreenshotText":[],"BlurbText":[],"TranscriptBy":"Chris Bourne","ReviewScores":null,"CompilationReviewScores":[]}]}]