|
To Base and Back Again
From NeoWiki
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.)