|
|
To Base and Back Again
From NeoWiki
| Revision as of 23:40, 3 October 2007 (edit) Lorinda (Talk | contribs) (add warning about Adjusting Form Properties. Create link for Button to Open Form article; adjust formatting) ← Previous diff |
Revision as of 23:41, 3 October 2007 (edit) (undo) Lorinda (Talk | contribs) m (fix page break issue) Next diff → |
||
| Line 2: | Line 2: | ||
| [[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.) | ||
| - | [[Creating a Table From a Spreadsheet]] (Importing data from (not connecting to) a spreadsheet.) | + | [[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> | ||
Revision as of 23:41, 3 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
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.)
