Database vba jobs

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already...

I am in need of a bespoke CRM and database system tailored to my business needs. The system must have the following functionalities: - Contact Management: The system should allow us to manage our contacts effectively. We need to be able to store and retrieve contact information easily, keep track of interactions, and assign contacts to specific team members. - Sales Pipeline Tracking: It's crucial for us to have a clear overview of our sales pipeline. The system should enable us to monitor leads, track their progress through the sales funnel, and forecast revenue. - Task Management: We need a tool that helps us manage our daily tasks efficiently. The system should allow us to create, assign, and prioritize tasks, set deadlines, and monitor their completion. In terms of the ...

I am in need of an experienced database developer to assist me in refining and managing a relational database with a primary focus on data update operations. Key responsibilities: - Familiarity with the MySQL management system is a must. - You will be primarily handling data update operations. Desired skills and experience: - Substantial background in relational databases and MySQL. - Proven track record in managing and updating large databases efficiently. - Excellent problem-solving abilities and attention to detail. I'm hoping for an individual who can bring their understanding of relational databases and MySQL to the project, making it reliable and efficient.

...who can help me resolve issues with my website running on the jannah theme in Wordpress. Website developer who can fix database Overload issue & Database crashing. - The website is currently experiencing problems with huge database and it's compatibility that need to be addressed. - The site database is also getting crashed that need to be fixed. - I made some recent changes to the site, including updating content and making hosting/server changes. The developer will need to ensure that these changes have not caused any additional issues. The ideal candidate should have: - Strong experience working with the Hannah theme in Wordpress - Proven track record of fixing Database issues. - Expertise in resolving compatibility issues between themes ...

I'm looking for an expert in database schema and development, ideally with experience in price comparison websites, especially in electronics sector. The scope includes: - Creating a comprehensive, efficient database to store data on electronics products primarily, including product prices, specifications, and details of the vendors. - This data will need to be structured in a way that allows for easy and consistent updates, as new products and prices will be integrated into the database on a daily basis. We are looking for experienced professionals to undertake the creation of a comprehensive database for the development of a price comparison website. The website will work similarly to well-known platforms such as greek website , providing users with in...

As the client, I need a skilled PHP developer proficient in both front-end and back-end development alongside managing databases. The project involves primarily database management, though experience and skill in website and web application development will be advantageous. Requirements: - Expert in Front-end development - Proficient in Back-end development - Solid experience in Database management Please note, while understanding PHP frameworks such as Laravel, Symfony, and CodeIgniter could be beneficial, it's not a mandatory requirement for this job.

...talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. • Previo...

Collect Database of Candidates Looking to do skills development courses

I require the creation of an employee database focusing on fresh graduates with 2-3 years of experience in the Technology and Finance sectors. The database needs to be structured and delivered in an Excel spreadsheet format. It should contain the following information for each candidate: - Name - Education qualifications - Work experience details - Phone number The ideal freelancer for this project should demonstrate strong data entry skills and have a firm grasp of Microsoft Excel. A background in recruiting, HR or a related field, and knowledge about the Technology and Finance industries would be beneficial. Efficiency, meticulous attention to detail and respect for confidential information are also critical for this project. Prior experience in developing such databases ...

I have a MySql database folder that I need to recover data from. Key requirements: - Extract specific data from the database You will work with a MySql database folder and extract the specific data that I need. Experience in data recovery and MySql is crucial.

Hello , I have simple job for PHP & JS Expert. I want to upload Text file and want to store text file data into database . you will have to split setance with ( dot ) and store into different column , while storing you will have connect document id , so later we can identify that data via search , its large documents ( txt ) file mainly. Bid you have expertise and experience for same I can pay 1000 INR for this job, i will share current source code and database , Further i will share FTP to upload task and make it run. I need to finish this task in 2 - 3 hrs or let me know how quick you can finish Regard

I am looking for a competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking database, that generates Product pricing reports. The Database/Access file should be able to: - Have a master list of Product ingredients that allows a user to easially update the cost price. For example, raw ingredients per kg (flour, sugar, etc). As a price changes from supplier the user can update the cost of the raw ingredient easily in a table. - The same type of list but for non-product resources. This list will include packaging, labour costs, etc. - A Master product list, which has the list of finished products. - The ability to create, edit and delete master products and then define what ingredien...

