Okay, I’d like an ACCESS database for logging my tapes. I’d like an Access database because I want to be able to source and then select clips. My work at present falls into 2 major groupings.
1 – For clients, wedding outfits and definable project-specific activity
2 – Out and about shooting on my own time, cameraman testing, Vegas and soon Boris Graf 3 testing and learning.
The first Group is a simple matter of shoot and work. By the time I’ve completed the work the tapes themselves don’t need to be “scrutinized” by me . . really. The projects are done, down ‘n dusted – finished.
The second Group is the one I want, allowing me to get a grip on my “content”. Vegas and Scenealyzer, can assist me to do actual logging for capture. . this I know. I’m looking for a “standalone” exo-NLE method of just viewing and entering text into a database. Maybe at some point I could develop this to show a tiny still/thumbnail within the database to assist me in making a selection from an Access Report showing a thumbnail. Kinda, “Oh that looks neat . . I’ll use that . . .”
At its simplest, this relational database would consist of 2 tables:
Table 1 – Tape name
Table 2 – Tape Contents
So Table 1 is a One-To-Many relationship. And subsequently Table 2 is a Many-To-One relationship.
Yes I could get to grips with the Access design for the relational side of things, but if someone out there knows of OR has one that works in a similar way I describe OR someone who is a database jockey I’d like to have a copy. I can get busy and further delineate the column names I want, but for brevity, they would be something like:
Tape Name [ simple table ] :
Col 1 - TapeIdNo
Col 2 - Description [ this could be General shots; Date [ Started:Finished ] . . there could be other columns .
Tape Contents [ This is the real deal! ] :
Col1 - TapeIdNo
Col2 - Clip IdNo
Col3 – StartTimecode
Col4 – EndTimcode
Col5 - Project [ testing camera work; testing/ideas Vegas; testing/ideas BorisGraf; ]
Col6 - Thumbnail [ nice but not essential! ]
Col7 - Emotion [ light; dark; upbeat; . . ]
Col8 - Venue [ outside; location ; inside ; ]
Col9 - VALUE [ this is where it starts kicking butt . . Here I could add comments as to where this clip maybe used and possible “flag” this to go with a project, get the idea? ]
If it comes with input forms great. If it comes with reports, giving me criteria to search on, even better.
Any takers?
Look, if something exists out there already – great! Just tell me where and I’ll go away . . .
Grazie
1 – For clients, wedding outfits and definable project-specific activity
2 – Out and about shooting on my own time, cameraman testing, Vegas and soon Boris Graf 3 testing and learning.
The first Group is a simple matter of shoot and work. By the time I’ve completed the work the tapes themselves don’t need to be “scrutinized” by me . . really. The projects are done, down ‘n dusted – finished.
The second Group is the one I want, allowing me to get a grip on my “content”. Vegas and Scenealyzer, can assist me to do actual logging for capture. . this I know. I’m looking for a “standalone” exo-NLE method of just viewing and entering text into a database. Maybe at some point I could develop this to show a tiny still/thumbnail within the database to assist me in making a selection from an Access Report showing a thumbnail. Kinda, “Oh that looks neat . . I’ll use that . . .”
At its simplest, this relational database would consist of 2 tables:
Table 1 – Tape name
Table 2 – Tape Contents
So Table 1 is a One-To-Many relationship. And subsequently Table 2 is a Many-To-One relationship.
Yes I could get to grips with the Access design for the relational side of things, but if someone out there knows of OR has one that works in a similar way I describe OR someone who is a database jockey I’d like to have a copy. I can get busy and further delineate the column names I want, but for brevity, they would be something like:
Tape Name [ simple table ] :
Col 1 - TapeIdNo
Col 2 - Description [ this could be General shots; Date [ Started:Finished ] . . there could be other columns .
Tape Contents [ This is the real deal! ] :
Col1 - TapeIdNo
Col2 - Clip IdNo
Col3 – StartTimecode
Col4 – EndTimcode
Col5 - Project [ testing camera work; testing/ideas Vegas; testing/ideas BorisGraf; ]
Col6 - Thumbnail [ nice but not essential! ]
Col7 - Emotion [ light; dark; upbeat; . . ]
Col8 - Venue [ outside; location ; inside ; ]
Col9 - VALUE [ this is where it starts kicking butt . . Here I could add comments as to where this clip maybe used and possible “flag” this to go with a project, get the idea? ]
If it comes with input forms great. If it comes with reports, giving me criteria to search on, even better.
Any takers?
Look, if something exists out there already – great! Just tell me where and I’ll go away . . .
Grazie