Part I: configuration1) Create a database with Microsoft Access and save it as Database1.accdb. If you don’t have Access you can use an openSource software such as LibreOffice2) Create a table for Students as shown in the following picture:Write a Java code to create a table “Employee” as shown belowPerform add, search and delete record operations in forma of a Menu as show What do you like to do2) Modify your code to add a new student record in your database3) Modify your code to delete a student record from the database4) Modify the code to search a student in the database using the ID numberSearch a recordAdd a recordDelete a record4. Quit Lab Manual223CCS-3 Advanced Object Oriented Programming2) Modify your code to add a new student record in your database3) Modify your code to delete a student record from the database4) Modify the code to search a student in the database using the ID numberPart III: (to finish at home)Write a Java code to create a table “Employee" as shown belowPerform add, search and delete record operations in forma of a Menu as showWhat do you like to do1. Search a record2. Add a record3. Delete a record4. QuitSURNAME GENDERMooreWilsonSALARYSTATECaliforniaEIDNAMEBIRTHDAY HIREDATEDEPTRebecca2 Ashley3 Rachel4 Emily5 Ashley6 Matthew7 Alexis8 Megan1974-11-20 2005-03-11 R&D1980-07-19 2008-03-16 FinanceNew Mexico 1970-12-17 2010-12-01 Sales1985-03-07 2006-08-15 HRF7000FNew York11000JohnsonF9000SmithFТехas7000SmithFТехаs1975-05-13 2004-07-30 R&D1984-07-07 2005-07-07 Sales1972-08-16 2002-08-16 Sales1979-04-19 1984-04-19 Marketing16000JohnsonMCalifornialinoisCalifornia.11000FIFSmith9000Wilson11000DavisJohnsonMooreDavisDavis|Wilson9 Victoria1983-12-07 2009-12-07 HRPennsylvania 1976-03-12 2006-03-12 R&D1974-12-16 2004-12-16 Sales1980-09-11 2008-09-11 Sales1982-05-14 2010-05-14 Finance1977-12-24 2005-12-24 SalesFТехаs300010 RyanM1300011 JacobMТехas.F1200012 Jessica13 Daniel14 AlyssaNew YorkFloridaFlorida7000M10000F4000 Mot AccesHome CreteEitenal DatsDate feosA CutV1cending Seleon-Dl ong A Seeitera CoyPateomat tertemove Sert Y toggle teOO . Lraes DecumentsSeach DeumentCiebardSot a erOrganionNefoldeMoset AccessDocuments libraryAmange by FelderIncludes 2lections*feerteDete medtedAAM tder1 0 AM Fetelder102124 PMNameTypeLerariesedicoumepetFiletelderHemegreveTelalFile folderSS 12 M telderHA 62PM FetelderS0/S PMComputerSveddeChepene11/4124PM FletelderNe122/27 124 PM Mcesoft AccessSevepe Mo Ace Dbe CHide FoldersTeelSeveCancel3) Configure the Data Source (ODBC) as shown in the following picture to be able to use yourdatabase with JDBC.coeC MoSe tl1- Go to ODBCSourceAdministration:en De SouCenceNaeDneControl Panel\System andSecurityAdministrativeFCl Mont Acce Dr n acoCLDESTOP D laCagpaancedToolsiDataSten DtSources (ODBC)2-click add andselection thedriverSelect ObeOceC Send e mon hwcoeaNende d Atheahe ndudngDeDe3-click configureCancDe4-add a name toyour databaseVERSADMINSTRATODESTOPearDePead OryS-click select toselect yourdatabase filePart II: JDBC1) Write the following code and execute it to test if it can access to your database.publicclassMyJDBCProgram {publicstaticvoid main(String args[]) throws Exception {String query = "SELECT * FROM Students";Class.forName ("sun.jdbc.odbc.JdbcodbcDriver");System.out.println("conencted");Connection con = DriverManager.getConnection("jdbc:odbc:FirstDataBase");Statement stmt = con.createStatement ();ResultSetrs = stmt.executeQuery(query);while (rs.next()) {String t = rs.getString("FIRSTNAME");inta= rs.getInt("LEVEL");System.out.println(t+a);} con.close();}Page 13 of 29

Question

