1) The database (DB) should be brought to the third normal form and contain the following information: Name of the person registered, Status (invalid, pensioner, etc.), Address, name of curator, address of curator, internal phone of the curator, amount pensions.
2) Create forms to enter information into each of the created tables.
3) Create three queries:
a. (Sorting) The name of the person who is registered, the status, the amount of the pension. Sort by name.
b. (Grouping) Full name of curator, number of supervised persons. Sort by the name of the curator.
c. (Parameter) Full name of the registered person, Address, Full name of the curator. All entries for the user entered status are displayed.
4) Create reports based on available queries.
5) Create the basic button form.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at email@example.com the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)