Word vba query sql database jobs
I'm in need of a professional who can convert my PDF files into Word format. The converted Word file should retain specific elements such as headers and footers, tables and charts, and images and graphics. Key Points: - Convert PDF files into Word format - Retain headers and footers, tables and charts, and images and graphics Ideal Skills and Experience: - Expertise in PDF to Word conversion - Proficient in Microsoft Word - Strong attention to detail - Ability to maintain the integrity of the original design and layout - Prior experience in prioritizing and maintaining specific elements during conversion - Efficient in handling short documents (less than 10 pages)
DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping
I need an experienced freelancer who's highly skilled in Microsoft Word formatting. The task involves formatting a short document of 1-10 pages to match the style of another document. Your main duty will be to change bulleted and numbered lists to resemble that of the document I'll provide. The hierarchical structure of these lists in the current document is similar to that of the reference document, making it a fairly straightforward project. Ideal candidates will have significant experience in content formatting, outstanding attention to detail, and a knack for preserving the integrity of document structures. Proficiency in using MS Word is a must.
Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks
I am in need of a highly skilled developer who can create a chatbot integrated with Zoho Desk for my employees. This ch...answering common FAQs. Given the type and nature of questions expected, an ideal candidate should: - Have experience in creating chatbots - Show familiarity with Zoho Desk API - Demonstrate ability to create bots that can answer technical support-related questions Understanding of the common issues faced in a technical support environment is a big plus, as the chatbot is intended to be primarily query-based. A well-defined and intelligent bot will not only improve our workflow but also help us resolve employee queries faster. That being said, I'm looking for someone who can deliver a chatbot which can accurately answer FAQs and improve overall operatio...
I'm in need of a professional who can help me edit a PDF document. I would like to make some text edits, add some new text, and also enhance the document with the addition of a few images. Ideal Skills: - Proficiency in PDF editing - Skilled in text addition and reformatting - Experienced in image editing and addition I already have the original document that was used to create the PDF, so you can make the required changes directly from the source file. I would prefer someone with a keen eye for detail and design, who can make the document visually appealing as well as functionally accurate. Please reach out if you're confident in your PDF editing and designing abilities.
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for acce...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...
I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.
I require a meticulous professional, experienced in the workings o...functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the softwar...
I need someone who is proficient in web development to help with passing query parameter string into the SEO title page in a dynamic manner. For example, this is the URL of the framer pager I would like help with: However, when I pass the URL into to check if the query parameter is being passed in the SEO title, it fails and doesn't update. I would like a Framer expert who is also proficient in coding to help me with this project.
I'm looking for a freelancer to convert a simple text PDF to a Word document. The key purpose of this conversion is to enable editing of the content in the Word document. Key requirements: - The PDF contains only simple text, no complex formatting, tables, or images. - The Word document should be in a standard format, making the content easily editable. The ideal candidate should have: - Proven experience in similar projects - Proficiency in PDF and Microsoft Word - Attention to detail to ensure accuracy in the conversion process Please include any relevant experience and examples of your work when applying.
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I'm looking for a professional who can perform a straightforward text extraction and formatting task. The job involves transforming a basic PDF document into a fully editable Word file, ensuring that all textual content is accurately transferred while keeping the original layout and formatting. Key Requirements: - The PDF document is solely text-based, without images, tables, or complex graphics. - You should be proficient in PDF to Word conversion, maintaining layout and formatting. If you're detail-oriented and have experience with similar tasks, I look forward to your proposal.
I'm in need of an expert server administrator with exte...Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk server administration, particularly in configuring and optimizing servers. - Strong troubleshooting abilities, particularly in resolving database query failures. - Ideally, experience in identifying and resolving security vulnerabiliti...
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Appl...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
I'm in search of a skilled video editor to work on my projects which are typically 5-10 minutes in length. Requirements: - Experience in Cinematic style video editing is desired. - Proficiency in various editing techniques such as color grading, slow motion, and animated text. - Ability to work on videos of 5-10 minutes. This role would suit someone with an eye for detail, creative flair, and a strong understanding of narrative structure. Please provide examples of your previous work that align with these requirements.
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should...
- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project
I want someone who can convert my pdf file to word file
Need a college B. Tech student who is studying and want to earn something.
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...
Need freshers who want his first job with good visibility.
...previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions rega...
I have handwritten notes that need to be entered into a Word document. Key Requirements: - Data Entry: The freelancer will be required to accurately transcribe the text data from the handwritten notes into a Word document. - Formatting: The data needs to be entered in a clear and organized manner, with appropriate paragraphing and alignment. Ideal Skills: - Proficiency in English: A good understanding of English language is necessary to ensure accurate transcription. - Typing Skills: Fast and accurate typing is essential to complete the task within a reasonable timeframe. - Attention to Detail: The ability to closely follow the source material and input the data with precision. - Microsoft Word: Familiarity with Word is important to ensure the data is entered...
### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commercial Platforms
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
Need freshers who want his first job with good visibility.
I'm looking for someone to convert my 1-10 page PDF document into a Word file. Here are the project specifics: - **Word File**: The final Word file should maintain the original formatting of the PDF. - **Content**: The PDF is text-only, with no images or graphics that need to be transferred to the Word document. The ideal candidate for this project should have: - Experience in PDF to Word conversions. - Proficiency in preserving original formatting during conversions. - Attention to detail to ensure all text is accurately transferred. Please bid if you're confident in handling this task with precision and meeting the formatting requirements.
I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual reports. ...
I need an experienced freelancer to convert 35 PDFs of workplace policies to Word. Key Tasks: - Conversion: These PDFs are under an old company name; I need these PDFs converted to Word documents, maintaining the standard business formatting. - Editing: I then need the old company name to be replaced with the new company name throughout the text and in the footer. This includes ensuring that all references to the old company name are replaced in the text. Requirements: - Proficiency in PDF to Word conversion and editing. - Strong attention to detail to ensure all instances of the old company name are replaced with the new company name. - Knowledge of standard business formatting in Word. - Experience in updating large numbers of documents would be beneficial.
We seek an Excel expert with experience in developing Bill of Materials (BOM) and I... - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow easy expansion for adding new sales data, inventory items, saved BOMs, assemblies, types or categories. **Skills Required:** - Demonstrated experience in BOM and Inventory system development. - Advanced Excel Macros and VBA skills. - An analytical approach with a focus on delivering simple and functional solutions. Candidates are encouraged to share examples of previous similar projects. This project aims to deliver a straightforward solution that supports our small home business operations effectively. Budget: Maximum o...
...experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this r...
I'm looking for a skilled professional to convert a simple Word document into a PowerPoint presentation. The key details of the project are as follows: - **Software Preference:** The conversion needs to be carried out using Microsoft PowerPoint. - **Formatting Consistency:** It's crucial that the converted presentation maintains the same formatting as the original Word document. This includes text style, layout, and image placement. Ideal candidates should have experience and skills in: - Proficiency with Microsoft PowerPoint - Strong attention to detail and consistency - Understanding of preserving formatting across different software The content of the Word document is straightforward, comprising of simple text and images. If you have a good eye for de...
...into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm l...
I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no expe...
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...
I'm looking for a professional and corporate style. I need someone to format my plan document. I'm looking to transform a standard word document into a visually appealing, professional and corporate format. Ideal Skills and Experience: - Proficiency in Microsoft Word - Experience in document formatting - Understanding of professional and corporate design aesthetics - Attention to detail and ability to follow specific guidelines
I am looking for an experienced writer to produce a 2500-word essay on a technology-related topic. Although no specific sources or references have been provided, you should be well-versed in proper citation and have a strong analytical approach to research. Your work should be original, well-structured, and engaging. Ideal Skills and Experience: - Proven experience in academic writing, particularly essays - Strong understanding of technology topics - Excellent research and analytical skills - Familiarity with proper citation and references in academic writing - Ability to deliver engaging and well-structured content
I'm in need of an experienced developer who can build a completely custom database website that primarily serves as a customer relationship management (CRM) tool. In addition to the standard CRM functionalities, I'm looking for the following: - Expertise in complex Java and YAML scripting - Ability to create custom database scripts - Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong...
in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...
I need a skilled professional who can transcribe my scanned Arabic PDF document into a Word document. Key Requirements: - The PDF is scanned, and the freelancer should have experience in converting scanned documents to text. - Arabic language proficiency is a must for accurate transcription of the text. - The final Word document should be in the exact same format as the original PDF. - No images or charts need to be included, so the project is focused on text transcription. Ideal Skills: - Expertise in Arabic language - Proficiency in OCR software for scanned PDFs - Proficient in Microsoft Word - Attention to detail for an exact format replication.
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...
The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the number of page and first Heading on the
