Pharmaceutical Edu

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

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

Objective: Creating and working with queries in MS Access Introduction    A query is a request for data results, for action on data, or for both. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data. Queries that you use to retrieve data from a table or to make calculations are called select queries. Queries that add, change, or delete data are called action queries.   You can also use a query to supply data for a form or report. In a well-designed database, the data that you want to present by using a form or report is often located in several different tables. By using a query, you can assemble the data that you want to use before you design your form or report. Creating a Query Open the database that you previously set up by using these steps . If not, then create a database. We are having a previously created database here.  On the Create tab, in the Queries ...

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

    Database refers to a collection of electronic records that could be processed to produce useful information. 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. The data can be accessed, modified, managed, controlled and organized to perform various data-processing operations.      The data is typically indexed across rows, columns and tables that make workload processing and data querying efficient. There are different types of databases: Object-oriented, Relational, Distributed, Hierarchical, Network and others. In enterprise applications, databases involve mission-critical, security-sensitive and compliance-focused record items that have complicated logical relationships with other datasets and grow exponentially over time as the userbase increases. As a result, these organizations require t...

     HTML  stands for Hyper Text Markup Language. It is used to design web pages using markup language. HTML is the combination of Hypertext and Markup language. Hypertext defines the link between the web pages. Markup language is used to define the text document within tag which defines the structure of web pages. This language is used to annotate (make notes for the computer) text so that a machine can understand it and manipulate text accordingly. Most of markup (e.g. HTML) languages are human readable. Language uses tags to define what manipulation has to be done on the text. HTML is a markup language which is used by the browser to manipulate text, images and other content to display it in required format. HTML was created by Tim Berners-Lee in 1991. The first ever version of HTML was HTML 1.0 but the first standard version was HTML 2.0 which was published in 1999. HTML is the standard markup language for creating Web pages. HTML VERSION YEAR HTML 1.0 1991 HTML ...

Unit - V  Computer as data analysis in Preclinical development Brief Notes     Scientists from many different disciplines participate in pharmaceutical development.Their esearch areas may be very different, but they all generate scientific data (and text documents), which are the products of development laboratories.   Even a typical Investigational New Drug (IND) application requires around 50,000 pages of supporting documents. One way or another, every single data point has to go through the acquiring, analyzing, managing, reporting, auditing, and archiving process according to a set of specific rules and regulations.The wide use of computers has tremendously increased efficiency and productivity in pharmaceutical development.    On the other hand, it has also created unique problems and challenges for the industry. This overview discusses these topics briefly by focusing on the preclinical development area (also known as the area of Chemical Manufacturin...