The account code for the financing of construction proj

Ready-made Access database "Accounting for the financing of construction projects by industry"
1. Create tables:

Table 1. Regions

Table structure: Region code, Region name

Table 2. Branches

Table structure: Industry code, Industry name (housing, health, culture, etc.)

Table 3. Building organization

Table structure: Organization code, Organization name

Table 4. Building object

Table structure: Name of the object, Region code, Industry code, Company code, Financing volume in the 1st quarter, Financing volume in the 2nd quarter, Financing volume in the 3rd quarter, Financing volume in the 4th quarter, Year of commissioning.

2.
Enter in Table 1 information on five regions, in Table 2 - information on five industries, in Table 3 - information about the three organizations.
3.
Create a form "Information on the financing of the construction site" to enter the data in Table 4. Provide input of all codes by selecting from the lists with reference data, control of the imported data (volumes and year of commissioning) and issuing messages when input errors occur.
4.
Create a form (such as the main / subordinate) "Information on the financing of construction sites by industry" to view the list of objects of the given industry, at the sites of which construction work is carried out, indicating the amount of financing by quarters and all. The list of objects should be ordered by region. The industry should be selected from the list.
5.
Create a report "Consolidated statement of financing facilities by industry" with the calculation of the total quarterly and annual amounts of funding for each facility, each construction organization and all. Dispatch object information in full view.
6.
Create a consolidated cross-report with totals for the year. Lines should correspond to regions, and columns - to branches.