View a table in an editing grid and add, change, and delete records.Maintain indexes on the tables to make data access faster.Create new tables for your data - and also change them as your needs change.Over the past two and half years almost every document I have produced was done in and then saved in a format which others could read such as Microsoft Word. is not, however, xenophobic about file formats and happily saves documents in Word, Excel, and other foreign formats. Or you can wait until next year when Microsoft Office will feature a proprietary xml file format in an insecure software package that will set you back $500. Internally a text document consists primarily of XHTML and CSS, with equations stored as MathML, all W3.org standards. In some sense is simply a browser that reads the new industry standard openDocument formats. Images are stored in their native formats in these compressed folders. Do not attempt to download this during working hours!įor those who are not aware of some of the other details of, the document files are actually compressed folders containing a collection of xml files. The package ranges from 84 some Mb for Windows to 104 Mb for Linux. I have yet to explore the reports submodule of Base as my database lacks any data to fill a form, but I am confident from what I've seen that it will prove capable.ĭo be aware that OpenOffice is a more complete package than Microsoft Office. While the style options in the wizard are limited, the tools of Writer are available to customize the look and feel of the forms interface once out of the wizard.Īt the last step one names the form and then can move to work with the form. Whether the form will simply display data, allow data entry, or show existing data for editing can also be set. While working through the wizard, user choices are reflected in the document. Thus all of the power of Writer - think Word - are available in setting up a form. Of interest is that forms are actually set up in Writer, the word processing module. With only a few hours of experimentation under my belt, I cannot be certain but what multi-table queries are read-only in Base. The above query, joining two tables, was read-only. This query is based on a single table and is editable. The design window can be hidden or shown while the query is running. Running the query produces a split-screen effect. If not, then a graphical grid interface allows queries to be set up, including grouping queries using the function field. One has the option of writing SQL statements should one be in the mood. Double-clicking on the join allows one to set a left or right join. The relations design dialog box is drag and drop to set up a inner join. Relationships can be set up from the relationships dialog box, tables are added as needed. Where choices are limited, OpenOffice is very helpful with drop down lists. The typo in the word "numer" is strictly my own! A right-click on a unique field allows one to set a primary key. Setting up tables in the design view is direct and aided by OpenOffice automatically entering the IDENTITY command for a field set to AutoValue automatically. OpenOffice is always open to interacting with other vendors products. A wizard gets one started, allowing choices of whether to utilize an embedded database or whether to use a connector to another vendors database. The basic interface is rather reminiscent of Microsoft Access. The database package is now relational and replete with tantalizing features. October 2005 saw the arrival of Release Candidate 1 and the fifth birthday of OpenOffice. By March 2005 the branch adopted the OpenDocument standard, and in early fall betas one and two were released. The first iterations of the database in December 2004 were simple flat files with little additional functionality beyond a spreadsheet. When the 2.0 branch forked, I began playing with the pre-release 1.9 versions. Since 19 January 2003 when I first started using OpenOffice I have moved into the newest builds. That's no typo: OpenOffice remains free for the downloading - Windows, OS X, and Linux. The increase in price from $0 to $0 is made quite tolerable by this addition. To this winning mix OpenOffice 2.0 adds a database. has always been cross-platform with a word processing module the equal of Microsoft Word called Writer, a spreadsheet that is nearly indistinguishable from Excel in capabilities, a presentation module that has all the capabilities of PowerPoint, and three other modules that Office has never offered: a WYSIWYG web page editor, a stand-alone math editor, and a drawing package with dozens of export options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |