Publisher: Open

Version: 3.1
Length: 1 day
Course-ID: 084291

Course Description

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 tasks, 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.


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
Appendices
  • Appendix A: Administering Base
  • Appendix B: Working with OpenOffice Base Extensions