I'm using Laravel and have been encountering connection errors in my database. Additionally, some data inconsistencies have surfaced in my project, such as missing data. Key points: - Identify and rectify the connection errors that are disrupting the database - Investigate and resolve any data inconsistency problems, particularly the missing data issue. Ideal skills and experience: - Laravel framework - Database management - Data consistency and integrity - Troubleshooting and error diagnosis in databases

...seeking a skilled database developer to create a comprehensive database for our co-operative in Australia. The database will need to store the following information: - Member names and contact information - Membership status and payment and activity history - Co-operative activities and events participation The database should be accessible via a desktop application and support multiple users accessing it at the same time with the same access level. Ideal skills for this project include: - Proficiency in database development - Experience in creating desktop applications - Ability to manage multi-user access If you have experience in similar projects, please provide examples in your bid. The successful freelancer will work closely with our co-operat...

...my current database. I have a usb card reader / writer and want the app to be able add the card to that user then add credit to the account, and the Raspberry pi card readers on 2 machines which are programmed and i need to get them to communicate with FM for credit usage etc. - I currently have a FileMaker database in place, so I need someone who is familiar with the software and can hit the ground running. - The specific enhancements I am looking for are related to user interface improvements, adding new functionalities and optimizing the performance of the database. - In terms of functionalities, I am particularly interested in data import/export, custom reports, and automation scripts. Ideal skills for this job include: - Proficiency in FileMaker Pro - Exper...

I’m looking for a proficient backend developer with ample experience in Node.js and RESTful API implementation to build a database for my project. Your role will largely concentrate on: - Creating a robust database using Node.js as per the design and structure outlined. - Developing the RESTful API to interact with the database. - Primarily handling user authentication through the API. Ideally, you should have a strong knowledge of Node.js and a proven track record of creating and working with RESTful APIs. I would appreciate it if you have experience working on user authentication systems before. A detail-oriented, problem-solver with good communication skills will fit the task perfectly.

I'm in need of an experienced MySQL database expert to help me with a specific issue I'm facing. The issue is related to a long running rollback transaction that has lead to some performance issues in the database. Requirements: - Ability to diagnose and troubleshoot a long running rollback transaction - Expertise in MySQL database management - Previous experience handling similar issues You will be provided with video conference access to the database for troubleshooting purposes. I'm looking for someone who can quickly and efficiently resolve this issue.

More details: What specific information do you need to gather for each company? Company name, Contact name, Contact email; Contact phone number; Company website, Gender, Position, Email What information should successful freelancers include in their application? Past work How would you like the database to be organized? Name, Position, Gender, Company, URL, Email, Phone, Notes Project Objective: To create an organized and detailed database, which includes the following columns: Name, Position, Gender, Company, URL, Email, Phone, and notes. Requirements: 1)Research Skills: Ability to conduct thorough online research to find accurate contact information for HR representatives, recruiters, and hiring managers within the specified companies. 2)Attention to Detail: Ensure ...

...specialized relational database that pulls text content, notably foreclosure sale information, from multiple websites (Website A, B, and C). This should function automatically and update on a regular basis, ensuring the most current data is retrieved and stored. Also the information can be manually added and edited and sorted. Ideally, the freelancer working on this project should have: - Experience in database creation and optimization - Expertise in data scraping from various websites - Knowledge in handling real estate or specifically foreclosure sale information - Proficiency in ensuring the confidentiality of scraped data An understanding of legal parameters regarding data scraping will also be helpful. With your skills, I hope to have a streamlined database...

I need to automate the creation of tasks and subtasks in Microsoft Planner from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable ...

We're looking for an expert to install KeyCloak and integration with MYSQL database. The task involves customizing our login page, which includes changing the layout, adding our company logo and branding, as well as customizing the form fields. This needs to be done in 2-3 days. There are 3 environments: - DEV - UAT - PROD Following activities need to be performed in these three environment along with documentation of every step taken: Installation: 1. Install KeyCloak latest version on the VM 2. Install MYSQL database on a Azure MYSQL PaaS 3. Integrate both of them 4. Install Domain on KeyCloak [Domain will be provided] 5. Install SSL [SSL certificate will be provided] 6. Show KeyCloak in running condition 7. Create a Realm [Details will be provided] 8. Create a Clie...

