Writers Association is an organization grouping writers in Gulf Cooperation Council (GCC) countries. The professional writers can join the association as members. Membership is granted to these writers with more than two publications (i.e. stories or books). Based on the number of publications, writers are categorized into: FULL Members and ASSOCIATE Members. Associate are the ones with less than 5 publications. You are asked to develop an automated information management system which facilitates the process of tracking writers/ members information together with their publications. You are to develop a Visual Basic application to access a database system, retrieve and record into it information relevant to the writers and their publications

The schema of the existing database is as follow:

WritersMembership:

memberID, name, gender, contactNo, membershipDate, noBooks, nnStories, membershipCategory

A.The application should: - Connect to Access Database 1.5 mark And provide the following services: - Retrieving and viewing writers details and publications info 1.5 mark - Add new writers details and publications info 6 mark - Modify existing writers details and publications info 6 mark - Delete existing writers details and publications info 6 mark B. Design an appropriate GUI that simplifies the use of the system. 8 Marks C. Give appropriate names to the variables and controls. 2 Mark D. Validate the user input 5 Marks F. Write and invoke user defined methods (i.e. subroutines or functions) 4 Marks F. Save your VB project as project_yourID (e.g. project _202200492)