Difference between revisions of "Certification/6.0 Base"
From Apache OpenOffice Wiki
B michaelsen (Talk | contribs) |
|||
(7 intermediate revisions by 3 users not shown) | |||
Line 22: | Line 22: | ||
|- | |- | ||
| | | | ||
− | || | + | ||6. Base |
|| | || | ||
|| | || | ||
Line 28: | Line 28: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.1 Workspace |
|| | || | ||
|- | |- | ||
Line 34: | Line 34: | ||
|| | || | ||
|| | || | ||
− | || 1.1 | + | || 6.1.1 Startup Wizard |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 1.2 | + | || 6.1.2 Tables |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 1.3 | + | || 6.1.3 Report |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 1.4 | + | || 6.1.4 SQL Design |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || 1.5 | + | || 6.1.5 Design Views |
|- | |- | ||
| | | | ||
Line 63: | Line 63: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.2 Creating a database |
|| | || | ||
|- | |- | ||
Line 69: | Line 69: | ||
|| | || | ||
|| | || | ||
− | || | + | || 6.2.1 Creating a new database |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || | + | || 6.2.2 Creating database tables |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || | + | || 6.2.3 Defining relationships |
|- | |- | ||
| | | | ||
Line 88: | Line 88: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.3 Creating a database form |
|| | || | ||
|- | |- | ||
Line 94: | Line 94: | ||
|| | || | ||
|| | || | ||
− | || | + | || 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 |
|- | |- | ||
| | | | ||
Line 118: | Line 118: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.4 Accesing other data sources |
|| | || | ||
|- | |- | ||
Line 124: | Line 124: | ||
|| | || | ||
|| | || | ||
− | || | + | || 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 | ||
|- | |- | ||
| | | | ||
Line 149: | Line 153: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.5 Using datasources in OpenOffice.org |
|| | || | ||
|- | |- | ||
Line 155: | Line 159: | ||
|| | || | ||
|| | || | ||
− | || | + | || 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 |
|- | |- | ||
| | | | ||
Line 179: | Line 183: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.6 Creating queries |
|| | || | ||
|- | |- | ||
+ | | | ||
+ | || | ||
+ | || | ||
+ | || 6.6.1 Using Wizards to create queries | ||
+ | |- | ||
+ | | | ||
+ | || | ||
+ | || | ||
+ | || 6.6.2 Using Design View to create a query | ||
|- | |- | ||
| | | | ||
Line 190: | Line 203: | ||
| | | | ||
|| | || | ||
− | || | + | ||6.7 Creating reports |
|| | || | ||
|- | |- | ||
Line 196: | Line 209: | ||
|| | || | ||
|| | || | ||
− | || | + | || 6.7.1 Creating a static report |
|- | |- | ||
| | | | ||
|| | || | ||
|| | || | ||
− | || | + | || 6.7.2 Creating a dynamic 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 |