Microsoft word vba sql database일자리

새 프로젝트의 번역가를 찾고 있습니다! 요구사항: - 영어 - 한국어 번역가; - 한국어 모국어 - ...

The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.

VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화

php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대

한글 논문 교열 및 영문화 (MS word 700자) 공학계열 논문의 2장 - 문헌연구에 대한 작성분입니다. 작성된 내용을 국문 교정/교열 과정을 거쳐 논문을 충분히 이해하신 후 영문화에 들어갔으면 합니다. 국문 교열 편집 경험이 있으신 bilingual 한 분이면 좋겠습니다. leesungwook[at]cau[dot]ac[dot]kr로 연락주시면 감사하겠습니다.

한글 논문 교열 및 영문화 (MS word 700자) 공학계열 논문의 2장 - 문헌연구에 대한 작성분입니다. 작성된 내용을 국문 교정/교열 과정을 거쳐 논문을 충분히 이해하신 후 영문화에 들어갔으면 합니다. 국문 교열 편집 경험이 있으신 bilingual 한 분이면 좋겠습니다. leesungwook[at]cau[dot]ac[dot]kr로 연락주시면 감사하겠습니다.

Im looking to update a MySql database used for CRM I need to fix some funytions on what I have and add a new PIPELINE dashboard please chec documentation, is very clear

...checks 5. Cryptocurrency Integration ? Support for major cryptocurrencies Crypto wallet integration Crypto-to-fiat conversion Transaction verification system Smart contract integration (optional) 6. Database Migration ? Migrate to PostgreSQL Implement database optimization Set up proper indexing Create backup systems Implement data archiving 7. Advanced Features ? Inspired by reference sites: Price alerts system Market analytics User reputation system Automated escrow system Trade insurance system Referral program Loyalty rewards system 8. Performance Optimization ? Implement caching Optimize database queries Add load balancing Implement CDN for static assets API optimization 9. Mobile Responsiveness ? Enhance mobile UI/UX Implement progressive web app (PWA) Add mob...

...with relational database data, specifically on SQL Server. - The primary goal is to reduce the execution time of this method. - You will be required to assess the load via concurrent requests. Additional Notes: - This is a remote job. No code sharing will occur. Therefore, you must be comfortable working via a remote connection and using any necessary tool. - The task is a quick fix and shouldn't take more than an hour. Please don't overquote, as I will pay per hour within the range of $10-15. - Only individual freelancers will be considered, agencies will not be entertained. Ideal Skills: - Extensive experience with C#, ASP.NET MVC, IIS, and Entity Framework - Strong knowledge of LINQ query generation - Proficient in assessing and handling concurrency - Famili...

I have a PDF typing project that primarily involves transcribing text documents into Word. The main content comes from academic papers that need to be faithfully replicated. The ideal freelancer for this project should: - Have excellent typing skills with high attention to detail. - Be able to accurately transcribe text from PDFs into Word documents. - Have experience working with academic texts. - Be proficient with Microsoft Word.

...control. - Functional controls. - Activate/deactivate some hardware functions and settings. - Manage WIFI connection between app/phone/hardware. - App should have photo/video controls: take photo, start/stop video, rapid burst photos, zoom/in out. - Editing capabilities – similar features to those on the iPhone. - Allow for storage of files on device or cloud-based services. - Work with Google/Microsoft/OneDrive/Dropbox. - Replicate all button functions from hardware onto the APP to allow a second person to control the device remotely (via the APP)....

I'm looking for a programmer with high knowledge of SQL, Access, and ChatGPT to automate our document management processes using n8n. This involves organizing all of our company's documentation into folders automatically based on labels. Key Requirements: - Proficient in n8n for process automation - High level of expertise in SQL and Access - Familiarity with ChatGPT for potential integration - Experience in document management systems - Capable of creating a system for organizing documents by department (Sales and Marketing, HR and Administration, IT and Operations)

I'm in need of an IT technician with specific expertise in troubleshooting software, particularly Microsoft Outlook and Teams. Key requirements: - Diagnose and fix installation problems - Solve connectivity issues - Improve performance problems Ideal Skills: - Extensive experience with Microsoft software - Proven track record in software troubleshooting - Strong problem-solving skills

