22
Jan
18

Open Access for DOS

Open Access is an suite of office software made by a German company called Software Products International (SPI). We got this software with our first PC early 1990, but the software copyright is for 1986. Dad used the spreadsheet function to manage the farms finances until we upgraded to using Works a few years later, I used to experiment with the word processor and graphics (charting). I’ve been meaning to post about this program for a while, but I had difficulties getting it to install and work properly under dosbox. I eventually had to resort to a full machine emulator (pcEM), which would allow me to use all the components.

The word processor module is fairly simple, typing a document is fairly straight forward, but there are few features built in. Some notable omissions are a lack of spell checker and thesaurus. There are only a few formatting options, basically the usual bold underline and italics which are displayed as different colours. As a text editor it does serve it’s purpose reasonably well, but isn’t as easy to use as something like Works.

The spreadsheet module got the most use, mostly from my Dad. He said it was a big improvement over doing the books by hand, which was a tedious and time consuming job. This module is much more feature rich and would probably have been comparable with contemporary competitors. Something I did notice whilst playing around was that the formula system has a different syntax that I don’t remember. It’s possibly the same as Lotus 1-2-3 (as that was seen as a standard) but without the manual I can’t make full use of it. Something notable here is that values in formulae do not update automatically, you have to select the recalculate option to refresh those cells.

This slideshow requires JavaScript.

The graphics module was for creating charts. It supported CGA and EGA graphics modes for creating the charts, although the emulation I have can only demonstrate the CGA mode. There isn’t any facility for entering data, instead you need to export a selection of data from either the spreadsheet or database module.

The info management (database) module was something we never used, and I wasn’t able to work out how to use it well enough to get a decent screen shot. Ironically it was one of the most popular features of the software that made it useful for many people. It supported a subset of the SQL language and was capable of storing what was an exceptional amount of data for the time. Later versions included a dialect of BASIC called PRO which made it a platform for developing database driven applications.

Using Open Access is not very intuitive for a user today as the interface is designed around using function keys on the keyboard. Unfortunately there isn’t really much documentation within the program itself, instead it comes with extensive printed documentation (which is presently at my parents place). At the time it was released this was completely normal, and if you used it often enough you’d soon remember all the function keys, so it wasn’t seen as a downside.


2 Responses to “Open Access for DOS”


  1. 1 John
    May 13, 2019 at 12:16 pm

    Installed one of the first LAN on IBM CGA graphics on IBM PCs back in 88/89 here in New Zealand. It was an American hotel system called Logistix that had very limited back office analysis and required word processing, spreadsheet support. Lotus was a ridiculous price for each module, so installed the OA package. OA did the job well particularly the spreadsheet (for it’s time). The hotelier became infatuated with spreadsheets and started requiring more mind bending analysis every time I saw him, nearly drove me crazy:)

    • May 13, 2019 at 1:04 pm

      Thanks for your comment John. Whilst I knew that lots of others had used this software, I had never actually heard about anyone using it. Interesting that lotus was expensive at the time, Dad doesn’t remember it, but it would probably have been the reason he went with OA.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


Blogs I Follow

Enter your email address to follow this blog and receive notifications of new posts by email.


Mister G Kids

A daily comic about real stuff little kids say in school. By Matt Gajdoš

Random Battles: my life long level grind

completing every RPG, ever.

Gough's Tech Zone

Reversing the mindless enslavement of humans by technology.

Retrocosm's Vintage Computing, Tech & Scale RC Blog

Random mutterings on retro computing, old technology, some new, plus radio controlled scale modelling.

ancientelectronics

retro computing and gaming plus a little more

Retrocomputing with 90's SPARC

21st-Century computing, the hard way

lazygamereviews

MS-DOS game reviews, retro ramblings and more...

%d bloggers like this: