LANGKAH-LANGKAH MEWUJUDKAN PANGKALAN DATA

• To start the Microsoft Access.

1. Click on the START BUTTON.
2. Point cursor at ALL Programs in the START MENU.A menu with list application software is display.
3. Move cursor to Microsoft Office and click on.
4. Click on the Microsoft Access 2003 in the list of programs.

• The three main window displays under the Getting Started task pane are:

1. Microsoft Access Office Online.
2. Open of the existing database-files and
3. Create a new database.

TITLE BAR : contains the control icon, the name program, minimize, maximize, restore  and close button.

MENU BAR : a set of options the little bar that lead to associated menus.

TOOLBAR : display button, which provide short cuts to menu.

  *  To create a new database.

1.     Click on file button.

2.     Click on new button.

3.     Select BLANK DATABASE on the new file task pane or press( CTR-N)

4.     Task name group in file name.

 


*Click table and design view.   

*TABLE

a)It stories information about special topic: DOCTOR,  PATIENT,

REGISTRATION, TREATMENT.

--> Size DOCTOR.

DocNO :text(4)

DocName : text (50)

TypeofSick : text(150)

Price :number( long integer)

MC :yes/no

TreatID:text (4)   

-->Size PATIENT.

PatientNo: text(4)

Name: text(50)

Address:text (100)

NoTEL:number( long integer)

Mobile:number( long integer)

RedID: text(4)

-->Size REGISTRATION

RegID: text(4)

RdIC: text(12)

RegDATE:

-->Size TREATMENT.

TreatID: text (4)

TreatDate: date/time

PatienNO: text(4)

*Click RELATIONSHIP and between 4 table.

*RECORD AND FINISH.