Database vba jobs

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks depending on the initi...

I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.

I'm seeking a skilled PHP developer with sound knowledge in Javascript to handle a unique assignment. It involves integrating a database and implementing specific user interaction elements including retrieving and showing images on the website. Skills and Expertise required: - PHP for back-end development - Javascript for front end development, focusing on user interaction - Proficiency in retrieving and showing images online - Experience in database integration Though no specific frameworks are required, familiarities with Laravel, jQuery, or React.js are a plus.

The task involves loading multiple large data files into a database. These files, approximately 15GB each and in various formats like CSV, .db, .sql, etc., add up to an estimated dataset size of 1-2 TB. Preference is given to keeping the data locally on the machine, thus ruling out cloud storage solutions. The task entails consolidating and organizing fragmented files into a suitable database, whether it's a relational database or non-relational database. Initially, attempting the task with MySQL or any SQL databases is preferred. However, exploration of whether a NoSQL solution is suitable for handling such big data is also required.

As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal ...of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs, I'...

This project is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at w...level details will be copied to the asset table when the order is confirmed. Bring up a print screen Send pdf of the sale order if a customer email is available. Administration Need Log-in and user management and security protocols based on used profile. Sample data will be provided to help with the development and testing efforts. Open Questions as this stage: Saving pictures of the product. Database management tools (backup, compa...

I need someone to help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categori...help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categorize and label data as per our requirements. - Maintain data confidentiality and security. Ideal skills and experience for this job: - Proficiency in data entry. - Prior experience with database entry preferred. - Meticulous attention to detail. - Ability to work efficiently and maintain accuracy. - Understanding of data security and confidentiality...

I'm in urgent need of a skilled C# developer to integrate a database into my application. The project needs to be completed as soon as possible. Key Requirements: - Database Integration: The most critical aspect of this project is the seamless integration of a database into the application. All data should be accurately stored and retrieved from the database. - Timely Delivery: The urgency of this project requires a developer who can deliver high-quality work quickly. Ideal Skills and Experience: - Proficient in C#: A solid understanding of C# programming language is essential for this task. - Database Management: Experience in integrating databases into C# applications is a must. - Quick Turnaround: Previous experience in delivering urgent projec...

I'm looking for an excel expert to help build and format an advanced product database for the services industry. I already have an existing excel spreadsheet with many items already programmed so this will just be added on. This will revolve around three main components: -Product database containing items -Drop down menu to insert products from database -Custom Graph A strong working knowledge of Excel features, particularly Pivot tables, VLOOKUP function and conditional formatting is a necessity. It would be ideal if you also have experience in data management for the services industry. Your expertise will enable the creation of an effectively organized and easy-to-manage database.

I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am looking to identify all nutritionists, gut health professionals and dietitians on instragram+tiktok that MUST be Australian based accounts with over 5000 followers. I need thier account name, and email address.

Add backup functionality to firebase and make simple design changes to flutter app.

I'm looking for an experienced programmer who can develop a WhatsApp bot: Please go through each point and give brief explanation on how you will achieve this. 1) I have data in access db format. 2) I want a whatsapp bot which can access this database and reply to the message automatically after searching the database . While there's no mandatory requirement for a specific programming language or framework, an expert understanding of chatbot technologies and experience in creating instant messaging bots would be a great bonus. The successful candidate will need to interpret my project goals into a working bot, therefore excellent communication and understanding are key. To meet my urgent need for this function, I need the project completed as soon as possible. P...

I'm looking to create a straightforward and minimalist online clothing webstore, complete with a database that's setup in the 3rd normal form. The database needs to be designed to utilize at least 2 PL/SQL commands. While the site will carry a simple, generic design, it won't require any login/signup feature for customers. Some of the essential skills and experience for the job include: - Proficiency in database design, particularly with establishing a database in the 3rd normal form. - Experience with executing PL/SQL commands. - Ability to create a minimalistic and generic web design. - Experience in creating online stores, specifically clothing stores, would immensely be helpful.

...skilled C# developer who can help with database integration, specifically using SQL Server. Key Requirements: - Database Integration: You will be expected to integrate SQL Server into our existing C# application. This will involve working with database tables, writing queries, and ensuring data is accurately and securely stored and retrieved. - Experience: I'm looking for someone with a strong background in C# development and a proven track record of successful database integration projects. Ideal Skills: - Strong C# Development skills - Proficient in SQL Server - Experience in database integration - Ability to write efficient and secure queries - Good communication skills This is a great opportunity for a talented C# developer to put their ...

I need someone to help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categori...help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categorize and label data as per our requirements. - Maintain data confidentiality and security. Ideal skills and experience for this job: - Proficiency in data entry. - Prior experience with database entry preferred. - Meticulous attention to detail. - Ability to work efficiently and maintain accuracy. - Understanding of data security and confidentiality...

Need a web-based database for businesses to register, visualize and search. Features: • Super admin can access, edit all the data and setting the site name, footer and logo, can create users. • Admin user can access all the data. • User based on District: can only access and edit only District records. • Integrate mail box/chat to registered business email (text and attachment). • Expire date notification: one month before notification warning/alert and email to registered business email and warning list in dashboard. • Dashboard/chart widget to embed in public website. Dashboard • Total registered business (number) and pie chart by Business status: (Ativa, Suspensaun) • Total registered business (number) and pie chart by Gender/Sex: (Feto,...

I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel

This is a Yii2 that has 90,000 screens as each page is 3 screens. We need a stable platform to use the processes coded in Html and java to update the databases. We need to keep the PHP version current. We need the new database documented page by page and process by process. There are 2 sites An individuals site. It has these services Member Services Act as an Agent for WebPicID Family-Protection-Service Identity theft fraud loss reduction Membership Merchant Membership Notification Payment Options Refer an organisation to sign up with WebPicID Safe Purchase Secure Message Merchant Services Identity Theft Fraud Loss Reduction WebPicID can Reduce ID Theft Fraud Losses and associated operating costs by at least 50%. WebPicID detects the ID Theft after the sale is paid for; befor...

I am in need of an expert database developer to create a relational database primarily for reaching out and making sales calls. The central idea is to increase efficacy and organization in our processes. Key responsibilities will include: - Developing a relational database. - Integrating it with our existing system. - Making sure it stores key information vital for sales calls, specifically contact details. Ideal candidate should: - Be experienced with creating and managing relational databases. - Understand the specific needs of a sales-focused system. - Possess problem-solving skills and an attention to detail. - Display proactive communication to understand and meet my project needs effectively. Previous experience with sales CRM or databases will be a signifi...

I'm in need of an experienced PHP developer who can get two small websites up and running. They are both basic, and will need secure coding. First is a confession site built in PHP 7. Most of it works. So far I see that it won’t post the confessions or comments to the database. Also there are problems when logging into the accounts. I also, want to get 2 new features added which is give me the option in the admin section to chose between the current CAPTCHA, or choose to use Cloudflare's Turnstile CAPTCHA. Second there i a ban words feature for confessions, I'd like it if those ban words also applied to the comments. The second site is a one page daily link sites that also breaks in PHPv8.2 The key requirement is that the sites need to be developed using PH...

Require a form that submits the form data in a mySQL database table. Once the form is completed and submitted it should email the user a PDF certificate that includes all the information submitted in the form. The certificate should also display the end of warranty date which is one year from the purchased date entered in the form. If possible the emailed pdf should have a QR code that contains all the information submitted in the form.

I'm looking to have a realtime database created which would serve the sole purpose of storing and retrieving user profile data in real-time. The operation speed should be top notch, with the least possible delays in data retrieval. Key Requirements: - Experience in designing realtime databases - Expert knowledge of user profile data handling - Basic user authentication implementation for accessing the database Data security is of utmost importance. The developer will be required to include basic user authentication to ensure that access to the data is controlled and secured. The right freelancer will have prior experience in creating similar databases and be able to demonstrate a good understanding of user profile data handling and data security.

I'm looking to integrate real-time Firebase database functionality into my existing Django application specifically for capturing and storing transaction records. Key Project Requirements: - Expertise in Django and real-time Firebase integration - Experience in handling transactional data Transactional Record Components: The transaction records to be stored should include a unique identifier that I refer to as 'Lab bacterias'. Your task would include creating an efficient way to store and retrieve this particular information. If you have experience building out similar database integrations, please feel free to bid with your proposed timeline and rate. A successful project execution will likely lead to additional phases of development on the same applicat...

I am in immediate need of a freelancer skilled in VBA & .net for the development of a yet disclosed project. The ideal candidate must be proficient in all aspects of VBA and have the ability to deliver quickly given the urgency of this project. Key Requirements Include: - An in-depth understanding of VBA - Proven track record of successful projects - Ability to work under tight deadlines Completion of the project needs to be as soon as possible. If you have extensive VBA experience and can work in a fast-paced environment, I enthusiastically encourage you to bid on this project.

...and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previ...

I'm looking for a skilled professional to install and configure Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c on a Windows Server 2022. The primary purpose of this installation is managing databases, so the main focus should be on optimal database functionality. Key Tasks: - Installation of Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Configuring Oracle DB with a high availability setup and performance tuning - Setting Windows environment variables for Java files - Copying 3 applications and 3 URLs from another server running Windows Server 2012 Ideal Skills and Experience: - Proven experience with Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Strong background in managing databases...

I need a freelancer who can assist me with moving data from Excel to an Oracle database. Responsibilities: - Copy data accurately from Excel to the database - Ensure all data is consistent and properly formatted Ideal Skills and Experience: - Proficiency in Excel - Experience with Oracle databases - Detail-oriented - Proven track record handling data migration tasks

I'm in need of a professional who's seasoned in Oddo database upgrade. The task involves updating my Oddo database from its current version 14 to 17. - Updating the current version to the latest one with all data carried over ** Please provide some proven exprinance on this area **

I am currently using MySQL as my database management system which holds a small-sized database. I require an experienced and skilled freelancer to migrate this database to my new EC2 WordPress installation. Ideal Skills and Experience: - Expertise in MySQL and AWS EC2 - Proficiency in handling WordPress installations - Experience in migrating small-sized databases Please note that a backup of the current database is available and must be effectively utilized to perform this project. Expectations include high-quality work with no loss of database data and minimal interruption in service.

...automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if f...

I'm looking for an AWS Glue expert to handle my large MySQL database, over 10GB, and write it to S3. You will need to have: - A strong understanding and experience in handling large databases. - Proficiency in using AWS Glue for data ETL processes. - Knowledge in determining the best strategy to quickly load large amounts of data. - Experience working with Parquet output format. The database gets updated daily, so a fast and efficient process is required to ensure optimal performance. Please detail your experience with similar projects when making your bid.

As the client, I am looking for an AI-powered scraper engine and database that can efficiently collect data from global small business listings. The project's focus will be on PitchBook Data primarily, and secondary sources may include Crunch Base and CB Insights. Key Requirements: 1. Data Extraction: The scraper should collect information such as Revenue, EBITDA, net profits along with contact information including email, LinkedIn profile and website. 2. Designing AI Database: A smart AI database should be constructed to filter and predict the Revenue, EBITDA, net profits. 3. Prioritization: Initially, the focus should be on extracting data from PitchBook Data. Though, it would be beneficial to later expand this to other platforms such as Crunch Base, and CB Ins...

1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.

I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and accuracy.

We are Creating a Searchable Product database for our products. DPX

I require a data expert to design and implement a comprehensive database system for my hospital. The project will include: - Patient Database: A system to manage patient registration, track medical history, and schedule appointments. - Medical Records Database: This should integrate with lab results, allow attachment of files such as test reports, and provide a robust search functionality. - Inventory Database: Tracking of medical supplies, equipment, and medicine inventory. The ideal freelancer should have a strong background in database design, preferably within healthcare environments. Knowledge in data privacy regulations in healthcare is essential. Exceptional attention to detail and a problem-solving mindset are also required.

...dependable freelancer to establish and maintain an email database for my monthly marketing campaigns. My small business, based in London, UK, caters to estate agents, necessitating the creation of a comprehensive lead database for email marketing purposes. Key Responsibilities: Set up and manage an Excel spreadsheet for the email database Regularly update the email database with new leads and modifications on a monthly basis Ensure the accuracy and integrity of data entries in the database Ideal Candidate: Proficiency in Excel and Microsoft Office suite Previous experience in email database management Meticulous attention to detail to uphold the accuracy of the database Proactive and capable of working independently to conduct monthly ...

I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid

I need a refined and comprehensive database of the customers who submit a query on Car Dekho. My primary purpose is to conduct market research and analysis. Requirements: - The details I need are their full name and contact number. Please omit any other personal or private details. - This data should be provided in a CSV file format, which will be easy to import for various kinds of analysis. Ideal Candidate: - Expertise in data mining and extraction - Proven track record in collecting accurate, high-quality data - Familiarity with the automotive industry is a plus - Strict adherence to data privacy laws - Extensive experience with CSV files and data formatting.

...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...

...am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challenges involve: - Slow database performance. - High CPU usage rate. - Regular timeouts and deadlock situations. The size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performa...

I'm seeking a talented developer to assist in setting up and managing a database system using Anaconda. The key features I require are Jupyter Notebook and Conda virtual environments. The primary use of this system will be for data analysis and visualization. I'm looking for someone with excellent knowledge of data analysis tools and techniques, as well as experience working with Anaconda. Ideal skills and experience for the job: - Proficiency in database management using Anaconda - Expertise in data analysis and visualization - Knowledge of setting up and managing Jupyter Notebook and Conda virtual environments - Experience in data analysis and visualization projects

In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purp...

I'm seeking a proficient database developer to construct an online database using MS Access. This database will primarily store and manage our transaction history. Key Responsibilities: - Implement a MS Access Online database solution - Store and manage transaction data - Generate basic reports upon request Ideal Skills: - Extensive experience with MS Access database development - Knowledge in transaction data management - Ability to create basic level reports. This project will require a clear understanding of SQL and best practices for organizing and storing transactional data. For those interested, please ensure you have relevant qualifications and proven experience in this area.

I am currently working on a comprehensive 3D model for the architectural project of an eight-semester database center. a freelancer with a solid grasp of architectural design, SketchUp model making, and material. Experience with data center designs would be beneficial as well. attached is the plan, the attached plan is not refined it will be refined and then the work has to be started. there are four-floor plans and the 3 and 4th plans are the same. work is to create a SketchUp model with material in it. and site trees and hills texture to give the effect of surroundings Skills and experiences: - Proficient in architectural 3D modeling - knowledge of SketchUp and materials - Ability to deliver quality work within a month, model with material should be delivered by 15 May 24. Pl...

I am in need of a freelancer to help with copy typing from online databases. - I need the data to be copied accurately from these online databases to a specific format. - The entries are in text format, so you would need to have good typing skills and attention to detail. Ideal Skills: - Proficient in typing and data entry - Experience with online databases - Detail-oriented and accurate in data entry.

I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding - Strong unders...

I need a Python expert to perform data analysis on my database. Key Requirements: - Proficiency in Python: You should be well-versed in Python and its data analysis libraries such as Pandas and NumPy. - Database Management Skill: Experience with database systems would be helpful as the data is stored there. - Data Analysis Expertise: You should have a strong background in data analysis to make meaningful insights and reports from the database. Please note that the database management system is not specified, so you should have a good understanding of different database systems, preferably MySQL, MongoDB, or PostgreSQL. Your ability to work with different systems and extract relevant data will be crucial.