CCNC/CNCC Module 5/The database application

5.1 The OpenOffice 2.0 Database Application

The focus of this section is threefold; first, you will develop an understanding of the a database, and how it can be used to gather, store and report on data that is within a specified subject domain. This first tutorial will also explore the basics of how to design a database for data integrity and for longevity of usefulness. When we speak of data integrity we mean the accuracy and reduced duplication required to keep data healthy. When we speak of longevity of usefulness we mean the database design has considered many of the future data needs. These two attributes may seem lofty goals, with thought and the application of database theory a strong and integral database can be built that will serve many needs for a good duration of time. Second, you will play with connecting to an existing database and how to create and save a new database. This second tutorial will also explore methods of how to get help when building, using and maintaining a database. Third, you will explore the application settings available within OpenOffice Base. These settings help you understand and manage the database application environment.

Tutorial 5.1.1 - Database Concepts

Outcomes

Upon completion of this tutorial the learner will: Understand what a database is Understand how a database is organized in terms of tables, records and fields Understand what a key is; in particular, a primary key Understand what an index is Understand the purpose of relating tables in a database Understand the importance of setting rules to ensure relationships between tables are valid

Tutorial 5.1.2 - First Steps with Databases

Outcomes

In this tutorial we will: Open (and close) a database application Open, log onto an existing database Create a new database Save a database to a location on a drive Use available Help functions Close a database

Tutorial 5.1.3 - Adjusting the application settings

Outcomes

In this tutorial we will: Change between view modes in a table, form, report Display, hide built-in toolbars Others