Need The Steps To Start Implemntaion The Program

Hi
Good Morning All !

Description of what I want :

I'am a faculty member in the university ( Professor ) , I run the application put my username and id

username: faculty1
password: faculty01

click on faculty button password check correct take me to the faculty menu form , I tick on some of research activities for example I choose conference , journal , click save

the result should be displayed on DeanMenu ,

The name of faculty members
Total Points calculated from Faculty Menu Form after I click conference and journal

The Research Activites Have Numeric Values :

Conference : 5
Journal : 7
Books And Patents : 10
Supplmentary Research Activities : 4


Example Of Running program :

Iam Faculty1 My Password Is Faculty01 , i have done conference and journal this semester , am saving details after choosing and ticking , Then the dean can view my name and my total points.

Output

Faculty Name : Faculty1
Research Total Points : 12


Iam Faculty2 My Password Is Faculty02 , i have done Books And Patents and Journal this semester , am saving details after choosing and ticking , Then the dean can view my name and my total points.

Output

Faculty Name : Faculty2
Research Total Points : 17


What i have done right now ?

- Login Menu ( Working ;p)
- 3 Databases for each user ( Facutly , Chairperson , Dean ) all contain information with username , password fields

Screenshots

Login Menu

http://i59.tinypic.com/210ioo3.png

Faculty Menu

http://i62.tinypic.com/2lo3jgj.png

Dean Menu

http://i60.tinypic.com/eta2yg.png

Databases

http://i61.tinypic.com/126bdwy.png

http://i61.tinypic.com/234dbm.png

http://i60.tinypic.com/1192bdw.png

First things first, you need one and only one database. By the looks of things, you don't even need three tables. You might have one table with the staff types, i.e. Faculty, Chairperson and Dean, and then another table for all the users. The second table would then have a column containing the ID from the first table that indicates what type of user each record represents.

I would suggest that you follow the Data Walkthroughs link in my signature below to learn a bit about data access. There's some videos relating to Access specifically and some relating to using Windows Forms with databases.

Ok after I create one database , what should be my next step to do ?

Quote:

---

Originally Posted by jack666sparrow

Ok after I create one database , what should be my next step to do ?

---

Your next step should be to read the rest of my post and do the rest of what I said and then come back when you've got an actual issue rather than when you just couldn't be bothered doing any research for yourself.

Ok Thanks Mr jmcilhinney , I ask u what is the next step because learn from expert better than read books and others staff that does not give u knowledge
Anyway , I will read more , just calm down because we are not all export or good at programming , some people would love to help even if it is silly questions is given or something too easy , if you don't have time to learn me something maybe someone else love this and like to help.

:)

I agree with jmcilhinney, with the only difference being that you should read my database articles:D

http://code.msdn.microsoft.com/site/...lue=.paul.%20_

Quote:

---

Originally Posted by .paul.

I agree with jmcilhinney, with the only difference being that you should read my database articles:D

---

Read both... just to be sure. ;)

I will read both , and see what knowledge it contain