-
Welcome to BirdForum, the internet's largest birding community with thousands of members from all over the world. The forums are dedicated to wild birds, birding, binoculars and equipment and all that goes with it.
Please register for an account to take part in the discussions in the forum, post your pictures in the gallery and more.
life list using Microsoft Access (1 Viewer)
- Thread starter delliott
- Start date
robinm
Registered User
Hi David, Firstly, welcome to BirdForum from all the staff here. Maybe you could introduce yourself in the "Say Hello" forum.
I have written my own listing system in Microsoft Access. Difficult to know where to tell you how to start. You need to get some practice with simple database design before you can start on this. If you have some more specific questions I wil try to answer them.
I would offer to send you mine but it is not in a state where I could do that and I am in the process of rewriting parts of it. Also at present it only handles Western Palearctic birds.
I believe there is an Access system that you can download off the internet but I can't remember where.
I have written my own listing system in Microsoft Access. Difficult to know where to tell you how to start. You need to get some practice with simple database design before you can start on this. If you have some more specific questions I wil try to answer them.
I would offer to send you mine but it is not in a state where I could do that and I am in the process of rewriting parts of it. Also at present it only handles Western Palearctic birds.
I believe there is an Access system that you can download off the internet but I can't remember where.
Dave B Smith
Well-known member
David,
There is an excellent one that one of the BF members did. His name is Jeff and you can download his program from his Brandonbird website.Here's the link: BrandonBirding
The only thing you would need to do is add the US bird list (I'd suggest the AOU list which you can download from their website). Then PM Jeff and ask how to upload that list into his software. I know he has said its fairly straightforward.
There is an excellent one that one of the BF members did. His name is Jeff and you can download his program from his Brandonbird website.Here's the link: BrandonBirding
The only thing you would need to do is add the US bird list (I'd suggest the AOU list which you can download from their website). Then PM Jeff and ask how to upload that list into his software. I know he has said its fairly straightforward.
Hello all
Just downloaded the database and am now frantically inputting the data from my note books - will end up with a couple of years worth of records - excellent!!
My local 'patch' is similar to Jeff's - Brandon, Coombe abbey , draycote water etc - basically Warwickshire - but my wife has just organised a long weekend in Norfolk for my 40th Birthday - that should boost the list abit
thanks Jeff - excellent effort
Gaz
Just downloaded the database and am now frantically inputting the data from my note books - will end up with a couple of years worth of records - excellent!!
My local 'patch' is similar to Jeff's - Brandon, Coombe abbey , draycote water etc - basically Warwickshire - but my wife has just organised a long weekend in Norfolk for my 40th Birthday - that should boost the list abit
thanks Jeff - excellent effort
Gaz
I wrote my own excel spreadsheet to record sightings. I print out a list to tick birds seen on when I'm out and fill in the spreadsheet when I get home. Saves the worry of taking all my notes out into the field and getting them wet, muddy, lost, etc. Works well for me and I modify it slightly as I decide I want more info in it etc. PM me if you want a copy of basic outline.Eliter7 said:
Jampots
Alan G
Well-known member
Been using Jeffs Birding Database for a few months now and find it very good but it only sorts by Life List or site.
Can anyone advise how I can get it to sort out my entries into year seen, county, etc?
It's MS Access so I assume it should be doable, it's just I'm not very good with Access?
Thanks
Alan
Can anyone advise how I can get it to sort out my entries into year seen, county, etc?
It's MS Access so I assume it should be doable, it's just I'm not very good with Access?
Thanks
Alan
Alan G
Well-known member
I like the look of that screenshot, Jeff.
How do I go about creating this for my own database?
Ideally, what I'm after is lifelist, yearlist (creatable by year), place list & county list (I'll need to create an extra column in the database to accept cuounty as this isn't currently recordable).
Currently, when I select a report (I can only select life & place at the minute) it lists every bird I've seen as well as the numbers seen ie: gadwall seen on 6 occasions, with a and each time listed and how many seen.
Although this is something I may find useful I'd really want it to ignore any recurrance of the bird (ie: only count each bird once) with the total number of species for that particular list.
I hope this makes sense?
Alan
How do I go about creating this for my own database?
Ideally, what I'm after is lifelist, yearlist (creatable by year), place list & county list (I'll need to create an extra column in the database to accept cuounty as this isn't currently recordable).
Currently, when I select a report (I can only select life & place at the minute) it lists every bird I've seen as well as the numbers seen ie: gadwall seen on 6 occasions, with a and each time listed and how many seen.
Although this is something I may find useful I'd really want it to ignore any recurrance of the bird (ie: only count each bird once) with the total number of species for that particular list.
I hope this makes sense?
Alan
robinm
Registered User
If you are using Jeff's Birding Database this is the standard reports screenAlan G said:
County is recorded by the database against each site. But needs to be pulled from the database in a query.Alan G said:
Again this is just a matter of writing the right queries. I am not sure I want to post something like this is the Forum - better in a PM.Alan G said:
jeff
Well-known member
Alan,
This is the standard form in v3.0 of my database.
http://www.brandonbirding.co.uk/download.asp
Reports can be done with any combination of.......
You can do your reports by year (set start and end date)
County/Site (pick a county, you'd have set this on the location form)
Species/Keyword (select or leave as ALL)
Then set either brief or full report.
Cheers
Jeff
This is the standard form in v3.0 of my database.
http://www.brandonbirding.co.uk/download.asp
Reports can be done with any combination of.......
You can do your reports by year (set start and end date)
County/Site (pick a county, you'd have set this on the location form)
Species/Keyword (select or leave as ALL)
Then set either brief or full report.
Cheers
Jeff
Attachments
Last edited:
Similar threads
