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. You will be prompted to name it (the name can be anything you like).įinally, save the whole database from the main Base window ( File > Save ). 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. Accept the default Field Type of Text and leave Description blank. On three lines, enter under Field Name Name, Address and Telephone. If this is not done, the form you create later will be much trickier to use and may generate errors for the user. Setting up the Primary Key field with Auto Value set to Yes is an important step. In the Field Properties at the bottom of the window is an Auto Value option change this to Yes. In the gray box at the left of the line, right-click and select Primary Key, bringing up a key icon in the box. On the first line, enter under Field Name ID and set the Field Type to Integer. We will have just three fields: Name, Address and Telephone. Use the Table Design window (Figure 382) to tell Base which fields to create. Here we are going to create a small table as an example.Ĭhoose Tables in the left-hand column, then choose Create Table in Design View under Tasks. Again, this is covered in more detail in the “Getting Started with Base†chapter in the Getting Started guide. The left-hand panel is Database, with icons for Tables, Queries, Forms and Reports. Unlike creating other documents in OOo, databases have to be saved when you first create them.Īfter saving the database, you should see the main Base window (Figure 381), which contains three panels. You need to do this if you want to link your forms into it.Ĭlick Finish and save your new database, giving it a name. Registering the database just means that it can be accessed from other OOo components such as Writer and Calc. On the next page, select Yes, register the database for me and Open the database for editing. Select Create a new database and click Next. Select File > New > Database to start the Database Wizard (Figure 380). We will give a short guide here to creating a very simple database with OOo Base. The chapter titled “Getting Started with Base†in the Getting Started guide covers in more detail how to create a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |