For Admission

B.Pharm Computer Practicals

By-Er.Ashis Kumar Dash

Practical-1 Design a questionnaire using a word processing package to gather information about a particular disease.

Practical-2 Create an HTML page to show personal information

Practical-3 Retrieve the information of a drug and its adverse effects using online tools.

Practical-4 Creating mailing labels using label wizard, generating label in MS Word

Practical -5 Create a DATABASE in MS Access to store patient information with the required fields.

Practical-6 Design a form in MS Access to View, Add, Delete, and modify the patient record in the database.

Practical-7 Generate report and printing the report from patient database.

Practical-8 Create invoice table using MS-Access

Practical-9 Drug information storage and retrieval using MS-Access.

Practical-10 Creating and Working with queries in MS Access.

Additional Notes on Writing Criteria

Practical-11 Exporting Tables, Queries, Forms, and reports to Webpage.

Practical-1 Design a questionnaire using a word processing package to gather information about a particular disease.

Laboratory Practical Record

Title: Designing a Disease Information Questionnaire Using Microsoft Word

Date:-----------

Objective: To create a questionnaire using Microsoft Word to collect information about a specific disease.

Equipment/Software Used:

- Computer with Microsoft Word installed

Procedure:

Step 1: Launch Microsoft Word

- Turn on the computer and open Microsoft Word from the Start menu or desktop icon.

Step 2: Create a New Document

- Click on "File" and select "New" to create a new blank document.

Step 3: Set Document Title

- At the top of the document, type the title of the questionnaire, for example, "Disease Information Questionnaire."

Step 4: Create Sections

- Organize the questionnaire into sections, e.g., "Patient Information," "Disease History," "Symptoms," "Treatment," etc.

- Use headings to label these sections.

Step 5: Add Questions

- For each section, type the questions you want to include in the questionnaire.

- Leave space for respondents to provide answers.

Step 6: Use Formatting Tools

- Utilize formatting tools to make the questionnaire neat and structured. You can use features such as bullet points, numbering, and bold text for emphasis.

Step 7: Add Response Types

- Specify the type of response you expect for each question. For example, you can use text boxes for written responses, checkboxes for multiple-choice questions, or radio buttons for single-choice questions.

Step 8: Include Additional Information

- Add any additional instructions or information that respondents might need while completing the questionnaire.

Step 9: Review and Edit

- Carefully review the questionnaire for any spelling or grammatical errors.

- Ensure that the questions are clear and concise.

Step 10: Save the Document

- Save the questionnaire using a descriptive file name, e.g., "Disease_Info_Questionnaire.docx."

Step 11: Print and Distribute

- If a physical copy is needed, print the questionnaire and make copies.

- Distribute the questionnaires to participants for data collection.

Conclusion:

In this laboratory practical, we have successfully designed a questionnaire for gathering information about a particular disease using Microsoft Word. This questionnaire can now be used for data collection and research purposes.

Signature:

--------

Date:

--------

Practical-2 Create an HTML page to show personal information

Code:

<html>

<head>

<title>Personal Information</title>

</head>

<form>

<table>

<tr><td><h1>Personal information Form</h1></td></tr>

<tr>

<td><h4>Middle Name:<input type="text" size="15"></h4></td>

</tr>

<tr>

<td><h4>Gender:

<input type="radio" name="Gender" Value="male">Male

</h4>

</td>

</tr>

<tr>

<td><h4>Age:

<tr>

<td><h4>Address:

<tr>

<td><h4>City:

<tr>

<td>

<h4>

</h4>

</td>

</tr>

</table>

</form>

</body>

</html>

Practical-3 Retrieve the information of a drug and its adverse effects using online tools.

Title: Retrieving Drug Information and Adverse Effects Using Online Tools

Date: [Date]

Objective: To learn how to gather information about a specific drug and its adverse effects using online resources.

Equipment/Software Used:

- Computer with internet access

- Web browser

Procedure:

Step 1: Access the Internet

- Ensure that the computer is connected to the internet.

Step 2: Open a Web Browser

- Launch a web browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge.

Step 3: Search for Drug Information

- In the web browser's address bar, type the name of the drug you want to research.

- Hit "Enter" to initiate the search.

Step 4: Visit a Trusted Medical Website

- Click on a link from a trusted medical website or source such as the National Institutes of Health (NIH), the U.S. Food and Drug Administration (FDA), or a reputable medical journal.

Step 5: Find Drug Information

- Locate and read information about the selected drug. This may include its name, uses, dosage, administration, and any precautions.

Step 6: Search for Adverse Effects

- Look for information on the adverse effects or side effects of the drug.

- Note any common, serious, or rare side effects.

Step 7: Document Your Findings

- Use a text editor or notepad software to record the drug's name, uses, dosage, and adverse effects.

Step 8: Confirm Information

- Cross-reference the information from multiple sources to ensure accuracy.

Step 9: Compile the Information

- Create a summary document that includes all the gathered information.

Step 10: Save and Store

- Save your summary document for future reference.

Conclusion:

In this laboratory practical, we have successfully learned how to retrieve information about a specific drug and its adverse effects using online resources. It's essential to use trusted medical websites to ensure the accuracy and reliability of the information.

Signature:

-----------------

Date:

-----------

Practical-4 Creating mailing labels using label wizard, generating label in MS Word

Practical -5 Create a DATABASE in MS Access to store patient information with the required fields.

Practical-6 Design a form in MS Access to View, Add, Delete, and modify the patient record in the database.

Practical-7 Generate report and printing the report from patient database.

Computer Practical Record

Title: Creating and Printing a Report from a Patient Database in MS Access

Date: ___________

Objective: To learn how to generate and print a report from a patient database in Microsoft Access.

Equipment/Software Used:

- Computer with Microsoft Access installed

- Patient database in MS Access

Procedure:

Step 1: Open MS Access and Select Your Database

- Launch Microsoft Access from the Start menu or desktop shortcut.

- Open your patient database by clicking on it in the "Recent" list or by browsing your files.

Step 2: Design a Report

- Click on the "Reports" tab in the database.

- Select "Report Design" to open the Report Design view.

Step 3: Add Fields to the Report

- In the Report Design view, drag and drop the fields you want to include in your report from the Field List onto the report design surface.

- Adjust the layout and formatting as needed by resizing and arranging the fields.

Step 4: Add Page Headers and Footers

- To add report headers and footers, navigate to the "Design" tab, and use the "Page Header" and "Page Footer" sections.

- Include information like report title, date, and page numbers in these sections.

Step 5: Set Report Properties

- Right-click on the report's title bar and choose "Report Properties" to specify options such as orientation (portrait or landscape) and paper size.

Step 6: Save the Report

- Save your report design by clicking the floppy disk icon on the Quick Access Toolbar or by pressing Ctrl + S.

- Choose a descriptive name for your report.

Step 7: Preview the Report

- Click "View" in the "View" group to see how your report will look when printed. Make any necessary adjustments by going back to the Report Design view.

Step 8: Print the Report

- While in the report preview, click the "Print" icon in the "Print" group or choose "File" > "Print" to initiate the printing process.

- Configure your printer settings, such as the number of copies and page range.

- Click "Print" to send the report to your printer.

Step 9: Save and Close

- After printing the report, you can choose to save it or close it without saving the print preview.

Conclusion:

In this practical, we learned how to create and print a report from a patient database in Microsoft Access. This skill is valuable for generating patient records, summaries, or other healthcare documents efficiently.

Signature:

_________

Date:

_______

Practical-8 Create invoice table using MS-Access

Creating an invoice table in Microsoft Access involves designing a table to store information

Step 1: Open Microsoft Access

1. Launch Microsoft Access on your computer.

Step 2: Create a New Database

2. Click on "File" and select "New" to create a new database.

3. Choose a location to save your database and give it a meaningful name (e.g., "InvoiceDatabase").

Step 3: Create the Invoice Table

4. In the new database, click on the "Table Design" icon to create a new table.

5. In the "Table Design" view, define the structure of your Invoice table by specifying the fields (columns) that it should contain. Here are some common fields you might include:

