FREE SOFTWARE FOR DOS — Database & Spreadsheet Programs. Free Software for DOSDatabase & Spreadsheet Programs For address / phone number managers, go to Calendars, Clocks & PIMs.
Other, specialized databases are in Information, Reference, Research. GENERAL PURPOSE DATABASE PROGRAMSData.
FREEBASE (FBASE) — Simple database uses plain text files. Trilogy — Note retrieval system for researchers and writers. FREEBASE and Trilogy represent a. LO1: Investigate Common Uses for Spreadsheets Page 2 3. INVESTIGATE A SUITABLE APPLICATION FOR CREATING A SPREADSHEET The following are all applications/programs which can be used to create spreadsheets: Microsoft - Excel. List of spreadsheet software. The following is a list of spreadsheets. Free and open source software. Resolver One – a business application development tool that represents spreadsheets as IronPython programs. Spreadsheet applications (sometimes referred to simply as spreadsheets) are computer programs that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in a cell. I programmed probably the first ever electronic spreadsheet application while on contract to Imperial. What are some common uses of spreadsheets? What are the main uses of a spreadsheet?
These spreadsheet programs are in Excel and are not copy protected. I hate having to work with a dozen spreadsheets to value a firm. Uses both restricted stock approach and bid-ask spread regression.
Perfect — Professional relational database.* * * * *. Now has Web- authoring capability. This is a mature program, highly stable, and designed to handle very large, complex jobs. None of the Windows platforms, when using only the applications generator (i. DP allows for, and most.. DP's relationality even with writing code.
Also, most do very poorly with medium to large databases (say, databases with data files holding over 5. DP allows for almost no slowdown, free of corruption, with data files in the millions of records each. Copyrighted freeware. Originally released by Word.
Perfect Corp., then Novell (through 1. Author: Lew Bastian (2. Padilla, Maurizio Converso. Download dp. 26x. K). Go to the Data. Perfect Users Discussion Group for manuals, tools, links to other DP sites, mailing list, etc. Base 1. 99. 7 (n.
B) — x. Base, *. DBF compatible database.* * * *. From my limited evaluation, it appears to be a solid choice for maintaining a variety of catalogs or databases. Source (*. PRF) available. Author: Daniele Giacomini, Italy (1.
For more info, go to the nano. Base 1. 99. 7 description page and to the online manual. PC- File — Award- winning, flat file database manager. PC- File, created by the .
PC- File won three PC Magazine Editor's Choice awards in the '8. I've heard much about it, but have no experience with it. I will allow an old advertisement to speak for this program: Awarded its second Editors' Choice in the June 2. PC Magazine, PC- File is the #1 rated flat- file database manager. The May 1. 4, 1. 99. PC Week said . Share.
Ware magazine awarded PC- File an Editors Choice award in 1. In December 1. 99. Home Office Computing awarded PC- File four stars stating, . PC- File is so popular because it does just what you need a database to do: store, organize, retrieve, manipulate and update information. Whether it's your mailing list or your membership list; your clients, your customers, or your contacts; sales, inventory, expenses, payables & receivables, even your hobby collection..
PC- File can keep track of it. PC- File sports an impressive list of features, such as easy database creation, relational posting and retrieval, customized data entry screens, powerful search and retrieval capabilities, five different ways to create reports, including point and click and a forms designer, merge letters, bar code output including ZIP+4 Postnet & UPC, pie, bar and line graphs, quick mailing labels, 1. Base file compatibility, extensive import and export with many other popular programs and much more! The freeware version is the fully functional v. Documentation may be inadequate for some features.
PC- File is not Y2. K compliant. Author: Jim Knopf . See description wih screenshots at the Easy Base page. It can produce data files with a large number of fields, and a variety of display formats.
A text editor is built in. Full keyboard operation. Minimum operating requirement: 6. K conventional memory. Recommended: 8. 03. EGA+, XMS memory, DOS5.
Cardware. Author: Zhuhan Jiang, Australia (1. Suggested by Lars- Erik Sandberg. Download dbm. 11. K). SIMPLER DATABASE–LIKE PROGRAMSFREEBASE (FBASE) — Simple database uses plain text files.
Trilogy — Note retrieval system for researchers and writers. These programs operate on collections of various pieces of text, e. We often want to search these pieces of text to find specific information. But we don't want to deal with the complexity, time, and effort of setting up and maintaining a full fledged database. FREEBASE and Trilogy let you label pieces of text with one or more descriptive keywords, and retrieve the text items by doing simple, . You can change the (ascii) data file with any text editor of your choice.
To add a new piece of text, you simply mark its beginning with a special character (~), and add one or more descriptive keywords at the end of the text. You retrieve items of text in one of two ways: You can search the text itself for the presence of one or more words (similar to a wordprocessor's search and replace mechanism). You you can search your list of descriptive keywords for these words. Does not require items to be imported to or exported from a special format. Has a wonderful, easy to use, well thought out interface and display format.
Has a DOS escape key, so you can use it as a pop- up data base by starting it and then escaping to DOS. Disadvantages: 1) Cannot perform complex Boolean searches on keywords (e. X, but not word, Y). Must search for text strings only, no wildcards available. You must prepare index of keywords manually by including a separate list of keywords as the first piece of text in your data file. Limitations on the size of the database.
The manual claims that a piece of text must be no more than a screenful of lines (2. However, I found that larger pieces seem to work fine. Other: The installation program can be used at any time to configure screen colors, filenames, reserved characters, and more.
Author: Glynn Shaffer (1. Maximum number of records is set in the config file, 3. Package includes BAS source code. Download fbase. 18. K). Trilogy permits more elaborate Boolean searches of keywords, and it automatically generates two indexes for you – an alphabetized list of keywords, and a list of .
The cost of these extras is using a specially formatted, non- ascii, database file. Preparation of pieces of text is equally easy: include one or more keywords at the beginning of the text, and then import the text into a data- base, using the trilogy program itself. You can view the indices of keywords and titles, and then retrieve pieces of text, using simple or relatively complex Boolean searches on the keywords or titles. Trilogy also lets you print out pieces of text, as well as viewing them. The program was originally written by a professor to keep track of notes made in preparation for writing a research book. Advantages: 1) Complex .
Searches can use a simple wildcard (*). Handles relatively large databases of up to 5. Meg, and multi- screen text items. Disadvantages: 1) Cannot search the text itself for words. To do this you must export the text out of Trilogy's data- base and search it with an ordinary editor. Changing the keywords or text in a data file is time consuming and awkward: You must export the text out of the database, change it with a text editor, and then import it back into the database.
Has an awkward, non- intuitive user interface. In particular, one cannot go directly from the keyword screen to the retrieve- text screen.
You can get around this limitation by using a key macro TSR (e. Quickey). Author: B. Ball (1. 98. 8). 1. Package includes BAS source code. Download trilogy. K). dg (data- grepper) — Search for a phrase, in text records.
It is suitable for keeping utility files, such as address or contact files or software requirements files, when the purpose of the search is not to settle just for individual lines containing the desired phrase, but to get the entire paragraph or record. It is like grep with some notion of context.. Unlike grep, which would report only the specific lines containing the search term (or a fixed number of lines either side of the find), data- grepper will print the entire record in which the search term was found – or a specified number of key lines for that record. It is useful from the command line, but most powerful when used in batch files that grab a set of records and then do further processing on them.. The program does not directly support wildcards, nor does it understand all unix . Suggested by Marianna Van Erp.
Download dg. 53. zip (1. K). Also see: FCAT, from Bob Ferguson's Freeware – a multi- tool disk and archive cataloger package; more complex but fairly versatile.
CD Navigator — Floppy, HD, CD cataloger.* * * *. The Norton Commander- like text mode interface is mouse compatible and easy to navigate. Unlike the more basic freeware Disk Manager (next item), CD Navigator can: 1) store user file notes (or 4. DOS descriptions); and, 2) read and store a disk's formatted label. Multiple disks can be cataloged together into larger groups.
A quick disk scan feature (MSCAN) is especially nice if you are cataloging a large collection of floppies at one time. CD Navigator includes a robust search engine for finding disk or file names, notes, and CD audio tracks.
Also plays audio CD tracks and includes a screen saver. The download file also includes a basic (but neat looking) stand- alone audio CD player (PCDN) which can read CD Navigator generated data files.
English, Hungarian and Polish language packages are available. You'll have to experiment to discover the hidden strengths of this program. Take a look at the configuration file for further information.
Author: J. Database size is essentially unlimited (unless you have 1,0. Neat color interface, online help. Author: A. C. Software (1.
Download ac. Search function included. A configuration file can store custom switches.
File size limit unknown, but it can handle relatively large files (I've only tested it with a 1. MB file). Pops up a directory browser if run without parameters.
Author: Raymond T. Kaya (1. 99. 4). 1. Download dbv. 12. K). DBFVIEW — x. Base (*. DBF) file viewer and editor, mouse support. Requires 8. 02. 86+, DOS3.
Author: Tibor Kov. Includes a search field function, displays header info, type of table, and table code page. Latest versions can also repair damaged headers and display Win. LFNs). Code page translation support. May choke on empty directory (i. DBF files). Author: Milan Kosina, Czech Republic (1. Download vfpvw. 32.
K). CLUT — Powerful DBF viewer, editor, and manipulator. All run under DOS or Win.
Bilingual, English and Italian. It also allows to execute any operation done in complex procedure.
What are the three most popular spreadsheet programs? For the best answers, search on this site https: //shorturl. Worksheet Computer software for recording and analysing numerical data. Arithmetic and statistical operations can be carried out by simple instructions. Any associated graphs and diagrams that are required can also be automatically drawn. Advantages of Spreadsheet Programs A spreadsheet allows users to enter and calculate numerical data. Using a spreadsheet greatly increases productivity for anyone who needs to manage receipts, create budgets, generate financial reports or even keep track of inventories and similar lists.
A spreadsheet combines the features of a general ledger with the flexibility of powerful data analysis and reporting functions. Entering Data A spreadsheet allows you to enter text, numerical values and formulas into an electronic worksheet. The worksheet's rows and columns can contain numerical data or labels that identify information. Every row is automatically numbered and every column has an alphabetical identifier. The intersection of a row and column creates a cell. Every cell's name or placeholder is unique.
Putting information into a spreadsheet is much simpler than using a paper system like a general ledger. Users can choose whether to place labels in columns or in rows, according to their needs. The majority of popular spreadsheet programs have more than 2. This makes them ideal for storing and reporting large amounts of numerical data. Editing Typing data into a spreadsheet is more efficient than using an adding machine.
If you make a mistake in a spreadsheet, you can correct it by entering a new number or text into that cell of your worksheet. Most spreadsheets also have an undo command that allows you to remove one or more entries that you no longer want. Since spreadsheets are electronic, you can copy and paste data to avoid repeatedly typing the same values. With spreadsheets, it simple to save your work, update data as it changes and compare estimates or forecasts to actual data. Calculations A spreadsheet makes calculating numerical data much more efficient than adding machines.
Unlike adding machines, an electronic worksheet allows you to change formulas and recalculate the results without reentering the values. In addition to the most common mathematical formulas, a spreadsheet provides users with the flexibility to create formulas that produce customized calculations. A spreadsheet also allows you to put cell names in formulas. Your calculations are automatically updated when you change data in cells that are part of the formula. Users can also make formulas that link one spreadsheet to values contained in another one.
Formulas like these would allow you to create a quarterly financial statement using information from three separate spreadsheets for each month in the quarter. Data Analysis A spreadsheet is a useful tool for sorting and analyzing data. A user enters labels in rows and values in columns, then highlights the information and use menu commands to reorder the sheet's contents. You can use labels to sort information, such as dates, names or prices in ascending or descending order. The data sorting function also allows users to sort on combinations of labels. Most spreadsheets even provide ways to extract information that meets specific criteria, such as all entries containing a particular zip code, and show it a separate area of your worksheet. Reporting You can report data in a spreadsheet in a variety of ways.
You can select a portion of the sheet for printing or the entire document. You can choose to have information and labels repeated on each page, so that large spreadsheets are easier to read. A spreadsheet can convert your labels and values into charts, tables and graphs. You can export worksheets to other office productivity software like word processors and presentation software. Updates in the spreadsheet can automatically be reflected in the destination document.
Advantages Spreadsheet databases allow for better error checking, for better integration of data from multiple sources, and for better handling of very large files. Spreadsheets are faster to get up and running, which can be an advantage for small tasks.
Spreadsheets also have an advantage when there are repetitive patterns in the data. A best practice model is: .
You can achieve these benefits by applying some straightforward recommendat.