You are here: Home / OpenOffice.org / English / Userguide3 / Base3 / Outline

Outline

10 Aug 2007: Jean's version of an outline proposed by Drew Jensen.


Note: Sections in chapters will not be numbered in the published version. Numbers are used here to help in planning the book. Chapter titles are draft and can probably be improved upon, but I would like to keep the title of Ch1 (Introducing Base) for consistency with other books.

Refer to <a href="http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning">this wiki page</a> for Drew's version (see "Discussion" tab).

Preface (could be chapter 1 and renumber all the other chapters)

To cover Drew’s suggestions to help people with where to start reading and suggest a different route through the chapters:

+ I have a Base database ( *.odb file ) and I need to work with it.

+ I need to create a database, like I have done before with ( XXXX )[Access, FileMaker..]

+ I need to create a database, like I have with Excel or Calc before.

+ I think I want a database, but have never used a database manager before

The examples used in the book

[not sure whether this belongs in here]: A brief history of OO.o databases and Base


Chapter 1: Introducing Base

1.1 What is Base?

1.2 How to open a Base file (or start a new one)

1.3 Main Base Document Window and its parts (as given by Drew)

1.4 Database objects

(These are the 4 items in the left-hand column of the Base window. Details as given by Drew, but write at quite a general introductory level and leave details for the chapter covering use of the item.)

1.4.1 Tables

1.4.2 Queries

1.4.3 Forms

1.4.4 Reports

1.4.5 keep track of it all (Using folders to keep things together.) [I’m not sure what this is, so not sure whether to keep it here or not:}

1.5 Data input and removal (general intro, with reference to Chapter 3 for details)

1.6 How to find your information (Searches and Filters) (general, with ref to Chapter 4 for details)

1/7 Let Wizards do most of the work (general intro, with refs to other chapters)

1.7 Mixing Base with the rest of OO.o (general intro, with refs to other chapters for details)

(Mention both input and output)

1.8 Using Base with other data sources (general intro, with refs to other chapters)


Chapter 2: Planning/designing your database

(I haven’t worked out the outline for this chapter yet, but I think it should contain these topics.)

2.1 Flat and relational databases

2.2 Data types (Default and HSQL datatypes—as given by Drew)

2.3 Key

2.4 Other basic theory-type topics needed when planning/designing?

2.5 Introduce example(s) to be used in the book (flat d/b and a relational one)?


Chapter 3: Data input and removal (topics not ncessarily in order)

3.1 New Table Wizard

3.2 Form Wizard

3.2 Working with the table templates

3.3 Create Exercise Log table

3.4 Other topics?

3.5 Example (flat database)

3.6 Example (relational d/b)?


Chapter 4: Data (information) output

4.1 Query Wizard

4.2 Report Wizard

4.2.1 Tables and Queries and SQL

4.2.2 Chose a layout

4.2.3 Can I make this little change?

4.2 Example (flat d/b)

4.3 Example (relational d/b)


Chapter 5: Exchanging data (include both input and output)

(include theory, practice, and an example in each case)

5.1 Working with Calc

5.2 Working with Writer

5.3 Working with Text files


Chapter 6: Customizing your database design

6.1 HSQL database properties (not sure what goes in here, Drew)

6.2 Designers (When you need to do it your way)

6.2.1 Table Designer

6.2.2 Relation Designer

6.2.3 Query Designer

6.2.4 Form Designer

8.2.5 Report Designer


Chapter 7: More customization

7.1 Using Macros (not sure what you have in mind here)

7.2 Validating data input

7.3 Generating calculated data

7.4 Working with multiple forms

7.5 Using other OO.o documents


Chapter 8: Using Base at work

(This may need to be subdivided into more than 1 chapter.)

8.1 Moving from an embedded single user Base file to a Multi-User HSQL server

8.1.1 Calling User Defined Functions

8.2 Using Other Servers (details from Drew’s outline)

8.2.1 MySQL

8.2.2 PostgreSQL

8.2.3 MS Access

8.3 Understanding Connections

8.3.1 Auto Commit

8.3.2 Handling multiple table transactions

8.4 Restricting Access to Forms and Reports


Appendix I Build the example database

Appendix II Overview of A Database

Appendix III Further reading on database design


Legal Disclaimers and Limitations | Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0. License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License v2.0.

"LibreOffice" and "The Document Foundation" are registered trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.