- InvoiceID: This should be a unique identifier for each invoice and can be an AutoNumber field.

- InvoiceDate: Date when the invoice was issued.

- CustomerName: Name of the customer or client.

- CustomerAddress: Address of the customer.

- InvoiceTotal: Total amount for the invoice.

- PaymentStatus: Payment status (e.g., Paid, Unpaid).

- DueDate: Date by which the payment is due.

- InvoiceItems: You may want to create a separate table for invoice items and establish a one-to-many relationship between invoices and invoice items. This allows you to store multiple line items for each invoice.

6. Define the data types for each field (e.g., Text, Date/Time, Currency) and set any necessary field properties (e.g., required, indexed, default values).

7. Save the table design and give it a meaningful name, such as "Invoices."

Step 4: Set Primary Key

8. Ensure that you've designated a primary key for your Invoice table. Typically, the InvoiceID field is set as the primary key to uniquely identify each invoice.

Step 5: Save the Table

9. Save the table structure by clicking the floppy disk icon or pressing Ctrl + S.

Step 6: Enter Data

10. Enter sample invoice data into your newly created Invoice table. You can do this by clicking on the "Datasheet View" icon or by using forms that you can create in Access.

Step 7: Create Queries, Forms, and Reports

Practical-9 Drug information storage and retrieval using MS-Access.

Drug information storage using Microsoft Access involves designing a database, creating tables, forms, queries, and reports to manage and retrieve drug-related data.:

Step 1: Database Design

1. Objectives: Common fields include drug name, dosage, manufacturer, expiration date, quantity on hand.

Step 2: Create Tables

1. Open MS Access: Launch Microsoft Access and create a new blank database.

2. Create Tables: Create tables for your drug information. For example:

