Database Programming with OpenOffice. Org Base and Basic


Book Description

OpenOffice.org has been gaining popularity over the years, and with the introduction of the database module (Base) in release 2.0, there has been more to learn. When working with databases, you will come to a point where the basic features are not sufficient. Databases have a large range of uses, and therefore, there is always a need for customization.This book will teach you how to write code in the BASIC language (also known as StarOffice Basic/OpenOffice.org Basic or just plain Basic) to enhance the features of OpenOffice.org Base. After reading this book, you will know how to: use UNO services to query, insert, update, and delete records in a database; use forms, sub-forms and form controls to manipulate data; use form and form control events; programmatically import and export data; and much more.You will also have an overall understanding of the database API, so that you can create custom solutions.




OpenOffice.org Macros Explained


Book Description

This book provides an introduction to the creation and management of macros in OpenOffice. Numerous examples and explanations demonstrate proper techniques and discuss known problems and solutions. The underlying data structure is discussed and techniques are introduced to evaluate OpenOffice objects, facilitating the use of returned objects in the absence of sufficient documentation.







Learn OpenOffice.org Spreadsheet Macro Programming


Book Description

"This book teaches the OOoBasic language and the Calc object model, so that you can manipulate spreadsheets and data from within your programs. You will also see how to create dialog boxes and windows for friendly user interfaces, and how to integrate your spreadsheets with other applications, for example writing spreadsheet data to a document, or capturing data from a database, and using the spreadsheet for generating advanced calculations and reports"--Resource description p.




Getting Started with LibreOffice 5.1


Book Description

LibreOffice is a freely-available, full-featured office suite that runs on Windows, Linux, and Mac OS X computers. This book is for anyone who wants to get up to speed quickly with LibreOffice 5.1. It introduces Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor), and Base (database). This book was written by volunteers from the LibreOffice community. Profits from the sale of this book will be used to benefit the community.




Getting Started with LibreOffice 6.0


Book Description

LibreOffice is a freely-available, full-featured office suite that runs on Windows, Linux, and macOS computers. This book is for anyone who wants to get up to speed quickly with LibreOffice 6.0. It introduces Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor), and Base (database). This book was written by volunteers from the LibreOffice community. Profits from the sale of this book will be used to benefit the community.




Getting Started with LibreOffice 5.2


Book Description

LibreOffice is a freely-available, full-featured office suite that runs on Windows, Linux, and Mac OS X computers. This book is for anyone who wants to get up to speed quickly with LibreOffice 5.2. It introduces Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor), and Base (database). This book was written by volunteers from the LibreOffice community. Profits from the sale of this book will be used to benefit the community.




Learning MySQL and MariaDB


Book Description

"With an easy, step-by-step approach, this guide shows beginners how to install, use, and maintain the world's most popular open source database: MySQL. You'll learn through real-world examples and many practical tips, including information on how to improve database performance. Database systems such as MySQL help data handling for organizations large and small handle data, providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. This book is also useful for web developers and programmers interested in adding MySQL to their skill sets. Topics include: Installation and basic administration ; Introduction to databases and SQL ; Functions, subqueries, and other query enhancements ; Improving database performance ; Accessing MySQL from popular languages"--




C# Database Basics


Book Description

Working with data and databases in C# certainly can be daunting if you’re coming from VB6, VBA, or Access. With this hands-on guide, you’ll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C#—basic skills you need if you intend to program with this language. No previous knowledge of C# is necessary. By following the examples in this book, you’ll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book’s code samples will help you get started on your own projects. Create a Windows Forms application with a datagrid Connect to multiple data sources, including Access and SQL Server Add, edit, and update data in a database you choose and design Enable users to choose their data source at runtime Learn the roles of DataTable, DataView, BindingSource, Filters, and other objects Understand where variables are declared and how they impact the code Build a simple web service that connects to a database




Information Systems for Business and Beyond


Book Description

"Information Systems for Business and Beyond introduces the concept of information systems, their use in business, and the larger impact they are having on our world."--BC Campus website.