To Base and Back Again

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 17:15, 12 October 2007 (edit)
Lorinda (Talk | contribs)
(Perfecting Forms - correct link name)
← Previous diff
Current revision (13:19, 11 June 2008) (edit) (undo)
Lorinda (Talk | contribs)
(Reports - Add a Section on Views in the Theme-oriented list.)
 
(23 intermediate revisions not shown.)
Line 13: Line 13:
#[[Creating A Data Entry Form With A Subform]]<br> #[[Creating A Data Entry Form With A Subform]]<br>
#[[Using Combo Boxes in a Form]]<br> #[[Using Combo Boxes in a Form]]<br>
-#[[Using Date Time and Formatted Controls in Forms]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37246#37246]+#[[Using Date Time and Formatted Controls in Forms]]
#[[Setting the Tab Order in a Form]] #[[Setting the Tab Order in a Form]]
#[[Adding a Button To Open Another Form]]<br> #[[Adding a Button To Open Another Form]]<br>
#[[Adjusting Form Properties]]<br> #[[Adjusting Form Properties]]<br>
#[[Using a Query to Combine Fields From Different Tables]]<br> #[[Using a Query to Combine Fields From Different Tables]]<br>
 +#[[Filtering in Queries and Tables]]
 +#[[Creating Indexes]] <br>
#[[Creating a Form in Design View]] #[[Creating a Form in Design View]]
-#[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]+#[[Filtering in Forms]]
 +#[[Adding a Search Control to a Form]]
#[[Using the Group Function in a Query]] #[[Using the Group Function in a Query]]
 +#[[Creating a Table and a Form to Store Images]]
 +#[[Adding a Subform to a Form in Design View]]
 +#[[Using An Outer Join in a Query]]
 +#[[Creating a Report]]
 +#[[Intro to the Data Source View]]
 +#[[Filtering in the Data Source View]] working with the Data Source View in Writer (or Calc)
 +#[[Sorting in the Data Source View]] working with the Data Source View in Writer (or Calc)
 +#[[Inserting Data from the Data Source View into a Writer Document]]
 +#[[Using a Union Statement in a View]]
 +#[[Splitting Tables]]
==Grouped by Topic Order== ==Grouped by Topic Order==
-===Designing and Creating Tables===+===Designing and Working With Tables===
[[Designing the Database "On Paper"]] (Thinking through how to organize your data before building the database.)<br> [[Designing the Database "On Paper"]] (Thinking through how to organize your data before building the database.)<br>
 +====Creating Tables====
[[Creating a Table From a Spreadsheet]] (Importing data from (not connecting to) a spreadsheet.) <br> [[Creating a Table From a Spreadsheet]] (Importing data from (not connecting to) a spreadsheet.) <br>
[[Creating a Table in Design View]]<br> [[Creating a Table in Design View]]<br>
-[[Establishing Relationships]]+[[Creating a Table and a Form to Store Images]]<br>
 +[[Splitting Tables]]<br>
 + 
 +====Other Table-Related Tasks====
 +[[Establishing Relationships]]<br>
 +[[Creating Indexes]] <br>
 +[[Filtering in Queries and Tables]]<br>
 +[[Using Tables and Queries as Datasources in Writer]]
===Forms=== ===Forms===
Line 34: Line 55:
[[Creating A Data Entry Form With A Subform]]<br> [[Creating A Data Entry Form With A Subform]]<br>
[[Creating a Form in Design View]]<br> [[Creating a Form in Design View]]<br>
 +[[Creating a Table and a Form to Store Images]]<br>
 +[[Adding a Subform to a Form in Design View]]
