Create Data base and reports

Well, if you open access, depending on the version the steps are slightly different, but create a new database and name the file. Then create a table, and name it what you want. Then just add 4 fields for the 4 headings (make the marks field a numeric field(. Inputting data can be done manually or write a macro to upload the data to the database if your data is long and in excel.
As far as report, I have not really worked with reports, but I also don't know if you literally mean report or just a query. For example to get the results you want in a query, the SQL would be:

Please Login or Register  to view this content.