Access program
Need help with implementing a database Access.
First
Attached is a file in which a home finance database needs to be created. In the query «зТрТранзакции», the field «ОстатокНаСчету» needs to show the result for each line considering the account from which the transaction was made, the transaction date, and the transaction code, meaning that after each operation, it should be possible to see how much is left in the account. The existing formula calculates incorrectly.
Second
In the same file, the table «тУчастки» indicates the distance between the start of the section in column «1» and the end of the section in column «2». In the query «з_Участки», the field «Сумма по участкам» needs to show the distance to each point across all sections considering branches, as in the table below:
Code | Name | Start | End | Length | Distance |
1 | 2536 | 01 | 02 | 1 | 1 |
2 | 2536 | 02 | 03 | 1 | 2 |
3 | 2536 | 03 | 04 | 4 | 6 |
4 | 2536 | 04 | 05 | 1 | 7 |
5 | 2536 | 05 | 06 | 1 | 8 |
6 | 2536 | 03 | 07 | 7 | 9 |
7 | 2536 | 07 | 08 | 1 | 10 |
8 | 2536 | 08 | 09 | 1 | 11 |
9 | 2536 | 07 | 10 | 10 | 19 |
10 | 2536 | 10 | 11 | 1 | 20 |
Calculation with connection lines (there may be several connections), the connection table combines different lines with each other and needs to expand the connected section from the connection point and in the field «Сумма по участкам» get the distance to each point across all sections considering branches, as in the table below (connection points 06 at 2536 and 04 at 4789):
Code | Name | Start | End | Length | Distance |
1 | 2536 | 01 | 02 | 1 | 1 |
2 | 2536 | 02 | 03 | 1 | 2 |
3 | 2536 | 03 | 04 | 4 | 6 |
4 | 2536 | 04 | 05 | 1 | 7 |
5 | 2536 | 05 | 06 | 1 | 8 |
6 | 2536 | 03 | 07 | 7 | 9 |
7 | 2536 | 07 | 08 | 1 | 10 |
8 | 2536 | 08 | 09 | 1 | 11 |
9 | 2536 | 07 | 10 | 10 | 19 |
10 | 2536 | 10 | 11 | 1 | 20 |
13 | 4789 | 04 | 03 | 8 | 16 |
12 | 4789 | 03 | 02 | 2 | 18 |
11 | 4789 | 02 | 01 | 2 | 20 |
14 | 4789 | 04 | 05 | 2 | 18 |
15 | 4789 | 05 | 06 | 2 | 20 |
16 | 4789 | 03 | 07 | 14 | 32 |
17 | 4789 | 07 | 08 | 2 | 34 |
18 | 4789 | 08 | 09 | 2 | 36 |
19 | 4789 | 07 | 10 | 20 | 52 |
20 | 4789 | 10 | 11 | 2 | 54 |
These tasks need to be solved using Access tools, preferably without macros.
-
3559 51 2 Good afternoon, my name is Alexander, I am a .NET developer with 3 years of commercial experience.
I have experience working with various technologies, including databases and Access, and I am confident that I can make a valuable contribution to the implementation of tasks related to your system. Allow me to present my solutions for the current tasks:
Tasks:
Account balance calculation: In your database, it is necessary to configure the query "zTrTransactions" to correctly calculate the account balance. It is essential to consider each transaction based on the date, account, and operation code. I will be able to update the formula so that the result is correct for each row, displaying the account balance after each transaction.
Distance calculation between plots: In the table "tPlots," the starting and ending points of each plot are already specified. In the query "z_Plots," it is required to calculate the total distance considering all plots and branches. I will implement this using SQL queries so that the distances to each point across all plots are correctly displayed, taking into account all connections and relationships between lines.
… My skills:
Deep understanding of C# and the .NET platform.
Experience with databases (SQL, Access).
Ability to optimize queries and correctly structure data.
Experience with systems requiring complex calculations and process automation.
I am confident that my knowledge and experience will help you achieve quality results in the shortest possible time. I would be happy to discuss the details of the assignment further and share my experience in an interview.
-
1330 44 5 1 Hello. I am ready to implement. Write to me in private messages, we will discuss the details.
-
2218 39 0 2 Hello, I work a lot with Access, I guarantee quality, write to me in private messages.
-
3012 73 4 2 Good day! I have experience - I can implement it! Contact me!!!!!