Sql access excel vba jobs

...using Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There sho...

I'm seeking an experienced developer to create a Chrome extension that logs specific web data. This browser extension is meant to automatically save all resources loaded by the browser, capturing the following: - URLs of resources - File types of resources - Sizes of resources - Time of access I expect this project to be completed as soon as possible. The ideal candidate will have a solid background in extension development, proficiency in JavaScript, HTML, and CSS, and a comprehensive understanding of Chrome's APIs. Familiarity with user interface design for added usability would be advantageous.

I'm looking for a security expert (Ethical Hack) to help me run testing on my website's login system and database access. After the testing, I need you to implement SSL encryption and two-factor authentication, as well as ensure regular security audits are in place. Ideal skills and experience include: - Proficiency in web security testing - Experience with implementing SSL encryption and two-factor authentication - Knowledge of conducting regular security audits - Familiarity with different website platforms and the ability to adapt these security measures to a custom-built website.

Real estate website using theme in Wordpress. We will provide the theme. 1st draft (4days) 2nd draft (3 days) final draft (3 days) Proper backend access to update new listings when we want. Theme: the above theme:

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

... premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry dates, display of policy summary, automated notifications, search/filter options, display of policy status, enabling data exports, provision of visual graphical representations, user login and access control for security purposes. The system should also be equipped with capabilities for client information management, policy tracking, automated alerts and reminders, commission calculation and provide an overview via the dashboard. The ideal candidate should possess the required skills in systems design and data management. They should also have a profound understanding of insuran...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

Please Sign Up or Login to see details.

I recently lost access to my domain purchase account, which I believe has been compromised by an unauthorized user. Despite contacting the domain provider's customer support, I couldn't recover the account. This issue has arisen as my email and phone number linked to the account were altered. The primary goals of this project are: - **Recover Access to Domain Account**: I need a hacking expert to help me regain control over my domain purchase account. This includes resetting the account's email ID and phone number to the original ones. - **Track the Unauthorized User**: Additionally, the freelancer should track the person who has taken over my account. It is essential to identify this user for legal and security reasons. I have already taken steps to secure m...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I urgently need a professional who can access my Windows Server 2016 VPS and enable the execution of custom applications for me. Due to some technical problems, I am currently unable to open any programs. Key Responsibilities: - Access my VPS server and troubleshoot the issue preventing program execution - Enable the successful execution of the custom applications Ideal Candidate Should: - Have extensive experience with Windows Server 2016 - Be proficient in troubleshooting and resolving technical issues - Be able to work quickly and efficiently to resolve the problem ASAP Please reach out if you possess these skills and can assist me with this urgent task.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

...Key Requirements: - Roof Material: The roof is made of metal. Therefore, it's crucial to determine whether it can bear the weight and be a suitable foundation for the HVAC unit. - Roof Condition: While it is in good condition, it is an old roof. The assessment should focus on whether the roof can still support additional weight without compromising its integrity. - Structural Blueprints: Full access to structural blueprints is available, which should aid in the assessment process. Ideal Skills & Experience: - HVAC Expertise: A background in HVAC systems and their installation is essential for this project. - Structural Engineering: Knowledge of structural engineering is necessary to evaluate the roof's capacity for supporting the HVAC unit. - Roofing Experi...

Description: We are seeking an experienced professional in networking to configure a Site-to-Site connection using OpenVPN Cloud Connexa between two distinct Internet Service Providers (ISPs). The primary objective is ...separate networks for efficient data transfer. T Key Details: Objective: Enable communication between two separate networks for seamless data transfer. OpenVPN Cloud Connexa Experience: Substantial personal experience with the platform. End Result: Connect two different devices, each with a private network, via Team Viewer private LAN. This connection should be established without any public access, ensuring privacy and security. Ideal Candidate Skills and Experience: Proficiency in configuring Site-to-Site connections. Experience with the OpenVPN Cloud Connexa...

Unicenta POS - Payment Module Integration with Linkly AND TYRO requirement add support for Linkly and Tyro payment. A link to our development portal can be found here: Access to Linkly and Tyro and Custom Unicenta POS source code will be provided. Linkly - Integration Features - On Prermise - Core Payments Tyro - Integration Features - Integrated Purchases - Integrated Receipts - Integrated Refunds - Integrated Split Payments - Integrated Surcharging

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...