I'm in need of professional Excel templates tailored for the construction industry. These will be specifically for quotations and invoic...quotations and invoices. Key Requirements: - The templates must include: - Client details and project scope - A breakdown of material and labor costs - Payment terms and due dates - The templates should be visually appealing and aligned with our brand: - Incorporating our company logo and branding colors - Special layout and design elements Ideal Skills and Experience: - Proficient in Microsoft Excel with a strong understanding of template design - Previous experience in the construction industry is a plus - Graphic design skills to ensure a professional and appealing layout - Attention to detail to ensure all necessary informat...

I'm in need of a service that...English to international military students. These words will be provided by me in sections. I have attached an PowerPoint example for section 7.1. Key Requirements: - Ability to source or create suitable images for each word. Any type of image is acceptable (stock images, custom illustrations, etc.) just as long as it appropriately represents the word. Preferably realistic. ChatGPT works. - Strong understanding of language to craft clear, concise definitions and example sentences. - Creativity and resourcefulness in finding or creating engaging and relevant images for each word. Ideal Skills: - Proficient in English with a strong grasp of vocabulary. - Experience in sourcing images or creating visual content. - Able to meet dead...

I'm looking for an experienced developer who can integrate my Python-based desktop application with Microsoft Active Directory (AD). The integration should support user authentication and user role management. Key Requirements: - Proficiency in Python, particularly in building and modifying desktop applications - In-depth understanding and experience with Microsoft Active Directory - Skills in implementing user authentication and user role management - Prior experience in similar projects would be a plus Please ensure your bid reflects your ability to meet these requirements and your experience with similar projects.

I have an existing ERP system utilizing MS SQL as the database engine and Microsoft Access as the frontend. We're looking to transition this to a web application built on ASP.NET. This will be a phased migration, implementing functionalities from the old frontend to the new one step by step. The first task in this migration is to rebuild the picking system, which is responsible for preparing orders from the warehouse. The current picking system includes: - Inventory Management: Keeping track of stock levels and warehouse layout. - Barcode Scanning: Utilizing barcodes for tracking items and improving efficiency. In terms of user authentication, we prefer a standard Username and Password system for the new application. As for user roles and permissions, we will ...

...Design and deliver comprehensive training programs on Microsoft Azure data services, including Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. Develop course materials, hands-on labs, and tutorials tailored to various skill levels. Stay updated with the latest Azure data engineering developments to keep training content current. Assess learners' knowledge and provide constructive feedback to facilitate improvement. Offer individualized mentorship to address learners' specific needs. Prepare learners for certifications, such as Microsoft Azure Data Engineer Associate. Candidate Qualifications: Proven experience as an Azure Data Engineer or in a similar role. Proficiency in Azure data services like Azure SQL...

I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.

I am looking for an expert in Elastic Search or TypeSense to improve the search functionality within my database. The primary goal of this project is to enhance the way we search through our database records. Key Requirements: - Deep knowledge and experience with Elastic Search or TypeSense. - Proven track record of improving search functionality within databases. - Ability to understand and work with database records. - Strong problem-solving skills and attention to detail. Ideal Skills: - Elastic Search - TypeSense - SQL - Database Management - Search Functionality Improvement Your expertise will play a key role in making our database search more efficient and effective. Looking forward to your insightful proposals.

I'm looking for a freelancer who can create a corporate-styled, editable invoice in PDF format for me. The invoice should include: - My company logo and contact information - An itemized list of products/services - Clear payment terms and due date The design should be professional and in line with corporate styling, rather than min...create a corporate-styled, editable invoice in PDF format for me. The invoice should include: - My company logo and contact information - An itemized list of products/services - Clear payment terms and due date The design should be professional and in line with corporate styling, rather than minimalist or overly creative. The invoice needs to be editable in software other than Adobe Acrobat or Microsoft Word, so it should be compatible w...

...installed Microphones with high-quality audio High-speed, password protected internet connection. Performing work over an open wireless network connection is NOT allowed If you will be recording with your partner virtually and need to use the client’s recording platform, you must meet the following requirements: Operating system: Windows 7 or higher, macOS Big Sur or higher Browser: Google Chrome or Microsoft Edge. Recommended: CPU with 4 or more cores. At least 5 GB free space on your system, an internet connection with 10 Mbps or better download, and 5 Mbps or better upload. Technical Requirements for submitted recordings File Type: Unprocessed, RAW .wav (24 bit, 48 kHz, stereo) Stereo Recording: One voice panned to Left channel, other panned to Right channel Noise Floor...

Hello, I am seeking a skilled freelancer to assist with the repair and import of a corrupted SQL Server file. Here's the situation: I accidentally deleted both the MDF and BAK files from our disk, and unfortunately, the file structure cannot be recreated. Using a hexadecimal editor, I managed to locate four MDF files, but I am uncertain which one contains the correct data. After some repairs, I believe one file might have the data I need. My primary interest is in recovering data from a specific period, which I couldn't retrieve using automated repair methods. Due to the size of the file, I require you to work directly on our system remotely.

I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained and linked to the same DB, but

I'm seeking a skilled SQL developer with a deep understanding of manufacturing business logic, specifically in production scheduling within the chip industry. Your role will involve: - Assisting in the creation of a production scheduling system aimed at optimizing resource usage, primarily raw materials and machinery. - Providing guidance based on your knowledge of the chip manufacturing business. Ideal candidates will have substantial experience in SQL development and a strong background in the manufacturing sector, particularly with chip production. Your expertise will be pivotal in enhancing the efficiency of our operations.

I need a freelancer to transcribe a PDF document, which is a literary text in Arabic, into a Word document. The transcriber needs to maintain the original formatting of the PDF document in the Word file. The task involves only the text, as there are no images or diagrams to be included. Ideal skills and experience for the job: - Proficiency in Arabic, both spoken and written - Excellent typing skills - Familiarity with Microsoft Word and its formatting options - Detail-oriented, able to maintain original formatting - Previous experience in transcribing literary texts would be a plus.

I'm seeking a skilled writer with a strong understanding of military operations and training programs to assist in drafting a 1,500 - 2,000 word journal article. The article will argue for a significant change in the current utilization format of the Army's 150U Warrant Officers, advocating for the implementation of an Uncrewed Aircraft System (UAS) training program and utilization similar to that of the USAF. Must be in word format., and reference all sources used. No preferred sourcing format. Key Focus: The article should primarily emphasize how such a shift could enhance 'Strategic Flexibility through Modernization'. Source Inclusion: The piece will predominantly reference 'Military reports and documents', so familiarity with these sourc...

I need an exp...Ticket email fetching and alert issues. Key Requirements: - Implement email notifications for new tickets and ticket responses. - Fix authentication issues with Microsoft 365 and Zeptomail. - Ensure outgoing SMTP is operational. Current Situation: - New ticket alerts and ticket response notifications need to be set up. - Encountering 'Authentication Failed' error when connecting to email services. - Troubleshooting steps taken: credentials have been checked and re-entered, email server settings updated, and Microsoft documentation consulted. Ideal Skills: - Previous experience with OS Ticket System. - Proficient in configuring Microsoft 365 for IMAP, POP3, and SMTP. - Familiar with Zeptomail configuration. - CPanel management experience. -...

BACKROUND​ What is it?​ We are creating a simple brochure website to show potential clients a demo of a ‘white label’ example to be deployed on client sites​. The website will demo a simple project portfolio tracking solution using the Microsoft suite (Sharepoint and PowerBI)​. ​What does it do​? Give prospects / clients a visual reference on how to simply manage their project portfolio​ ​ What this isn't​: A Project Management application​ A Resource Management solution​ Scheduling and Project Time Management solution​ Finance and Project Cost Management solution Job Brief Create a logo and color palette for ​ We would like to incorporate the 'triangle/play button' into the Logo as per the example logos attached. Create simple landing page concept. *Us...

I need assistance with a Windows 10 .exe file that runs an Access database. The executable file is experiencing startup issues and needs debugging. The main purpose of this project is to understand the software behavior, so a keen eye for detail and strong analytical skills are crucial. Key Responsibilities: - Debug the .exe file to identify the cause of the startup issues - Study the compiled software to understand its behavior - Implement necessary fixes to enable smooth startup of the executable file Ideal Skills and Experience: - Extensive experience with Windows 10 .exe files - Proficiency in working with Access databases - Strong debugging skills - Excellent understanding of software behavior - Ability to implement effective solutions to technical issues

