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

    Possible question in the design of a database


    Dear All
    I want to analyze the system and a small clinic you design tables for the patients ... but the question has to sometimes be booked by appointment Telephone Will I do the design table reservations or do I put the main data table bookings for patients immediately with

  2. #2
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    I would use another table for reservations and use a reservation subform in your main form

  3. #3
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    I have attached a little database to show what I mean, doing it this way means that you also keep a history of all appointments that patient has made, and you could add fields like failed to keep appointment ect
    Attached Files Attached Files

  4. #4
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37
    very very thank you my dear teacher

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

Similar Threads

  1. design Simple Attendance System
    By AzizSader in forum Forms
    Replies: 2
    Last Post: 12-07-2013, 11:26 PM
  2. New System Design
    By tweety in forum Database Design
    Replies: 4
    Last Post: 11-19-2012, 01:54 PM
  3. Appointment system Design
    By monkeyhead in forum Database Design
    Replies: 1
    Last Post: 04-02-2012, 09:10 AM
  4. USG Clinic exam system: Changing User
    By isnpms in forum Access
    Replies: 2
    Last Post: 08-22-2010, 07:31 PM
  5. System lag when in report design view
    By vCallNSPF in forum Access
    Replies: 5
    Last Post: 12-10-2009, 08:38 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