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

    A few general questions...

    Hi,

    I have a DB that I am using to keep track of student data. Despite reading lots of online info and the "bible", it seems my best answers come from this forum. So I have a few general questions:
    1. should a form always be created from a query or is a table equally effective?
    2. in creating a form from a table, can the records be "selected" i.e. show only active students?
    3. what would be the best way to approach recording daily attendance for multiple students in multiple courses? Right now I can't even imagine how to do that!
    4. what is the easiest way to find and print a single page from a report?
    Thanks in advance for any and all of your replies/answers,

    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
    49,229
    1. A table can be RecordSource. A query allows more flexibility in setting filter and sort criteria within the RecordSource.

    2. Use the Filter and FilterOnLoad properties of the form.

    3. Don't know your data structure but guess would involve form/subform arrangement and entering a record for each day for each student. This is why big schools have bubble sheets for attendance forms and machines that read bubble sheets and special attendance database software to manage the data. At least that was the method when I worked in schools 10 years ago.

    4. Can't, as far as I know. Apply filter criteria to the report so it has only the data you want to report.
    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 again June7. Your advice helped a lot.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,229
    Minor addendum to No. 4. You can print a specific page of a report but figuring out which page has the record you want is beyond me. That's what filtering is for.
    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.

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

Similar Threads

  1. General Questions about Access 2010
    By jack0987 in forum Access
    Replies: 2
    Last Post: 01-29-2012, 01:09 AM
  2. General Access questions - can or cannot
    By Armitage2k in forum Access
    Replies: 2
    Last Post: 11-28-2011, 07:28 PM
  3. Querry general questions
    By newtoAccess in forum Access
    Replies: 2
    Last Post: 04-04-2011, 06:56 PM
  4. General questions re:Access front-end
    By MWMike in forum Access
    Replies: 5
    Last Post: 09-25-2010, 10:33 AM
  5. General Questions about a Switchboard
    By yes sir in forum Access
    Replies: 2
    Last Post: 09-23-2010, 11:28 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 - Senior Forums