How to Design a form in MS Access to view, add, delete and modify the patient record in the database

-

Designing a form in MS Access to view, add, delete and modify the patient record in the database

     A form in Access is a database object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source. Alternatively, you can create an "unbound" form that does not link directly to a data source, but which still contains command buttons, labels, or other controls that you need to operate your application.


Creating a database table

  • Open MS Access. And create a blank database by choosing database name and file location.

  • Create a table. Select the table and go to design view by right clicking on the table name.

  • Design the table by entering the field name & data type and apply the primary key to suitable field. Give the description of the field if required.

  • Now go to data sheet view by right clicking on the table name.

  • Make your data entry.
  • If you want to add one more field, click on 'Add new field' & rename it and select data type from "Datasheet" tab.

  • Make the entry to the table and click save. 
  • You can also edit this table later from Design view and Datasheet view both.

Creating Form

  • Click on ''Create'' from menu bar. And click on 'Form Design'.

  • A Blank Form will appear. as shown below. Adjust the form size if required.

  • Click on Add existing field. Add required fields from the Field list. And adjust their suitable location on the form.

  • Select 'Label' from "Design" toolbar. And add labels for Form Heading.

Adding the operational button in the form.

  • Select 'Button' from Controls in Design Tab. ~> Click once on the Form sheet. (A 'Command Button Wizard' Popup will appear. OR If you couldn't find the 'Button' in Design Tab. Select the 'Command Button Wizard' Directly if shown.
  • Select the 'Record Operation' from the 'Categories' And 'Add New Record' from 'Actions' And click 'Next'.
  • Select the preview type(Text/Picture) of the Button and Click 'Next' and then 'Finish'.
  • Adjust the Location and Shape of the Button on the Form. 
  • Similarly, add button for Find/View, Delete Record, Previous and Next Record. (You can also add Save Button, But even if you don't add save button, the record will be saved automatically, when you click to Add new record.)

Formatting the Form

  • Select the Format Tab and Give the format to the form as you like.

  • Now close the form, Rename it and Save.

Data Entry/Adding A Record

  • Open the Form in the Form View.
  • Fill the details all fields and Click Save/Add New Record.
  • Similarly add few more Records.

View/Find Record

  • Click on the View/Find Button.
  • Enter the Name and click find.

Deleting A Record

  • To delete a record open the record in the form view.
  • And click on the Delete Button. The Record will be removed from the database.

Modifying the Record Detail

  • Open a record in the form view.
  • Replace the field value to make change.
  • Click Save/Add New Record.
To get notification of our next post. Enter your email address:

Computer applications in pharmacy

*If you have additional questions or require more information, do not hesitate to Contact Us.

Comments

Post a Comment

Popular posts from this blog

Exporting Tables, Queries, Forms and Reports to web pages

-
Image
Objective: Exporting Tables, Queries, Forms and Reports to Web Pages using simplest steps in MS Access    MS Access allows users to built a powerful integrated platforms of inserting, saving, retrieving the information into the database. There are many platforms for these facilities in MS Access for example  Tables ,  Quires ,  Forms ,  Reports , etc.    In previous posts we have learnt how to create the  Tables ,  Quires ,  Forms  and  Reports , etc. But if we want to open the data into another application then it provides  a way to do the same. We can export the table, queries, etc. into another format such as XML, web pages.    In this tutorial, you will come to know how to export the tables or queries into the web page format which allow you to open the table in web browsers.   If you don't know how to create the data tables, queries, and reports then please  read those articles  bef...
Read more

Exporting Tables, Queries, Forms and Reports to XML pages

-
Image
Objective: Exporting Tables, Queries, Forms and Reports to XML Pages using simplest steps in MS Access     Tables , Quires , Forms and Reports generation in the features supported by the MS Access in order to influence more convenience and beneficial data insertion and retrieving to the database. It is used in many professional, social and professional works and Also in many companies to manipulate the data.    It is important to backup some date  or to export  these data. In today's tutorial you will come to know about how to export the table. queries and reports in the XML format.     If you don't know how to create the data tables, queries, and reports then please read those articles before it. Procedure: 1. Open a database table that is created previously or create a new database table. 2. Go to the External Data ribbon and click on  XML File from the Export group. 3. Now Click on browse to specify the destination of the XML fi...
Read more

Drug information storage and retrieval using MS Access

-
Image
Drug information storage and retrieval using MS Access      The storage, retrieval, and dissemination of information constitutes a major function of any drug information service (DIS). We developed a computerized system for the storage and retrieval of data from drug information requests (DIR) using a MUMPS-based information system. In the past, DIR forms were stored in looseleaf binders and filed chronologically. Due to the success and increased use of our DIS, this manual filing system became inadequate and awkward to use. Our solution was to develop a computer system where data could be entered from DIR forms and retrieved rapidly and easily. Each DIR was reviewed and key data elements were selected for input. The DIS files may now be searched online rapidly and efficiently. The MUMPS-based information system has provided open access for all staff pharmacists, 24 hours a day. The benefits have been an increase in both the quantity and quality of drug information p...
Read more