Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

23 USD

Access program

23 USD

Databases & SQL

3 out of 3

suspended by administration

publication
open for proposals
suspended by administration

Project translated automatically. Log in or register, to view the original

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.

Proposals 4

by default date online rating cost completion time

30 USD

Alexandr S.

51 2

30 USD

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.