Results 1 to 7 of 7
  1. #1
    DPG is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    12

    Calendar question in access 2007


    Hi

    I am creating an access 2007 database for a preschool. I have all the essential data captured in one table, such as child details, contacts, emergency contacts etc. However I need to capture the days the child attends and need to query on this. what is the best way to do this? Do I create another table to record attendances or is there a calendar feature? I also want to calculate the cost per month and keep a track of this. What is the best way to do this?

    Thanks in advance.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by DPG View Post
    Hi

    I am creating an access 2007 database for a preschool. I have all the essential data captured in one table, such as child details, contacts, emergency contacts etc. However I need to capture the days the child attends and need to query on this. what is the best way to do this? Do I create another table to record attendances or is there a calendar feature? I also want to calculate the cost per month and keep a track of this. What is the best way to do this?

    Thanks in advance.
    Yea you will need another table for attendance. You will also need some more tables for the invoicing.

    I also suspect that there will be normalization issues if you really "have all the essential data captured in one table." You probably will need to break this table up not multiple tables.

    For example: You should have a table of all people. Children, parents, emergency contacts, teachers, etc.

  3. #3
    DPG is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    12
    Quote Originally Posted by HiTechCoach View Post
    Yea you will need another table for attendance. You will also need some more tables for the invoicing.

    I also suspect that there will be normalization issues if you really "have all the essential data captured in one table." You probably will need to break this table up not multiple tables.

    For example: You should have a table of all people. Children, parents, emergency contacts, teachers, etc.
    Hi Boyd

    Thanks for your response. Just to clarify, are you suggesting to split my table in to more than one and have several tables? such as, one for parents, one for emergency contacts, one for teachers etc etc? What do you mean by normalization issues?

    I would like to ask you further questions. How do I get in touch with you directly by email? if thats ok.

    Cheers
    David

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by DPG View Post
    Hi Boyd

    Thanks for your response. Just to clarify, are you suggesting to split my table in to more than one and have several tables? such as, one for parents, one for emergency contacts, one for teachers etc etc?
    You would have a single table for ALL People.

    I just a single junction table to relate the people together ar a parent or emergency contact ot teacher , etc.


    Quote Originally Posted by DPG View Post
    What do you mean by normalization issues?
    The rules of data normalization should be followed when designing any database.

    The key to a successful database is a good table structure that is properly normalized. When done properly, I rarely have to add new fields to a database.

    Here is just a few links to get you started:

    Understanding Normalization by Michael Hernandez:
    http://www.formeremortals.com/Downlo...malization.pdf
    Database Design Tips by Michael Hernandez:
    Database Design Tips.zip

    ACC: Database Normalization Basics
    http://support.microsoft.com/?id=100139
    http://support.microsoft.com/?id=209534
    http://support.microsoft.com/?id=283878
    Glossary of database terms:
    http://www.dhdursoassociates.com/dat...lossary-3.html
    Where to find information about designing a database in Microsoft Access:
    http://support.microsoft.com/?id=289533
    "Understanding Relational Database Design" Document Available in Download Center:
    http://support.microsoft.com/?id=283698
    http://support.microsoft.com/?id=164172
    ACC2000: "Understanding Relational Database Design"
    http://support.microsoft.com/?id=234208
    Fundamentals of Relational Database Design:
    http://support.microsoft.com/?id=129519
    http://www.oreilly.com/catalog/acces...pter/ch04.html
    Database Normalization Tips by Luke Chung
    http://www.fmsinc.com/tpapers/genacc...abasenorm.html
    Data Normalization Fundamentals by Luke Chung:
    http://www.fmsinc.com/tpapers/datanorm/index.html

    Support WebCast: Database Normalization Basics
    http://support.microsoft.com/default.aspx?scid=/servicedesks/
    webcasts/wc060600/wcblurb060600.asp

    Concepts Of Database Design And Management:
    http://www.sitepoint.com/article/dat...ign-management
    Database Design And Normalization (aimed at dBase, but still valid):
    http://www.jpmartel.com/bu12_c.htm
    Database Normalization:
    http://burks.bton.ac.uk/burks/foldoc/35/28.htm
    Introduction To Data Modeling:
    http://www.utexas.edu/its/windows/da...ing/index.html
    Access Data "Clean-up" Tips:
    http://pubs.logicalexpressions.com/P...cle.asp?ID=182
    Defining relationships between tables in a Microsoft Access database:
    http://support.microsoft.com/?id=304466
    http://support.microsoft.com/kb/304467/
    http://support.microsoft.com/kb/304468/

    Database Normalization Techniques:
    http://databases.about.com/od/specificproducts/a/normalization.htm

    Introduction to Database Normalization:
    http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

    Database Normalization:
    http://en.wikipedia.org/wiki/Database_normalization

    MVP Crystal Long's Access Basics document:
    http://www.allenbrowne.com/casu-22.html

    Data Modeling 101 by George Hepworth:
    http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf

    A Little Treatise on Normalization by Access MVP Jerry Dennison:
    http://tinyurl.com/hczcd
    Fully Qualified Naming - The First Step To Normalization by Access MVP Jerry Dennison:
    http://tinyurl.com/frgb3
    Glossary of Terms and Definitions by Access MVP Jerry Dennison:
    http://tinyurl.com/jow3q
    General Database Design Topics and Articles:
    http://www.databasedev.co.uk/general.html

    Rules of Data Normalization:
    http://www.datamodel.org/NormalizationRules.html

    Normalization Rules - Beyond The Third Normal Form
    http://www.curlingstone.com/Normalization2.html

    Normalization:
    http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html

    Normalization:
    http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

    Advanced Normalization:
    http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html

    Overview of Normalization:
    http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html

    Normalization:
    http://db.grussell.org/section008.html

    Normalization – BCNF:
    http://db.grussell.org/section009.html

    A Simple Guide to Five Normal Forms in Relational Database Theory:
    http://www.bkent.net/Doc/simple5.htm

    Introduction to Relational Databases - Part 1: Theoretical Foundation:
    http://www.15seconds.com/issue/020522.htm

    On DK/NF Normal Form:
    http://www.dbdebunk.com/page/page/621935.htm

    Database eLearning:
    http://db.grussell.org/index.html

    ACC: General Initial Planning Phase For A New Database Part I:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041
    ACC: General Planning a database – Part 2:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586
    Database Design Strategies:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932
    Normalizing a Database:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208
    Indexes - Info and Links:
    http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994
    SQL Tutorial:
    http://www.1keydata.com/sql/sql.html

    Data Warehousing and Business Intelligence:
    http://www.1keydata.com/datawarehousing/datawarehouse.html

  5. #5
    DPG is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    12
    Quote Originally Posted by HiTechCoach View Post
    You would have a single table for ALL People.

    I just a single junction table to relate the people together ar a parent or emergency contact ot teacher , etc.



    The rules of data normalization should be followed when designing any database.

    The key to a successful database is a good table structure that is properly normalized. When done properly, I rarely have to add new fields to a database.

    Here is just a few links to get you started:

    Understanding Normalization by Michael Hernandez:
    http://www.formeremortals.com/Downlo...malization.pdf
    Database Design Tips by Michael Hernandez:
    Database Design Tips.zip
    ACC: Database Normalization Basics
    http://support.microsoft.com/?id=100139
    http://support.microsoft.com/?id=209534
    http://support.microsoft.com/?id=283878
    Glossary of database terms:
    http://www.dhdursoassociates.com/dat...lossary-3.html
    Where to find information about designing a database in Microsoft Access:
    http://support.microsoft.com/?id=289533
    "Understanding Relational Database Design" Document Available in Download Center:
    http://support.microsoft.com/?id=283698
    http://support.microsoft.com/?id=164172
    ACC2000: "Understanding Relational Database Design"
    http://support.microsoft.com/?id=234208
    Fundamentals of Relational Database Design:
    http://support.microsoft.com/?id=129519
    http://www.oreilly.com/catalog/acces...pter/ch04.html
    Database Normalization Tips by Luke Chung
    http://www.fmsinc.com/tpapers/genacc...abasenorm.html
    Data Normalization Fundamentals by Luke Chung:
    http://www.fmsinc.com/tpapers/datanorm/index.html
    Support WebCast: Database Normalization Basics
    http://support.microsoft.com/default.aspx?scid=/servicedesks/
    webcasts/wc060600/wcblurb060600.asp

    Concepts Of Database Design And Management:
    http://www.sitepoint.com/article/dat...ign-management
    Database Design And Normalization (aimed at dBase, but still valid):
    http://www.jpmartel.com/bu12_c.htm
    Database Normalization:
    http://burks.bton.ac.uk/burks/foldoc/35/28.htm
    Introduction To Data Modeling:
    http://www.utexas.edu/its/windows/da...ing/index.html
    Access Data "Clean-up" Tips:
    http://pubs.logicalexpressions.com/P...cle.asp?ID=182
    Defining relationships between tables in a Microsoft Access database:
    http://support.microsoft.com/?id=304466
    http://support.microsoft.com/kb/304467/
    http://support.microsoft.com/kb/304468/
    Database Normalization Techniques:
    http://databases.about.com/od/specificproducts/a/normalization.htm
    Introduction to Database Normalization:
    http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
    Database Normalization:
    http://en.wikipedia.org/wiki/Database_normalization
    MVP Crystal Long's Access Basics document:
    http://www.allenbrowne.com/casu-22.html
    Data Modeling 101 by George Hepworth:
    http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf
    A Little Treatise on Normalization by Access MVP Jerry Dennison:
    http://tinyurl.com/hczcd
    Fully Qualified Naming - The First Step To Normalization by Access MVP Jerry Dennison:
    http://tinyurl.com/frgb3
    Glossary of Terms and Definitions by Access MVP Jerry Dennison:
    http://tinyurl.com/jow3q
    General Database Design Topics and Articles:
    http://www.databasedev.co.uk/general.html
    Rules of Data Normalization:
    http://www.datamodel.org/NormalizationRules.html
    Normalization Rules - Beyond The Third Normal Form
    http://www.curlingstone.com/Normalization2.html
    Normalization:
    http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html
    Normalization:
    http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html
    Advanced Normalization:
    http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html
    Overview of Normalization:
    http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html
    Normalization:
    http://db.grussell.org/section008.html
    Normalization – BCNF:
    http://db.grussell.org/section009.html
    A Simple Guide to Five Normal Forms in Relational Database Theory:
    http://www.bkent.net/Doc/simple5.htm
    Introduction to Relational Databases - Part 1: Theoretical Foundation:
    http://www.15seconds.com/issue/020522.htm
    On DK/NF Normal Form:
    http://www.dbdebunk.com/page/page/621935.htm
    Database eLearning:
    http://db.grussell.org/index.html
    ACC: General Initial Planning Phase For A New Database Part I:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041
    ACC: General Planning a database – Part 2:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586
    Database Design Strategies:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932
    Normalizing a Database:
    http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208
    Indexes - Info and Links:
    http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994
    SQL Tutorial:
    http://www.1keydata.com/sql/sql.html
    Data Warehousing and Business Intelligence:
    http://www.1keydata.com/datawarehousing/datawarehouse.html

    Thank you for this I shall have a good read.

  6. #6
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    You're welcome.

    We will be here when you have more questions.

  7. #7
    Join Date
    May 2010
    Posts
    339
    Code:
    Here is just a few links to get you started:
    LOL

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Acess 2007 & SQL question
    By willigiann in forum Forms
    Replies: 3
    Last Post: 09-15-2010, 09:54 AM
  2. Access 2007 question?
    By NewOrder in forum Access
    Replies: 3
    Last Post: 08-08-2010, 06:39 AM
  3. Replies: 0
    Last Post: 11-17-2009, 02:35 PM
  4. Access Calendar Control
    By JGG in forum Access
    Replies: 7
    Last Post: 04-03-2009, 04:34 AM
  5. Access - Calendar Control
    By James890 in forum Forms
    Replies: 3
    Last Post: 04-01-2009, 04:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums