Results 1 to 3 of 3
  1. #1
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37

    appointment Sample Database

    Dear All


    This is a simple example to reserve dates sick and you design tables patient table and table reservations and you link between the two tables ONE TO MANY
    But sometimes be booked an appointment by telephone, how can register the patient in this case
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,972
    Don't understand the question. What does it matter that the information is provided in person, over phone, by email, or sticky note? Enter data into table.
    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
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    I agree with June7! Regardless of how the appointment is made, you have to input the patient information (name, birthdate, gender, etc) for the patient table/form before you can make an appointment for them, in the subform. Whether you take the infomation face-to-face or over the phone doesn't matter.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. sample database for patient database and lap reports
    By vijay in forum Sample Databases
    Replies: 3
    Last Post: 11-07-2014, 03:40 AM
  2. Sample database for a beginner
    By amphinomos in forum Sample Databases
    Replies: 4
    Last Post: 07-13-2013, 03:51 PM
  3. Appointment Booking Database
    By richie2837 in forum Access
    Replies: 1
    Last Post: 07-16-2011, 01:39 AM
  4. sample database
    By TP takamiya in forum Access
    Replies: 4
    Last Post: 10-06-2010, 07:33 PM
  5. ULS database sample please...
    By genesis in forum Access
    Replies: 1
    Last Post: 07-17-2009, 12:12 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