CCNC/CCNC Module 5/The database application

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.

Database Concepts

Outcomes

Upon completion of this tutorial the learner will: Describe a database and how it is used Discuss how a database is organized in terms of tables, records and fields Differentiate an entity from an attribute Describe the different data types and how they are used Normalize a database to second normal form

Database Design

Outcomes

Upon completion of this tutorial the learner will: Normalize a database to third normal form Identify a key field; in particular, a primary key Describe an index, its purpose, and how it is implemented Discuss the purpose of relating tables in a database Set rules to ensure relationships between tables are valid

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

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 (Oo 2.0 TBD)