Ms access assignment now how to do it
Tasks Details:
Use MS Access to create database with the name “DATESHEET” and add a
Table to it with name “STUDENT”.
Your table should have following fields.
RollNo
StudentName
City
DegreeProgram
CourseID
SessionID
Date
Time
Enter at least 20 records in the table.
Create a System DSN with the name “studentDSN”.
Build a simple GUI based program which will connect to this database
And query all the records in the “STUDENT” table and display them.
Use Grid Layout to display the records.
You should use Jlabel in every cell of the grid layout to display a field from
Table.
Also add a header row in the layout which would contain the names of the
Fields. (Use hard coded names of table fields, do not use meta data)
Exceptions Handling related to DB should be handled properly.
Code should be nicely aligned and well commented where required.
I hope someone can help me in no time...
