Download Using Databases – OpenOffice.org Base

Table of Contents
DATABASES _________________________________________________________ 4
Introduction to Databases ________________________________________________ 4
Tables ________________________________________________________________________ 5
Forms ________________________________________________________________________ 7
Queries _______________________________________________________________________ 8
Reports _______________________________________________________________________ 9
Creating a Database _____________________________________________________ 9
Creating Databases and Objects with a Wizard _______________________________________ 9
Saving a Database _____________________________________________________________ 16
Actions in a Database ___________________________________________________ 19
Opening a Database File ________________________________________________________ 19
Actions with Database Objects ___________________________________________________ 20
Creating a Table in Design View __________________________________________________ 22
Modifying a Form in Design View _________________________________________________ 26
Entering, Modifying and Sorting Data ______________________________________ 28
Entering Data in a Database _____________________________________________________ 28
Creating a New Record _________________________________________________________ 29
Deleting a Record (Data) ________________________________________________________ 29
Field Index Management _______________________________________________________ 30
Record Sorting ________________________________________________________________ 31
Record Search ________________________________________________________________ 32
Data Retrieval _________________________________________________________ 35
Applying Filters _______________________________________________________________ 35
Creating Queries ______________________________________________________________ 37
Creating a Query with a Wizard __________________________________________________ 38
Creating a Query in Design View __________________________________________________ 41
Information Output _____________________________________________________ 43
Reports ______________________________________________________________________ 43
Data Export __________________________________________________________________ 49
Printing______________________________________________________________________ 51
Additional Actions in the Application _______________________________________ 55
Application Help ______________________________________________________________ 55
Displaying and Hiding Toolbars ___________________________________________________ 56