Back to FAQ index.

Back to FAQ index.

Back to FAQ index.

1. A Pocket Checklist of The Birds of Peninsular Malaysia and Singapore. Richard Gregory-Smith. Malaysian Nature Society 1996. This book was used mainly to enter the common and scientific names only.
2. A Field Guide to the Birds of West Malaysia and Singapore. Allen Jeyarajasingam and Alan Pearson. Oxford University Press 1999. This book was used to counter check errors, to add local names and other data such as size, migratory status etc
3. A Field Guide to the Birds of South-East Asia. Craig Robson. New Holland Publishers 2000. This book was used when data is not available in Allen J's book or as a comparison of naming conventions. Data for some species not found in Allen J's book are taken from this guide.

Back to FAQ index.

Back to FAQ index.

What data or bird lists had already been added?

In addition to a few records of my own sightings to test this database, I had also added the following bird lists:

1. Kinta Valley Former Mining Areas Bird List compiled by Lim Kim Chye/Lim Swee Yian
2. Kuala Gula Perhilitan Bird List from records of Dept of Wildlife and National Parks Malaysia
3. Bukit Larut Bird List compiled from records of Choy Wai Mun and T. Guna
4. Burmese Pool Bird List compiled by Lim Kim Chye/Lim Swee Yian
5. Kledang Hill Bird List compiled by AL Tan
6. Fraser Hill Bird List from souvenir book 13th Fraser Hill Bird Race 2000
7. Sg Relau/Kuala Juram Bird List compiled by MNS (1997-2000)
8. Sungkai Wildlife Sanctuary Bird Lists (Nov and Dec 2000) compiled by Lim Kim Chye

If you have any other bird list or additional species to existing lists which you would like me to add, please email me.

Back to FAQ index.

Back to FAQ index.

There are two forms (SightingsDetailForm and SightingsSimpleForm) available to add your data but you need to use only one of them. The former allows you to view species related data such as size and scientific names during data entry but has a smaller area for SightingNotes. The latter has a larger area for SightingNotes.

Since some of the data are entered from popup lists, you must ensure that the values you are going to enter are already in the appropriate tables before attempting to add sighting records. For example, for Trip Name you must first go to the Trips form to define that particular Trip (for once only). The same principle applies to the Location and Birder Name.

Back to FAQ index.

Back to FAQ index.

Notes on the Tables
Table: Species. Stores information about each species.
Table: Family. Store information about family of birds.
Table: Migration. Store popup values about migratory status.
Table: Location: Store information about birding location/destinations. Please note that 'Location' field refers to a more specific place such as 'Fraser Hill, rubbish dump area' whereas 'BirdingArea' field refers to a more general area such as 'Fraser Hill'. Currently, reports mostly makes use of the latter field only.
Table: Birders. Store information about birders.
Table: Trips. Store information about birding trips.
Table: Sightings. This is the table storing the most important data - information about each bird sighting. Each species sighted in a particular trip is stored as one record.
Table: SightingsArchive. This is a mirror table to Sightings. If you have too many sightings records and want to keep the Sightings table small, you can transfer records by cutting records from the 'Sightings' table and pasting it into the 'SightingsArchive'. Records in the archives will not be available for inclusion in any of the reports unless you create new reports specifically to retrieve them.

Back to FAQ index.

Some of the queries will prompt you for values to be used for filtering the tables. If the value requested is a keyword (character field), you may type in a complete word, part of a word or a phrase depending on how specific you want your filtering to be. If you type nothing and press enter, it is assumed you want to ignore filtering for the particular field. However, if you are prompted to enter a date, you must enter a valid date for the queries to work.

Back to FAQ index.

Back to FAQ index.

Back to FAQ index.

