Build Access Database and Excel chart dashboard that connect efficiently

Hi Sir. I am highly skilled in Excel and Access systems and possess fairly reasonable knowledge about Oil production. I have a few proposals to make if they interest you. Firstly I propose to keep the front end in MS Excel. Make entries to Access database via Excel forms and retrieve the data from Access to Excel for interpretation. Do not make direct entries in Access as you have mentioned. Please discuss if you are interested in continuing with me. I have done several projects with similar scope before and I can handle this with ease for you, in minimum possible time. Thank you. Usman

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. 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

Hi, Approach: Before going into details of approach, I would like you to look at this project, where I am developing costing software for Pest Control company. https://www.freelancer.com/projects/Excel-spread-sheet-for-costing.html This software has 2 module: Costing module, Material flow (inventory module) with CRUD facilities. 1) User interface: User-forms or drop-down lists for getting various inputs from accountant/user. 2) Database: This contains various input tables like raw material prices, sales agent information etc. We also save generated quotes here for future analysis on profitability etc. We can use MS Access or Excel for database. 3) Calculation logic: This is where all the processing of information is done. 4) Generating quotes in MS Word: Finally we can link costing tool to MS word and automate quote generation process. This saves time and reduces human error. 5) Email integration: Sending mails/alerts based on condition. Tool language:It is based on Microsoft excel and uses VBA code for operation. MS access is used as database. My background: I am working as Lead Pricing Analyst in a Fortune 500 MNC. Prior that I have completed MBA and bachelor in Engineering. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. [Would like to share a sample program] Regards! Vikas

please send the project details to develop the project road map for discussion with you .

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in MS excel, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

Hello I am working with MS-Access database, Ms-Excel and VBA for the past 14 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your project specification. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John

I am very interested in your project. I have 5+ years exp. in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I will give you my best possible work. I would like to thank you in advance.

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

Hi, I will be happy to provide you with the required solution. The kind of business you operate requires a perfect solution that boosts your business rather than hindering it. I will provide you with both Access and Excel interface/dashboard. I will use my VBA skills to automate all of the required processes in the background to enable the user to perform the required tasks in a few clicks. We can talk via Skype if you think this is a convenient method for you. Please have a look at my profile/portfolio and do not hesitate to contact me for further information Best Regards Ahmed

Dear Sir/Madam, I work as a Business Data Analyst for Ford Motor Company. I have 3 years of experience in reporting using Excel and relation databases like MsSQL, Oracle and Access. I think I can help you setting up the database structure you mean and a user friendly interface to upload data and to create reports from it.

HI, I WOULD BE HAPPY TO ASSIST AS I DO HAVE BOTH MS ACCESS AND MS EXCEL SKILLS,AS WELL AS DATABASE DESIGN SKILLS. PLEASE FEEL FREE TO CONTACT ME FOR FURTHER ASSISTANCE. KIND REGARDS,ENRICO

I have a very good command over access and vba, vb.net. this will be a very easy task for me. Do consider my bid. thanks

A proposal has not yet been provided

I know your heart is set on MS Access, but consider a browser-based cloud database application service that includes ALL IT services in a single plan. During twenty years of creating database applications for clients, I developed a method to support a diverse set of CUSTOM applications. We combine all services: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT into a single plan--one low monthly fee to fully support your IT needs. Search for "Konduit Transaction Editor". I can set up your CUSTOM Oil and Gas Production database application on a production Transaction Editor (TEd) cloud server within two weeks for just $495. Users can Test Drive the application online for two months as we continue to refine your requirements. You get immediate hands-on experience and we can calculate the affordable monthly recurring fee based on the complexity of the application we build. * Each TEd application combines spreadsheet ease-of-use with the accountability of a database and includes ongoing professional APPLICATION support. * Intuitive SEARCH, SORT, and VIEW-creation capabilities * All user data changes recoverable from CHANGE HISTORY LOG * Column and Row USER-ACCESS CONTROLS * Highly reliable and secure * IMPORT/EXPORT - named VIEWS and file format specifications * JOB scheduling and EVENT-based data modifications * NOTIFY capabilities * and so much more... Contact me for a demonstration.

A proposal has not yet been provided

I took Energy Economics at Cornell and knows about the trade of oil and gas professionally. I used Microsoft Access and Excel in multiple projects at Cornell and off campus. For example, I used Access to track performance of all parties participating in a wood stove change-out program across the Tompkins County, NY., and I used Excel to generate energy consumption scenarios for the Tompkins County planning department. The information required in this project, i.e. entries into the database, can be built as "keywords" and got connected in Access. The program can also realize the desired data populating, query, report, and exporting to Excel in a professional manner. Given the data imported in the same format, Excel can build a dashboard that displays charts illustrating the desired information automatically. The clients interests can be met be showing them a scalable Access interface that presents only the essential pieces of information. The revenue forecasting is not live on Access or Excel. The unit price can be obtained from EIA, but the simulation of daily oil production needs some assumptions that we should make together. I pay close attention to details, enjoy efficient work, and have high standards for the quality of work I do. Please feel free to ask me any questions regarding my thoughts about the project and/or regarding me. I look forward to hearing from you! Thank you!