Difference between revisions of "Certification/6.0 Base"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(8 intermediate revisions by 3 users not shown)
Line 16: Line 16:
 
||
 
||
 
|-
 
|-
−
|Draw
+
|Base
 
||
 
||
 
||
 
||
Line 22: Line 22:
 
|-
 
|-
 
|
 
|
−
||1. Base
+
||6. Base
 
||
 
||
 
||  
 
||  
Line 28: Line 28:
 
|
 
|
 
||
 
||
−
||1.1 The Base interface
+
||6.1 Workspace
 
||  
 
||  
 
|-
 
|-
Line 34: Line 34:
 
||
 
||
 
||
 
||
−
|| 1.1 Menus
+
|| 6.1.1 Startup Wizard
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2 Toolbars
+
|| 6.1.2 Tables
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3 Rulers
+
|| 6.1.3 Report
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4 Status bar
+
|| 6.1.4 SQL Design
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5 Workspace
+
|| 6.1.5 Design Views
 
|-
 
|-
 
|
 
|
Line 63: Line 63:
 
|
 
|
 
||
 
||
−
||1.2 Creating a database
+
||6.2 Creating a database
 
||  
 
||  
 
|-
 
|-
Line 69: Line 69:
 
||
 
||
 
||
 
||
−
|| 1.2.1 Creating a new database
+
|| 6.2.1 Creating a new database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.2 Creating database tables
+
|| 6.2.2 Creating database tables
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.2.3 Defining relationships
+
|| 6.2.3 Defining relationships
 
|-
 
|-
 
|
 
|
Line 88: Line 88:
 
|
 
|
 
||
 
||
−
||1.3 Creating a database form
+
||6.3 Creating a database form
 
||  
 
||  
 
|-
 
|-
Line 94: Line 94:
 
||
 
||
 
||
 
||
−
|| 1.3.1 Using the wizard to create a form
+
|| 6.3.1 Using the wizard to create a form
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.2 Modifying a form
+
|| 6.3.2 Modifying a form
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.3 Creating form in Design View
+
|| 6.3.3 Creating form in Design View
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.3.4 Creating subforms in Design View
+
|| 6.3.4 Creating subforms in Design View
 
|-
 
|-
 
|
 
|
Line 118: Line 118:
 
|
 
|
 
||
 
||
−
||1.4 Accesing other data sources
+
||6.4 Accesing other data sources
 
||  
 
||  
 
|-
 
|-
Line 124: Line 124:
 
||
 
||
 
||
 
||
−
|| 1.4.1 Accesing a dBase database
+
|| 6.4.1 Database Drivers
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.2 Accesing a Mozilla addressbook
+
|| 6.4.2 Accesing a dBase database
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.3 Accesing spreadsheets
+
|| 6.4.3 Accesing a Mozilla addressbook
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.4.4 Registering database created by OOo 2.x
+
|| 6.4.4 Accesing spreadsheets
 
|-
 
|-
 
|
 
|
 
||
 
||
−
||1.5 Using datasources in OpenOffice.org
 
 
||
 
||
 +
|| 6.4.5 Registering database created by OOo 2.x
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.1 Viewing data sources
+
||
 
|-
 
|-
 +
|
 
||
 
||
 +
||6.5 Using datasources in OpenOffice.org
 
||
 
||
−
|| 1.5.2 Editing data sources
 
 
|-
 
|-
 +
|
 
||
 
||
 
||
 
||
−
|| 1.5.3 Launching Base to work with data sources
+
|| 6.5.1 Viewing data sources
 
|-
 
|-
 +
|
 
||
 
||
 
||
 
||
−
|| 1.5.4 Using data sources in OOo documents
+
|| 6.5.2 Editing data sources
 
|-
 
|-
 +
|
 
||
 
||
−
|| 1.6.0 Creating queries
 
 
||
 
||
 +
|| 6.5.3 Launching Base to work with data sources
 
|-
 
|-
 +
|
 
||
 
||
−
|| 1.7.0 Creating reports
 
 
||
 
||
 +
|| 6.5.4 Using data sources in OOo documents
 
|-
 
|-
 +
|
 +
||
 
||
 
||
 
||
 
||
−
|| 1.7.1 Creating a static report
 
 
|-
 
|-
 +
|
 
||
 
||
 +
||6.6 Creating queries
 
||
 
||
−
|| 1.7.1 Creating a dynamic report
 
 
|-
 
|-
 +
|
 +
||
 +
||
 +
|| 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
 +
|-
 +
|
 
||
 
||
 
||
 
||
−
|| 1.7.1 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/6.0_Base&oldid=149566"
Personal tools