Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Fact Table

 
   Database Forums (Home) -> MS Access -> Tables DB Design RSS
Next:  Order By giving two groups  
Author Message
Charles L. Phillips

External


Since: Apr 03, 2005
Posts: 3



(Msg. 1) Posted: Tue Apr 26, 2005 9:10 pm
Post subject: Fact Table
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

Hello,
Please explain the usage of a "fact table" in an MS-Access database...


Thank you,
--
Charles L. Phillips

 >> Stay informed about: Fact Table 
Back to top
Login to vote
Haris Rashid

External


Since: Mar 30, 2005
Posts: 1



(Msg. 2) Posted: Fri Apr 29, 2005 11:08 am
Post subject: RE: Fact Table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

hi Charles L. Phillips,

Fact table is not specific to MS Access. This a dimensional modelling
attribute.

Regards,

----------------
Haris Rashid
<a rel="nofollow" style='text-decoration: none;' href="http://www.manage-systems.com" target="_blank">http://www.manage-systems.com</a>
---------------------------------------

"Charles L. Phillips" wrote:

 > Hello,
 > Please explain the usage of a "fact table" in an MS-Access database...
 >
 >
 > Thank you,
 > --
 > Charles L. Phillips
 >
 >
 >

 >> Stay informed about: Fact Table 
Back to top
Login to vote
Charles L. Phillips

External


Since: Apr 03, 2005
Posts: 3



(Msg. 3) Posted: Sat Apr 30, 2005 4:29 pm
Post subject: Re: Fact Table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello,
Sorry for the delay in my reply, but to answer your question(s), I was
reading "Designing the Star Schema Database"
(http://www.ciobriefings.com/whitepapers/StarSchema.asp), and "The Data
Warehouse Toolkit (Ralph Kimball)... I wanted to apply some of the
techniques I've read about to an application I am designing...


Charles



"Charles L. Phillips" wrote in message

 > Hello,
 > Please explain the usage of a "fact table" in an MS-Access database...
 >
 >
 > Thank you,
 > --
 > Charles L. Phillips
 >
 >
 >> Stay informed about: Fact Table 
Back to top
Login to vote
Charles L. Phillips

External


Since: Apr 03, 2005
Posts: 3



(Msg. 4) Posted: Sat Apr 30, 2005 4:30 pm
Post subject: Re: Fact Table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello,
Sorry for the delay in my reply, but to answer your question(s), I was
reading "Designing the Star Schema Database"
(http://www.ciobriefings.com/whitepapers/StarSchema.asp), and "The Data
Warehouse Toolkit (Ralph Kimball)... I wanted to apply some of the
techniques I've read about to an application I am designing...


Charles



"Nikos Yannacopoulos" wrote in message

 > Charles,
 >
 > I'm not sure this is a standard Access term. Where did you come accross
it?
 >
 > Nikos
 >
 > Charles L. Phillips wrote:
  > > Hello,
  > > Please explain the usage of a "fact table" in an MS-Access database...
  > >
  > >
  > > Thank you,
  > > --
  > > Charles L. Phillips
  > >
  > >
 >> Stay informed about: Fact Table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Calendar Table and Roster Table Relationship Recommendatio.. - I work in an office that has an A shift and a B shift. 3 days a week, the A and B Shifts work together. For Example: John Smith on Shift A works alternating weeks Mon., Tues, Wed, Thurs. and Tues, Wed, Thurs, Fri. Jane Doe on Shift B works..

Relationship between a Calendar Table and Employee Table - Need Help: I work at an office that has two shifts (A and B) that share 3 days a week and alternate work days every other week. For example: John Smith on the A Shift works Week 1 – Mon, Tues, Wed., Thurs and Week 2 – Tues, Wed, Thurs, Fri. Jan...

Value from one table to another - I have two tables, tblA and tblB. tblB has only 2 fields; Number and BarCode. tblA has the same and also others with data, but here the field BarCode is empty. Now I want to update tblA with the BarCode values from tblB where the both Number fields are....

Many to Many Table design - I am having trouble with a many to many issue. We are a Yacht charter business and each charter order can have many products associated. Each product may have one or many components. I have created tables as follows: tblProducts ProductId PK..

Un Hide a Table - I have hiiden a table in my Access project (MDB) how do I unhide this table?? -- Mcnewbie
   Database Forums (Home) -> MS Access -> Tables DB Design All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]