Find Jobs
Hire Freelancers

Calculations with Microsoft Access

€30-250 EUR

Completed
Posted about 4 years ago

€30-250 EUR

Paid on delivery
I have a Microsoft Access database, where I record transactions with securities on the stock exchange. I need help in order to calculate accounting parameters, like return on investment from the database. The right freelancer should meet the following criteria: 1. a strong background in Microsoft-Access; 2. be able to solve technical problems with Access calculations and be willing to explain his/her solution; 3. a basic understanding of trading with securities: you do not have to be an expert in stock picking, but you should understand the difference between stocks and bonds, and who distributes dividends; 4. a basic understanding of accounting: a university degree is not required but you should understand the difference between an asset, income, expense, and what of these 3 is taxable. 5. Owning a computer with Windows Operating system, Microsoft Access, and a functional phone. Although there is a specific problem at the moment, additional problems will pop-up. The chosen candidate can expect additional assignments, which will be paid separately, so the right candidate can earn ca. 460 € per year. Please read the screening questions in the attached Word file before writing me. If you are not able to answer these questions, then please do not contact me. The right candidate should be able to answers most of these questions correctly. The candidate that provides the best answers, will be invited to a telephone interview. After the phone interview, I will send the freelancer an Access database. The freelancer should help me to calculate financial balances in difference currencies.
Project ID: 23958140

About the project

11 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Please find answers below:- 1) Relationships, this is also commonly referred as Entity relationship diagram 2)Dates (tDates), Key Persons (tComm-Pers) can be one however Product Names (tProducts) can be many 3)To add a new person to tPerson, we can create a form and user can make use of that form to add new person to tPerson. In order to create the table, we can make use of continous forms and provide button on the form to export data to Excel 4)Sum is total the values in a column, dsum can be used to provide a criteria to filter the values to be summed up 5) Create a query using Find Duplicates Query Wizard in MS Access and then run that query to see the duplicate records 6) Field=> f, Record=> e, Table=>b, Datasheet=>d, Query=>a, Form=> g, Report=> c 7) d 8) When a new database is created, table is created first so correct answer is option d 9) 1=> (b), 2=> (d), 3=> (f) 10) c (basically it is going to filter the records of table Table_Items to show only those records where item_price > 100000 and item_name contains the word car. Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013,2019 projects both big and small using MS Access as a front end as well as back end. I have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
€110 EUR in 5 days
4.9 (53 reviews)
5.7
5.7
11 freelancers are bidding on average €150 EUR for this job
User Avatar
*** I AM EXPERT IN MS ACCESS DATABASES *** Dear, I checked your project doc file, and I confirm I can develop your MS-Access program. Could you send me your Access file, I need to take a look ? I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
€90 EUR in 5 days
4.7 (82 reviews)
7.3
7.3
User Avatar
Hello, I can help you with your project - Calculations with Microsoft Access I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€240 EUR in 5 days
5.0 (12 reviews)
5.6
5.6
User Avatar
Hi, I hope you are doing well. The proposal process doesn't allow us to attach any doc. However, your answer is ready. Please ping me so that I can send you over chat. Microsoft Access and Microsoft SQL Server in combination are extensively serving small businesses since 1997 in getting their business processes automated and staying ahead in this competitive world. In the same timeline, I am offering my software/database development services since 2007. I have exposure to all the flavors of MS Access (Access97 to the latest one). I can provide you best support on your current project. I have done more than 1500 MS Access database projects and this project is related to my area of expertise. Please ping me to discuss project details in detail and I am willing to take care of your project. Thanks in advance. Rayyan
€250 EUR in 10 days
5.0 (19 reviews)
4.9
4.9
User Avatar
I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access certified. I'm confidence I can help you to finish this project for you as requested.
€100 EUR in 7 days
4.9 (30 reviews)
4.5
4.5
User Avatar
I had studied your screening question docx attachment. I had done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-design-18665960/ • https://www.freelancer.com/projects/microsoft-access/Microsoft-Access-VBA-Application/reviews • https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ • https://www.freelancer.com/projects/database-programming/data-base-search-options/ I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008
€200 EUR in 17 days
4.4 (4 reviews)
4.2
4.2
User Avatar
Dear Sir, Madam, Questions in the Word document answered fully and successfully. I'm proficient in MS Access, I have been working with for years. I'm also proficient in finance, no problems to understand what's stocks and securities and how to assess return provided from those financial instruments. Looking forward to work with you. Thanks and regards.
€111 EUR in 3 days
5.0 (4 reviews)
2.3
2.3
User Avatar
i'm a mechanical engineer and i've good experience using access as i designed a similar system in my last job. i hope if i can work on this project Regards
€140 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can help your with your project. I'm expert developing applications based in Access and VBA. These are my answers to the screening questions: 1.- This is the relations tab. 2.- Two or more records in tCommunication table can have the same Contact Date. Also, two or more records in tComm-Pers .- table can have the same CommId (I suppose this relation should be explicitly defined as one to many). Also, several products can be related to the same CommId in tComm-prod table. 3a.- A form can be used to add a new record to the table, however sometimes is handy to use a macro or an append query to add new records. It depends on the situation. 3b.- There are several way to do this. If the actual table object needs to be built and these two records automatically added to that table, I will use a macro for that. If the table already exists, I will use a form for the user to enter the records and then a VBA macro (using the TransferSpreadsheet command) to export to Excel. 4.- I think the only difference is that with DSum, you can sum values specifying the domain (the table or the query). 5.- There are several ways to do this. We can simply filter the fields we are interested in, or we can run an sql query, or we can use the DCount aggregate function.. 6.- f, e, b, d, a, g, c 7.- d 8.- d 9.- 1 -- a., 2 -- d., 3 -- f. 10.- I would mark d. Although the select SQL itself does not count the number of records. To count records we would need to use SELECT COUNT.
€120 EUR in 3 days
0.0 (0 reviews)
1.0
1.0
User Avatar
Hello i had worked with stock broking firm in India for 2 years in back office. And have cert. In Mutual Fund. Bookkeeping knowledge 1 year exp. knowledge of Access know Can't see attch send in chat Relevant Skills and Experience Excel vba Function and formulas Basic Access but can do formula with some online help. Accounting function n formulas Vat calculations Will do stock calculations with some online help. 8 years exp.
€44 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Siegburg, Germany
5.0
1
Payment method verified
Member since Nov 27, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.