Ready database Access «Domoupravlenie»
1. Select a variant of the task according to the number in the group´s log.
2. Having specified and having added the given subject area, to reveal the necessary set of essences, to define a required set of attributes for each entity, to define connections between objects.
3. Create table structures, key fields. Fill tables with data. The amount of data in the tables should ensure the issuance of at least 3-5 records for each job request. Establish links between tables.
4. Create forms for entering information in a user-friendly format.
5. Create queries for the selection according to the task. Create a parametric query. Create update and delete requests. Create a cross request. Create a query to create a report.
6. Create a simple report and report based on the previously created query.
7. Create a button form for working with all previously created database objects (tables, forms, queries, reports). Provide in the form an output from the database.
Option 14. House management
Minimum list of characteristics:
• Apartment number, house number, number of residents, area;
• Type of payment, unit price, price per one tenant;
• Payment amount, month and year of payment, date of payment.
In one apartment different types of payment are used.
• Determine the amount of monthly payment for all apartments in house number 5.
• Determine the arrears for paying for the ´heat supply´ of apartment No. 512 of House No. 5.
• Determine the total number of tenants of the house number 5.
• Choose a list of apartments that do not have debts at the beginning of the current year.
1) To determine the debt, you need to know the beginning of the accounting period. Because people can use services, and pay unevenly. For this purpose, a one-line table "Start accounting" was created
2) Since the calculation of debts is used in several places, calculations are carried out 1 time, but temporary variables Tempvars are used. Therefore, some requests and reports by themselves may not work correctly. They need to be run only by macros, in which these temporary variables are given the required values. That is, you need to work with the main button form by clicking on the buttons.
3) Apartments without debt can be found in 2 ways: in general or for a service. Has made the second.