We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Question:     (20 Marks)

 

Create a new database in MS Access and add a table in the database. The name of database should be same as your own VU ID (like BC0000000) and the name of table should be Student. Student table will have four attributes i.e. ID, NAME, ADDRESS and PROGRAM.

 

Now, design a graphical user interface in java as given below (You must have to mention your own VU ID in title as shown in screenshot).

 

 

 

Your program should perform following tasks:

 

1. Add new record in database

 

Whenever user enters some new data in text fields and clicks “Add Record in Database” button, all the text fields’ data should be stored in Student Table.

 

2. Search a record from database on the basis of ID and display it on screen

 

Whenever user enters any ID in text field and clicks “Search Record from Database” button, your program should fetch this record from database. If this ID is available in database then display the record of this ID in the mentioned text fields otherwise show an error message that no such record is available.

 

Important Regarding Development:

 

If you are using JDK1.8 or above then you’ll have to use ucanaccess driver to connect to MS Access database. In this case, I'll suggest you to view the following tutorial.

 

https://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.mp4

 

Following links will be helpful in creating new database in MS Access.

 

https://support.office.com/en-us/article/Create-a-new-database-32a1...

http://www.dummies.com/software/microsoft-office/access/how-to-buil...

https://www.wikihow.com/Make-a-Database-Using-MS-Access

 

Important Regarding Submission:

 

After completing your code, execute your java file(s) and take the screenshot of the output/result. Now, compress your code, database file and screenshot of the output using winzip or winrar and upload it on VULMS.

 

NOTE:  Do not put any query on MDB about this assignment, if you have any query then email at cs506@vu.edu.pk.  Furthermore, if any student found cheating from any other student or from online forums then he/she will be awarded ZERO right away and strict disciplinary action will be taken against the student.

 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 1066

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Attachments:

Replies to This Discussion

solution?

soloution of 2nd assignment?

Solution with complete Explanation

https://www.youtube.com/watch?v=NZO9ZqUsVys

Finally Assignment is ready.

Attachments:

RSS

Latest Activity

+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS507 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS507 Information Systems
30 seconds ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS507 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS507 Information Systems
42 seconds ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS507 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS507 Information Systems
2 minutes ago
Furqan Muzamil joined + M.Tariq Malik's group
5 minutes ago
+Mr President updated their profile
7 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS405 Database Programming using Oracle 11i
13 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS405 Database Programming using Oracle 11i
13 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS405 Database Programming using Oracle 11i
14 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS405 Database Programming using Oracle 11i
14 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS405 Database Programming using Oracle 11i
15 minutes ago
Ayaat replied to Kashif Nadeem - MSCS's discussion All in one MCQs of Midterm ENG201 in the group ENG201 Business and Technical English Writing
15 minutes ago
Profile IconAyaat and Mati Ullah joined + M.Tariq Malik's group
15 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019
16 minutes ago
+ M.Tariq Malik added a discussion to the group CS405 Database Programming using Oracle 11i
17 minutes ago
Ayaat replied to + ℱȺℋ££M ᏕȺQǐβ's discussion 16 Eng 301 MiD Term Solved Papers with Reference + Solved Short Questions in the group ENG301 Business Communication
17 minutes ago
Ayaat replied to + ℱȺℋ££M ᏕȺQǐβ's discussion 16 Eng 301 MiD Term Solved Papers with Reference + Solved Short Questions in the group ENG301 Business Communication
18 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MCM304 Mass Media in Pakistan Assignment No 01 Fall 2019 Solution & Discussion in the group MCM304 Mass Media in Pakistan
19 minutes ago
Ayaat replied to + ℱȺℋ££M ᏕȺQǐβ's discussion 16 Eng 301 MiD Term Solved Papers with Reference + Solved Short Questions in the group ENG301 Business Communication
19 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT611 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group MGT611 Business & Labor Law
20 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion PHY301 Circuit Theory Assignment No 01 Fall 2019 Solution & Discussion in the group PHY301 Circuit Theory
22 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service