- Cell Phones 2172
- Desktop 778
- Editors 282
- Education, Science & Engineering 1131
- Games 1779
- Internet 5101
- Multimedia & Graphics 921
- Office software 780
- PC 397
- Programming 1809
- 1C 112
- ActiveX 3
- Assembler 32
- C# 70
- C/С++ 275
- Data Bases 367
- Delphi/Pascal 489
- Disassemblers 5
- OpenGL/DirectX 5
- PHP 156
- Setup Software 37
- Visual Basic 27
- Others 231
- Security 784
- SEO 318
- Software for Pocket PC 208
- Utilities 972
Code for tax inspection database.mdb
Refunds: 0
Uploaded: 09.10.2015
Content: text (489 symbols)
Description
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