Database Management System

DATABASE MANAGEMENT SYSTEM 7

DatabaseManagement System

DatabaseManagement System

OpenOfficeBase is a desktop database management system (DTBMS) which allows auser to make tables, forms and reports. One can also create queries.The software is available free of charge online. It is part of theOpenOffice.org office software and it is maintained by Oracle. Basehas similar characteristics to Microsoft Access it has a featurethat allows modification by the open source community (Malik,2007).

PreviouslyOpenOfficeBase installation process used its own independent setupapplication which was platform independent. Right now theinstallation process is done with its own platform specificinstallers.

OpenOfficeBasecomes with a new Java GUI installation wizard included in theproducts package (OpenOfficeBase with JRE-Java Runtime Environment).This installation wizard simplifies the installation process on allmajor platforms. GUI assists in selecting the destination directoryand the components. Java must be installed on the system for theinstallation wizard to work. The wizard supports all the majorinternational languages (Malik,2007).

Installationset is compatible to packages in different formats. We Save the OpenOffice installation files in the computer hard disk. Downloadingbegins and shows the estimated time it will take to finish. I thendouble-clicked on the downloaded file. The setup wizard began to run.Accepted the license terms then clicked &quotNext&quot until Ireached the &quotInstall Type&quot screen, then the ‘Finish’option.

Whenusing Windows Explorer or Mozilla Download Manager, one can navigateto the OpenOffice file downloaded. By using Windows Explorer one mustfind the downloaded file and double-click so as to launch theunpacking and installation program. By using Mozilla you open theDownload Manager and then highlight the file, before clicking thelaunch file. The unpacking program starts to run. (Yarnold,R., and Solty, R.C. 2011.p104)

Welcomewindow appears to show that OpenOfficeBase has been downloaded .ThenClick Next for the next process.

Whenthe License Agreement window comes up I used the scroll bar to gothrough all the license agreement text then selected ‘I accept theterms in the license agreement’ Clicked next and the customerinformation window appeared. The form can be left blank or a username/organization’s name entered. If one is logged in as anadministrator a prompt for installation for all users appears.

CustomerInformation form appears and must be completed, clicked ‘Next’for the setup window to appear. I selected complete set-up typebefore clicking ‘Next’ again then the file type window comes up.All files type selection is the default configuration. OfficeBase canonly open when the selected files are opened. De-select by clickingon the ticks to view and edit these file types. I chose files thatare not associated with OfficeBase, to avoid the long process ofrestarting the whole installation process. This was done by startingOpenOfficeBase then opened the file by choosing open in the filemenu. Once through with this I clicked ‘Next’. Ready to installwindows appears.

Whenthe ‘Ready to install window’ appears, I clicked on ‘Install’option to commence the installation process. When the installationwizard finished window appears I clicked ‘Finish’

WhenOpenOfficeBase is opened after installation, the accept licenseprompt window appears again. I accepted the license, entered my username and registered the copy.

NowI was able to Login using my user account, OfficeBase now appeared onthe programs sub-menu of the start menu. When I clicked one of theOpenOfficeBase components the welcome window appeared. By clicking on‘Next’ license agreement window appeared. After accepting theagreement by clicking ‘Accept and continue’, the personal datawindow was displayed. I then clicked ‘Next’ to display the userinfo window. Screen prompt to enter name appeared. I entered my namethis is important in documents and templates properties and forrecording of changes made to documents.

Theprogram is now successfully installed and can run. One can get onlinehelp assistance by choosing OpenOfficeBase Help from the help menu orby getting support online by choosing and clicking the support taboption available from the web pages (Yarnold,R., and Solty, R.C. 2011.p102).

Somedistribution soft wares that can be used alongside OpenOfficeBasehave strict guidelines about licensing this means some parts of theOpenOfficeBase which rely on soft wares which do not meet the strictcriteria may be disabled. Another lesson learned is to checkcarefully before using third-party built that does not have all theparts of OpenOffice required.

Otherprograms in OpenOffice do not rely completely on Java, such programssuch as writer calc and impress only require Java on rare occasions(Gabriel, 2009). One can prevent OpenOffice from prompting the use ofJava by unchecking on the tools menu go to OpenOffice.orgjava,and then uncheck. Java runtime however is highly recommended so as totake advantage of all the features available.

Initially,I started the installation process using Java Version 7 and the errormessage ‘No java installation found’ appeared. After changing toJava version 6, the process progressed smoothly. It seems that someJava versions have issues, or are not compatible at all. When theinstallation process delays or its not progressing as expected onecan always go to the Option button and choose java or OpenOffice torestart the whole process. I noted that installing direct from thewebsite is much faster and devoid of installation problems.

REFERENCES

Gabriel,G. (2009). AConceptual Guide to OpenOffice.org 3.ISBN 978-0-9778991-6-6

Malik,C. (2007). Software Installation Manual. Retrieved fromhttp:/www.nova.edu/fsehs/arc/tunon.pdf

Yarnold,R., &amp Solty, R.C. (2011). Optimal Data Analysis: A guide WithOfficeBase. Washington DC.