Results 1 to 3 of 3
  1. #1
    Daryl2106 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    167

    Design question

    I am a very new user tasked with designing a datbase to manage student records for a small (120 student) program.



    My priority task is to create a form that will allow teachers to enter monthly attendance data, progress and grade data for each student enrolled in their courses (typically three). I would like them to be able to select their name from a combo box and then choose the week they wish to add the attendance for each student. They need to be able to access previous records to update if necessary.

    I have (as far as I know) all the tables and relationships established. I just thought I would seek some advice before I began trying lots of different things before I stumbled upon the simplest and best way to do it.

    Any and all suggestions are appreciated.

    Thnaks in advance.

    Take care,

    Daryl

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Reinventing the wheel. If you Google: Access database student attenance, will find it has been done. You might find one that suits you or will give ideas.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Daryl2106 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    167

    Thanks

    Hi,

    Thanks so much. I have found a few and am using them to help solve problems I encounter and get ideas from.

    Take care,

    Daryl

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

Similar Threads

  1. Database Design Question
    By AccessNewBiegr in forum Access
    Replies: 2
    Last Post: 02-08-2011, 08:22 AM
  2. Basic design question
    By Brant in forum Access
    Replies: 2
    Last Post: 11-10-2010, 12:37 PM
  3. Design Question
    By grahamee in forum Access
    Replies: 2
    Last Post: 06-14-2010, 11:13 AM
  4. DB design question
    By dlburkins in forum Database Design
    Replies: 2
    Last Post: 08-28-2009, 07:06 PM
  5. Design Question
    By bdriscoll in forum Database Design
    Replies: 3
    Last Post: 05-03-2009, 08:57 AM

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