Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Develop a simple GUI based database driven application for Banksystem. Core Requ

ID: 3615255 • Letter: D

Question

Develop a simple GUI based database driven application for Banksystem.

Core Requirements:

Detailed Description:

You are required to use MS Access to create a database namedBank and add a table named Account into thisdatabase.

The Account table must have following fields:

You must enter 10 records within Account table of Bankdatabase.

Create a system DSN (Data Source Name) named bankDSN and usethis DSN in a program to connect to this database.

Write a program which will have following functionalities:

1) A method which will have the functionalityto connect to database.

2) A method which will retrieve all the recordsof user from database and display on GUI window. The top header ofGUI window must have columns name of table Account. Thecolumn names displayed on GUI must be same as columns name withintable of database. You have to use ResultSetMetaData object forthis purpose. You cannot use hard coded values to display columnsname.

Explanation / Answer

x.