Ready-made Access database "Accounting for the financing of construction projects by region"
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.
Enter in Table 1 information on five regions, in Table 2 - information on five industries, in Table 3 - information about the three organizations.
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.
Create a form (such as the main / subordinate) "Information on the financing of construction sites in the region" to view the list of objects in the given region, where construction work is carried out, indicating the amount of financing by quarters and all. The list of objects should be ordered by industry. The region should be selected from the list.
Create a report "Consolidated statement of financing facilities by region" with the calculation of the total quarterly and annual amounts of funding for each facility, each industry, each region and all. Dispatch object information in full view.
Create a consolidated cross-report with the results for the first half of the year - in the rows of the list of regions, in the columns - the list of organizations.