I'm in need of a Power BI dashboard designed specifically for monitoring operational efficiency, with a focus on resource utilization. The dashboard needs to connect to a SQL database for data retrieval and analysis. Key Requirements: - Design a Power BI dashboard tailored for operational efficiency monitoring - Focus on tracking resource utilization metrics - Connect and retrieve data from a SQL database Ideal Skills and Experience: - Proficient in Power BI - Experience in designing operational efficiency dashboards - Familiarity with SQL database Please provide examples of similar projects you've completed, along with your proposed timeline for delivering this dashboard.

I need assistance with a simple yet critical task involving two Excel files. The project involves copying data from the L Block excel schedule into the 2-week look ahead file. ...Important Notes: - Both files already contain the required dates, so no additional dates need to be added. - It is crucial to maintain the same formatting as in the L Block file; do not alter the format of the dates in the 2-week look ahead file. - Rows 6 to 18 in the 2-week look ahead file are hidden; do not unhide them during the copying process. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly skilled in copy-pasting tasks. - Strong attention to detail to ensure all dates and vendor information match accurately. - Previous experience with data verification tasks will be highly...

I'm looking for someone to convert an 11-page "client onboarding form" from Word into a fillable PDF. The PDF will need to include text fields and checkboxes, but it does not need any e-signature capability or advanced interactive features like dropdowns and validations. Ideal skills and experience: - Proficiency in Adobe Acrobat or similar software - Attention to detail to ensure the PDF matches the original Word document - Ability to create a user-friendly, fillable PDF format

I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query optimization

I have a handwritten document that needs to be typed up into a Word document. I have provided the document images attached with this project invite. Ideal skills and experience include: - Proficient in English language - Excellent attention to detail - Familiarity with Microsoft Word - Proficient in English grammar and spelling (very important) There must be no spelling errors and the handwritten document must be copied carefully. The attached images are number (1) to (5) on the top corners in small writing. The document must follow in the order of 1,2,3,4,5.

Job Description: We are seeking a skilled and reliable WordPress developer to rebuild our existing 5-page HTML website, , into a modern, responsive, and user-friendly WordPress site. This project requires someone with a strong eye for design and attention to detail, as the website represents an artist's portfolio. This job has the potential to lead to ongoing projects as a trusted vendor for my company, which specializes in printing, design, and promotional items. Key Responsibilities: 1. Rebuild the current HTML website in WordPress. You can see the site at: o Maintain the existing site structure and design aesthetic. o Ensure responsiveness for desktop, tablet, and mobile devices. 2. Implement SEO best practices for faster page loading and improved search rankings. 3. Inc...

I'm looking for an expert in Microsoft Access who can create a tailored database for managing customer information. The primary focus of this database is capturing and organizing individual customer contact details and their service history. Key Requirements: - Create a user-friendly Microsoft Access database - Capture individual customer contact details - Track and manage customer service history Skills & Experience: - Proficient in Microsoft Access - Experienced in database design and development - Knowledge in customer information management systems - Attention to detail and strong organizational skills

Project Title: Data Entry Specialist Project Description: We are seeking a highly accurate...validation tasks, including identifying and correcting errors. * Maintain data integrity and accuracy throughout the data entry process. * Follow specific instructions and guidelines for each project. * Meet deadlines and maintain a high level of productivity. Qualifications: * Excellent typing speed and accuracy * Strong attention to detail and the ability to identify errors. * Proficiency in Microsoft Excel and other data entry software. * Excellent communication and organizational skills. * Ability to work independently and as part of a team. * Strong work ethic and commitment to deadlines. Deliverables: * Clean, accurate, and validated data sets. * Regular progress reports an...

I'm looking for a skilled application tester based out of Jamaica to help me with my web application. Your main focus will be assessing the functionality of the application. The testing needs to be conducted primarily on Google Chrome and Microsoft Edge, so familiarity with these browsers is a must. Ideal Skills and Experience - Proven experience in web application testing, specifically in assessing functionality - Proficient in using Google Chrome and Microsoft Edge - Excellent attention to detail and problem-solving skills - Strong communication skills to provide feedback and suggestions

Write code to retreive data from SQL Server and other apps

