Download No 44

East Usambara Biodiversity Database: A User’s Manual
Table of Contents
1)
INTRODUCTION .................................................................................................................................................3
1.1
Using this manual...................................................................................................................................3
1.2
Background to the database ...................................................................................................................3
1.3
Database basics......................................................................................................................................4
1.4
Moving data to other Office programmes...............................................................................................4
1.5
Using the Office assistant .......................................................................................................................5
2)
TABLES .............................................................................................................................................................6
2.1
Opening the database .............................................................................................................................6
2.2
Introducing tables...................................................................................................................................6
2.3
Moving around tables.............................................................................................................................7
2.4
Entering data in a table ..........................................................................................................................7
2.5
Editing records .......................................................................................................................................8
2.6
Sorting and filtering records ..................................................................................................................9
2.7
Changing the table layout.....................................................................................................................10
2.8
Saving changes in tables.......................................................................................................................11
2.9
Looking at table design.........................................................................................................................11
2.10
Dates in tables ......................................................................................................................................12
2.11
Relationships between tables................................................................................................................12
2.12
Linked tables.........................................................................................................................................13
3)
FORMS ............................................................................................................................................................14
3.1
Introducing forms .................................................................................................................................14
3.2
Viewing data using forms .....................................................................................................................14
3.3
Entering data using forms ....................................................................................................................14
3.4
Using the find tool in forms ..................................................................................................................15
3.5
Sorting and filtering forms....................................................................................................................15
3.6
Printing forms.......................................................................................................................................16
3.7
Looking at form design .........................................................................................................................17
4)
QUERIES..........................................................................................................................................................18
4.1
Introducing queries...............................................................................................................................18
4.2
Select queries........................................................................................................................................18
4.3
Using criteria in select queries.............................................................................................................18
4.4
Using Mathematical Operators ............................................................................................................20
4.5
Using Logical Operators ......................................................................................................................20
4.6
Sorting with Queries.............................................................................................................................21
4.7
Updating records with queries .............................................................................................................21
4.8
Simple calculations...............................................................................................................................22
4.9
Multi-table queries ...............................................................................................................................23
5)
DATABASE MANAGEMENT..............................................................................................................................24
5.1
Security .................................................................................................................................................24
5.2
Backing up the database.......................................................................................................................24
5.3
Viruses ..................................................................................................................................................25
5.4
Quality control......................................................................................................................................25
APPENDIX 1
A BREAKDOWN OF THE CONTENTS OF THE DATABASE TABLES ....................................................28
INDEX .......................................................................................................................................................................30
2