- Drugs Table: Fields include Drug ID (Primary Key), Drug Name, Dosage, Expiration Date, Quantity on Hand, Manufacturer ID (Foreign Key), Supplier ID (Foreign Key.

- Manufacturers Table: Fields include Manufacturer ID (Primary Key), Manufacturer Name, Address, Contact Information.

- Suppliers Table: Fields include Supplier ID (Primary Key), Supplier Name, Address, Contact Information.

3. Establish Relationships: Define relationships between tables. Connect Manufacturer ID and Supplier ID in the Drugs table to their respective tables. This enforces referential integrity.

Step 3: Data Entry Forms

1. Create Data Entry Forms: Build forms for entering and editing drug information. We can use the Form Wizard in Access to help with this process.

2. Customize Forms: Add form controls and arrange them to match the layout you prefer. Ensure that users can input data easily.

Step 4: Queries

1. Create Queries: Design queries to extract specific information from your database. For example, you can create queries to find drugs that are about to expire, track inventory levels, or list drugs from a specific manufacturer.

Step 5: Reports

1. Generate Reports: Build reports for presenting and printing data. You might create reports to show a list of all drugs in your inventory, purchase history, or sales reports.

Step 6: Data Entry and Maintenance

1. Data Entry: Start entering your drug information into the database. Use the forms you created to make data entry user-friendly.

Practical-10 Creating and Working with queries in MS Access.

Date:

Objective: To create a query in Microsoft Access to retrieve specific information from the Patient Information database.

Steps:

Step 1: Open Microsoft Access

- Launch Microsoft Access on your computer.

Step 2: Open the Database

- Go to "File" > "Open" and select your database file, Hospital Mgmt.mdb or .accdb.

Step 3: Select the Query Design View

- Click on the "Create" tab on the top menu.

- In the "Queries" group, click on the "Query Design" button.

Step 4: Choose Tables or Queries

- A window called "Show Table" will appear.

- Select the necessary tables or queries from the list and click the "Add" button for each.

- If needed, define relationships between tables by dragging and dropping related fields.

Step 5: Close the "Show Table" Window

- Once you've added all the necessary tables/queries, click the "Close" button in the "Show Table" window.

Step 6: Build Your Query

- In the Query Design View, you'll see a grid with the tables/queries you've added.

- Drag and drop fields from the tables/queries to the grid to specify which data you want to retrieve.

- Add criteria to filter the data by specifying conditions in the "Criteria" row under each field.

Step 7: Run the Query

- Save your query by clicking the "Save" button on the toolbar and providing a name.

- To run the query, click the "Run" button (exclamation mark icon) on the toolbar.

- The query results will appear in a datasheet view.

Step 8: Save the Query

- Save your query design changes by clicking the "Save" button in the Query Design View.

Step 9: Close the Query

- Close the query by clicking the "X" in the upper-right corner of the Query Design View window.

Conclusion: I have successfully created and run a query in Microsoft Access to retrieve specific information from your database.

Additional Notes on Writing Criteria

Certainly, here are some examples of criteria you can use in Microsoft Access queries to filter and retrieve specific data: 1. Filter by Date Range: - To retrieve records with a date within a specific range, use criteria like: - `[Order Date] >= #01/01/2023# AND [Order Date] <= #12/31/2023#` 2. Filter by Text Values: - To retrieve records with a specific text value in a field, use criteria like: - `[Category] = "Electronics"` 3. Filter by Numeric Values: - To retrieve records with a specific numeric value in a field, use criteria like: - `[Price] > 100` 4. Filter by Multiple Criteria (AND): - To combine multiple criteria and retrieve records that meet all conditions, use criteria like: - `[Category] = "Electronics" AND [Price] > 100` 5. Filter by Multiple Criteria (OR): - To retrieve records that meet at least one of several conditions, use criteria like: - `[Category] = "Electronics" OR [Category] = "Clothing"` 6. Filter by Partial Text Match (Wildcard): - To retrieve records that contain a specific word or phrase within a text field, use criteria like: - `[Product Name] Like "*camera*"` 7. Filter by Null or Non-Null Values: - To retrieve records with or without values in a particular field, use criteria like: - `[Notes] Is Null` (for records with no notes) - `[Email] Is Not Null` (for records with email addresses) 8. Filter by Date Comparison (e.g., Past Due): - To retrieve records with dates that are past a certain date, use criteria like: - `[Due Date] < Date()` 9. Filter by Multiple Conditions (Complex): - To create more complex queries, you can use parentheses for grouping, e.g.: - `([Category] = "Electronics" OR [Category] = "Clothing") AND [Price] > 100` 10. Filter by First Letter or Character: - To retrieve records where a text field starts with a specific letter or character, use criteria like: - `[Product Name] Like "A*"` These are just a few examples of criteria you can use in your queries. You can combine and customize these criteria to match your specific data filtering requirements. Remember to adjust field and table names in the criteria to match your database's structure.

Practical-11 Exporting Tables, Queries, Forms, and reports to Webpage.

Date:

Objective: The objective of this experiment is to export tables, queries, forms, and reports from a Microsoft Access database to a webpage for online access and sharing.

Materials and Equipment:

- Computer with Microsoft Access installed

- Microsoft Access database

- Internet connection

Procedure:

1. Launch Microsoft Access on the computer.

2. Open the Access database that contains the tables, queries, forms, and reports you want to export.

3. Exporting Tables:

- Select the table you want to export.

- Right-click on the table and choose "Export" from the context menu.

- Choose the desired format (e.g., Excel, CSV, HTML).

- Specify the destination folder and filename.

- Click "OK" to export the table.

4. Exporting Queries, Forms, and Reports:

- For each query, form, or report you want to export, open it in Access.

- Click "File" > "Save As."

- Choose the desired format (e.g., HTML).

- Specify the destination folder and filename.

- Click "OK" to export the query, form, or report.

5. Accessing Exported Content on the Web:

- Open a web browser.

- Navigate to the folder where you exported the HTML files.

- Click on each HTML file to view the exported content in a web browser.

Data Collection:

- Names of the tables, queries, forms, and reports exported.

1 Patient Table

2Patient info form

3 appointment query

Conclusion:

- Potential use cases for this method.

Helps in Data sharing, Web integration, We can publish data to webpage after export from database.

By Er. Ashis Kumar Dash

content is protected by copyright law and that unauthorized copying or distribution is prohibited

Page updated

Google Sites

Report abuse