Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Theory and practice of database design | Forum profile
Forum profile page for Theory and practice of database design on http://www.access-programmers.co.uk. This report page is the aggregated overview from a single forum: Theory and practice of database design, located on the Message Board at http://www.access-programmers.co.uk. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Theory and practice of database design" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
Site: Access World Forums - Theory and practice of database design
Access World Forums
(site profile, domain info access-programmers.co.uk)
Title: Theory and practice of database design
Url: http://www.access-programmers.co.uk/forums/foru...
Users activity: 33 posts per thread
Forum activity: 9 active threads during last week
 

Posting activity on Theory and practice of database design:

  Week Month 3 Months
Threads: 9 44 141
Post: 19 131 462
 

Theory and practice of database design Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Vergy39
2
user's latest post:
Help with Database design
Published (2009-11-19 09:04:00)
Thanks for the help. Here is a copy of the db. For some reason it is read only, so not sure how to change that. Again, Thanks David V.
Rabbie
2
user's latest post:
Normalization Explained
Published (2009-11-24 11:04:00)
Quote: Originally Posted by vrk1219 Hi Moniker, Both the links you have provided are not working. Could you please re-provide them with proper links. Thanks RK Veluvali Moniker only visits here very rarely at present. Last Visit was im March so you may have a long wait to get a reply
slackda
2
user's latest post:
Order Intake DB
Published (2009-11-25 01:07:00)
Thanks for the Replies, I understand the point/difference of Access and Excel, i have only been working for my current company for a month and i dont likle using excel to store data esp when the excel file is now 90mb in size... To elablorate the reason for 4 tables, they are generated from the same source a report generator within our system, the report generator in the system is able to produce a orders received report however this...
The_Doc_Man
1
user's latest post:
Checkboxes and Normalization
Published (2009-11-19 10:19:00)
dportas is absolutely right. Normalization doesn't guarantee correctness, just as denormalization doesn't guarantee incorrectness (but does guarantee awkwardness). What must always be the final source of deciding correct or incorrect is whether your design supports your business model. And to decide that, you always, always , always start from the business model, working your way from gross detail to fine detail. At each step of the...
ajetrumpet
1
user's latest post:
Help with Database design
Published (2009-11-19 08:27:00)
http://www.access-programmers.co.uk/...d.php?t=140587
mgrabows
1
user's latest post:
Checkboxes and Normalization
Published (2009-11-19 21:41:00)
Thank you Doc Man and dportas both for your comments. We did accomplish a design that was better suited for our organization here. As dportas mentioned, our initial usage of checkboxes to indicate accreditations was not necessarily unnormalized, but rather just kind of a pain to manage in MS Access. Sustainability is key (especially since I'll be leaving) so now we use one table (facilityAccreditations) to list all accreditations for all...
vrk1219
1
user's latest post:
Normalization Explained
Published (2009-11-22 02:46:00)
Hi Moniker, Both the links you have provided are not working. Could you please re-provide them with proper links. Thanks RK Veluvali
vrk1219 vrk1219 is offline...
1
user's latest post:
Normalization Explained
Published (2009-11-22 02:46:00)
Hi Moniker, Both the links you have provided are not working. Could you please re-provide them with proper links. Thanks RK Veluvali
georgedwilkinson
1
user's latest post:
Looking for the BEST way of...
Published (2009-11-23 13:29:00)
Duplicate post reported.
Chaz
1
user's latest post:
Link Excel to Access DB...
Published (2009-11-23 08:20:00)
Apologies of digging up an old thread but is it possible to have an excel document 'read' figures from Access 2007 (query and/or report)?
  

Latest active threads on Theory and practice of database design::

Started 5 days, 22 hours ago (2009-11-24 14:51:00)  by speakers_86
Please understand that Access and Excel are two completely different things. Think of Excel as a giant calculator. Excel is not meant to store information, Access is. That being said, why don't you start from the beginning? What type of business do you run? How does the business run? Who are your customers? How does a customer place a transaction with you? What are the different things ...
Thread:  Show this thread (7 posts)   Thread info: Order Intake DB Size: 618 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Order Intake DB :: Theory and practice of database design :: Access World Forums"
Started 2 years, 8 months ago (2007-03-07 22:04:00)  by boblarson
Great post - good reference material. thanks
Thread:  Show this thread (7 posts)   Thread info: Normalization Explained Size: 99 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Normalization Explained :: Theory and practice of database design :: Access World Forums"
Started 1 year ago (2008-11-07 13:04:00)  by Pat Hartman
The theoretical maximum number of users for an Access database is 255 although the practical limit is closer to 25. The problem is most likely with the shared .xls file.
Thread:  Show this thread (4 posts)   Thread info: Link Excel to Access DB problem,Office 2007 Size: 170 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Link Excel to Access DB problem,Office 2007 :: Theory and practice of database design :: Access World Forums"
Started 2 weeks, 6 days ago (2009-11-09 19:40:00)  by georgedwilkinson
You're right, it is not properly normalized. Think about it in a business sense. The word "Primary" is not a business word, nor is Secondary or Tertiary. As such, they should not be used for database object names. An example of how to straighten this out is to create a couple of more tables and move some of the columns from the existing tables: tblFacilities: stores facility ...
Thread:  Show this thread (15 posts)   Thread info: Checkboxes and Normalization Size: 1,655 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Checkboxes and Normalization :: Theory and practice of database design :: Access World Forums"
Started 2 weeks, 6 days ago (2009-11-10 09:33:00)  by HiTechCoach
I would use Access for this. In your design, I would put all people in a single table. This means employees and customers. About calculating the workdays, see: Add work days and calculate net work days
Thread:  Show this thread (11 posts)   Thread info: Help with Database design Size: 386 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Help with Database design :: Theory and practice of database design :: Access World Forums"
Started 2 weeks, 1 day ago (2009-11-14 13:19:00)  by wiklendt
one giant table with lots of nulls will take up space - lots of it. it will also not only slow down your queries but cause them to be VERY PAINFUL (and sometimes impossible, depending on the complexity of the results you want) to create in the first instance. what you need to do is "normalize" your data - you need a client table, a MedicalRecords table (with a ClientID in it to match them up) ...
Thread:  Show this thread (5 posts)   Thread info: Storing lots of NULL values Size: 834 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Storing lots of NULL values :: Theory and practice of database design :: Access World Forums"
Started 2 years, 3 months ago (2007-08-28 06:59:00)  by Bee
I use VSS which is a bit slow espcially if you are using it with WAN and used it to transfer large files. I don't understand your question: Quote: Access allows source control w/ that. Can you elaborate please? B
Thread:  Show this thread (4 posts)   Thread info: Access' Source Control with TFS??? Size: 538 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Access' Source Control with TFS??? :: Theory and practice of database design :: Access World Forums"
Started 2 weeks, 1 day ago (2009-11-15 04:17:00)  by georgedwilkinson
spam reported
Thread:  Show this thread (2 posts)   Thread info: On occasion television series Size: 13 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: On occasion television series :: Theory and practice of database design :: Access World Forums"
Started 2 weeks, 1 day ago (2009-11-15 04:13:00)  by georgedwilkinson
spam reported
Thread:  Show this thread (2 posts)   Thread info: Radio drama remains popular Size: 13 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Radio drama remains popular :: Theory and practice of database design :: Access World Forums"
 

Hot threads for last week on Theory and practice of database design::

Re: Order Intake DB - 7 new posts
Started 5 days, 22 hours ago (2009-11-24 14:51:00)  by speakers_86
Please understand that Access and Excel are two completely different things. Think of Excel as a giant calculator. Excel is not meant to store information, Access is. That being said, why don't you start from the beginning? What type of business do you run? How does the business run? Who are your customers? How does a customer place a transaction with you? What are the different things ...
Thread:  Show this thread (7 posts)   Thread info: Order Intake DB Size: 618 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Order Intake DB :: Theory and practice of database design :: Access World Forums"
Started 2 years, 8 months ago (2007-03-07 22:04:00)  by boblarson
Great post - good reference material. thanks
Thread:  Show this thread (7 posts)   Thread info: Normalization Explained Size: 99 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Normalization Explained :: Theory and practice of database design :: Access World Forums"
Started 1 year ago (2008-11-07 13:04:00)  by Pat Hartman
The theoretical maximum number of users for an Access database is 255 although the practical limit is closer to 25. The problem is most likely with the shared .xls file.
Thread:  Show this thread (4 posts)   Thread info: Link Excel to Access DB problem,Office 2007 Size: 170 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Link Excel to Access DB problem,Office 2007 :: Theory and practice of database design :: Access World Forums"