Getting started with OpenOffice Base
()
About this ebook
This book focuses on BASE, the OpenOffice database management system. The organization of information is carried out by numerous features such as tables, fields, primary key, queries, SQL expressions, forms, reports and other objects.
BASE enables you to connect to several data sources through drivers. Wizards will help you to better present controls in the forms.
The exercises will help you to understand the different data management techniques.
Enjoy your reading.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.
Read more from Remy Lentzner
Macros & Basic with OpenOffice Calc Rating: 0 out of 5 stars0 ratingsUPGRADING YOUR SKILLS WITH POWERPOINT Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH OPENOFFICE CALC Rating: 0 out of 5 stars0 ratingsGetting started with Numbers Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH OPENOFFICE WRITER Rating: 0 out of 5 stars0 ratingsGetting started with Sparkle Rating: 0 out of 5 stars0 ratingsUPGRADING YOUR SKILLS WITH OUTLOOK Rating: 0 out of 5 stars0 ratingsGetting started with OpenOffice Impress Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL Rating: 0 out of 5 stars0 ratings
Related to Getting started with OpenOffice Base
Related ebooks
GETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL Rating: 0 out of 5 stars0 ratingsGetting started with php & mysql: Professional training Rating: 0 out of 5 stars0 ratingsUpgrading your skills with Access Rating: 0 out of 5 stars0 ratingsExcel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5Oracle APEX Tips and Tricks Rating: 0 out of 5 stars0 ratingsAdvance Excel 2016: Training guide Rating: 0 out of 5 stars0 ratingsSQL Programming & Database Management For Noobee Rating: 0 out of 5 stars0 ratingsMicrosoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More Rating: 0 out of 5 stars0 ratingsExcel for Beginners 2023: A Step-by-Step and Comprehensive Guide to Master the Basics of Excel, with Formulas, Functions, & Charts Rating: 0 out of 5 stars0 ratingsPolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond Rating: 0 out of 5 stars0 ratingsExcel 2021 Rating: 4 out of 5 stars4/5Excel 2016: QuickStart Guide for Beginners Rating: 1 out of 5 stars1/5Oracle APEX Reporting Tips & Tricks Rating: 2 out of 5 stars2/5SQL Rating: 0 out of 5 stars0 ratingsAccess 2016: Up To Speed Rating: 5 out of 5 stars5/5Accounting Database Design Rating: 5 out of 5 stars5/5Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources Rating: 0 out of 5 stars0 ratingsSQL All-in-One For Dummies Rating: 4 out of 5 stars4/5Pivot Tables In Depth For Microsoft Excel 2016 Rating: 3 out of 5 stars3/5Improve your skills with Google Sheets: Professional training Rating: 0 out of 5 stars0 ratingsExcel 2016 Hands-On Lab Rating: 0 out of 5 stars0 ratingsMastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Programming Concepts in C++ Rating: 0 out of 5 stars0 ratingsData Analysis with Excel: Tips and tricks to kick start your excel skills Rating: 0 out of 5 stars0 ratings10 Techniques the Pros Know About Microsoft Excel Rating: 0 out of 5 stars0 ratingsMicrosoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators Rating: 4 out of 5 stars4/5
Databases For You
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Practical Data Analysis Rating: 4 out of 5 stars4/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing Rating: 0 out of 5 stars0 ratingsLearn SQL Server Administration in a Month of Lunches Rating: 3 out of 5 stars3/5Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Blockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Learn Git in a Month of Lunches Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratings100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5Learning Oracle 12c: A PL/SQL Approach Rating: 0 out of 5 stars0 ratingsBehind Every Good Decision: How Anyone Can Use Business Analytics to Turn Data into Profitable Insight Rating: 5 out of 5 stars5/5Access 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsExcel 2021 Rating: 4 out of 5 stars4/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsThe Data and Analytics Playbook: Proven Methods for Governed Data and Analytic Quality Rating: 5 out of 5 stars5/5Getting Started with SQL Server 2014 Administration Rating: 0 out of 5 stars0 ratingsA Concise Guide to Object Orientated Programming Rating: 0 out of 5 stars0 ratingsData Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5SQL: Practical Guide for Developers Rating: 2 out of 5 stars2/5Jump Start MySQL: Master the Database That Powers the Web Rating: 0 out of 5 stars0 ratingsCodeless Data Structures and Algorithms: Learn DSA Without Writing a Single Line of Code Rating: 0 out of 5 stars0 ratingsLearning ArcGIS Geodatabases Rating: 5 out of 5 stars5/5CompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratings
Reviews for Getting started with OpenOffice Base
0 ratings0 reviews
Book preview
Getting started with OpenOffice Base - Remy Lentzner
Chapter 1
The working environment
This chapter shows the working environment with its menu groups and different features.
1.1 At Startup
As soon as the OpenOffice application is installed on your computer, a menu appears offering different available modules (figure 1.1).
Figure 1.1 : Starting the OpenOffice application
You can work with the spreadsheet CALC, the word processing WRITER, the slides management system IMPRESS, a DRAWING application for making drawings and a tool for manipulating mathematical formulas. Everything is programmable with the BASIC language integrated in each module.
When the database module is started, a wizard takes over and several dialogues are proposed to create a database. Figure 1.2 shows the first step.
Figure 1.2 : Creating a database
If you press the Finish button, OpenOffice will ask you to enter a database name, then the working environment will be displayed.
Figure 1.3 shows this environment.
Figure 1.3 : The BASE working environment
If you choose Connect to an existing database, instead of Create a new database, OpenOffice will display a list with several database drivers which are adaptor programs required for making a connection to other systems of different types.
Figure 1.4 : Database drivers
The default driver is HSQL database engine. HSQL DB or HyperSQL DataBase is a SQL relational database system written in Java.
1.2 What is a database?
In the workplace, most people use spreadsheets that enable them to enter numbers and formulas. This numerical data is placed in cells within a group of columns and rows. When it comes to manipulating numerical or even alphabetical values in columns, the spreadsheet is the ideal