Access help?
I need to set up a database of records for a listing of backup tapes. Can someone help me come up with the best way to organize it? I don't know the more complicated aspects of Access very well. I'm not sure when to use a form or a query or a report...or when I should be combining any of them
The tapes are all numbered, and I made that my key. Some of them also have specific names in addition to their numbers. On each tape is a subdivision of company names. And under each company name is a list of all types of work done for the company.
Ex: Tape 1 (aka Graphics Tape) with contents: IBM (Promo, Graphics, PSA); Cablevision (Images, Commercial, Promo)
On any given tape, the companies won't repeat. What I want to do is set up a database that can be easily searched through. I started by creating an individual table for each Backup Tape, but I'm not sure if that's the most efficient way. I wanted to make a form that would allow the user to type in a searchable keyword and then find all occurrances of that word in the different tables.
Help with this would be GREATLY appreciated!!!! Also sorry for any cross-posting.
The tapes are all numbered, and I made that my key. Some of them also have specific names in addition to their numbers. On each tape is a subdivision of company names. And under each company name is a list of all types of work done for the company.
Ex: Tape 1 (aka Graphics Tape) with contents: IBM (Promo, Graphics, PSA); Cablevision (Images, Commercial, Promo)
On any given tape, the companies won't repeat. What I want to do is set up a database that can be easily searched through. I started by creating an individual table for each Backup Tape, but I'm not sure if that's the most efficient way. I wanted to make a form that would allow the user to type in a searchable keyword and then find all occurrances of that word in the different tables.
Help with this would be GREATLY appreciated!!!! Also sorry for any cross-posting.
