Showing posts with label Access. Show all posts
Showing posts with label Access. Show all posts

Friday, February 1, 2013

History of Database Software



Databases originated in the 1960’s with the development of computers designed to manage large business data sets.  The term “data base” was used in the 1960’s until the single word, database, became popular in the 1970’s (The Linux Information Project, 2006).  The concept of a desktop computer database did not develop until after the 1970’s with the development of personal computers.  A personal computer (PC) was a term used to differentiate a computer designed for use of an individual, rather than a business organization. 

Early Relational Database Development

Two early PC relational databases were dBase and FoxPro.  dBase was developed in 1978 by Wayne Ratliff, a programming contractor at the Jet Propulsion Laboratory in Pasadena, California (Martel, n.d.). Ratliff developed the database to win the office football pool (Unarchived, 2012). He ran the program on his kit-built home computer. Early PCs were kit-built for users as a hobby. Later, Ratliff collaborated with George Tate to create a company and market the software.  dBase was very popular during the 1980’s and later sold to Borland in 1993. dBase began to lose popularity as competition database software was released to the marketplace.  However, dBase is still available today from http://www.dbase.com/. 



Two other early PC database programs were FoxPro and Paradox. FoxPro was developed in 1984 by Fox Software and was acquired by Microsoft in 1992 (Wikipedia Authors, 2012a).  Richard Schwartz and Robert Shostak developed Paradox for DOS in 1985.  Their company was Ansa Software and later purchased by Borland in 1987.  Like dBase, dBase and Paradox were designed for developers with programming knowledge rather than home users (Wikipedia Authors, 2012b).  

The development of Windows with a graphical user interface (GUI) forced developers to redesign software.  In the early 1990’s all developers were scrambling to use GUI.  Paradox was designed for Windows by a different team of programmers.  Paradox for Windows was released in 1993 two months after the release of Microsoft Access, which had already had taken hold in the marketplace.

Two prevalent commercial personal databases used today are FileMaker Pro and Microsoft Access.  An historical view of the development for the two applications provides an understanding of the differences noted in the products used today.  Microsoft Access is available only for the Microsoft Windows operating system (OS). In contrast, FileMaker Pro is available for Microsoft Windows OS, Mac OS X, and the Apple iPad.

FileMaker Pro

The origin of FileMaker was the early 1980’s. The developers were Spec Bowers, Alan Albert, Dan Chadwick and Jega Arulpragasam, employees of Wang Labs in Lowell, Massachusetts (Koenig, 2004).  They designed their first database application, Nutshell, to provide an efficient user interface.  Leading Edge, a company that manufactured and sold PC clones, marketed the software.  About the same time, Apple introduced Macintosh computers to the marketplace.  Leading Edge would not sell to Mac market, so the developers redesigned Nutshell for the Mac computers, naming it FileMaker (Koenig, 2004).  Later, Claris, a subsidiary of Apple, purchased FileMaker. Claris redesigned, FileMaker to work with Microsoft Windows.  Afterwards, Apple dissolved Claris and established FileMaker as a separate company.  FileMaker, Inc., a subsidiary of Apple, markets FileMaker Pro software today.

Microsoft Access

Microsoft Access was first released in 1992 (the same year FoxPro was purchased) for the Windows OS (Beitler, 2010).  In 1993, a second version was released to be more compatible with Microsoft Office.  Microsoft released additional versions of Access to be compatible with newer iterations of Windows operating systems.  Access was a component of Microsoft Office Professional. Access 2010 is the most recent version of the relational database software, although 2013 is scheduled for release in 2013.  The target audience for the software continues to be small and medium-sized businesses. 

Summary

Database software development has mirrored the development of personal computers and mobile devices since the 1960’s.  The early databases were designed and used by computer programmers.  When desktop database solutions were marketed to small business owners, the software design began to change so that programming knowledge was not required.  Two popular desktop database solutions used today are Microsoft Access and FileMaker Pro. 

References


Sunday, January 13, 2013

Thursday, November 29, 2012

eBook Progress

I have been writing an eBook, Introduction to Data Analysis for Healthcare Professionals: Spreadsheet and Database Applications, for several weeks. As noted previously, the plan is to have the book in the Apple iBooks store at no charge.  I plan to use iBooks Author, so for the moment, am writing the book using MS Word.  To prepare the text for iBooks Author, I will save the text as a text file (.txt).  Once the final draft is completed, I will copy the text into iBooks Author.  The next steps will be to add the graphics and video files. I will design the videos as the last.The videos will be created using ScreenFlow.

I am considering publishing a version in the Amazon bookstore as an ePub file.  I will copy the text from MS Word into Apple iWork Pages and save the file in the ePub format. Of course the ePub book will not have the interactive features that are possible with iBooks Author. 

I have chapters about spreadsheets and databases in a good working draft form.  I have started a chapter on using FileMaker Pro tutorials.  I will be covering the following:
  • Spreadsheet software
    • Microsoft (MS) Excel
    • Apple iWork Numbers
    • Google Drive Spreadsheets
    • Free spreadsheet software (desktop and cloud apps)
  •  Database software
    • FileMaker Pro (available for  MS Windows and Mac PCs - about, includes history
    • FileMaker Go
    • MS Access - about, includes history
    • Free database software (desktop and cloud apps)
  • Spreadsheet tutorials for using
    • MS Excel
    • Apple iWork Numbers
    • Google Drive Spreadsheets
  • Database tutorials for using
    • FileMaker Pro for the Mac (MS Windows users should be able to find equivalent menus)
    • FileMaker Go
    • MS Access
I welcome any suggestions for the eBook. 

Tuesday, June 12, 2012

FileMaker Pro 12 vs Access Update

The past few weeks I have been learning how to use FileMaker Pro 12 so that I can teach it to students in a few weeks - there you go - the life of a teacher (learn one, do one, teach one).  The bottom line is that I really am liking FileMaker Pro!!  My son told me (sons are always smarter than mothers) that FileMaker Pro is more intuitive than Access and I have to agree.

FileMaker Pro makes fantastic use of "layouts."  Layouts are views of table and query data.  FileMaker Pro does not use the techie terms of queries.  The calculation formulas are identical to Access with the exception that FileMaker Pro uses semicolons ; instead of commas, in the calculations.

Okay - Microsoft - Access was the only app that kept me in the Microsoft system.  Since 1/3 of the students in the class I am teaching this summer are Mac users and I need to introduce them to database software - I am sucked into the Apple ecosystem.

I am also learning ScreenFlow software in order to show the students certain database functions.  Will have additional blogs on that software.  Learned an important lesson today on how the videos show up in YouTube in HD!  OMG!  Amazing!!  Thanks FL!!!!

Now if I could only do without any sleep I could be twice as productive :-)