Database vba jobs

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.

...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Pro...

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is extr...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track recor...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play ...

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

I am looking to get this done in two weeks. Please see the included specs and html wireframe layout before bidding. I need someone who is skilled in ASP.NET and experienced with mobile apps. I would rather have the app developed with cross-platform software but it will for now be used in iOS.

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.

I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding o...

...excessively time-consuming. We require a more efficient algorithm to enhance the speed and effectiveness of these exact match lookups. Project Objectives: Develop a Python script that can perform exact match lookups quickly and accurately. Ensure the integrity and accuracy of the lookups to maintain database cleanliness. Key Requirements: Efficiency: The algorithm must reduce the time complexity compared to the current linear search approach. Accuracy: As the script is intended for database cleaning, the precision of matching cannot be compromised. Ideal Candidate Profile: Proficient in Python, with a strong background in data processing and text analysis. Experience with efficient data search algorithms and possibly with text matching techniques. Ability to write clean...

The process is Visit Search for: Drainage companies Glazing repair Boiler repairs in London Open a google sheet and write the following in the sheet: Company name Website Officers name Establish the limited company name and visit Type in the company name and then go to officers and type the name of the officee on the spread sheet. Visit the website and go to the contact us page. Fill out the contact us page Name: Chris Number: Email Message: Hello (enter the name of the officer) I am the CEO of and I came across your business, we are an AI company for trades people and we are looking for a partner we can offer our Job booking AI tool to for free for a month, please can you send me your email and I will send over details for your review.

I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped ...customization should be advanced, allowing me to set up metrics and views according to my preferences. I'm looking for a skilled Excel expert who has experience in creating similar systems, particularly in the workshop or inventory management domain. You should be proficient in creating complex formulas and functions in Excel, as well as designing user-friendly interfaces and dashboards. Experience with VBA programming would also be a huge plus. Please provide examples of previous similar ...

I'm looking for an expert in data scraping to effectively extract text data from online databases. Primarily, I am interested in customer details. This data will be pivotal to my operations. Key tasks include but are not limited to: - Extracting textual data from specified online databases - Focusing on customer details during extraction - Organizing the extracted data in an easily accessible format The ideal candidate is proficient in data scraping and has a deep understanding of online databases. Proficiency in using tools and scripts for scraping is necessary. Previous experience with customer data extraction will be a plus. A rigid approach to data privacy and ethical scraping standards is imperative. Accuracy, efficiency, and detail-orientation are crucial skills for this posi...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

Project Title: Radiologist Database Creation for Victoria, Australia Project Description: I am looking for a skilled and creative freelancer to compile a comprehensive list of all radiologists currently working in Victoria, Australia. The goal is to create a detailed database that includes their names, contact information, and relevant professional details. Requirements: Research and Data Collection: The freelancer should be proficient in online research and data scraping. Identify reputable sources, databases, and directories where radiologist information can be found. Collect accurate and up-to-date details for each radiologist. Data Fields: Full Name Clinic/Hospital Name Clinic Address Phone Number Email Address (if available) Specialization (e.g., diagnostic radiolog...

...goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is essential. Thank you for your interest, and I look forwar...

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

VBA EXCEL Bulk SMS Template

I am looking for someone to help me create a comprehensive database of art galleries in Dallas, Texas. This will be used for market research purposes. Key Requirements: - The database should include the names, phone numbers, and email addresses of the art galleries. - For each entry, I also need the street address, city, state, and zip code to be included. Ideal Skills and Experience: - Prior experience in data collection and database creation would be highly valued. - Strong attention to detail is crucial to ensure accurate and complete information. - Familiarity with art-related databases would be a definite plus. The end goal is to have a well-organized, accurate and comprehensive database that can be used effectively for market research purposes.

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...