To Base and Back Again

From NeoWiki

Revision as of 00:30, 11 October 2007 (edit) Lorinda (Talk | contribs) (remove warning about Form Properties link; I could have sworn I did this already!) ← Previous diff		Revision as of 01:07, 11 October 2007 (edit) (undo) Lorinda (Talk | contribs) (reorganize page; two lists of links; one numbered, one grouped by category) Next diff →
Line 1:		Line 1:
-	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. Note that the red links are articles that have not yet been written. In some caes, they are followed by a blue number in brakets. 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.<br><br>	+	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, once in the order they should be followed if you are working through the tutorial, the second time they are 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.<br><br>
		+
		+	==Tutorial Order==
		+	#[[Designing the Database "On Paper"]]<br>
		+	#[[Creating a Table From a Spreadsheet]]<br>
		+	#[[Creating a Table in Design View]]<br>
		+	#[[Establishing Relationships]]<br>
		+	#[[Creating a Simple Data Entry Form]]<br>
		+	#[[Creating A Data Entry Form With A Subform]]<br>
		+	#[[Using Combo Boxes in a Form]]<br>
		+	#[[Setting the Tab Order in a Form]]
		+	#[[Adding a Button To Open Another Form]]<br>
		+	#[[Adjusting Form Properties]]<br>
		+	#[[Using a Query to Combine Fields From Different Tables]]<br>
		+	#[[Creating a Form in Design View]]
		+	#[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]
		+	#[[Using the Group Function in a Query]]
		+
		+	==Grouped by Topic Order==
		+	===Designing and Creating 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]]
		+
		+	===Forms===
		+	====Creating Forms====
	[[Creating a Simple Data Entry Form]]<br>		[[Creating a Simple Data Entry Form]]<br>
	[[Creating A Data Entry Form With A Subform]]<br>		[[Creating A Data Entry Form With A Subform]]<br>
-	More On Forms	+	[[Creating a Form in Design View]]<br>
-	:[[Adjusting Form Properties]]<br>	+
-	:[[Using Combo Boxes in a Form]]<br>	+	====Perfecting Forms====
-	:[[Adding a Button To Open Another Form]]	+	[[Adjusting Form Properties]]<br>
-	:[[Setting the Tab Order in a Form]]	+	[[Using Combo Boxes in a Form]]<br>
-	:[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]	+	[[Adding a Button To Open Another Form]]<br>
-	:[[Using Formatted Fields]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37246#37246]	+	[[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>
		+	[[Using Formatted Fields]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37246#37246]
		+
		+	===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.)

---

Revision as of 01:07, 11 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, once in the order they should be followed if you are working through the tutorial, the second time they are 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 Creating Tables 2.2 Forms 2.2.1 Creating Forms 2.2.2 Perfecting Forms 2.3 Queries

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. Setting the Tab Order in a Form
9. Adding a Button To Open Another Form
   
10. Adjusting Form Properties
    
11. Using a Query to Combine Fields From Different Tables
    
12. Creating a Form in Design View
13. Adding a Search Control to a Form [1]
14. Using the Group Function in a Query

Grouped by Topic Order

Designing and Creating 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

Forms

Creating Forms

Creating a Simple Data Entry Form
Creating A Data Entry Form With A Subform
Creating 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 [2]
[3]

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.)