====Perfecting Forms==== ====Perfecting Forms====
Line 41: Line 64:
[[Setting the Tab Order in a Form]]<br> [[Setting the Tab Order in a Form]]<br>
[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]<br> [[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]<br>
-[[Using Date Time and Formatted Controls in Forms ]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37246#37246]+[[Using Date Time and Formatted Controls in Forms]]
 + 
 +====Other Work With Forms====
 +[[Filtering in Forms]]
===Queries=== ===Queries===
[[Using a Query to Combine Fields From Different Tables]]<br> [[Using a Query to Combine Fields From Different Tables]]<br>
-[[Using the Group Function in a Query]] (Creating a Query that lists all bird species seen.)+[[Using the Group Function in a Query]]<br>
 +[[Filtering in Queries and Tables]]<br>
 +[[Using An Outer Join in a Query]]<br>
 +[[Using Tables and Queries as Datasources in Writer]]
 + 
 +===Views===
 +[[Using a Union Statement in a View]]
 + 
 +===Reports===
 +[[Creating a Report]]<br>
 + 
 +===Using Database Data in Writer and Calc===
 +[[Intro to the Data Source View]]<br>
 +[[Filtering in the Data Source View]]<br>
 +[[Sorting in the Data Source View]]<br>
 +[[Inserting Data from the Data Source View into a Writer Document]]<br>
{{botlangbarEN| [[It:Verso_Base_e_Ritorno|Italiano]] [[Fr:Base Aller et Retour|Français]]}} {{botlangbarEN| [[It:Verso_Base_e_Ritorno|Italiano]] [[Fr:Base Aller et Retour|Français]]}}
[[Category:NeoOffice]] [[Category:NeoOffice]]

Current revision

This is the "home page" for a series of tutorial articles. The tutorials follow the creation of a database designed to serve as a birder's log, tracking birding field trips, bird sightings, etc. This project is still very much in process. More tutorials will appear over time.

The list of articles appears twice below: first in the order they should be followed if you are working through the tutorial, then grouped by topic (tables, forms, etc.)

Note that the red links are articles that have not yet been written. In some cases, they are followed by a blue number in brackets. These are links to forum threads or other pages containing information I plan to use in the articles; they are also provided here for those who need more information about those features of base.

Contents

Tutorial Order

  1. Designing the Database "On Paper"
  2. Creating a Table From a Spreadsheet
  3. Creating a Table in Design View
  4. Establishing Relationships
  5. Creating a Simple Data Entry Form
  6. Creating A Data Entry Form With A Subform
  7. Using Combo Boxes in a Form
  8. Using Date Time and Formatted Controls in Forms
  9. Setting the Tab Order in a Form
  10. Adding a Button To Open Another Form
  11. Adjusting Form Properties
  12. Using a Query to Combine Fields From Different Tables
  13. Filtering in Queries and Tables
  14. Creating Indexes
  15. Creating a Form in Design View
  16. Filtering in Forms
  17. Adding a Search Control to a Form
  18. Using the Group Function in a Query
  19. Creating a Table and a Form to Store Images
  20. Adding a Subform to a Form in Design View
  21. Using An Outer Join in a Query
  22. Creating a Report
  23. Intro to the Data Source View
  24. Filtering in the Data Source View working with the Data Source View in Writer (or Calc)
  25. Sorting in the Data Source View working with the Data Source View in Writer (or Calc)
  26. Inserting Data from the Data Source View into a Writer Document
  27. Using a Union Statement in a View

Grouped by Topic Order

Designing and Working With Tables

Designing the Database "On Paper" (Thinking through how to organize your data before building the database.)

Creating Tables

Creating a Table From a Spreadsheet (Importing data from (not connecting to) a spreadsheet.)
Creating a Table in Design View
Creating a Table and a Form to Store Images

Other Table-Related Tasks

Establishing Relationships
Creating Indexes
Filtering in Queries and Tables
Using Tables and Queries as Datasources in Writer

Forms

Creating Forms

Creating a Simple Data Entry Form
Creating A Data Entry Form With A Subform
Creating a Form in Design View
Creating a Table and a Form to Store Images
Adding a Subform to a Form in Design View

Perfecting Forms

Adjusting Form Properties
Using Combo Boxes in a Form
Adding a Button To Open Another Form
Setting the Tab Order in a Form
Adding a Search Control to a Form [1]
Using Date Time and Formatted Controls in Forms

Other Work With Forms

Filtering in Forms

Queries

Using a Query to Combine Fields From Different Tables
Using the Group Function in a Query
Filtering in Queries and Tables
Using An Outer Join in a Query
Using Tables and Queries as Datasources in Writer

Views

Using a Union Statement in a View

Reports

Creating a Report

Using Database Data in Writer and Calc

Intro to the Data Source View
Filtering in the Data Source View
Sorting in the Data Source View
Inserting Data from the Data Source View into a Writer Document



This article in other languages: Italiano Français
Personal tools