CASE BACKGROUND Social Security Benefits Application CASE BACKGROUND MGMT SS STATS, an umbrella body that facilitates and serves various Social Security Organizations/Departments within the Caribbean territories, stood poised to meet the needs of its stakeholders by launching an online database at www.SSDCI.gov. The database will provide members and the public access to the complete set of services that can (also) be initiated face-to-face, and it will provide managed, private, secure access to a repository of public and/or personal information. Ideally, the database will have basic details of pension plans recorded in the registry, member plan statistics, and cash inflows and outflows from pension funds. For example, insured persons accumulate contributions. Records for these persons will include information on the insured persons able to acquire various benefits once work is interrupted due to sickness, death, retirement, and maternity or employment injury. They will also include information on pensions such as invalidity, disability, and survivors that stem from one of the above. Members of the umbrella body, who are required to sign in, can submit requests for services, review active requests, or post comments/complaints on past or current requests online directly into the database. Visitors to the database can search for products and services, read other comments or complaints, and view advice provided by MGMT SS STATS. As a new employee of MGMT SS STATS assigned to the Management Information Systems Department, your manager wants you to design, develop, and produce reports related to pension plans in preparation for the website's public launch.
1. Since your manager desires several business reports, justify with an explanation three (3) queries you will likely make regarding the reports' creation. For one (1) report, indicate what type of business report it is (NB! Research Types of Business Reports), outline the layout and possible content relevant to the case scenario (NB! You can show it diagrammatically if desired), and which Management level and Functional area, with justification, would be best served by this report.
2. Design diagrammatically a Form layout with a Subform that facilitates data entry for your
database system. Provide a brief description of the form's purpose and functionality.
3.Identify a feature of MS Access to ensure end-users have a centralised area for accessing
and completing tasks. Explain how this feature enhances usability and efficiency.


Step by step
Solved in 2 steps with 1 images




