OpenOffice 3.1:Base 3.1

Getting Started with OpenOffice Base
Overview of Database Concepts
Explore the Base Interface
Customize the Base Environment
Use Help in Base

Designing a Database
Understand the Relational Database Design Process
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships

Building a Database
Create a Database
Create a Table
Enter Data in a Table
Modify Table Design
Manage Tables
Create a Table Relationship
Access Data from Other Data Sources

Managing Data in a Table
Modify Table Data
Sort Records
Filter Records

Querying the Database
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Group
Create a View

Designing Forms
Create a Form
Work with a Form
Modify the Design of a Form
Modify Form Controls

Generating Reports
Create a Report
Modify the Layout of a Report
Enhance the Appearance of a Report
Add a Calculated Field to a Report

Appendix A: Administering Base
Appendix B: Working with OpenOffice Base Extensions

After completing this course, students will know how to:

Examine the basic database concepts and explore the OpenOffice Base environment so thatyou will be all set to work with the application.
Design a database using the relational database design process to suit your needs.
Build a new database with related tables so that it becomes easier to retrieve and manage data.
Manage data in a table by using the Table Data View toolbar, the Form Navigation bar, the Sort Order dialog box, the Standard Filter dialog box, and operators.
Query a database to obtain required results.
Design forms to ensure quick and accurate data entry.
Generate reports so that you can analyze data effectively.
Administer Base so that you can re-create information in the database in a different application.
Work with OpenOffice.org extensions.

Prerequisites

Use of Personal Computers