adham <ad*********@yahoo.comwrote in
news:11**********************@p47g2000hsd.googlegr oups.com:
On May 26, 7:39 am, "jahoobob via AccessMonster.com"
<u12179@uwewrote:
>I am sure that it is possible.
adham wrote:
>Hey there,
>I am creating an access database which stores information on
websites, and i would like to create table that displays the
interest flags. Basically i want to create a 5 X 9 table
with both text, and a yes/no field. For example if the
website is about cars, i would check the tick box in the car
box. Im sure you can visualise a 2d table with different
interests in each box, which includes a tick box. Now i want
to include the entire table for each website. So each
website would have a 2d table that flags the different
interests retaining to the specific website.
>Is it possible to do this with access?
>any help would be much appreciated
>thanks
adham
yeah me too, otherwise i wouldnt have asked
jahoobob answered the first question. What he didn't answer was
your second, because although it is possible to design a
database as you described, it's not desireable.
Excel is good for matrices; Access really shines at
relationships between entities. Here is how I'd design a
database for your end result:
tblWebSites
ID autonum Primary Key
URL text
Title text
dateVisited date/Time
Comments text
etc...
TblInterests
ID autonum P.K.
Description text
TblSiteInterests
WebsiteID LongInteger Foreign Key to tblWebsites
InterestID LongInteger Foreign Key to tblInterests
Comments text
The tblSiteInterests is used as the seed for your matrix, which
exists only as a crosstab query
The reasons are many, but ease of addingg new interests, new
sites, and reduction of wasted diskspace are but three.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com