OpenOffice Base 2.3

Overview

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer-based applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and design and modify databases and their various objects using the OpenOffice Base relational database application. Course Objectives

You will create and modify new databases and their various objects. Prerequisites

To ensure the successful completion of the OpenOffice Base 2.3 course, students should be familiar with using personal computers.

Target Student

Business professionals who wish to learn the basic operations of OpenOffice Base program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. Performance-Based Objectives

Upon successful completion of this course, students will be able to:

examine basic database concepts and explore the OpenOffice Base 2.3 environment.

design a simple database.

build a new database with related tables.

manage data in a table.

query a database to obtain the required results.

design forms.

generate reports.

Hardware Requirements For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

A 1 GHz Pentium-class processor or faster.
256 MB of RAM. Recommended 512 MB of RAM.
A 10 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for the Office installation.
A CD-ROM drive.
A mouse or other pointing device.
1024 x 768 resolution monitor recommended.
Network cards and cabling for local network access.
Internet access (contact your local network administrator).
A printer along with its drivers installed on the PC.
A projection system to display the instructor’s computer screen.

Platform Requirements

Microsoft� Windows� XP

Software Requirements

OpenOffice.org 2.3 Suite

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Course duration 1 Day(s) Course outline Lesson 1: Getting Started with OpenOffice Base 2.3

Topic 1A: An Overview of Database Concepts

Topic 1B: Explore the OpenOffice Base Interface

Topic 1C: Customize the Base Environment

Topic 1D: Obtain Help in OpenOffice Base

Lesson 2: Designing a Database

Topic 2A: Describe the Relational Database Design Process
Topic 2B: Define Database Purpose
Topic 2C: Review Existing Data
Topic 2D: Determine Fields
Topic 2E: Group Fields into Tables
Topic 2F: Normalize Data
Topic 2G: Designate Primary and Foreign Keys
Topic 2H: Determine Table Relationships

Lesson 3: Building a Database

Topic 3A: Create a New Database
Topic 3B: Create a Table
Topic 3C: Enter Data in a Table
Topic 3D: Modify the Table Design
Topic 3E: Manage Tables
Topic 3F: Create a Table Relationship
Topic 3G: Access Data from Other Data Sources

Lesson 4: Managing Data in a Table

Topic 4A: Modify Table Data
Topic 4B: Sort Records
Topic 4C: Filter Records

Lesson 5: Querying a Database

Topic 5A: Create a Query
Topic 5B: Add Criteria to a Query
Topic 5C: Add a Calculated Field to a Query
Topic 5D: Perform Calculations on a Record Grouping
Topic 5E: Create a View

Lesson 6: Designing Forms

Topic 6A: Create a Form
Topic 6B: Work with a Form
Topic 6C: Modify the Design of a Form
Topic 6D: Modify Form Controls

Lesson 7: Generating Reports

Topic 7A: Create a Report
Topic 7B: Modify the Elements of a Report
Topic 7C: Enhance the Appearance of a Report
Topic 7D: Add a Calculated Field to a Report
Topic 7E: Prepare a Report for Print
Topic 7F: Export a Report