1. This may sound naive but it is a practical problem: if you have trouble reading the computer screen at 800x600 resolution, change the resolution to 640x480 while entering data in the forms. This can prevent a lot of errors and time wasted in finding and correcting them later on. I am speaking from experience - I typed many double spaces in between words and ended up in a mess at one time because some of these errors occurred in critical fields (involved in relationships). Correcting these errors is a time consuming effort.
2. You can add sightings records _almost_ exclusively with keyboard alone and circumvent the need to use your mouse to navigate between the fields. Pressing the TAB key on the keyboard (usually just above the CAPS LOCK key) will move the cursor to the next field. Unlike the ENTER key, the TAB key always move the cursor to the next field. In memo fields, the ENTER key will add a hard return/new line instead of moving to the next field. Pressing the Shift-TAB key will move back to the previous field for you to correct mistakes.
3. Most of the sightings data are added by selecting values from popup lists. While the cursor is in a particular field with popup list, type the first character (do not worry about capitation in the sightings form but use correct capitation in other forms) of the value you are going to enter and the popup list will show you the first matching value available. If that is the value you want to enter, pressing the TAB key again will complete the data entry AND move the cursor to the next field. If that is not the exact value, typing the second, third or more characters etc will quickly move you to more specific values. If this still fails, you can still use the mouse to scroll down or up the list to find your desired value to be entered.
4. Use short-cut keys such as Ctrl-' whenever possible. When you add new records to the sightings table, the fields need to be typed in include date (of sighting), species name, tripname, location, birder name and date computerised. You will notice that among all these fields, only the species name differs from one record to another. For other fields, you need to enter the correct value only once. After that, use the value of the previous (just added) record to put into subsequent records with the short-cut key: Ctrl-apostrophe (Ctrl-'). Pressing these two keys simultaneously will put the value of the previous record into the existing record. There are probably many other short-cut methods to enter data. Take the trouble to check the HELP menu of Access and you may be able to find other fast ways of doing things in Access.
5. Work with subsets of the records. It is easier to work with subsets of the records by applying a filter while in a form or table. For example, if you are typing in sightings for a certain trip called 'Fraser Hill Feb 2001 Birding Trip' you can click Records > Filter by form > click tripname in the form and select the filter value. Then click 'Filter' > Apply Filter/Sort. You will then be working only on all records in this trip. You can switch between form view and datasheet view to find your records easily while a filter is in effect. Also, sorting the sightings by SightingsID and then viewing in datasheet view will provide you with a list of records in the order that was entered into the computer. This can then be compared or matched with the hard copy of birding notes to check for errors, omissions or duplications.
6. If you had modified any forms, reports etc or deleted any records, it is advisable to optimize file size by compacting the database. This is done from the Tools menu > Database Utilities > Repair Database. Then go through the same menu and do Compact Database. This can make your database smaller and save a fair amount of disk space..
7. This database allows you to generate 'Lifers' list. You must enter your 'lifers' in the sightings form but I am sure many veteran birders had long forgotten the date, trip or location about their 'first time'. This situation can be solved by using a general trip name such as 'Trips before millenium' etc. The location can be something like "Unspecified/Forgotten". The date field can be left empty to indicate a date from the 'dinasour' period. It is suggested that other tha the above situations, trip name used should be easy to remember or find. I usually use a combination of the destination and date to form trip names, e.g. 'Kuala Gula Birding Apr 2000' is a meaningful name which is self explanatory.
8. Some sightings may be made by more than one birders. In this case, it may be better to define a group of birders such as "Selangor Branch Bird Group" instead of a specific person. This can avoid duplication of sightings records by more than one birders from this group.
9. The following characters have special meaning in Access so that you should avoid using them in any field if possible: # [ ] ( ) ' "
10. If you find that in your reports, there are some bird sightings with invalid or empty family name or other fields, it is likely that the bird species name in the sightings table had been entered wrongly. Find that record by noting the sightingsID or details of other fields. Correct the spelling carefully by selecting the name from the pop-up list. See also section on How to correct data which are involved in integrity checks.

How to correct data which are involved in integrity checks?
If you had accidentally mis-spelled data for the species name, trip name, location or birder name, and then linked one of these to the corresponding sightings table from the popup list, you cannot correct the errors in these fields directly. Access will report violation of relationship integrity and prevent you from saving the corrected records. To correct errors in these fields, you must first delete all records in the sightings table with the same field values. Then correct the error and add back new records in the sightings table with the corrected value.

Back to FAQ index.

1. I am a relatively new user of Access and do not know how to add modules/macros. Thus the database is not as user-friendly as I would like it to be and you would need to have some knowledge of Access to use it.
2. The use of many popup lists aids in accurate data entry but this means that the database may not be compatible with PalmPilot (using Palm OS) which is a popular handheld device allowing data entry in the field. I do not own a PalmPilot or other handheld computers and has no knowledge of Windows CE (the operating system for the latter gadgets). So the database had been designed without taking into account of compatibility with Palm OS or Windows CE. I can only hope that it is compatible and some days in the future, you can actually enter sightings data in the field and later sync the database with your desktop computer or notebook.
3. If multiple birders are entering sightings into the same database, this database has no way of preventing multiple entries of the same sighting under different birder names.
4. The relationships between tables were designed with enforcement of 'referential integrety'. This means that Access will check to ensure correct spelling of data involved in relationships. Mis-spelled values will be rejected and this may seem to slow down or prevent data entry altogether. But it is a small price to pay for error-free data entry. This also means that once data had been entered into some fields (e.g. TripName, BirderName and Location) they should not be changed or deleted. The sightings form is an exception. You can delete a record in sightings without disrupting the integrety of the relationships.
5. I realise that the three books I referred to sometimes have different convention in bird names. Some birds included in one book may not be included in another as present in Malaysia but these species had been included in the database as long as they are listed in any one of the three books. Species without ID for Allen J or Robson's books indicate that I could not find them in the respective books. I presume Plumed Egret (Alle J) and Intermediate Egret (Robson) are the same species and have different scientific names. Both had been entered into the species tables. Some of the bird lists also contain species not listed in Allen J and I added these to the species table too e.g. Vinous-breasted Starling and Bar-backed Partridge. Oriental Dwarf Kingfisher is listed as two different species (Black-backed and Rufous-back) as they have different scientific names..

1. I shall be entering bird lists from other areas as they become available to me.
2. I may decide to add a table or modify the species table to enable cataloging recordings of bird videos or pictures.
3. You may notice that there are some extra/unused fields in some tables. These are for potential enhancements in the future such as multiuser data entry. If there is anyone interested in starting a bird sighting registration on the web in future, these field will be used.

I would like to thank the owners/compilers of the bird lists which I had computerized into the database. If you feel your list should not be put in, please contact me so that I can remove the records.

Many thanks.

Back to FAQ index.

Send your comments and feedback.
If you have any comments, enquiry or wish to report any problems with this database, please email to me at:
[email protected]

Back to FAQ index.