MSAccess form, VBA, query tasks -- 2

$30-250 USD

クローズ

投稿日:

約9年前

$30-250 USD

完了時にお支払い

1. Build a query to update [login to view URL] (query to be included behind [login to view URL] GL button) 1st AccountNo, AP Record DLineNo=1 2nd AccountNo, AP Record DLineNo=2 3rd AccountNo, AP Record DLineNo=3, etc. eg. AccountNo AP DLineNo 0686688200 AP630 1 0686688200 AP630 2 0686688200 AP630 3 0686688200 AP887 1 0686688200 AP887 2 0686688200 AP922 1 0686688200 AP930 1 0686688200 AP940 1 0686688200 AP950 1 0686688200 AP950 2 0686688200 AP950 3 2. Format the Manager & Accountant output spreadsheets (produced from [login to view URL] Spreadsheets button :- 2.1. Fit column widths for all columns in all worksheets 2.2. Bold Titles for the columns 2.3. Current, LastMonth & 12MnthAvg columns to be formatted as currency, $ with 2 decimal places 2.3. OUTop20Calls format 2.3.1. CallDateTime dd/mm/yy hhmm 2.3.2. Seconds , between thousands 000 2.3.3. ChgExGST $, 2 decimal. 3. Place a message on [login to view URL] when reports are being generated ‘Report generation in progress, please wait’ This message should only appear when reports are being generated and should disappear when reports are complete 4. Place message in worksheets where data was not found ‘- no data found - 5 Create a query that will generate the output using tables GLTemp_H, GLTemp_L & GLTemp_D The output query will be exported as CSV format , (comma) delimited no text delimiter The format for the output file is as follows: refer doc I will load a spreadsheet with more explanation on this output.

Microsoft Access

プロジェクト ID: 7367819

プロジェクトについて

23個の提案

リモートプロジェクト

アクティブ 9年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

この仕事に23人のフリーランサーが、平均$147 USDで入札しています

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.

$150 USD 8日以内

4.9

(215 レビュー)

7.6

@Neno585

Hello, I am employed MS Access/SQL Server developer and I can do all of your tasks without much of my problem. As the rating and your satisfaction is very important to me I would do my best and even fulfill minor additional requests if you happen to had ones. If you are interested, fell free to contact me. In any case, thank you for the consideration and I wish you all the best.

$155 USD 5日以内

5.0

(23 レビュー)

7.4

@jhaynes75

I have 15 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven record of providing quality workmanship. My experience and knowledge of coding and databases makes me one of your top bidders for this project. I take pride in my work and always strive to exceed customer expectations. I look forward to hearing from you and hope we can work in the near future. I'm available to start right away. Regards, Jerry

$200 USD 5日以内

5.0

(30 レビュー)

6.0

@dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you like to complete some tasks as you described. I have 6 year's experience designing and developing Microsoft Access Application. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.

$111 USD 3日以内

4.9

(70 レビュー)

6.0

@jawadaman

Hi I am interested in this project. I can do the job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks. Regards, Jawad

$77 USD 3日以内

5.0

(79 レビュー)

5.7

@mail2vimalarora

Hi Gary, I have gone through your project details and would like to work on it. I am putting my bid here to start working on it. Rest we can have discussion on Skype on the project progress. Thanks, Vimal

$127 USD 2日以内

4.7

(121 レビュー)

6.1

@winghei

Hi, I see your needs and I want to help. I am a skilled DBA/Software Developer working on several platforms both on desktop/web application mainly on MS Access and PHP/MySQL. With my skills and years of experience, I can assure you can have a quality product. Moreover, since I am an accountant too, I think I'm the best fit for this job. I have also created a similar project using excel as the final output and where data stored are on Access Database. Hoping for you response and have a nice day. Best Regards, Sherwin

$200 USD 3日以内

5.0

(33 レビュー)

5.5

@farr4u

HI, expert here ready to start, I assure you high quality work done, thanks in advance.

$194 USD 4日以内

5.0

(22 レビュー)

5.3

@bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL, MYSQL,SQL server and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.

$180 USD 3日以内

5.0

(9 レビュー)

5.2

@mdkass

Hello, I have good experience with Access and writing vba and automation, I can do your project easily. Regards.

$65 USD 3日以内

4.8

(13 レビュー)

4.8

@piekn

Hello. I think, it's real to perform it. But I need to specify some tasks: 1. "Format the Manager & Accountant output spreadsheets" - MS access allows format only forms (not tables), that may have "table-like" view. And it's possible to format exactly the form, created and linked with this table. 2. "Place message in worksheets where data was not found" - table doesn't allows that, only forms. Form may have the same name, the same view like the linked table. So, - no data found - may be only on the form 3. ‘Report generation in progress, please wait’ - I think, it possible using modal form. So, if you agree with my specifies, contact me, please.

$60 USD 3日以内

5.0

(12 レビュー)

4.3

@robnicholson

I can help with your Access forms and VBA requests. I have worked with Access for over ten years, so I have a good grip on changing Access objects, modifying and creating VBA. Please note my bid is low because I am doing this to improve my rank rather than to gain money. Regardless of whether you choose me, have a nice day :-)

$70 USD 2日以内

5.0

(2 レビュー)

2.6

@barkatmulani

I have years of experience working with MS Access. Could deliver the given tasks with quality work and in reasonable time frame.

$110 USD 10日以内

4.8

(4 レビュー)

2.6

@milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan

$150 USD 3日以内

5.0

(1 レビュー)

2.0

@pnjadhav

Please review my profile I am working with skills that you required for this job from 14 years. Screenshots I have attached in zip file which has lots of samples of MS Access,Excel,MS SQL with VBA work I have done. I can definitely help you in this job, to make your database design very proficient. Recently I have done projects in Power Pivot,DAX with Excel. If you want to know my advanced level skills in MS Access/Excel with VBA, we will do a Skype or G-talk discussion. I will shows my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc.

$277 USD 3日以内

5.0

(1 レビュー)

0.6

@achintya

Hi. I have done several projects like this in past. I have 10+ yrs of exp. in VBA for Excel/Access and online. I can deliver you project quickly with excellent code quality. I will also provide proper documentation so in case of any change requirements in future it can be done easily. Thanks.

$155 USD 3日以内