To Base and Back Again

From NeoWiki

Revision as of 13:41, 13 October 2007 (edit) Lorinda (Talk | contribs) (→Tutorial Order - Add more links for planned articles) ← Previous diff		Revision as of 13:46, 13 October 2007 (edit) (undo) Lorinda (Talk | contribs) (→Grouped by Topic Order - add links to planned articles) Next diff →
Line 28:		Line 28:
	==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 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]]<br>		[[Establishing Relationships]]<br>
-	[[Creating a Table and a Form to Store Images]]	+	[[Creating a Table and a Form to Store Images]]<br>
		+	[[Filtering in Queries and Tables]]<br>
		+	[[Using Tables and Queries as Datasources in Writer]]
	===Forms===		===Forms===
Line 48:		Line 50:
	[[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 ]]	+	[[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]] (Creating a Query that lists all bird species seen.)<br>
		+	[[Filtering in Queries and Tables]]<br>
		+	[[Using Tables and Queries as Datasources in Writer]]
		+
		+	===Reports and Mail Merges===
		+	[[Creating a Report]]<br>
		+	[[Using Tables and Queries as Datasources in Writer]]
	{{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]]

---

Revision as of 13:46, 13 October 2007

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 1 Tutorial Order 2 Grouped by Topic Order 2.1 Designing and Working With Tables 2.2 Forms 2.2.1 Creating Forms 2.2.2 Perfecting Forms 2.2.3 Other Work With Forms 2.3 Queries 2.4 Reports and Mail Merges

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 a Form in Design View
15. Filtering in Forms
16. Adding a Search Control to a Form [1]
17. Using the Group Function in a Query
18. Creating a Table and a Form to Store Images
19. Creating a Report
20. Using Tables and Queries as Datasources in Writer

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 a Table From a Spreadsheet (Importing data from (not connecting to) a spreadsheet.)
Creating a Table in Design View
Establishing Relationships
Creating a Table and a Form to Store Images
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

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 [2]
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 (Creating a Query that lists all bird species seen.)
Filtering in Queries and Tables
Using Tables and Queries as Datasources in Writer

Reports and Mail Merges

Creating a Report
Using Tables and Queries as Datasources in Writer