Difference between revisions of "Certification/6.0 Base"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Syllabus - Base)
 
(4 intermediate revisions by 2 users not shown)
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
 
|-
 
|-
 +
|
 +
||
 +
||
 +
|| 6.4.5 Registering database created by OOo 2.x
 
|-
 
|-
 
|
 
|
Line 149: Line 153:
 
|
 
|
 
||
 
||
−
||1.5 Using datasources in OpenOffice.org
+
||6.5 Using datasources in OpenOffice.org
 
||
 
||
 
|-
 
|-
Line 155: Line 159:
 
||
 
||
 
||
 
||
−
|| 1.5.1 Viewing data sources
+
|| 6.5.1 Viewing data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.2 Editing data sources
+
|| 6.5.2 Editing data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.3 Launching Base to work with data sources
+
|| 6.5.3 Launching Base to work with data sources
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.5.4 Using data sources in OOo documents
+
|| 6.5.4 Using data sources in OOo documents
 
|-
 
|-
 
|
 
|
Line 179: Line 183:
 
|
 
|
 
||
 
||
−
||1.6 Creating queries
+
||6.6 Creating queries
 
||
 
||
 
|-
 
|-
Line 185: Line 189:
 
||
 
||
 
||
 
||
−
|| 1.6.1 Using Wizards to create queries
+
|| 6.6.1 Using Wizards to create queries
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.6.2 Using Design View to create a query
+
|| 6.6.2 Using Design View to create a query
 
|-
 
|-
 
|
 
|
Line 199: Line 203:
 
|
 
|
 
||
 
||
−
||1.7 Creating reports
+
||6.7 Creating reports
 
||
 
||
 
|-
 
|-
Line 205: Line 209:
 
||
 
||
 
||
 
||
−
|| 1.7.1 Creating a static report
+
|| 6.7.1 Creating a static report
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.7.2 Creating a dynamic report
+
|| 6.7.2 Creating a dynamic report
 
|-
 
|-
 
|
 
|
 
||
 
||
 
||
 
||
−
|| 1.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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Certification/6.0_Base&oldid=149566"
Personal tools