Access program
11 USD Need help 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 date of the transaction, 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 «тУчастки» specifies 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 the branches, as in the table below:
1 | 2 | 3 | sum |
01 | 02 | 1 | 1 |
02 | 03 | 1 | 2 |
03 | 04 | 4 | 6 |
04 | 05 | 1 | 7 |
05 | 06 | 1 | 8 |
03 | 07 | 7 | 9 |
07 | 08 | 1 | 10 |
08 | 09 | 1 | 11 |
07 | 10 | 10 | 19 |
10 | 11 | 1 | 20 |
These tasks need to be solved using Access tools, without macros.
-
3 days18 USD
1330 44 5 1 3 days18 USD
Good afternoon. I am ready to solve tasks, write in private messages.
-
1 day16 USD
2218 39 0 2 1 day16 USD
Good afternoon, I have extensive experience working with accessories, I will solve it without macros, I am ready to help.
I am waiting in private messages.
-
1 day18 USD
1857 43 0 1 day18 USD
Good day!
I can do it using SQL queries or using the query builder.
Current freelance projects in the category Databases & SQL
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 3 hours 50 minutes back ∙ 2 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 9 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 2 days 14 hours back ∙ 33 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 2 days 18 hours back ∙ 13 proposals |
Project: Basic Setup of End-to-End Analytics (Analytics Engineer / Data Analyst)
203 USD
About us and current stack: We are a B2C web product. Currently, we have disparate data that needs to be consolidated into a single system for marketing decision-making. Database: PostgreSQL (user data). Payments: Stripe. Web analytics: Google Analytics 4. Traffic sources:… Databases & SQL ∙ 4 days 12 hours back ∙ 10 proposals |
Odessa