I need a well-structured informational website built. ...need a well-structured informational website built. Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you've complet...

Looking for a React professional with experience in N...Understanding of and experience with Server-Side Rendering (SSR) - Familiarity with handling complex applications. Project Overview: - Transform existing React app with Server-side rendering (SSR) to to advance performance - App has high complexity including a large number of pages and multilayered features - Main aim is to deliver better app performance The expert will not have access to any source code, will be working remotely, and will guide us on how to structure the project. No code will be shared. The current project is developed using React with Material UI design. We recommend that the expert dedicate 3 hours per day for 3 days to work with us. Looking forward in working together on this thrilling proje...

: logo with display menu: select option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u

Join AWS Reward Program and Boost Your AWS Projects! Are you an AWS en...websites, and project details. Earn Rewards: Receive monetary rewards for each validated submission, contributing to your project's success while earning extra income. Why Join CRP: Monetary Incentives: Earn money for sharing public information about your AWS projects. Enhanced Collaboration: Connect with like-minded professionals and expand your network within the AWS community. Support from us: Access expert guidance and support from our team to maximize the potential of your AWS projects. Join CRP Today: Don't miss out on this exciting opportunity to monetize your AWS expertise and contribute to the growth of cloud computing. Join our CRP Program today and take your AWS projects to new heights! R...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewer plesae let me know...

I am looking for someon...mailbox systems. The main responsibility will involve the collection of emails filtered according to specific criteria and their subsequent organization. Key tasks: - Collection of email data from enterprise mailbox - Sorting obtained emails using three criteria: date, sender and specific keywords in the subject Ideal Organization: - Emails should be organized exclusively by the sender for easy access. Ideal Skills: - Data collection and organization - Detailed understanding of enterprise mailbox structures - Competency in refining searches This task requires accuracy and an eye for detail, as the correct sorting and collection of these emails is critical for the smooth operation of our enterprise. Previous experience in similar jobs will be highly...

I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive data man...

...customer-oriented website and application for my business. The primary purpose of this platform is to facilitate information sharing and, most importantly, to host a comprehensive product or service catalog. Key Features: - Product/Service Catalog: The platform should serve as a repository for our offerings, allowing customers to browse our array of products/services. - User Registration/Login: In order to access and potentially purchase from the catalog, customers should be able to create accounts and log in securely. - Responsive Design: An intuitive and responsive design is crucial to ensure an optimal user experience across different devices. The ideal candidate for this project should have: - Proven experience in developing user-friendly websites and applications, particu...

I need a skilled videographer/video editor to create 15 separate videos to promote a song on TikTok. The videos should be about 30 seconds long. I will provide you with three different parts of ...(it is an emotional summer dance song). The videos should be: - Independent scenes, not one continuous storyline - Theme: freedom, emotions, open landscapes, driving at night, traveling, flying... We will discuss the specific style in detail once I receive your application. Requirements: - Experience in editing (probably also in filming) - Creativity and ability to engage the TikTok audience - Access to a paid database of stock videos and your own footage is a plus. Please note that I can only accept customized applications with the code TikTok2024. Thank you. I look forward to hearing...

I'm in need of an experienced and diligent freelancer to install and set up an open-source Apache Fineract/Mifos on AWS. The key aim is to be able to consume API's in another application securely and access the user interface using a browser. And provide documentation of how to do it myself. To succeed in this project, the freelancer should be capable of: - Installing and setting up open-source Apache Fineract/Mifos on AWS. - Ensuring that APIs can be securely consumed in another application. - Setting up a user interface that can be easily accessed via a browser. Reference link : https://mifosforge.jira.com/wiki/spaces/docs/pages/3559555073/Mifos+X+23.12.31+Installation+Guide+for+Windows+11+Ubuntu+22.04+Lts

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

...automation requirements. 2. Developing the Integration Using Stripe’s API and our Education management system API to integrate the payments and automate the transfer of payment information from Stripe & bookings/Transactions from our Education Management System to eventually present live information of the correct balance for the students and tutors. And to check if we can create a login page to access students’ payments, invoicing, and balances. 3. Testing and Troubleshooting Thorough testing to ensure that the integration and all data is working well with 100% accuracy. This includes handling different types of payment statuses and ensuring data accuracy. 4. Deployment and Go-Live Deploying integration in the live environment and monitoring the initial trans...

