MS Access Manual for Biologists


URL: http://faculty.ucr.edu/~tgirke/Documents/Access/Access.html

INDEX
  1. Introduction
  2. Data Im/Export and Tables
  3. Queries
  4. Reports
  5. Forms
  6. Useful Utilities



1. Introduction

Why MS Access?
Limitations
Alternatives

2. Data Im/Export

Background
Create New Database
Orientation
Data Import (Table)
Link to External Database
Datasheet, Pivot Table and Design View
Create New Table
Some Characteristica of Database Tables
Sort and Filter Tables
Data Export
Exercise 1:

3. Queries

Background
Creating a New Query
Query Criteria (selection)
Calculations
Table Query
Append Query (be aware of primary key violation)
Find Duplicates Query
Remove Duplicates
Export Query
Exercise 2:

4. Reports

Background
Report Wizard
Export to Word
Exercise 3:

5. Forms

Background
Relationships
Form Wizard
Add Subform to Existing Form
Exercise 4:

6. Utilities