100 videos for CAD $200 Project budget is fixed. Please no placeholder bids. I am only looking for Beginner skill resource who can create step by step SharePoint training videos - either from existing older videos or generate videos based on sample videos. This task is ideal for someone with beginner skills and looking for his or her first project. If you have advanced SharePoint skills then the budget might not work for you. I need training videos made for my SharePoint Online platform. I want a series of instructional videos that cover fundamental tasks in SharePoint, and also demonstrate best practices. The project price described is not per video but rather series of small videos. Topics will be provided. 1. Describe what type of screen capture software you will use. Should be c...

I have handwritten notes for my life story that need to be transcribed into a Microsoft Word document. The project consists of 10 pages of text that require standard formatting (headings, paragraphs). Key Requirements: - Typing: You should have excellent typing skills, as the project may take up to 4 hours. - Microsoft Word: Proficiency in Microsoft Word is essential, as the final document needs to be in this format. - Formatting: Basic standard text formatting is required. - Font: The document should be typed in Times New Roman. I am looking for a freelancer who can deliver a neat and properly formatted document. If you have experience with transcription and typing, I'd love to hear from you.

I am in need of a large scale database primarily storing financial records. The database should incorporate role-based access control to ensure security and proper data management. Key Requirements: - Design and implement a large scale database. - Primarily focused on storing and managing financial records. - Incorporate role-based access control into the database. Ideal Skills and Experience: - Extensive experience in database design and management, particularly with financial records. - Expertise in implementing robust access control systems. - Proven track record of creating large scale databases.

...S3. • SQL databases for financial transactions. 3. Backups: • Daily and weekly data backups. Integration and Flexibility: 1. Integration with Platforms: • WooCommerce, Shopify, Magento. And all online stores • Connecting using API and Keys. 2. User Interface: • Comprehensive analytics interface to monitor sales. • Display data on web and mobile applications. • Dark Mode. Additional features: • Classification of transactions according to risk levels. 2. Alerts and notifications: • Instant mobile notifications. • Login alerts from new locations with display of connected devices. 3. Innovative features: • Payment using NFC. • Support for virtual currencies for payment. • OCR for document verification. Target groups...

I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms

I'm seeking a seasoned Power BI professional to craft a thorough sales performance report. Key Responsibilities: - Extract data from SQL databases to analyze sales performance - Create a variety of visual representations of the sales data - Compile detailed tables for in-depth data breakdowns Ideal Candidate: - Proficient in Power BI and SQL - Skilled in creating comprehensive and insightful reports - Strong background in data analysis and visualization, particularly in sales Please note, specific sales metrics and types of visualizations will be discussed in detail with the selected freelancer. The frequency of report updates will also be determined at that time.

I'm in need of an expert in Microsoft Visio who can assist me with creating floor plans and other drawings. I have specific standards/templates that will be provided, but the ideal candidate will be proficient in Visio and capable of creating a new template for drawing floor plans. Key requirements: - Proficiency in Microsoft Visio - Experience in creating floor plans - Ability to work with provided standards/templates Please note, I will provide the necessary standards/templates, so there's no need for you to help define these. Your primary task will be to use Visio to create the floor plans according to these specifications.

We are looking for a Senior Full Stack Developer with 8+ years of hands-on experience in both frontend...in daily standups, grooming sessions, and retrospective meetings. Requirements: Experience: Proven expertise in full stack development with modern frontend and backend technologies. Familiarity with Agile Scrum processes. Skills: Strong proficiency in frontend technologies (React, Angular, or Vue). Backend development expertise (Node.js, Django, ASP.NET, or similar). Experience with databases (SQL/NoSQL). Interviews: Comfortable with HR interviews. Ability to handle technical questions. Live coding and system design sessions. Additional Requirements: Camera must be on during interviews for better communication. Let’s discuss more about your experience and skills during ...

My Open Cart ...stopped functioning properly. I'm not receiving notifications for sales, and sales are not being recorded in the database. I need a skilled professional to evaluate the situation and determine the best course of action. Key requirements: - Diagnose the issue and decide on the best approach to resolve it - Ensure that sale notifications, database entries for sales, and overall site performance are fully functional post-repair Ideal skills and experience: - Extensive knowledge of Open Cart - Strong problem-solving abilities - Experience with database management - Ability to assess and implement effective solutions Please note that nothing has been changed in the database, and I would like to ensure all aspects of the site are o...

I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.