Part I: configuration1) Create a database with Microsoft Access and save it as Database1.accdb. If you don’t have Access you can use an openSource software such as LibreOffice2) Create a table for Students as shown in the following picture:Write a Java code to create a table “Employee” as shown belowPerform add, search and delete record operations in forma of a Menu as show What do you like to do2)  Modify your code to add a new student record in your database3)  Modify your code to delete a student record from the database4)  Modify the code to search a student in the database using the ID numberSearch a recordAdd a recordDelete a record4. Quit Lab Manual223CCS-3 Advanced Object Oriented Programming2) Modify your code to add a new student record in your database3) Modify your code to delete a student record from the database4) Modify the code to search a student in the database using the ID numberPart III: (to finish at home)Write a Java code to create a table “Employee&#34; as shown belowPerform add, search and delete record operations in forma of a Menu as showWhat do you like to do1. Search a record2. Add a record3. Delete a record4. QuitSURNAME GENDERMooreWilsonSALARYSTATECaliforniaEIDNAMEBIRTHDAY HIREDATEDEPTRebecca2 Ashley3 Rachel4 Emily5 Ashley6 Matthew7 Alexis8 Megan1974-11-20 2005-03-11 R&D1980-07-19 2008-03-16 FinanceNew Mexico 1970-12-17 2010-12-01 Sales1985-03-07 2006-08-15 HRF7000FNew York11000JohnsonF9000SmithFТехas7000SmithFТехаs1975-05-13 2004-07-30 R&D1984-07-07 2005-07-07 Sales1972-08-16 2002-08-16 Sales1979-04-19 1984-04-19 Marketing16000JohnsonMCalifornialinoisCalifornia.11000FIFSmith9000Wilson11000DavisJohnsonMooreDavisDavis|Wilson9 Victoria1983-12-07 2009-12-07 HRPennsylvania 1976-03-12 2006-03-12 R&D1974-12-16 2004-12-16 Sales1980-09-11 2008-09-11 Sales1982-05-14 2010-05-14 Finance1977-12-24 2005-12-24 SalesFТехаs300010 RyanM1300011 JacobMТехas.F1200012 Jessica13 Daniel14 AlyssaNew YorkFloridaFlorida7000M10000F4000 Mot AccesHome CreteEitenal DatsDate feosA CutV1cending Seleon-Dl ong A Seeitera CoyPateomat tertemove Sert Y toggle teOO . Lraes DecumentsSeach DeumentCiebardSot a erOrganionNefoldeMoset AccessDocuments libraryAmange by FelderIncludes 2lections*feerteDete medtedAAM tder1 0 AM Fetelder102124 PMNameTypeLerariesedicoumepetFiletelderHemegreveTelalFile folderSS 12 M telderHA 62PM FetelderS0/S PMComputerSveddeChepene11/4124PM FletelderNe122/27 124 PM Mcesoft AccessSevepe Mo Ace Dbe CHide FoldersTeelSeveCancel3) Configure the Data Source (ODBC) as shown in the following picture to be able to use yourdatabase with JDBC.coeC MoSe tl1- Go to ODBCSourceAdministration:en De SouCenceNaeDneControl Panel\System andSecurityAdministrativeFCl Mont Acce Dr n acoCLDESTOP D laCagpaancedToolsiDataSten DtSources (ODBC)2-click add andselection thedriverSelect ObeOceC Send e mon hwcoeaNende d Atheahe ndudngDeDe3-click configureCancDe4-add a name toyour databaseVERSADMINSTRATODESTOPearDePead OryS-click select toselect yourdatabase filePart II: JDBC1) Write the following code and execute it to test if it can access to your database.publicclassMyJDBCProgram {publicstaticvoid main(String args[]) throws Exception {String query = &#34;SELECT * FROM Students&#34;;Class.forName (&#34;sun.jdbc.odbc.JdbcodbcDriver&#34;);System.out.println(&#34;conencted&#34;);Connection con = DriverManager.getConnection(&#34;jdbc:odbc:FirstDataBase&#34;);Statement stmt = con.createStatement ();ResultSetrs = stmt.executeQuery(query);while (rs.next()) {String t = rs.getString(&#34;FIRSTNAME&#34;);inta= rs.getInt(&#34;LEVEL&#34;);System.out.println(t+a);} con.close();}Page 13 of 29

Accepted Answer

Start Access.
Access starts you out with what is, for Microsoft, a remarkably streamlined window…