training video database

[bkvisler]

I am semi new to access and I have been tasked with creating a database to keep track of training video for a the california smokejumper base in Redding. We need to keep track of: Practice Jumps, Fire Jumps, Parachute landings, training exits, training landings.
The database should be searchable by Name, Date, Jumpspot,



Also, new jumpers(names) will have to be added every year.
Anyone out there interested in giving me a quick and dirty description of how to do this..

brian kvisler
http://gacc.nifc.gov/oncc/logistics/...ers/index.html

[RuralGuy]

It sounds like a Video Store package would do it with the Jumpers as Customers.

[bkvisler]

what is this video store package? how do i get this? please forgive my newbieness.

[RuralGuy]

Similar to: http://www.softstore.net/

[RuralGuy]

Here's a link you might find useful: http://www.profsr.com/access/accless0.htm

[Ted C]

I am semi new to access and I have been tasked with creating a database to keep track of training video for a the california smokejumper base in Redding. We need to keep track of: Practice Jumps, Fire Jumps, Parachute landings, training exits, training landings.
The database should be searchable by Name, Date, Jumpspot,

Also, new jumpers(names) will have to be added every year.
Anyone out there interested in giving me a quick and dirty description of how to do this..

Seems like you need a table of Jumpers with information about your people. It will have a primary key of something like JumperID.

The VideoType table will need a VideoTypeID and a VideoType. The video type will be "Practice Jump", "Fire Jump", etc.

You will need a table of Videos. It will need a VideoID column and a VideoType column that accepts a number that links to the VideoType table. It will also need a JumperID column that links to the Jumper table. Finally, it will need a Date column to accept the date of the video.

You should then be able to build forms and queries that sort and filter by Jumper, Type, and Date.

If "Jumpspot" is a location, you'll need another table for it with SpotID and a description. The Video table will need another column for SpotID.

[bkvisler]

thanks for all the help guys....