I'm in need of an expert in VB/VBA development to assist with my software solution, primarily dealing with a scale system for a food company. Understanding Macola software would be highly beneficial. The core focus will be on: - Error fixing in current functionalities when they occur like label printing and commimocation errors - Developing and integrating new features into the system - troubleshooting errors as there arent many but I need the person to be able to support US EST (East coast US) hours The exact errors to address are not currently available, but a strong analytical mindset will be crucial in tackling this project. The ideal candidate should be knowledgeable in VB/VBA, demonstrate solid problem-solving skills, and have experience working with Macola softw...

I'm seeking an experienced data miner to build an extensive B2B database containing more than 500 companies. It's important that the database includes specific categories of information for each company. Required Information: - Company name - Contact person details with email - Industry type Industries of Interest: - Market Research - Retail - Consumer Product The ideal freelancer for this job would be a proficient researcher with excellent data entry skills. Experience in building B2B databases and knowledge of the chosen industries is an added advantage. Your attention to detail, accuracy, and confidentiality will be key.

...of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on inventory. Ideal candidate: The ideal candidate should be an exper...

I'm in immediate need of an experienced freelancer to efficiently scrape data from a specific database. The scope of the project includes: - Data extraction from an identified database As the second question was skipped during the initial discussion, it is unclear whether the data should be cleaned or processed post-scraping. Therefore, the ideal candidate should possess: - Experience with data scraping, especially databases - Ability to clean and process data in the event it is required - Availability to complete the task as soon as possible Please, when submitting your bid, include details of your related past works and note your readiness to start immediately due to the urgent nature of this project.

Hello, I am looking for someone to go through a file and collect brand logo images based on that file. The file has around 1700 entries but a lot of them are duplicates. I need this done today and sorted correctly. If you can do this and you actually read this please type the word IMAGES at the beginning of your proposals. Proposals without it will be ignored.

I am looking for an Excel expert who can set u...a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the count in the dashboard the sample file for problem solving. Ideal skills and experience: - Expertise in Excel: A deep understanding of Excel's functionality and the ability to customize it to meet specific requirements. - VBA programming: Experience with VBA programming is a plus as it will be needed to create the custom formulas and set up the automation. - Automation: Proven experience in automating tasks within Excel and making processes more efficient. - Attention to detail: It's crucial that data is handled accurately and that the formulas are correctly implemented to ...

I'm in need of an Airtable professional who can assist me in designing a sophisticated database to manage employee records. Tasks and Responsibilities: - Database design focused primarily on capturing data related to office assignments and organization Ideal Skills and Experience: - Proven experience in Airtable - Attention to detail for data entry - Outstanding database design knowledge - Expertise in setting up automation workflows The main objective of this project is to create a functional, user-friendly database that seamlessly captures and organizes crucial employee data related to their office assignments. Hence, experience in similar projects will be highly appreciated.

I'm in need of a small, web-based database that can both collect and organize data, as well as send automated emails. The database will primarily be used by our internal team members, so simplicity is more important the design. Key features of the project: Page one - team member will select from a few drop downs and have options to manual enter if choice is not listed. Page two - Team mambe rwill select a category Page three - team member will select a device and qty Page four - team member will have selections displayed and have options to edit, add or delete any selections then submit. "Submit" will generate an email to a constant email address. subject will be genreated from the selections on page one. Body will contain parts from page one and item selected...

I am in need of an expert in Python who can aid in the automation of my database management tasks. The specific duties will revolve mostly around designing and implementing automation sequences. Relevant skills I'm looking for include: - Solid experience with Python, with a particular emphasis on automating tasks - Familiarity with database management, especially with undefined databases - Good problem-solving abilities and a knack for creating efficient solutions Should have a good understanding of databases in general as the specific database type in use hasn't been determined. The successful bidder will be someone who can demonstrate a deep understanding of Python and its applications in database management.

I need the Database development. coder for multiple jobs. Details will be discussed.

I need the Database development. coder for multiple jobs. Details will be discussed.

I need an expert freelancer to develop a database and website for my Leca block factory, plus make some updates on other websites. For the Leca block factory: - The primary purpose of the database is to track production data. It should be able to store and update information on the manufacturing process, the output, and other relevant data. - As for the website, it should be user-friendly and only accessible to admins. For the other websites: - I need changes in content, layout, and the addition of new pages. Ideal skills and experience for this project include: - Proficiency in database development with a focus on production data tracking. - Experience in website development, particularly for admin-only access. - Versatility in content updates, layout changes, a...

