Create a database of some tax inspection for the registration of tax returns of individuals
Option 1
1. Create a database of some tax inspection to record tax returns of individuals.
2. Organize the database in the form of the following tables:
Table Taxpayers, including data on the taxpayer: the name (for a legal entity) or full name (for an individual), legal status (individual, state enterprise, ICP, LLC, CJSC, etc.), addresses, telephones, etc. information.
Table Source of income, including information about the organization (private person) from which the income is received;
Income table containing the taxpayer´s code, income source code, year of receipt, month of receipt, amount of income, amount of tax paid from this income.
3. Enter at least 5 entries into the tables without a foreign key and at least 10 entries into the tables that contain the foreign key field. Enter into fields with a small set of possible values ​​(for example, gender, position, legal status, etc.) to organize using the fields of substitution. (As a list of values)
4. Create a database schema with the integrity of the data.
5. Create a request that allows you to display income data, indicating taxpayers and sources of their income.
6. Create a parametric query that allows you to display data on income belonging to a particular parameter to the taxpayer.
7. Create a request to display the total income of each taxpayer.
8. Create an arbitrary query with a grouping to display the data requestor of interest
9. Create an arbitrary cross request
10. Create a form in the Designer according to the tables of the Taxpayers and the Source of income, by adding buttons for switching between records
11. Create a report on the first query by adding the name and group of the student who compiled the report to the notes area.
12. Create the main form in which to place the buttons to open all the tables, forms and report.
13. Set the opening of the main form when opening the database
Option 2
1. Create a database of some tax inspection to record tax returns of individuals.
2. Organize the database in the form of the following tables:
a) Table of taxpayers, including data on the taxpayer: the name (for a legal entity) or full name (for a natural person), legal status (individual, state enterprise, ICP, LLC, CJSC, etc.), addresses, telephones and other information.
b) Table Source of income, including information about the organization (private person) from which the income is received;
c) Income table containing the code of the taxpayer, the source code of the income, the year of receipt, the month of receipt, the amount of income, the amount of tax paid from this income.
3. Enter at least 3 entries into the tables without a foreign key and at least 7 entries into the tables that contain the foreign key field. Enter in fields with a small set of possible values ​​(for example, gender, position, legal status, etc.) to organize using the fields of substitution.
4. Create a database schema with the integrity of the data.
5. Create a request that allows you to display income data, indicating taxpayers and sources of their income.
6. Create a parametric query that allows you to display data on income belonging to a particular parameter to the taxpayer.
7. Create a request to display the total income of each taxpayer.
8. Create an arbitrary query to display the data requestor of interest.
9. Create a form according to the tables Taxpayers and Source of income.
10. Create a form from the Taxpayers table by adding buttons for switching between records.
11. Create a report on the first query, adding the name and the group that compiled the report to the notes area.
12. Create macros to open all forms and report tables.
13. In the window that is maximized on the whole screen, create a form in which to place the buttons for executing all the macros from the previous job.
14. Create a macro that allows you to open a form