Pharmacy Infoline
Search
  • Home
  • Disease
  • Drugs
  • Jobs
  • News
  • Syllabus
    • D Pharmacy Syllabus, Notes
    • B Pharmacy Syllabus, Notes
  • MCQ
  • Pharma Industries
  • Artificial Intelligence

Create a database in MS Access to store the patient information

BP210P Computer Applications in Pharmacy Practical


Aim

Create a database in MS Access to store the patient information with the required fields using access


MS Access

MS Access is a relational database (RDBMS). A database is a collection of information that’s related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection.

For example, suppose the phone numbers of patients are stored in various places of hospital; in reception center, in finance section, in medical store, etc. If patient phone number changes, you might have to update that information in all places. In a database, however, you only have to update that information in one place.

Characteristics of Database

  • Self-describing: a database gives description about itself.
  • Multiple users can access the same data.
  • Data exits permanently
  • Data security protects the data from unauthorized access with the help of the passwords.
  • Much software is used as Database Management Systems. Example: MS-Access, ORACLE etc.

Starting Access

Click on the Start button

Then go to MS Office

Then go to Microsoft Office Access 2007.

Notice the screen shown below appears

Now Specify the location of your database file by clicking on file button and give the suitable name to your database file and click on create button and screen as shown like below will appears.


Creating a Table

When you click the Create button your Access 2007 screen will change to the image below.

This is the “new look” in 2007 Office. You will now see Tabs and Ribbons that automatically appear for the area in access on which you’re working. Instead of a Menu Bar and drop down selections, you’ll now see these new features.

On the left of the Table Tools-Datasheet Tab/Ribbon you’ll see a view button.

Click the View button.


A Save As menu screen will appear similar to the image on the right.

Type patient information in the Table Name: area and

Click the OK button Your Access 2007 screen will now change again – to the image below

We’ve enlarged the upper left corner of this image below.

Notice (in the image above) that our Table Tools Tab still appears. However, because we are now in the Design process, the lower Tab/Ribbon has changed to Design – to assist us with designing our Table.

In the image on the last page you will notice that the primary key button is “orange” and in our Personnel Table, that is also “orange”-with a little key to the left of ID. Notice, under the Blue Bar at the top of the Design screen there are

Field name Data type Description

And, in the lower half of the window; Field Properties will appear

Significant Note:

When creating a database it is always best to “break down” a field into its “smallest parts.” For example – Name would break down into First Name, and Last Name (you could also have Middle Initial, Title, etc.) Address would break down into Street Address, city, state, and Zip (you could also have Apartment Number, etc). Because we are working in Access 2007 it will be very simple to “put the fields back together” with a few mouse clicks when we need to do this.

This will save a lot of time.

Look at the image on the right. Clicking the area or space under Field Name and type- in Last Name (to replace ID). Tap Enter or click-in the area to the right under Data
Type. Click the down arrow under Data Type on right (see arrow on right). Your design screen should look like the one on the right.


Data Type

  • Text you may type in any alphabetical/numerical data that you desire – up to a maximum of 255 characters. As indicated, this is a text field, so you can’t do mathematical calculations. Examples of Text data are: names, addresses, stock numbers, room numbers, zip codes, etc.
  • Memo this field is for lots of text. You can have up to 32,000 characters.
  • Number this field is for numbers where you want to add, subtract, multiply, divide, average, and do numerical calculations. This field can be a very large size, so when we get to Field Properties, we’ll talk about “sizing” this field so it doesn’t take up to much “space” in storage.
  • Date/Time You may format these later, as you may desire.
  • Currency Dollars ($). You may format these later, as you may desire.
  • AutoNumber This field is an “automatic” counter that assigns a number each time you put data into a new field.
  • Yes/No this is a “True/False” or “Yes/No” type of field.

Entering Data into the database

In the design view, Type-in the Field Names as indicated below and set them to the Data Types and Sizes indicated. Start each new Field Name and Data Type below the previous field (see example below).

Let’s create a patient information database with Patient ID as the primary key.

  • You can add a new field,  rename a new field if it is not descriptive enough, and delete an unwanted field.
  • Setting a field to store numerical values that you can use in calculations, set its data type to number or currency.
  • Field properties are a set of characteristics that provide additional control over how the data in a field is stored, entered or displayed. Which properties are available depends on a field’s data type.

Now type Gender in Field Name, and in data type select lookup Wizard… as you select it window will appear given beside and then after typing male and female press next and finish.

Now select datasheet view from view button and in gender column select arrow you will show two options are displayed for typing in the column

Similarly, you can add data type in look up wizard for ‘consulting dr’, ‘patient type’ and ‘mediclaim’ Field name.

For DOB field select date/time in data type, when you will see in datasheet view, icon shown above will appear for entering DOB of patient.

Now that the structure is created let’s make the ‘Patient_ID’ field a primary key. (Keep your pointer in it and click the right button of your mouse to get a menu of items).

Save the file and now let’s start entering data of individual patient.

Entering data into database

Notice the database view of the table appear in front of you to add data to it. Now the field names are displayed as headings and a blank row is provided to enter data. Now that you have specified the data type, text that effect can only be entered in that field.

Notice when you type data in the last field and press the TAB key the pointer automatically moves to the next record. Now that you have successfully entered data into the first record, type the remaining which you need to add. Once the data entry is over save the file in your directory.


Result:

Thus we studied to create a  database in  MS  access to store the patient information with the required fields.


