project works

[vesh]

hi just new in this field but want to know how to start a project "Reservation System" using VB/Access just tips will do

[MMcCarthy]

hi just new in this field but want to know how to start a project "Reservation System" using VB/Access just tips will do

Have a look at this tutorial on Database Normalization and Table Structures.

[ameesha]

hi just new in this field but want to know how to start a project "Reservation System" using VB/Access just tips will do

hi,

just follow these steps:
1)collect details abt topic..
suppose if it hospital mangement s/w..
den get details..i mean wat all data has to be recorded..(get info frm hospital or person wrkin n admin in hospital)

2)note down..
records of-patient,doctor,dept,stock-medicine&equipment..etc...

3)think wat all info goin to include for ur s/w...(sonsult end user for their requirements f any s der)
suppose creatin s/w for storin only patient,doctor n dept details..den

4)nw go a bit mre deep
colect info regrdin each..
patient can b divided into 2-inpatient n outpatient.
etc..

5) wat all actions we can perform ?
we can add,delete,edit record...

6)den...
think in detail wat all field required for each..
inpatient-
id,name,addr,date.
outpatient-
id,name,addr,date of admit,date of discharge....
etc..

7)den draw data flow diagram


8)den get an idea of wat all tables required..
login,outpatient,inpatient,doctor,dept,billing...

9) jst mak a outline f each form with textfield for corresponding fields..

also include required buttons...
mk outline for all forms..
den go for main form...with menubar includin all frm..

10)design it...
11)er diagram...
apply normalisation,identify primary key...

12)start codin...for each page..den go for linking each other...

hope dis method ll help u in someway...