Pharmaceutical Edu

Creating invoice table using - MS Access  An invoice, bill or tab is a commercial document issued by a seller to a buyer, relating to a sale transaction and indicating the products, quantities, and agreed prices for products or services the seller had provided the buyer. Home Computer Application in Pharmacy Previous Year's Question Paper EVS Notes Time Table Creating Invoice in MS Access Open MS Access and create or open database. From the create tab, locate the table design and click on the Table Design. Create the fields as "InvoiceNum","Text"; "ContractNum","Text"; "InvoiceDate","Date/Time"; "InvoiceItem","Text"; "InvoiceAmt","Currency"; "InvoicePaid","Yes/No";   w.r.t  "FieldName","DataType"  respectively. Apply the primary key to the InvoiceNum. Save and Rename the table. Open the table in Table View. Enter the field values. Save the Tabl...

Generating report and printing the report from patient database       Reports offer a way to view, format, and summarize the information in your Microsoft Access database. If you need to share information from your database with someone but don't want that person to actually work with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access 2010 makes it easy to create and customize a report using data from any query or table in your database.      A report is a database object that comes in handy when you want to present the information in your database for any of the following uses: Display or distribute a summary of data. Archive snapshots of the data. Provide details about individual records. Create labels. Creating a report in Access You can create reports for you Access desktop database by following the steps below: Step 1: Choose a record source The record s...

Unit - V  Computer as data analysis in Preclinical development Home Computer Application in Pharmacy Previous Year's Question Paper EVS Notes Time Table GET PDF: The Complete chapter in brief  CLICK HERE. Introduction   Scientists from many different disciplines participate in pharmaceutical development.Their research areas may be very different, but they all generate scientific data (and text documents), which are the products of development laboratories.   Literally, truckloads of data and documents are submitted to the regulatory authorities in support of investigational and marketing authorization filings.   For example, 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. Needless to say, the wide use of com...

Home Computer Application in Pharmacy Previous Year's Question Paper EVS Notes Time Table 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 f...

Home Computer Application in Pharmacy Previous Year's Question Paper EVS Notes Time Table Creating a database in MS Access to store the patient information with the required fields Using access. A Fact To MS Access   Although Microsoft won’t admit it, Access can be intimidating—intimidating enough to trigger a cold sweat in the most confident office worker. Even though Microsoft has spent millions of dollars making Access easier to use, most people still see it as the most complicated Office program on the block. They’re probably right. 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.    Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a...

Home Computer Application in Pharmacy Previous Year's Question Paper EVS Notes Time Table Creating mailing labels Using Label Wizard, Generating label in MS WORD        Generally a Mailing label is a piece of paper with a mailing address already printed on it. Creating Labels Page: Start Microsoft Word. Create a New Document. Select Letters and Mailings tab, then select Envelopes and Labels. Select  Labels. "Envelope and Labels" Pop-Up Window will appear. Click Options. Select the type of labels you want to create and then click OK. Click New Document in the "Enevelope and label window".The Label Page is ready now. Type and format the content of your labels. Turn on table grid-lines (borders) so that you can see the outline of your labels: from the Table menu, choose Show Grid-lines. If you are creating a page of labels that will all look the same, type and format one label, then use copy and paste to create the rest of the labels. Insert photos into your labels...