I'm in need of a passionate Oracle expert who can assist me in both administration and development of an Oracle database. Key responsibilities for this project include: * Database design * Query optimization * Performance tuning * Implementing a brand new database development from scratch The ideal candidate will have: * Profound knowledge and sound experience in Oracle database design and performance tuning * Excellent capabilities in optimizing database query * Strong track records of developing Oracle database from the ground up. This project is more about proficiency and less about years of experience. If you're eager and confident in your Oracle skill-set then I'd like to hear from you. Given the complex nature, you'll ...

Need a database of companies: Location: Singapore Industries: - food wholesalers - food distributors - food importers - grocery stores - food trading companies - food manufacturers - restaurants - other industries (diverse) Require data: Company Name 100% Address 80-100% Email 100% Phone 80% Industry 100% Number of companies: 3300 Due date: 19.04

I am in need of a comprehensive database for business owners contact no of service providers in Tamilnadu, Chennai. The database should include at least 2500 business owners. Please provide a clear outline of your approach to this project in your bid. Thank you.

I need a proficient Python developer to create a stock and options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet...

I am trying to fetch ebay api token. Code works in php but not in vba

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I am looking for a professional Omniscript developer with a keen eye for aligning with existing designs, to build a single web page. My design is ready and I need you to transform it into reality effectively. Functionalities Included: - The key functionality required is Form submission. Special Features: - Not only should the form be functional but also integrated with a database for maintaining records of submissions. Skills and Experience: - Strong practical experience with Omniscript is mandatory. - Proficiency in working with databases is vital. - A deep understanding of form design and integration is needed. - Previous projects in which you have successfully executed existing designs are valued. Let's build one robust, seamlessly designed, data-integrated page togethe...

I am aiming to establish a comprehensive database of 10,000 small businesses in home services across the US's major cities. The target includes plumbing services, cleaning services, roofing, HVAC, handyman, fencing, landscaping, and water heaters businesses. The purpose of this database is for a cold calling campaign. 1 New York 8,550,405 2 Los Angeles 3,971,883 3 Chicago 2,720,546 4 Houston 2,296,224 5 Philadelphia 1,567,442 6 Phoenix 1,563,025 7 San Antonio 1,469,845 8 San Diego 1,394,928 9 Dallas 1,300,092 10 San Jose 1,026,908 11 Austin 931,830 12 Jacksonville 868,031 13 San Francisco 864,816 14 Indianapolis 853,173 15 Columbus 850,106 16 Fort Worth 833,319 17 Charlotte 827,097 18 Seattle 684,451 19 Denver 682,545 20 El Paso 681,124 21 Detroit 677,116 22 Washington ...

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!

Enterprise Data Architect Level III Clearance: TS (preferred) Software: Databrink and Palantir Timeframe: 40hrs / week - 3 month contract with possible extension Purpose of the Job: The Enterprise Data Architect is responsible for setting the strategy for the EPMs’s data architecture and providing technical architecture direction for delivery of the target state. This person is an integral member of the Enterprise Architecture Team and will be responsible for the design and implementation of the enterprise-wide data strategy, ensuring the strategy supports the current and future business needs. They will apply their knowledge of good architecture practice, architecture documentation and data technologies to comprehensively capture the bank’s current state holistic data ar...

Enterprise Data Architect Level III Clearance: TS (preferred) Purpose of the Job: The Enterprise Data Architect is responsible for setting the strategy for the EPMs’s data architecture and providing technical architecture direction for delivery of the target state. This person is an integral member of the Enterprise Architecture Team and will be responsible for the design and implementation of the enterprise-wide data strategy, ensuring the strategy supports the current and future business needs. They will apply their knowledge of good architecture practice, architecture documentation and data technologies to comprehensively capture the bank’s current state holistic data architecture and oversee target state design and implementation. The role will involve collaborating with...

Task list 1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database Conditions: We do have a budget limit which is set to 150 USD, after rea...

I'm seeking a proficient Microsoft Word VBA expert. Your responsibility will be: - Automating repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is def...