I want to design a database that holds news items by date and display news heading links on a page using ASP when user clicks on a headline link the details news should be displayed. I am using MS Access. How can I go abt desiging the database. I am thinking of
News_id - Auto number
news_date - Date/time
News_headline - Text

Select.asp --> which creates the page wih news headings
can I write a query like
Select news_headlines, id from table where news_date between start date and end date
Hoe can i then go on writing the ASP code for displaying the whole news details.
I will appreciate some feedback.