KPresenter & Kexi
Presenter is KOffice’s presentation program. It has the same interface elements expected for the menu, toolbars and the slides and you will not be losing too much time on learning what is where. For those who use presentation software, the menus and the toolbars are at the top of the screen, slide views are at the left pane and the rest of the screen is the main slide design.
KPresenter offers you the basic functionalities of any on-screen presenting applications. You can insert/edit text, use bullets, numbering, indentation, color etc., include and edit graphics, set background, set header/footer, group/ungroup of elements and of course use animations. Inserting tables is a little bit weird though, because KPresenter offers KSpread to insert tables. Since we do not expect a fully functional table in a presentation slide, it would be much better to include a simple table, I believe. In addition, do not look for a master slide. This has a different implementation in the program with “Sticky Objects" which are displayed on each slide.
KPresenter can output the presentation in HTML format, which is particularly handy if you want to publish your presentation in a web page. Importing from Microsoft PowerPoint is still under development.
Kexi is KOffice’s database application. Although it is one of KOffice’s younger members, it has come a long way. It is a simple database application that lets the users design and use databases without going deep into database notions. However, to begin working with database applications differ from working with a word processor and you have to know some basics to design a database.
Like other database applications, Kexi has tables, queries and forms. The data is stored in the tables, extracted, computed and manipulated by queries and easily input with forms. Kexi has all these features handy in terms of interface. If you know the simple database concepts you will get going easily.
One of the Kexi’s powerful points is that it can either work with its own database in .kexi files or connect and work with MySQL/PostGresQL through plug-ins both for local and remote databases. The program asks you with the launch which database type you prefer to work and the relevant component has to be installed for PostGresQL, and kexi-driver-mysql for MySQL.
Queries are dynamic, meaning that in addition to working with one table you can also work with multiple data tables.
Forms are created by the users visually and it is possible to insert additional buttons, such as check boxes, radio buttons, text fields etc. (called widgets in Kexi) in the form design mode.
Kexi can import Microsoft Access databases and allows you to migrate from MySQL/PostGresQL. The program has improved support for working with CSV (Comma Separated Values) files as well.