OpenOffice Base 2.3

Course Description
Course Outline

Course Description

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. You will create and modify new databases and their various objects.

Who should attend

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.

What will I learn

How to 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 and generate reports.

We offer a range of OpenOffice training courses

Getting Started with OpenOffice Base 2.3
An Overview of Database Concepts Explore the OpenOffice Base Interface Customize the Base Environment Obtain Help in OpenOffice Base
Designing a Database
Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships
Building a Database
Create a New Database Create a Table Enter Data in a Table Modify the 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 a Database
Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping 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 Elements of a Report Enhance the Appearance of a Report Add a Calculated Field to a Report Prepare a Report for Print

Publisher:	Open
Version:	2.3
Length:	1 day
Course-ID:	084290

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Small group, relaxed and open atmosphere. Felt comfortable admitting being lost or confused

- British Gas