Code for tax inspection database.mdb

Affiliates: 0,09 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 5 (last one 17 days ago)
Refunds: 0

Uploaded: 09.10.2015
Content: text (489 symbols)

Description

Code for tax inspection database.mdb

Code for DB nalogovoy inspektsii.mdb
Download the report on the database screen forms for free http://access.avorut.ru/1/nalogovoj/214_otchjot_dlja_nalogovoj_inspekcii.doc


Name: DB nalogovoy inspektsii.mdb

Link: http://access.avorut.ru/load/0-0-0-214-20

Additional information

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

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market 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.)