I'm seeking a skilled web developer to create an engaging web portal, which will contain extensive modules as PDF files in a database. Key requirements are: • Implement an alert system, which both sends an email notification and highlights a newly added module on the website. • The portal should allow direct access without the need for user authentication - no registration or login process. • The portal needs to connect with cloud storage solutions such as Dropbox or Google Drive, for seamless integration of new PDF module uploads. The ideal person for this project will have extensive experience in web development, particularly in creating interactive and dynamic web portals. Proficiency in integrating with cloud storage solutions is essential. The ability ...

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

I'm looking for someone to create a compelling advertisement for my retail furniture brand. It doesn't need to be top-tier or overly professional since it's for a demon...entirely applicable, as it was created for an e-commerce service provider called "Quickfix" with a primary goal of raising awareness. For our current furniture brand, the focus of the ad should be on showcasing the products, capturing consumer interest, and persuading them to make a purchase by effectively conveying why they need our products. The sample ad is in a ppt slide, since I dont have access to the original document at the moment) Note: Please keep in mind that we are short on time and need the project before 10th of May. Morever, if this project is executed well, there could be p...

Please Sign Up or Login to see details.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I'm in need of a proficient Microsoft power apps developer to creat...for a selected month and by first half & second half (i.e. by default the current one) for each employee overall chargeability, overall available time, chargeability (calculated as total hours poste on a chargeable job dived by working hours available in the period – excluding holiday) [OPTIONAL] User access management: -Admin role: full access - job owner: full access to a set of job views (could perform data entry) - job viewer: access to a set of job view in read mode - advanced viewer: access to overview dashboard - I prefer a design that is simple and minimalistic, focusing more on functionality and easy user experience - Required skills: Proficiency in Microsoft ...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me...

...should accommodate potential changes in branding signs and skincare products, allowing for easy updates without compromising the display's integrity 4. Storage Space for Disposables: Provision of designated compartments for disposables such as q-tips, napkins, and spatulas, ensuring convenience and organization. 5. Rotational Capability: Integration of a rotating mechanism to facilitate easy access and browsing for customers, optimizing user experience. Specifications: - Material Selection: Utilization of high-quality materials to ensure durability and a premium aesthetic. - Dimensional Considerations: Design should accommodate various product sizes and quantities while maintaining a sleek profile. - Ease of Assembly and Maintenance: Consideration of assembly simplicit...

I'm seeking an experienced PowerApps developer to assist in creating a system for daily information management. - Data Formatting: The information will consist mainly of text fields, numeric data, images o...mainly of text fields, numeric data, images or multimedia, and a predefined set of choices. - User Interface: The system should offer a user-friendly interface for data entry and management. - Data Storage: The daily information should be saved to a centralized excel or table, allowing all authorized users to access the data at any time. The ideal candidate for this project would have prior experience in PowerApps development, particularly in creating systems for data management and user input. Experience with integrating PowerApps with Excel or other databa...

...externally - Accurate length, width, and height dimensions - Conformance with ADR 42 regulations - Creation of a bolt-on application design - Ease of access for occupant - Allowance for wiring and lighting etc - AERODYNAMIC design to avoid wind drag or excess fuel consumption with the following dimensions being a must. Internal Dimensions External Dimensions Length- 650mm (Min) Length- 680mm (Max) Width- 2350mm (Min) Width- 2480mm (Max) Height- 1800mm (Min) Height- 2100mm (Max) Maximum width of any vehicle in Australia is 2500mm Pedestrian doors are only permitted on the Left hand side with the access on the right only being for emergency use. must include 1 rear window (Acrylic) to allow for natural light. I look...

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Numbe...

I need a professional who can resolve a persistent issue I'm experiencing while connecting my GoHighLevel whitelabel account to Cloudflare. Your primary task is to troubleshoot and fix the 1014 CNAME Cross User Banned Error that repeatedly occurs during the connection. I have full access to both my Cloudflare and GoHighLevel accounts, so you can freely work on resolving the issue. The ideal candidate for this project should have: - Profound knowledge and expertise working with GoHighLevel and Cloudflare - Extensive experience in troubleshooting and resolving CNAME errors - Excellent problem-solving skills I need this issue resolved promptly to ensure seamless connectivity between my GoHighLevel whitelabel account and Cloudflare. Please only bid if you are confident in your ...