W
WILLIAM
I have an excel sheet with the following fields, and how
the fields are populated, I use to track my offsite backup
tape storage, and I want to move it to a database:
Date of Backup (short date, 1/5/2005, manually entered)
Tape Drive (Drop down list of two choices)
S/N (A number field 7 digits long, manually entered)
Media ID (Four alph-numeric characters manually entered)
Media Pool (Drop down list of 9 choices)
Sequence (Drop down list for tape sequences, ie 1, 1-2, 1-
3, 1-4...)
Tape Name (Free text..could be anything)
Bin (Drop down list of bin names, WEEK1 MON, WEEK1 TUE,
WEEK1 WED.....all the way down to WEEK4 FRI. It's a long
list with a lot of repeating in the names, ie week1 five
times, week2 five times...mon four times, tue four
times...)
Date sent (short date, 1/5/2005, manually entered)
I've created a database, if you want to call it that, with
one table. It's a glorified excel sheet with a real
pretty form to enter the data. I designed it around that
form actually.
I received a little help and got the idea I need at least
3 tables, one for the bins, one for the tapes, and one for
the offsite transport. I'm thinking I probably need one
for the backups too (to store the dates at least) but i'm
stuck, I don't know how these tables should relate.
ANyone want to tackle this? Or am I asking for a bit too
much help here...?
Thanks so much!
the fields are populated, I use to track my offsite backup
tape storage, and I want to move it to a database:
Date of Backup (short date, 1/5/2005, manually entered)
Tape Drive (Drop down list of two choices)
S/N (A number field 7 digits long, manually entered)
Media ID (Four alph-numeric characters manually entered)
Media Pool (Drop down list of 9 choices)
Sequence (Drop down list for tape sequences, ie 1, 1-2, 1-
3, 1-4...)
Tape Name (Free text..could be anything)
Bin (Drop down list of bin names, WEEK1 MON, WEEK1 TUE,
WEEK1 WED.....all the way down to WEEK4 FRI. It's a long
list with a lot of repeating in the names, ie week1 five
times, week2 five times...mon four times, tue four
times...)
Date sent (short date, 1/5/2005, manually entered)
I've created a database, if you want to call it that, with
one table. It's a glorified excel sheet with a real
pretty form to enter the data. I designed it around that
form actually.
I received a little help and got the idea I need at least
3 tables, one for the bins, one for the tapes, and one for
the offsite transport. I'm thinking I probably need one
for the backups too (to store the dates at least) but i'm
stuck, I don't know how these tables should relate.
ANyone want to tackle this? Or am I asking for a bit too
much help here...?
Thanks so much!