Question How can i connect the titles with the dates?

[Picky]

Good morning and hello to everyone.

So, i have to build a database of 1000 magazines.

1 table with name title_magazines
2 table with name the title_of_magazine (like M1,M2,M3, until M1000)
3 table with name Location (issued by)
4 table the dates.

I gave the names in my tables. The question is how can i connect these titles of my magazines with the dates ?

For example the magazine "Time" published in 1985 until 2000 and i have only the dates of 1987 1988 and 2000.

Also a magazine differ in the dates from other magazines. How can i build this database and how finally can i build a querry that will show me for example how many magazines exists in the decade 1980-1990 or how many magazines published in New York?

*the dates are from 1900 until 2000.

 

[isladogs]

Welcome to AWF

This doesn't sound like a normalised structure.
Is this for a school or college project?

Can you show a screenshot of the table relationships window

 

[June7]

Databases for books/music/magazines have been discussed in many threads. Have you done any research? You might look at the MS Lending Library database template.