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
Software Requirements
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
