To Base and Back Again

From NeoWiki

Revision as of 19:04, 7 October 2007 (edit) Lorinda (Talk | contribs) m (fix line break issue) ← Previous diff		Revision as of 14:05, 10 October 2007 (edit) (undo) Lorinda (Talk | contribs) (add link for new article) 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 production. More tutorials will appear over time.<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. 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>
	[[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>
Line 13:		Line 13:
	:[[Setting the Tab Order in a Form]]		:[[Setting the Tab Order in a Form]]
	:[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]		:[[Adding a Search Control to a Form]] [http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617]
		+	:[[Using Formatted Fields]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37246#37246]
	[[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 14:05, 10 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. 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.

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 Simple Data Entry Form
Creating A Data Entry Form With A Subform
More On Forms

Adjusting Form Properties (warning: directions don't work at the moment)

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]

[2]

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