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

-

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 member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. 
   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
   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 fitness database could track your daily running log, your inventory of exercise equipment, and the number of high-protein whey milkshakes you down each day, as three separate tables.

Important point to remember

  You can customize a table in two ways:
  • Design view lets you precisely define all aspects of a table before you start using it.
  • Datasheet view is where you enter data into a table. Datasheet view also lets you build a table on the fly as you insert new information.

Creating a database

  • 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 field. Give the description of the field if required.

  • Now go to data sheet view by right clicking on the table name.

  • Make your data entry.
  • If you want to add one more field, click on 'Add new field' & rename it and select data type from "Datasheet" tab.

  • Make the entry to the table and click save. 
  • You can also edit this table later from Design view and Datasheet view both.
To get notification of our next post. Enter your email address:

Computer applications in pharmacy

*If you have additional questions or require more information, do not hesitate to Contact Us.

Comments

Post a Comment

Popular posts from this blog

Exporting Tables, Queries, Forms and Reports to web pages

-
Image
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  before it. We just follow some easy steps to do the same as follow: Procedure: 1. Open a database
Read more

Exporting Tables, Queries, Forms and Reports to XML pages

-
Image
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 file where you want to save it in your comp
Read more

Computer as data analysis in Preclinical development - Brief Notes

-
Image
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 Manufacturing and Control, or CMC). Consi
Read more