Database vbacông việc

...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...

...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...

...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...

...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...

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