Lis Book Society (Required Knowledge in Access Database)

Requirements:
(An application) In Microsoft Office Access: (see example file)
1.Create a new record and print a membership card for those who wish to join at first attendance.

2.Add new books to the database

3.Add new groups to the database

4.Keep a record of the discussion dates of a book

5.Record attendance of members at meetings

6.To view records of any book discussion, enabling Ali to enter attendance at the meeting.

Ali would like the following reports:

1.A list of members, sorted by group and surname

2.A list of books, sorted by genre

3.A list of book titles, including the author, genre, the dates on which they have been discussed and by which group.

4.Attendance lists for meetings, showing the total amount of money taken for the evening

5.A list showing each member, the group they belong to and the books they have read.

In word:
1.A Form Diagram (see Diagram.Example File)

2.A short report (500 words) noting any improvements or additional functionality you would like to have included in your database.

FOR MORE DETAILES: PLEASE DWONLOAD THE (Alis Book Society) FILE.