OpenOffice.org 3.1 Base

Course length: 1.0 day(s)

Course Description
You will create and modify new databases and their various objects.

www.Openoffice.org is the leading open-source office software suite. It works on all common PCs, it stores all data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used free of charge for any purpose.

Target Student:
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.

Delivery Method:
Instructor-led Training

After completing this course the student should be able to:

  • examine the basic database concepts and explore the OpenOffice Base environment so that you 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.

Prerequisites:
To ensure successful completion of OpenOffice.org 3.1 Base course, students should be familiar with using personal computers.

Course Content

Lesson 1: Getting Started with OpenOffice Base

  • Topic 1A: Overview of Database Concepts
  • Topic 1B: Explore the Base Interface
  • Topic 1C: Customize the Base Environment
  • Topic 1D: Use Help in Base
Lesson 2: Designing a Database

  • Topic 2A: Understand the Relational Database Design Process
  • Topic 2B: Review Existing Data
  • Topic 2C: Determine Fields
  • Topic 2D: Group Fields into Tables
  • Topic 2E: Normalize Data
  • Topic 2F: Designate Primary and Foreign Keys
  • Topic 2G: Determine Table Relationships
Lesson 3: Building a Database

  • Topic 3A: Create a Database
  • Topic 3B: Create a Table
  • Topic 3C: Enter Data in a Table
  • Topic 3D: Modify 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 the 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 Group
  • 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 Layout of a Report
  • Topic 7C: Enhance the Appearance of a Report
  • Topic 7D: Add a Calculated Field to a Report
Appendix A: Administering Base
Appendix B: Working with OpenOffice Base Extensions
© 2010 Carolina Computer Training
Home | Email the Webmaster