User Guide Epilepsy Database
Contents
1. Pmt hao Sepa Savina 64 8 if Thee type of Ala could am pou poar aT it Onna Nas ia aL ea Wig ou ling fo pe fe eet eee bp woe cope Tiag Tantel j kiai inhi Ej Ep ie et yl fey dc Page 5 Loading the database To load the database 1 Browse to the file location in which the database is stored 2 Double click on the database icon to access to database see figure 6 Figure 6 Database Icon y Mon Bolton version Microsoft Access Application 34 304 KB 3 0 Using the database When you first access the database the Main Menu screen figure 3 will appear providing clinic population statistics and a choice of buttons which enable users to access menus and forms Another button has been provided to enable the user to exit the database at any point Figure 7 Main Menu Young Person s Epilepsy Clinic population Patients in Clinic 5 statistics Patients discharged from Clinic 2 Total number of Patients seen thus far T mi Open Fatient Menu Charts __ Add New Patient Details __ Maintain Drop Down Boxes Menu Buttons mi Open Query Menu _ Exit the Datafase Exit Button linked to menus and forms Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 Page 6 The user can access the following menus and forms from the Main Menu Patient Menu Charts Menu Query Menu Maintain Drop Down Boxes Menu Add New Patient Details Form VVVV WV 3 1 Patie2. Show patients under treatment Select a referral and show associated patients Select a Therapy and show associated patients Show Age Vs Sex of patients Show Discharged Patients Show Current Patients Show Transition Clinic Attendees Show Side Effects of Drugs Show all DTH Original Patients Show Test Vs Epil Synd Vs test result VVVVVVVV VV To access a query 1 Click on any button between 1 and 10 To close the Query Menu 1 Click on button 11 Bolton Children s and Young Person s Epilepsy Clinic select a referral and show associated patients select a therapy and show associated patients Buttons 1 to 4 show Age W s Sex of patients 10 which are Show Discharged Patients 5 g linked to queries G show Current Patients 7 chow Transition Clinic Attendees g show side effects of drugs g show all OTH original patients 10 show test v s Epil Syd W s test result 1 Return to Main Menu Return to Main Menu Eas Jesigned and Built By Team l 15 Institute University of Salford May 2005 Page 15 3 2 1 Patients Under Treatment query When you click on button 1 the Patients Under Treatment will query form will appear as shown in figure 22 The form provides a drop down menu to enable the user to select a drug As a result of the selection of a particular drug the query will retrieve and display the patients that have taken the drug selected Three buttons are also provi
3. amla th BLEamMenriasorne Carbamazepine Clobazarn Clonazeparn Diazepam Ethosuximide Gabapentin 3 Click on the drug highlighted Page 24 The selected drug should appear in the drop down menu box as shown in figure 41 below Figure 41 Selected Drug appears in drop down menu box H Select drug name V EpilSyd for side effects Eg Please select Drug Name and select Open Form to view records OR select Show All to view all records OF select Drug Name Epilepsy Syndrome and select Drug EpilSyc nvon Fom how At cancel To select an epilepsy syndrome follow the same steps for the drug drop down menu To retrieve records of patients who have suffered the epilepsy syndrome and drug entered 1 Click on Open Form To show all patients 1 Click on Show All To close the form and return to the Query Menu 1 Click on Cancel 3 2 9 Show all DTH Original patients Query When you click on button 9 the Show Side Effects of Drugs query form will appear as shown in figure 42 This particular form provides an input box that requires you to enter either Y for Yes or N for No As well as an input box the form includes three buttons One is called Open Form which retrieves records of patients who are either DTH original or not depending on the value entered Another button is included called Show All which retrieves records of all patients regardless of whether they are DTH original or not Finally a butto
4. Menu 1 Click on Close Form Page 36
5. and manage patient information The user guide contains the following sections gt Getting Started Provides a description on how the database can be obtained and opened gt Using the database Provides a step by step guide on how to use the different features of the database 2 0 Getting Started 2 1 Where Now lf you are a user who has not previously downloaded the database then refer to the Software Requirements section below lf you are a user who has downloaded the database but has never used it before then refer to the First Steps section Users who wish to view to another section of the user guide please refer to the contents page at the beginning of this document 2 2 Software Requirements In order to use the Epilepsy Care database you need the following software to be installed on your computer gt Microsoft Office 2000 version This contains Microsoft Access which the Epilepsy Care database runs on gt Windows 2000 ME XP or Vista Microsoft Office 2000 can run on these operating systems Page 3 2 3 Downloading the Database To download the database follow the following steps 1 Click on the Internet Explorer icon figure 1 to log on to the Internet Figure 1 Internet Explorer Icon F Internet Explorer 2 Enter http www boltonepilepsycare com in to the URL box displayed in figure 2 Figure 2 Location of URL Box File Edt view Favorites Tools Help
6. appear in the drop down menu box as shown in figure 29 below Figure 29 Selected referral appears in drop down menu box 6 Select a Referral fx Please select a referral from the drop down bos and then select Open Form OR select Show All to show all referrals npon Fom show At Conc To view the patients who under particular referral 1 Click on the Open Form button To view records of patients who have been referred 1 Click on the Show All button Page 18 To close the form and return to the Query Menu 1 Click on the Close form button 3 2 3 Associated Patients Query 2 When you click on button 3 the Associated Patients query form will appear as shown in figure 30 The form provides a drop down menu to enable the user to select a therapy As a result of the selection of a particular therapy the query will retrieve and display the patients who have undertaken the therapy selected Three buttons are also provided that show patient who have undertaken a selected therapy show all patients in the clinic that have undertaken a therapy and finally close the form Figure 30 Form to select a Therapy E Select a therapy Eg Please select the therapy required and select Open Show All Form to view records OR select Show All to view Therap 2 drop Button all records down menu w Ap Cancel 4 To select a therapy from the therapy drop down menu Open Form Cancel button to close form b
7. displays records of patients who are currently being treated The form provides a close button to enable you to exit the form at any point Figure 36 Current Patients Query Current Patients Patient ID Epilepsy Syndrome Age Hame of GP 1000 Maximus Decimus Meridius ESES 20 H Dr l Ferguson 1003 Damen Hill Complex febnle convulsions H Dr 5 McPhearson E 1004 David Hasselhof ESES 21 H Dr F Richardson E 1006 Condolezza Rice BECT 13 H Dr H Gordon E 1007 James Whale Complex febrile convulsions 12 H DrK Livingston E AutoN umber 0 E Page 22 To close the form and return to the Query Menu 1 Click on Close Form 3 2 Transition Clinic Attendees Query When you click on button 7 the Transition Clinic Attendees query form will appear as shown in figure 37 This particular form displays records of patients who are attendees of the transition clinic The form provides a close button to enable you to exit the form at any point Figure 37 Transition Clinic Attendees Query Transition Clinic Attendees Patient ID Epilepsy Syndrome 1001 Phoebe Buffet Benign epilepsy with occipital paroxysms 19 H T 1004 David Hasselhof ESES 21 M Iv Ci AutoNumber o C To close the form and return to the Query Menu 1 Click on Close Form 3 2 8 Show Side Effects of Drugs Query When you click on button 8 the Show Side Effects of Drugs query form will appear as shown in figure 38 This particular form provides two drop down menus Thes
8. in drop down menu box H Select Test V Epil Syd V test result Please select the search crtena from the three drop down boxes and then select Open Form OR select Show All to view all records Test Name SED Level Test Result ED Levels Show A To select a test result and epilepsy syndrome follow the steps for the test name drop down menu To retrieve records of patients who match the values selected from the drop down menus 1 Click on Open Form To view all records of patients 1 Click on Show All To close the form and return to the Query Menu 1 Click on Cancel Page 28 3 3 Charts Menu To open the Charts Menu 1 Click on Charts on the Main Menu See Figure 47 Figure 47 Main Menu Young Person s Epilepsy Patients in Clinic 5 Patients discharged from Clinic 2 Total number of Patients seen thus far T __ Open Patient Menu Charts Button to __ Add New Patient Details __ Maintain Drop Down Boxes Menu open the __ Open Query Menu __ Exit the Database charts menu Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 When you have clicked on Charts the Charts Menu will appear as shown in figure 48 This particular form contains a menu of buttons numbered 1 to 8 Five of the buttons are linked to a particular chart two are linked to other chart menus while the other enables the user to close the Chart Menu at any time The following charts c
9. Assessment Chromosomes CT Brain Scan ECG MR Brain Scan VVVVVVV WV Page 30 Other PET Scan Prolonged EEG Sleep EEG Specialist Centre Work up SPECT Scan Straight EEG Toxoplasma Serology Urine Metabolic Work up gt Video EEG VVVVVVVV V To access a chart from the Test Ordered and Result menu gt Click on the button that is linked to the graph of your choice To close the form and return to the Chart Menu gt Click on the Close Form button Figure 49 Test Ordered and Result Bolton Children s and Young Person s Epilepsy Clinic AED Levels Ec Specialist Centre Workup Blood Metabolic work up MF Brain Scan SPECT Scan Blood Sugars Calcium Mkher Straight EEG Cardiology 4ssessment PET Scan Toxoplasma Serology Chromosomes Prolonged EEG Urine Metabolic work up CT Brain Scan Sleep EEG video EEG Menu of buttons that are linked to charts PE Close Form ee Fone buton 3 3 2 Number of Specific Interventions per Child Menu When you click on button 6 the Number of Specific Interventions per Child menu form will appear as shown in Figure 50 This particular form provides a total of seven buttons which are Page 31 all linked to a chart The form also provides a close button to enable you to close the form and return to the Chart Menu The following charts can be accessed from this form Behavioual Immunoglobulins Ketog
10. Back x H A p Search S p Favorites E A EA a aa 3g Address http www boltonepilepsy cart v BIG http www boltonepilepsycare com entered in to the URL box 3 Press Enter on your keyboard and the Epilepsy Care Centre website Home page will appear as shown in figure 3 4 Click on the Downloads link see figure 3 Figure 3 Home Page www boltonepilepsycare com l Halliwell Children s Centre Telephone 01204 529381 Bolton Welcome to Bolton Prima Care Trust Please choose which version of the site you would like to Announcement nn view 01 April 2008 gt Message Board New Epilepsy Care website goes live gt Drug Information O01 January 2008 gt Information Flash version New Epilepsy Care website nearing Non Flash version completion gt Downloads 01 October 2007 New Epilepsy Care Downloads Download Adobe Flash Player here website under link intensive development If after clicking on Flash version you get an Internet Explorer security message like the one below click on Allow and then reload the page We Be Bolton Epilepsy Care Website To heip protect your security Internet Explorer has restricted this webpage from running scripts or ActiveX controis tha in Ke a a Page 4 A page providing three download links one of which is called Database see figure 4 Figure 4 Downloads Page www boltonepllepsycare com Halliwell Children s Centre Telepho
11. Condolezza Rice Damen Hill David Hasselhot James Whale Maximus Decimus Meridius Phoebe Buttek Page 8 2 Move the mouse cursor over a name shown in the drop down menu and click on the name once highlighted as shown in figure 12 below Figure 12 Name Selection Alice Cooper Condolezza Rice Damien Hill David Hasselhot James Whale Maximus Decimus Meridius Phoebe Buffet After you have clicked on a name it should then be displayed in the drop down menu box as shown below Figure 13 Name Displayed EEE l Now you have chosen a name select a form in which you want to access that will provide the information that you want regarding the chosen patient The forms that you can access are as follows gt Patient Details Provides general information regarding the chosen patient gt AED History Provides information regarding drugs taken and seizure frequency gt Test Results Provides information on how patients fared when undertaking tests gt Other Therapies Provides information of any other therapies that the patient has received To access these forms 1 Click on one of four buttons linked to a form on the Patient Menu Figure 14 If at any point you want to exit the Patient Menu and return to the Main Menu 1 Click on Main Menu Page 9 Figure 14 Menu Buttons E Patient Menu Eg Please select the patient name from the list below and then select the required form View AED J
12. Figure 54 Main Menu Young Person s Epilepsy Patients in Clinic 5 Patients discharged from Clinic 2 Total number of Patients seen thus far T __ Open Patient Menu Charts _ Add New Patient Details __ Maintain Drop Down Boxes Menu Open Query Menu __lExit the Database Add New Patient Details button Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 Page 35 When you have clicked on the Add New Patient Details button the Add New Patient Details form will appear as shown in figure 55 This particular form is a blank version of the Patient Details form which enables you to enter data The form provides a close button to enable you to close the form and return to the Main Menu at any point Figure 55 Add New Patient Details Form Patient Details Personal Details Epilepsy History General History Check List Discharge Details Nursing Care Plan Name Consent E View Chart z Input fields at First Seen View Chart blank Eee Age First Seen jo View Chart Enter age first seen Se et Close Form pilepsy Syndrome button Original to Clinic jo Symptom State Age E ror Close Form Enter Age 0 i Delete Record To add a record to the patient table 1 Enter values in to the empty form The values entered are automatically added to the patient table To close the form and return to the Main
13. User Guide For The Epilepsy Database Page 1 Contents 1 0 Introduction Pete PE NE ET A A EE E EA RE A namie ee TARE Page 3 1 1Aim OF the CA AD AS Ciro sacs unna edena ESERE READERIN Page 3 1 2How to use this MaANnUal cocsnsessredenestvanserwiei benedeni Page 3 20 GEUING Started sn a a sa ceee Page 3 6 2 TWhNer NOW szsirdsianeoz n Da a aaa Page 3 2 2 Software REQuireMent 2 ccccceccccnncnncercennennennennecnensnensenes Page 3 2 3 Downloading the Database cccccccececnenenenenneeeeenenennanans Page 4 6 2 4Loading the DalavaSe vvriincscasercviicassumicosiercdaseerebdiazdamueyioee Page 6 3 0 Using the database nsnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn Page 6 36 31 AUONE Mensiz aa Page 7 14 3 1 1 Patient Details FOrM aannnnaannnnannnnnnnnnnnnnnnnnnnnnnnnnn Page 10 13 2V2 AED HISO FOMM s222c eurveedascel osanunededsensiceocersbongcaundees Page 12 13 So ll CSUINCSUNG ic 2s san taneghecieaonrensacesat tuenlet Eaa Page 13 3 1 4 Other MGA DISCS visite eirsotra a eaieteseteun ion voateieleadieete tena deavad Page 14 2 QUV MODNU ecstasy ees E esas Usee ieee eiceoe wena Page 14 28 3 2 1 Show Patients Under Treatment Query 0 ce eee Page 16 17 3 2 2 Associated Patients 1 ccc cece cee ee cece eee eeeeeeeeenees Page 17 19 3 2 3 Associated Patents 2 42 0 si gebaenseadieeeduaduivatenbacaiseniecontied Page 19 20 3 2 4 Age Vs Sex of Patients QUETY 0
14. ames Whale T View Patient History form Details form Patient Details AED History View Test Test Results View Other Results form Main Menu Return to Main Menu Therapies form When the user clicks on the Patient Details button the Patient Details form will appear displaying information of the patient chosen as shown in figure 15 This information can be both edited and deleted The Patient Details form is divided in to six different sections that cover different aspects of the patient These sections are as follows 3 1 1 Patient Details Form gt Patient Details Provides general information about the patient such as name sex and age gt Epilepsy History Provides information regarding the epilepsy seizure history of the patient gt General History Provides information on the general medical history of the patient gt Check List Provides information on how the patients condition is managed and any advice they receive gt Discharge Details Details whether the patient has been discharged or not gt Nursing care plan Provides information on the care that the patient will receive To access the other sections of the form 1 Click on one of the six tabs provided at the top of the form Refer to Figure 15 The Patient Details form also provides links to charts that represent statistical information a particular aspect of the clinic population These links have been named as View Chart a
15. an be accessed from the Chart Menu AED s used for clinic population Number of AED s tried per child AED that has been allocated first Number Major Minor side effects Causes of epilepsy VVVV WV Chart Menus that can be accessed from the Chart Menu gt Test ordered and result gt Number of Specific Interventions per child Page 29 To access a particular chart gt Click on buttons 1 2 3 4 and 7 To access one of the extra chart menus gt Click on buttons 5 and 6 To close the chart menu and return to the Main Menu gt Click on button 11 Figure 48 Chart Menu Bolton Children s and Person s Epilepsy Clinic Buttons p AED s used for clinic population linked to P Numbers of AED s tried per child charts AED that has been allocated first Number I major minor side effects Buttons Test ordered and result linked to extra menu Number of specific interventions per child Causes of epilepsy Button to return to Main Return to Main Menu Menu 3 3 1 Test Ordered and Result Menu When you click on button 5 the Test Ordered and Result menu form will appear as shown in Figure 49 This particular form provides a total of eleven buttons which are all linked to a chart The form also provides a close button to enable you to close the form and return to the Chart Menu The following charts can be accessed from this form AED Levels Blood Metabolic work up Blood Sugar Calcium Cardiology
16. ates is calculated and this difference is searched against the values stored in the Age field in the Patient table Another input box is provided to enable you to enter either M for male or F for female This enables you to search against male or female patients whose age match the difference calculated As well as three input boxes four buttons are included on the form One of the buttons is called Open Form which is only used if search criteria is entered in to all three input boxes and displays records that of patients whose details match the search criteria entered Another button shows all patients in the clinic regardless of their age or sex No search criteria needs to be entered before clicking on this button A third button called View both Sexes is included that searches against age values stored using the start and finish date entered Patients whose age match the difference calculated are displayed regardless of their sex This means that the patient s sex does not have to be entered Finally a button called Cancel has been included to enable you to close the form Page 20 Figure 34 Age Vs Sex Query form Please enter date range for search and the sex required and then select Open Form to view records OF select Show All Show All to view all records button Start and End date input boxes Start Date for search End Date for search P Se E Pipen Form stow at View Both Sexes Sex input
17. box Open Form button Cancel Button View Both Sexes button To search against age and sex 1 Enter a start date in the format of 12 Mar 01 2 Enter an end date in the format of 12 Mar 01 3 Enter either M for male or F for female 4 Click on Open Form To retrieve all patients regardless of age or sex 1 Click on Show All To search against age and show records of patients whose age matches the difference calculated 1 Enter a start date 2 Enter an end date 3 Click on View Both Sexes To close the form and return to the Query Menu 1 Click on Cancel 3 2 5 Show Discharged Patients Query When you click on button 5 the Discharged Patients query form will appear as shown in figure 35 This particular form displays records of patients who have been discharged The form provides a close button to enable you to exit the form at any point Page 21 Figure 35 Discharged Patients Query Discharged Patients Date of Discharge Hame Discharged To Reason for Discharge Epilepsy Syndrome 1O 9 2004 Phoebe Buffet Dr 5S Farnham maintaining condition 372272003 Alice Cooper bir 7 Maxwell Benign epilepsy with occipital paroxysm Benign epilepsy with occipital paroxysm To close the form and return to the Query Menu 1 Click on Close Form 3 2 6 Show Current Patients Query When you click on button 6 the Current Patients query form will appear as shown in figure 36 This particular form
18. ccc cece eee ee ee eee ees Page 20 21 3 2 5 Discharged Patients QUETY cece cece e eee e eee eeeeeeeaees Page 21 22 3 2 6 Current Patients QUETY c ccc cece ee eeeeeeeseeeenaeeneaes Page 22 3 2 7 Transition Clinic Attendees ccc cece eeceaeeeeeeeeeeaas Page 23 3 2 6 SIde Effects Of DIUGS ic saatsctiwdsscncdniceaneauiiionees dquecatdatienont Page 23 25 22 9D Tr Onginial Patents sergisine Aee Page 25 26 3 2 10 Test Vs Epilepsy Syndrome Vs Test Result Query Page 26 28 33 Charl MON caseasc senate esa aaceet EERE EEE RAER Page 29 33 3 3 1 Test Ordered and Result MeNu ccc ceeee cence eee ees Page 30 31 3 3 2 Number of Specific Interventions per Child menu Page 31 32 3 4 Maintain Drop Down Boxes Menu 11cccccecsencnnenneeesennennanens Page 33 35 3 4 1 Maintain and Enter Acute Treatments 0 0ccee eee Page 34 35 3 5 Add New Patient Details FOrm ccccccccceeenceneesenennensseenennaaes Page 35 36 Page 2 1 0 Introduction This user guide has been compiled to assist database users in operating the database and gaining an understanding of the database functionality 1 1Aim of the database The aim of the database developed is to provide staff at the Bolton Epilepsy Care Centre with a means of storing patient information which can later be retrieved when needed Moreover the database aims to assist the Epilepsy care staff to effectively organise
19. d isn t valid for this field Jj For example vou may have entered text in a numeric field or a number that is larger than the FieldSize setting permits gt Numeric Fields All fields such as Age must be entered as a number NOT text If you fail the enter a numeric value the error message shown above will appear gt Discharged field Enter either Yes or No NOT Y or N This will prevent problems occurring with the charts as the database will only count the Yes or No values gt DTH Orginial field Enter either Y or N NOT Yes or No This will prevent problems occurring with the charts as the database will only count the Y or N values gt All fields must have a value entered To avoid problems occurring with the charts ensure that you enter a value in to all fields provided If a field happens to be not applicable for the patient either enter N A or none To edit data 1 Make the appropriate changes to the patient s information ensuring that you follow the data entry regulations 3 1 1 2 Deleting Data To delete data from the database 1 Click on the Delete Record button See Figure 15 3 1 2 AED History form When the user clicks on AED History the AED History form will appear as shown in figure 17 The form displays two tables One displays information of the drugs that the patient has taken and the other that displays
20. ded that show patients who have taken the drug selected show all patients in the clinic that have taken a drug and finally close the form Figure 22 Patients Under Treatment Query form H Select a Drug Eg Show All Please select a drug from the drop down box and then Drug drop Button elect Open Form OF to show all select Show All down menu Open Form a l button Cancel button to To select a drug 1 Click on the down arrow on the right hand side of the drop down menu as shown in figure 23 Figure 23 Down Arrow gt 2 Move the mouse cursor over a drug so that the drug name is highlighted as shown in figure 24 Figure 24 Drug highlighted E Select a Drug Eg Please select a drug from the drop down box and then select Open Form OF to show all select Show All betamethasone Carbamazepine Clobazami 3 Click on the drug highlighted Page 16 The selected drug should appear in the drop down menu box as shown in figure 25 below Figure 25 Selected Drug appears in drop down menu box H Select a Drug Ed Please select a drug from the drop down bos and then select Open Form OF to show all select Show All ACTH Ovan om B shonas f corea To view the patients who have undertaken the selected drug 1 Click on the Open Form button To view records patients who have taken a drug 1 Click on the Show All button To close the form and return to the Query Menu 1 Clic
21. e drop down menus enable you to select a drug and an epilepsy syndrome The selected drug and epilepsy syndrome will be used to retrieve specific patients that have taken a particular drug and experienced a certain epilepsy syndrome As well as drop down menus three buttons are included One of the buttons is called Open Form which displays records of patients who have taken the drug and suffer the select epilepsy syndrome Another button is called Show All which shows records of all patients regardless of the drugs taken and epilepsy syndrome suffered Finally a cancel button is included to enable you to exit the form at any point Page 23 Figure 38 Show Side Effects of Drugs Query H Select drug name V EpilSyd for side effects Ed Please select Drug Name and select Open Form to view records OR select Show All to view all records OR select Drug Name Epilepsy Syndrome and select Drug Y EpilSyd Drug name and Show All a Drug Name PA epilepsy utton Pt Sa syndrome drop down menus To select a Drug from the Drug Name drop down menu 1 Click on the down arrow on the right hand side of the drop down menu as shown in figure 39 Figure 39 Down Arrow Down arrow Drug Marre 2 Move the mouse cursor over a drug so that the drug name is highlighted as shown in figure 40 Figure 40 Drug highlighted Syndrome and select Drug W EpilSyd Drug Name Epilepsy 5 pr drome
22. inic Diet Other Palliative Surgery Resective Surgery gt VNS VVVVVV To access a chart from the Test Ordered and Result menu 1 Click on the button that is linked to the graph of your choice To close the form and return to the Chart Menu 1 Click on the Close Form button Figure 50 Number of Specific Interventions per Child Menu Other Immunoglobulins Palliative Surgery Ketogenic Diet Resective Surgery Menu of buttons that are linked to charts lt Close Form button Page 32 3 4 Maintain Drop Down Boxes Menu To access the Maintain Drop Down Boxes Menu 1 Click on the Main Drop Down Boxes Menu button on the Main Menu see Figure 51 Figure 51 Main Menu Young Person s Epilepsy Patients in Clinic 5 Patients discharged from Clinic 2 Total number of Patients seen thus far T Maintain Drop Down Boxes __ Open Patient Menu Charts __ Add New Patient Details __ Maintain Drop Down Boxes Menu Open Query Menu __lExit the Database Menu Button Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 When you have clicked on Maintain Drop Down Boxes Menu the Maintain Drop Down Boxes Menu form will appear as shown in figure 52 This particular form provides a menu of buttons that direct you to a form that provides the functionality to change what options are included in the drop down menus contained in this database Each button i
23. k on the Close form button 3 2 2 Associated Patients Query 1 When you click on button 2 the Associated Patients query form will appear as shown in figure 26 The form provides a drop down menu to enable the user to select a referral As a result of the selection of a particular referral the query will retrieve and display the patients under the referral selected Three buttons are also provided that show patients under the selected referral show all patients in the clinic that have been referred and finally close the form Figure 26 Associated Patients Query 1 ES Select a Referral Please select a referral from the drop down bos and then select Open For OR select Show ll to show all referrals _ a Show All Button Referral drop down menu Open Form button Cancel button to close form Page 17 To select a referral from the referral drop down menu 1 Click on the down arrow on the right hand side of the drop down menu as shown in figure 27 Figure 27 Down Arrow 2 Move the mouse cursor over a referral so that the referral type is highlighted as shown in figure 28 Figure 28 Referral highlighted H Select a Referral Ed Please select a referral from the drop down box and then select Open Form OF select Show All to show all referrals Acute Child Psych i Other Paed Mm RI l 3 Click on the referral type highlighted The selected referral should
24. n called Cancel is included to enable you to close the form Page 25 Figure 42 DTH Original Patients Query Form H Select DTH original Show All button There are 4 DTH original patients Select Open Forr to view all OTH orginal patients OF type no and then select Open Form to view non OTH onginalpatients OF select Show All to view all records Input box Open Form button fot ETTE To search for DTH Original or non DTH Original patients Cancel Button 1 Enter Y for Yes or N for No in to the input box provided 2 Click on Open Form To view all patients records 1 Click on Show All To close the form and return to the Query Menu 1 Click on Cancel 3 2 10 Show Test Vs Epilepsy Syndrome Vs Test Result When you click on button 10 the Show Side Effects of Drugs query form will appear as shown in figure 43 This particular form provides three drop down menus These drop down menus enable you to select a test name test result and an epilepsy syndrome The selected test name test result and epilepsy syndrome will be used to retrieve specific patients that have undertaken a particular test and suffered a certain epilepsy syndrome As well as drop down menus three buttons are included One of the buttons is called Open Form which displays records of patients who have undertaken the selected test and have suffered the selected epilepsy syndrome Another button is called Show All which sho
25. n the user clicks on Other Therapies the Other Therapies button appears as shown in figure 18 This particular form displays a table that provides information of other therapies that the patient has received To close the form and return to the main menu 1 Click on Close Form Figure 19 Other Therapies Name James Whale Other Therapies _ TreatmentName Date Started Date Finished Side Hinds Comments EJ 21 Jul 98 28 Aug 98 FIRE PEET 12 Nov 00 08 Dec 01 a showing other therapies received Close Form button 3 2 Query Menu To access the Query Menu 1 Click on Open Query Menu on the Main Menu See figure 20 Figure 20 Query Menu Button Young Person s Epilepsy Patients in Clinic 5 Patients discharged from Clinic 2 Total number of Patients seen thus far T mi Open Patient Menu Charts __ d New Patient Details __ Maintain Drop Down Boxes Menu Open Query Menu __ Exit the Database Open Query Menu button Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 Page 14 When you have clicked on Open Query Menu the Query Menu form will appear as shown in figure 21 This particular form contains a menu of buttons numbered 1 to 11 Ten of the buttons are linked to a particular query while the other enables the user to close the Query Menu at any time The following queries can be accessed from the Query Menu
26. nd appear next to certain fields that relate to a particular chart detailed in figure 11 For example on the Patient Details section a link appears next to the Date First Seen field which will display a chart showing the number of patients first seen on a particular date Page 10 To view a Chart 1 Click on the View Chart link Also provided on the Patient Details form is a close button detailed in figure 11 To close the form and return to the main menu 1 Click on Close Form Figure 15 Patient Details Form Patient Details James Whale Six tabs Vies art to vi ew chosen Date First Seen 24 Jul 91 View Chart sections atient P Age First Seen ew Chart Enter age first seep _ Complex febrile convulsions Close Links paginatto Clinic iw Form to Symptom State Probably Symtomatic button charts i eee ails ie pe ine Close Form Enter Age E l Delete Delete Record record button 3 1 1 1 Editing Data Before editing data please follow the following regulations for data input gt Date Fields Dates are stored in the format of DD Month YY and therefore must be entered in this format Example Date 12 Mar 00 Page 11 If you fail to enter a date correctly the error message shown in figure 16 To return to the form 1 Click OK Figure 16 Error Message Childrens Epilepsy Clinic Ed The value you entere
27. ne 01204 529381 Bolton Welcome to Bolton Primary Care Trust File Download Centre Announcement gt Home 4 From this page you may download the new Epilepsy Care Database Database User Guide and the ee gt Message Board Website Admin Guide Simply right click on the download link and select Sawe Target As to initiate the stil SARE aes Wheat eee er werner file transfer The database file will need to be downloaded and saved to your computer for it to run ai aia ie ZL B E properly Please be sure to run a precautionary scan for virus s and other malware on the file before 01 January 2008 gt Information opening it New Epilepsy Care website nearing gt Downloads completion Database Download a blank copy of the database ready to use gt Links 01 October 2007 User Guide Download a copy of the database user guide New Epilepsy Care gt Contact website under Website Admin Guide Download a copy of the webiste admin quide ae ITEMSIVe development 5 Click on the Database link A screen will appear consisting of three buttons called Open Save and Close 6 Click on Save and select the file location in which you want the database to be stored in Figure 5 Save button ie Doped a Seve e umn hini yar congue H bhi ie aileron hipa w GS pagui fe poa a ect Bulle ara ha oiga do net open g kieh thae Poy Fe vee Mei Dataa Le ancl 1 Save button Foie Papa Monnit ieoi aga ape
28. nt Menu To access the patient menu 1 Click on the Open Patient Menu button Figure 8 in the Main Menu Figure 8 Main Menu Young Person s Epilepsy Open Patient Patients in Clinic 5 Menu button Patients discharged from Clinic 2 Total number of Patients seen thus far T Ei Open Fatient Menu Charts __ Add New Patient Details __ Maintain Drop Down Boxes Menu Si Open Query Menu __lExit the Database Designed and Built By IS Institute University of Salford 2000 Modified 2006 2007 Page 7 When you have clicked on Open Patient Menu the Patient Menu will appear as shown below in figure 9 Figure 9 Patient Menu E Patient Menu Please select the patient name from the list below and then select the required form a Patient Details AED History Test Results Other Therapies Main Henu The Patient Details menu provides the user with a drop down menu which provides the user with a choice of patient names It is essential for the user to select a patient name as the forms in which the user can access from the Patient Menu display information of a chosen patient To choose a patient name from the drop down menu 1 Click on the down arrow highlighted in figure 10 on the right hand side of the drop down menu Figure 10 Down Arrow Clicking on the drop down arrow displays the names of patients stored on the database as shown in figure 11 Figure 11 Names Displayed Alice Cooper
29. s shown in figure 53 This form contains an input box that enables you to enter a new record and view other records Two navigation buttons are included that enable you to move to either the previous or the next record Three other buttons are included One is called Add which adds the value entered in to the input box to the drop down menu Another is called Delete which enables you to delete a displayed value from the drop down menu Finally a button called close has been provided to enable you to close the form at any point Figure 53 Maintain and Enter New Acute Treatments Add button to add a record value entered Button to show Add ie previous record apate Delete button E m hecord 14 4 a bb hal 9 A Acute Treatments Input box to view and enter a record value Button to view next record Close Form button Page 34 Note All maintain drop down box forms are formatted in the same way To add a value to the drop down menu 1 Click on the Next record button until no value is displayed in the input box 2 Enter a value in to the input box provided 3 Click on Add To delete a value from the drop down menu 1 Click on Delete To close the form and return to the Maintain Drop Down Boxes Menu 1 Click on Close Form 3 5 Add New Patient Details To access the Add New Patient Details form 1 Click on the Add New Patients button on the Main Menu see Figure 54
30. s numbered from 1 to 9 Buttons 1 to 8 are linked to a form that maintains and edits a drop down menu while button 9 enables you to return to the Main Menu at any point The following forms can be accessed from the Maintain Drop Down Boxes Menu Maintain and Enter New Acute Treatments Maintain and Enter New Drug Names Maintain and Enter New Epilepsy Syndromes Maintain and Enter New Referrals Maintain and Enter New School Types Maintain and Enter New Seizure Types Maintain and Enter New Tests Maintain and Enter New Therapies VVVVVVV V To enter a form to maintain and edit a particular drop down menu Page 33 1 Click on any button numbered between 1 and 8 To return to the Main Menu 1 Click on button 9 Figure 52 Maintain Drop Down Boxes Menu Maintain Menu Sele Bolton Children s and Young Person s Epilepsy Clinic ay Maintain and Enter Mew Acute Treatments Buttons 2 Maintain and Enter New Drug Names l to 8 3 Maintain and Enter New Epilepsy Syndromes a Maintain and Enter New Reterrals aintain and Enter Mew School Types 6 Maintain and Enter New Seizure Types Maintain and Enter Mew Tests Return to Main 8 Maintain and Enter New Therapies Menu button 9 Returnto Main Menu Designed and Built By Team 1 15 Institute University of Salford May 2005 3 4 1 Maintain and Enter New Acute Treatments When you click on button 1 the form to maintain and enter new acute treatments will appear a
31. the frequency of seizures To close the form and return to the main menu 1 Click on Close Form Page 12 Figure 17 AED History AED History of a Patient Patient Name James Whale Drugs Taken DrugName DateStarted_ Date Finished Max Dose per kilo day Minor Side Effects Major Side Effects gt 14 Mar 96 12 May 96 0 6kg per day f Table ACTH 21 Jul 98 28 Aug 98 0 6kg per day f showing drugs l 8 Table showing taken seizure frequency record of the patient 12 7 1990 2 8 1991 18 11 13 1991 12 6 27 1992 11 3 99 1002 17 Record 14 4 100E gt I gt gt of 12 a N e NW Close Form button 3 1 3 Test Results When the user clicks on Test Results the Test Results form will appear as shown in figure 18 This particular form displays a table showing the test results of the chosen patient To close the form and return to main menu 1 Click on Close Form Figure 18 Test Results Name James Whale Test Results TestName Dae Crest Result Comments __ ACD Levels Ey 27 Oct 92 Abnormal AED Levels 17 Dec 94 Mormal AED Levels 12 Feb o Abnormal AED Levels 05 Aug 00 Abnormal AED Levels 01 Jan 03 Mormal 03 Mar 05 Mormal AED Levels Table showing test results Close Form button rd 4 4 1 gt ht ese of 6 Page 13 3 1 4 Other Therapies Whe
32. utton 1 Click on the down arrow on the right hand side of the drop down menu as shown in figure 31 Figure 31 Down Arrow 2 Move the mouse cursor over a therapy so that the therapy type is highlighted as shown in figure 32 Figure 32 Therapy highlighted H Select a therapy Eg Please select the therapy required and select O per Form to ELA records 0 F zelerct ms ha Wl thy II to yje all records Behavioural Immunoglobulins Other m alli shiv Cc DIrOcearil 3 Click on the therapy type highlighted Page 19 The selected drug should appear in the drop down menu box as shown in figure 33 below Figure 33 Selected therapy appears in drop down menu box S Select a therapy Eg Please select the therapy required and select Open Form to view records OR select Show All to view all records To view the patients who have undertaken the selected drug 1 Click on the Open Form button To view records of patients who have undertaken a therapy 1 Click on the Show All button To close the form and return to the Query Menu 1 Click on the Cancel button 3 2 4 Age Vs Sex of Patients Query When you click on button 4 the Age Vs Sex of Patients query form will appear as shown in figure 34 This particular form provides you with three input boxes that enable you to enter search criteria Two of the input boxes require you to enter a start and end date The difference between the two d
33. ws records of all patients regardless of the tests undertaken and epilepsy syndrome suffered Finally a cancel button is included to enable you to exit the form at any point Page 26 Figure 43 Test Vs Epilepsy Syndrome Vs Test Result Query Form Select Test V Epil Syd V test result Show All Please select the search criteria from the three drop down boxes button and then select Open Form OR select Show All to view all records Test Name Test TeshWame Result and Test Result Epilepsy Syndrome drop down menus Cancel Button 1 Click on the down arrow on the right hand side of the drop down menu as shown in figure 44 Figure 44 Down Arrow Test Name 2 Move the mouse cursor over a test name so that the test name is highlighted as shown in figure 45 Epilepsy Syndrome Open Form button To select a test name Figure 45 Test Name highlighted H Select Test V Epil Syd V test result Please select the search criteria from the three drop down boxes and then select Open Form OF select Show All to view all records Test Name Test Result AED Levels B Blood Metabolic Yy ork up Epilepsy Syndrome Blood Sugar Calcium Cardiology assessment Chromosomes 3 Click on the test name highlighted CT Brain Scan ECG MA Brain Scan Page 27 The selected test name should appear in the drop down menu box as shown in figure 46 below Figure 46 Selected test name appears
Download Pdf Manuals
Related Search