Hello, I would like to know if anyone is carrying on the OOo 2 Base Guide. I have checked at the OOoAuthors site but I haven't found any finished works.
Here in the Italian group, we have a very good guide (in Italian) that could be used / translated in English. http://www.softcombn.com/04_docfree_05.htm (in Italian) The contents are available here: http://www.softcombn.com/04_docfree_05_a.htm (in Italian) Below I have attached a Google Translated version in order to provide an idea of the contents. Actually the licence is Creative Commons, please clear if this can be a problem. Is there the possibility to merge this work in the guide? Any opinions? Thanks Andrea Sanavia --- Contents 2,0 OpenOffice and the Database (Index of the Contents) * 1. Introduction * 1.1 Better but not to be deceived.... 1,2 Used configuration 1,3 Installation of the Applications * 2. The world of the Database * 2.1 First steps.... 2.2 We plan a Database 2.3 The Table 2,4 Indices 2.5 Main Types of Give to you 2.5.1 Fields of type Tighten 2.5.2 Fields of Numerical type 2.5.3 Fields of Data/Ora Type 2.5.4 Fields of Booleano Type 2.5.5 Fields of Binary type 2.5.6 Particular fields: Entire to increment automatic rifle 2.5.7 Particular fields: Timestamp 2.6 Our Database of example 2,6,1 Structure of Arches to you 2,6,2 TbMedia Table - > The Main Archives 2,6,3 Table TbSupporti - > Tipologie of the Supports 2,6,4 Table TbArgomenti - > Tipologie of the Arguments 2,6,5 TbUtenti table - > the Archives of the Customers of Lend to you 2,6,6 TbPrestiti table - > the Archives of lend to you and of the restitutions 2,7 Referenziale integrity 2,8 Serveur di Database 2,9 Modalities of access to Give to you 2.10 We speak a little Structured Query Language * 3. Database Serveur MySql * 3,1 Installation 3,1,1 Installation in Windows of the Serveur 3,1,2 Installation in Windows of the Driver MyODBC 3,1,3 Installation in Windows of the Client programs 3,1,4 Installation in Linux of the Serveur 3,1,5 Installation in Linux di MyODBC 3,1,6 Installation in Linux of the Client programs 3.2 The Types of Give to you 3,3 MySql Administrator 3,3,1 MySql Administrator: parameters of start of the Serveur 3,3,2 MySql Administrator: management of the Database 3,3,3 MySql Administrator: Creation of our Database of example 3,4 Management of the Tables 3,4,1 Mysql Administrator: Modification of the structure of the Tables 3,4,2 MySql Administrator: to add the Tables to Mediateca 3,4,3 Referenziale integrity 3,4,4 MySql Administrator: Formulation of Referenziale Integrity 3,5 Backup of Arches MySql to you 3,5,1 MySql Administrator: Backup of Gives to you 3,5,2 MySql Administrator: Restore of Gives to you 3.6 The emergency: Customers and Rights 3,6,1 Management of the emergency from commando line 3,6,2 MySql Administrator: the emergency 3,7 Execution of Statements SQL 3.8 Other Tools Graphical for the management of MySql * 4. Database Serveur PostgreSQL * 4,1 Installation 4,1,1 Installation in Windows 4,1,2 Files of configuration in Windows 4,1,3 Installation in Linux 4,2 Types of Give to you 4,3 PgAdmin III 4,3,1 PgAdmin: Creation of the Database of example 4,3,2 PgAdmin: adding of the Tables 4,3,3 PgAdmin: formulation of the Primary Key 4,3,4 PgAdmin: definition of the Indices 4,3,5 PgAdmin: Referenziale integrity 4,4 Backup of Arches Postgres to you 4,4,1 PgAdmin: Backup and Restore of Arch to you 4.5 The emergency: customers and rights 4,5,1 PgAdmin: creation of a new customer 4,5,2 PgAdmin: creation of a new Group 4,5,3 PgAdmin: allocation of the rights * 5. Finally OOo.... * 5.1 As OpenOffice is connected to the Database 5,1,1 Generation of the DSN in Windows 5,1,2 DSN for MySql 5,1,3 DSN for Postgres 5,1,4 Generation of the DSN for MySql in Linux 5.2 The source gives you of OOo 5.3 The Wizard of the Module "Base" * 6. The Module "Base" * 6,1 Tables 6,2 Modification of the structure of a Database 6,3 Searches 6,4 Com' was... com' is... * 7. The Mediateca * 7,1 Philosophies to comparison 7.2 The Form 7.3 The Form for the Mediateca 7.4 Some information in more * 8. Advanced use of the Forms * 8.1 We leave from the end 8.2 First part - the Table 8.2.1 A more complex Search... 8.2.2 A new Form.... 8.3 The second part - the Card 8.4 To complete the job... * 9. Management of the Relationships * 9.1 The Relationships of the Module Base 9.2 To the inside of a Relationship.... 9,3 Relationship of Group 9.4 To alter a Relationship that is... * 10. Relationships.... Old Style * 10,1 Calc in order to generate and to print Report 10.2 The Report in Calc * 11. Use of OOo with other motors of Database * 11,1 Dbase 11,2 HSQL 11,3 Microsoft Access (MDB) 11,4 Microsoft Sql Serveur 11,5 Oracle 11,6 Sybase * 12. Advanced use of.... * 12,1 Searches 12,1,1 Searches on single Tables 12,1,2 Searches with parameters 12,1,3 Searches with more Tables 12,1,4 Searches with more parameters 12,1,5 Criteria ... 12,1,6 Modifiable searches 12,1,7 Direct execution of Commandos SQL 12,1,8 Groupings and mathematical Formulas 12,1,9 Aesthetic treatment 12,2 Forms 12,3 Relationships 12,4 Macro and Linguaggio di Programmazione * 13. Appendix To - Installation of OpenOffice * 13,1 Installation in Windows 13,2 Installation in Linux * 14. B appendix - Outline of the Database di Example * * 15. Appendix C - Type of Gives you of MySql * 15,1 Values of Numerical Type 15,1,1 Range of the values admitted for entire the numerical type 15,2 Values of Type Date and Time 16.Valori of Type Tighten
