|
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 process. More tutorials will appear over time.
The list of articles appears twice below: first in the order they should be followed if you are working through the tutorial, then 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 |
Tutorial Order
- Designing the Database "On Paper"
- Creating a Table From a Spreadsheet
- Creating a Table in Design View
- Establishing Relationships
- Creating a Simple Data Entry Form
- Creating A Data Entry Form With A Subform
- Using Combo Boxes in a Form
- Using Date Time and Formatted Controls in Forms
- Setting the Tab Order in a Form
- Adding a Button To Open Another Form
- Adjusting Form Properties
- Using a Query to Combine Fields From Different Tables
- Filtering in Queries and Tables
- Creating a Form in Design View
- Filtering in Forms
- Adding a Search Control to a Form [1]
- Using the Group Function in a Query
- Creating a Table and a Form to Store Images
- Creating a Report
- Using Tables and Queries as Datasources in Writer
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
Creating a Table and a Form to Store Images
Forms
Creating Forms
Creating a Simple Data Entry Form
Creating A Data Entry Form With A Subform
Creating a Form in Design View
Creating a Table and a Form to Store Images
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]
Using Date Time and Formatted Controls in Forms
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.)