Drug information storage and retrieval using MS Access

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 provided.

   Here, we will create a Drug Information Storage and Retrieval System Using MS Access. Before that Let have a sight on Introduction to MS Access.

Introduction

    A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.
    Database objects are the main players in an Access database. Altogether, we have six different types of database objects. From these we'll use Table to create database & Queries to retrieve the stored drug information.
    Tables store information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information. A drug databases of marketed drugs contain trade name, dosage form, and strength, they usually do not allocate a unit of prescription or route of administration to the trade name. Apart this, electronic dose calculation, the relation between the denominator of strength and prescribed unit also available software in coded form.
    When you want to review, add, change, or delete data from the database, consider using a query. Using a query, you can answer very specific questions about the data that would be difficult to answer by looking at table data directly. You can use queries to filter your data, to perform calculations with your data, and to summarize your data. You can also use queries to automate many data management tasks and to review changes in your data before you commit to those changes.

   Creating a Table

• Create a Table with by using the suitable fields and data type respectively.  Visit page How to Create a database in MS Access to store the patient information with the required fields Using access. to know more.

Creating Queries

1. On the Create tab, click Query Design.
2. In the Show Table dialog box, on the Tables tab, double-click Products/Tables you created.
3. Close the Show Table dialog box.
4. In the Products table, double-click Fields to add these fields to the query design grid below (design grid: The grid that you use to design a query or filter in query Design view or in the Advanced Filter/Sort window. For queries, this grid was formerly known as the QBE grid.).
5. Add Criteria to field the you want to be asked on Query RUN, to show filtered record according to the query entered.
   
6. On the Design tab, in the Results group, click Run. Enter the Field Value and click OK.

The query runs, and then displays a list of Fields adn their records. This is called retrieval of records.