|
To Base and Back Again
From NeoWiki
Revision as of 02:45, 5 October 2007 (edit) Lorinda (Talk | contribs) (add latent link and link to info on search controls) ← Previous diff |
Revision as of 19:04, 7 October 2007 (edit) (undo) Lorinda (Talk | contribs) m (fix line break issue) 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 production. More tutorials will appear over time.<br><br> | ||
- | [[Designing the Database "On Paper"]] (Thinking through how to organize your data before building the database.) | + | [[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> |
Revision as of 19:04, 7 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 production. More tutorials will appear over time.
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]
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.)