Difference between revisions of "Certification/6.0 Base"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (changed chap # from 1 to 6, rh.)
 
(2 intermediate revisions by one other user not shown)
Line 28: Line 28:
 
|
 
|
 
||
 
||
||6.1 The Base interface
+
||6.1 Workspace
 
||  
 
||  
 
|-
 
|-
Line 34: Line 34:
 
||
 
||
 
||
 
||
|| 6.1.1 Menus
+
|| 6.1.1 Startup Wizard
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.1.2 Toolbars
+
|| 6.1.2 Tables
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.1.3 Rulers
+
|| 6.1.3 Report
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.1.4 Status bar
+
|| 6.1.4 SQL Design
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.1.5 Workspace
+
|| 6.1.5 Design Views
 
|-
 
|-
 
|
 
|
Line 124: Line 124:
 
||
 
||
 
||
 
||
|| 6.4.1 Accesing a dBase database
+
|| 6.4.1 Database Drivers
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.4.2 Accesing a Mozilla addressbook
+
|| 6.4.2 Accesing a dBase database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.4.3 Accesing spreadsheets
+
|| 6.4.3 Accesing a Mozilla addressbook
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
|| 6.4.4 Registering database created by OOo 2.x
+
|| 6.4.4 Accesing spreadsheets
 
|-
 
|-
 +
|
 +
||
 +
||
 +
|| 6.4.5 Registering database created by OOo 2.x
 
|-
 
|-
 
|
 
|
Line 217: Line 221:
 
|| 6.7.3 Modifying a report
 
|| 6.7.3 Modifying a report
 
|-
 
|-
 +
[[Category:Certification]]

Latest revision as of 09:17, 25 November 2009

Syllabus - Base

First Draft

Module Chapter Topic Knowledge
Base
6. Base
6.1 Workspace
6.1.1 Startup Wizard
6.1.2 Tables
6.1.3 Report
6.1.4 SQL Design
6.1.5 Design Views
6.2 Creating a database
6.2.1 Creating a new database
6.2.2 Creating database tables
6.2.3 Defining relationships
6.3 Creating a database form
6.3.1 Using the wizard to create a form
6.3.2 Modifying a form
6.3.3 Creating form in Design View
6.3.4 Creating subforms in Design View
6.4 Accesing other data sources
6.4.1 Database Drivers
6.4.2 Accesing a dBase database
6.4.3 Accesing a Mozilla addressbook
6.4.4 Accesing spreadsheets
6.4.5 Registering database created by OOo 2.x
6.5 Using datasources in OpenOffice.org
6.5.1 Viewing data sources
6.5.2 Editing data sources
6.5.3 Launching Base to work with data sources
6.5.4 Using data sources in OOo documents
6.6 Creating queries
6.6.1 Using Wizards to create queries
6.6.2 Using Design View to create a query
6.7 Creating reports
6.7.1 Creating a static report
6.7.2 Creating a dynamic report
6.7.3 Modifying a report
Personal tools