First Year B Pharm Notes, Syllabus, Books, PDF Subjectwise/Topicwise

First Year B Pharm Notes, Syllabus, Books, PDF Subjectwise/Topicwise

F Y B Pharm Sem-IF Y B Pharm Sem-II
BP101T Human Anatomy and Physiology I TheoryBP201T Human Anatomy and Physiology II – Theory
BP102T Pharmaceutical Analysis I TheoryBP202T Pharmaceutical Organic Chemistry I Theory
BP103T Pharmaceutics I TheoryBP203T Biochemistry – Theory
BP104T Pharmaceutical Inorganic Chemistry TheoryBP204T Pathophysiology – Theory
BP105T Communication skills TheoryBP205T Computer Applications in Pharmacy Theory
BP106RBT Remedial BiologyBP206T Environmental sciences – Theory
BP106RMT Remedial Mathematics TheoryBP207P Human Anatomy and Physiology II Practical
BP107P Human Anatomy and Physiology PracticalBP208P Pharmaceutical Organic Chemistry I Practical
BP108P Pharmaceutical Analysis I PracticalBP209P Biochemistry Practical
BP109P Pharmaceutics I PracticalBP210P Computer Applications in Pharmacy Practical
BP110P Pharmaceutical Inorganic Chemistry Practical
BP111P Communication skills Practical
BP112RBP Remedial Biology Practical

Suggested readings:

  • BP210P Computer Applications in Pharmacy Practical
  • DSBM MCQ PDF Chapterwise
  • Retrieve the information of a drug and its adverse effects using online tools
  • ER20-11P Pharmaceutics Practical D Pharm
  • ER20-25P Hospital & Clinical Pharmacy Practical D Pharm

Recommended

  • Social Pharmacy Practical D Pharm
  • Hospital Pharmacy Location Layout staff
  • Roll on deodrant base ingredients

    March 3, 2023

    Roll on deodrant base ingredients Roll-on deodorants typically contain the following base ingredients: It’s important to note that not all roll-on deodorants will contain all of these ingredients, and some formulas may also include additional ingredients for specific purposes. Be sure to check the ingredient label to determine the specific ingredients in a particular product. Preparation of roll-on deodorants Making your own roll-on deodorant can be a fun and rewarding DIY project. Here’s a basic recipe to get you started: Ingredients: Instructions: Note: It may take some experimentation to find the right combination of ingredients and consistency that works best for you. Also, be sure to test the deodorant on a small patch of skin before using to make sure you don’t have any allergic reactions. Examples of roll-on deodorants There are many different brands of roll-on deodorants available on the market, each with their own unique formulations and fragrances. Here are a few examples: Suggested readings:

  • Use Aartificial Intelligence for optimisation of pharmaceutical formulation

    February 20, 2023

    Use Aartificial Intelligence for optimisation of pharmaceutical formulation AI can be a powerful tool for optimizing pharmaceutical formulations by enabling more efficient and effective experimentation, as well as data-driven decision making. Here are some ways AI can be used for this purpose: Overall, AI can provide significant benefits in the optimization of pharmaceutical formulations, reducing the time and cost of development, improving product quality, and speeding up the delivery of new treatments to patients. Suggested readings:

  • Bayesian approch for optimisation of pharmaceutical formulation

    February 20, 2023

    Bayesian approch for optimisation of pharmaceutical formulation The Bayesian approach is a statistical method that can be used for optimizing pharmaceutical formulations. It involves building a statistical model of the process and using the model to make informed decisions about the formulation. Here are the key steps in applying a Bayesian approach for optimization of pharmaceutical formulation: The Bayesian approach provides a rigorous and systematic framework for optimizing pharmaceutical formulations that can help to improve the quality, safety, and efficacy of drugs. By incorporating prior knowledge, new data, and statistical modeling, the Bayesian approach can reduce the time and cost of drug development and improve patient outcomes. Suggested readings:

B Pharmacy Notes (Subjectwise/Topicwise)

  • F Y B Pharmacy Notes
  • S Y B Pharmacy Notes
  • T Y B Pharmacy Notes
  • Final Year B Pharmacy Notes
  • B Pharmacy All Subject Notes

D Pharmacy Notes (Subjectwise/Topicwise)

  • 1st Year D Pharmacy
  • 2nd Year D Pharmacy

  • Artificial Intelligence
  • Books
  • Disease
  • Drugs
  • Drugs medicine and pharmaceuticals
  • Jobs
  • News
  • pharma events
  • Pharma Industries
  • Pharmacy MCQ
  • Pharmacy Video Lectures
  • Uncategorized
  • ups and battery
  • Roll on deodrant base ingredients
  • Use Aartificial Intelligence for optimisation of pharmaceutical formulation
  • Bayesian approch for optimisation of pharmaceutical formulation
  • Top 10 cosmetics companies in world
  • Attention Deficit Hyperactivity Disorder (ADHD)

Telegram Groups

  • F Y D Pharm: t.me/fydpharm
  • S Y D Pharm: t.me/sydpharm
  • F Y B Pharm: t.me/fybpharmnotes
  • S Y B Pharm: t.me/sybpharmnotes
  • T Y B Pharm: t.me/tybpharm
  • Final Year B Pharm: t.me/finalyearbpharm



©2022 PHARMACY INFOLINE ALL RIGHTS RESERVED Pharmacy Notes, Books, PDF Downloads

Follow us