By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,458 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,458 IT Pros & Developers. It's quick & easy.

How to input interest flags for an access database

P: n/a
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

May 25 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
--
Message posted via http://www.accessmonster.com

May 26 '07 #2

P: n/a
On May 26, 7:39 am, "jahoobob via AccessMonster.com" <u12179@uwe>
wrote:
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

--
Message posted viahttp://www.accessmonster.com- Hide quoted text -

- Show quoted text -
yeah me too, otherwise i wouldnt have asked

May 26 '07 #3

P: n/a
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

May 26 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.