MS Access database help
I'm creating a database for my m$ access class, well actually its final project which I decided to do early. The requirements are that the database needs to have at least 2 tables, 2 form, 2 reports, a few queries. Macros & and a Switchboard are extra credit.
The database I'm creating is a spyware database.
So far I know for sure that I want a spyware table a table containing different types of spyware, and a antispyware table containing a list of products that remove spyware.
I've created a a table known as Spyware, the fields are as follows:
Spyware ID, Name, Category, Threat Level, Description, Information URL, Symptoms, and Removal Tool.
A typical field would have the following info:
AD01 | 123mania | Adaware | 3 - Moderate (based on a 1 - 5 scale) | Program that creates advertisments | hxxp://www.123mania.com/ | Changes browser, opens ports, shows ads. | X-Cleaner |
Anyhow the problem is that I want duplicate my primary key, because I want to have more removal tools such as the following:
----------------------------------------------------------------------
AD01 | 123mania | Adaware | 3-Moderate | Program that creates advertisments | hxxp://www.123mania.com/ | Changes browser, opens ports, shows ads. | SpyBot Search & Destroy |
----------------------------------------------------------------------
AD01 | 123mania | Adaware | 3-Moderate | Program that creates advertisments | hxxp://www.123mania.com/ | Changes browser, opens ports, shows ads. | SpySweeper |
----------------------------------------------------------------------
Is it possible to do it like above?
Or should I just create another field such as:
Spyware ID, Name, Category, Threat Level, Official Description, Information URL, Symptoms, Removal Tool, Removal Tool.
I guess what I'm asking is which makes more sense?
|