Asp database manipulationJobs

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.

I'm seeking a proficient programmer to develop a code for programmatically filling forms using data from a JSON file. I don't know the PDF file internals and have encountered issues while attempting to parse fillable fields using Python libraries. The solution should effectively extract data from a JSON file and populate correspondin...seeking a proficient programmer to develop a code for programmatically filling forms using data from a JSON file. I don't know the PDF file internals and have encountered issues while attempting to parse fillable fields using Python libraries. The solution should effectively extract data from a JSON file and populate corresponding form fields within a PDF document. Prior experience with PDF manipulation and strong programming skills are...

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows that meet a specific static condition. The main functionalities of this script in...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...

...the users and aid in their learning process. - 3D object manipulation is crucial for the application to provide a hands-on experience, making it more immersive and beneficial for the users. - Real-time information overlay is another essential feature that will enhance the user experience and provide additional context to the subjects being taught. Subject and Focus: The augmented reality application will be focused on the subject of Science. It should be designed in a way that makes learning science fun, interactive, and easy to comprehend for its users. Ideal Skills and Experience: - Proficient in Unity and AR development. - Experience in creating interactive educational applications. - Strong understanding of 3D object manipulation and real-time information overlay. - ...

I'm in need of an experienced JavaScript developer to enhance my website's interactivity through DOM manipulation. The main focus will be on making the menus and navigation elements interactive. Key Requirements: - Proficient in JavaScript and DOM manipulation - Understanding of UI/UX principles - Experience with adding interactivity to menus and navigation If you have a proven track record of enhancing website interactivity through DOM manipulation, please include examples in your bid.

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

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.

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pu...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 manipulation in the Power BI reports, so this p...

...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?** - **Tailored Approach:** Each lesson is customized to your skill level and learning style, en...

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - ...

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

I'm in need of a versatile software that can record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of how you plan to approach this proj...

I need a photo editor skilled in photoshop to edit a personal photo to be used as my professional headshot. The task involves the addition of a realistic, black, straight-across bra to the image in order to eliminate any visible cleavage. Here are few key aspects: - The edit should appear as realistic as possible to maintain a pr...involves the addition of a realistic, black, straight-across bra to the image in order to eliminate any visible cleavage. Here are few key aspects: - The edit should appear as realistic as possible to maintain a professional appearance. - No other alterations to the photo are required. This job is best suited to a freelancer with a keen eye for detail and extensive experience in realistic photo manipulation. Please provide examples of similar photo retouc...

I'm looking for a skilled developer to enhance my homepage functionality by incorporating URL parameters. Specifically, I w...other pages, allowing for dynamic content based on these parameters. - Error Handling: In case of missing or invalid URL parameters, the home page should gracefully revert to default content. This will ensure a good user experience even when there are issues with the parameters. Ideal candidates for this project should have: - Proficiency in web development, particularly with URL parameter manipulation. - Experience with front-end technologies, especially in adjusting layouts dynamically. - A strong understanding of error handling in web applications. If you have these skills and are confident in your ability to deliver a robust solution, I'd li...

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

I’m looking for an expert with MySQL skills to help me write a query or script. This task in...three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excellent communication and patie...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

Please fix my task that we spoke about

...with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel functions and data manipulation ...

...development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experience in creating forms in MS Access - Ability to understan...

I'm in need of a Python script that can efficiently take addresses from an excel spreadsheet and search google maps locate solar panels on roof tops Ideal Skills and Experience: - Proficiency in Python programming - Experience with image processing and analysis - Familiarity with satellite image utilization - Understanding of data output and manipulation in Excel Key Features: - The script should focus on residential rooftops specifically, using satellite images to identify solar panels. - It should be able to iteratively search through said images, pinpointing and marking the locations of solar panels. - The final output should be an Excel spreadsheet containing the results of the search, detailing the coordinates of the identified solar panels. Please, only bid if you...

In this project, I need a competent photo editor to make a couple of specific changes to an image. The edits needed are: - Removal of 'Person C' from the photograph. The person sitting - Adjustment of 'Person B's' orientation in the photograph to face the opposite direction. To face the man The ideal freelancer for this job should possess strong skills in photo manipulation, and have prior experience in using editing tools effectively to remove and manipulate subjects within photos. High attention to detail is essential to maintain the realism of the edited photo.

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

Hi, we are a nonprofit based in Brazil. I am seeking a freelancer with outstanding research and data management skills to compile a list of geographical location of (environment and social) projects supported by a set list of 300 UK foundations (attached). Key Responsibilities: - I am only interested Foundations that provided grants to Brazilian organizations in the past 3 years (so the final list will be considerably shorter) - For these, I would need to know what are the themes covered by the foundation (for those grants but also beyond) - For some of these (that we will select later), I would need the email of the grants manager in charge (process wise, if it is easier to get te email of this entire subset, that’s ok) If a list of themes can be provided before hand, we can...

I'm looking for a skilled data analyst who can help me with a project that involves identifying patterns in customer behavior data. Key Requirements: - Proficiency in Python for data analysis - Extensive experience working with customer behavior data - Ability to create and present insights us...cleaning the provided customer behavior data - Applying appropriate data analysis techniques to uncover patterns(classification problem) - Presenting the findings through visually engaging charts The ideal candidate would have a strong background in data analysis and visualization techniques, especially in the context of customer behavior data. Experience in using Python libraries for data manipulation and chart creation is also essential.

...management and Warehouse overview. Essential Functionalities: - Inventory Management: The system should allow for the easy management of inventory. - Warehouse Overview: An overview of warehouse status and stock levels should be clearly available. User Interface Design: - List View: I envision the inventory management interface as a list view with search and filter options for easy access and manipulation of data. Ideal Skills and Experience: - Proven experience in Python frontend development - Strong understanding and experience in Inventory management systems - Proficiency in creating user-friendly UIs with search and filter options - Ability to distill complex data into clear and actionable insights - Previous experience with warehouse management systems would be a great ad...

We are seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance a...seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance and scalability. MYSQL Dat...

I'm looking for a skilled developer to create a script that will pass hash value from the parent page to an iframe, and use the hash value as part of the iframe's URL....developer to create a script that will pass hash value from the parent page to an iframe, and use the hash value as part of the iframe's URL. Key Requirements: - Extract the hash value from the parent page's URL. - Pass the extracted hash value into the iframe. - Utilize the hash value as part of the iframe's URL. Ideal Skills: - Proficiency in JavaScript, particularly working with iframes and URL manipulation. - Strong understanding of web security principles. The successful candidate for this project will have a keen eye for detail and the ability to create a robust, secure solution tha...

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Exp...Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation wi...

I'm seeking an expert data scraper to compile a comprehensive list of small to medium enterprises (SMEs) across Victoria, NSW, North Queensland, and South Australia. The scope of businesses should focus on restaurants and retail stores. The information needed for each business is as follows: - Business Name - Address - Phone Number - Website - Email Ideal candidate should have robust experience in data collection and validation to ensure the information provided is current and accurate. Proficiency in navigating Australian business directories and databases will be a valuable asset. Your scrupulous attention to detail and commitment to data integrity are critical for this task.

I need a database where we can store our sales transactions. The database will be manually updated by our staff. I would also like to have reports generated on our sales. Key Requirements: - Develop a database to store sales transactions - Enable manual data entry by staff - Implement a reporting system that can generate sales reports Ideal Skills: - Proficiency in database development - Experience with manual data input systems - Ability to create custom reporting features Please provide examples of previous similar projects you've worked on.

I'm aiming to procure an artist who can use AI technology to enhance a photo of a human face, making it appear more realistic. This enhanced image will be used for a party flyer. The party ...be used for a party flyer. The party theme is a tropical birthday party specifically aimed at an adult demographic. Key Requirements: - Enhancing a photo of a human face - Creating a realistic and engaging design - Adapting the design to suit a tropical-themed party flier - Ensuring the design is appealing to an adult audience Ideal Skills and Experience: - Proficiency in photo editing and manipulation - Experience with AI technology for image enhancement - Creativity in adapting design to suit specific themes - Understanding of design principles for adult audiences, particularly for pa...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mat...fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the p...

I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.

I'm in need of a skilled developer who can craft GET and POST requests in C#. It is necessary for write some simple queries: specifying the first and last name, date of birth, phone number, gender and password. Then a request to send a text message with a code. Key Responsibilities: - Development of GET and POST requests - Ensuring efficient data retrieval, i...birth, phone number, gender and password. Then a request to send a text message with a code. Key Responsibilities: - Development of GET and POST requests - Ensuring efficient data retrieval, insertion, and modification Required Skills & Experience: - Extensive knowledge in C# and networking - Proficiency in handling GET and POST requests - Strong problem-solving skills - Understanding of data manipulation techni...

I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...

I need a professional to remove a white text watermark from each photo. The watermark is not consistent in placement and varies across the images. Ideal Skills: - Strong image editing skills, particularly with watermark removal - Familiarity with working on images with randomly placed elem...photo. The watermark is not consistent in placement and varies across the images. Ideal Skills: - Strong image editing skills, particularly with watermark removal - Familiarity with working on images with randomly placed elements - Attention to detail Experience: - Previous experience removing watermarks from images - Portfolio demonstrating successful watermark removals - Knowledge in image manipulation techniques Please include examples of similar tasks you have successfully completed in...

...my project to the next level, addressing a specific issue with an OSLC connection over HTTPS. Postman isn't delivering the expected GET/POST data and, instead, is producing an HTML response. Here are the key responsibilities: - Download j_username and j_password - Send J_security in URL to retrieve data The freelancer should have experience in: - Postman - REST API for data retrieval, manipulation, and authentication & authorization - Red Hat technology stack In your proposal, please include your past work related to Red Hat and REST API along with your detailed project proposal. This project involves manipulating data and managing authentication and authorization, substantial experience in these aspects will be highly appreciated. Your expertise will be instr...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.

Photo enhancements, manipulation, retouching, adding removing subjects, etc

I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individua...

I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

I'm...urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and will connect and probably do it together ...

I require an expert in image manipulation who can skillfully change certain parts of a pre-existing red-colored image to display a polished aluminum finish/Silver instead. I would also like the image delivered with a transparent background. Key responsibilities: - Identify the specified parts that need color adjustment and maintain the quality of the rest of the image. - Modify the specified areas to render a convincing polished aluminum texture. Ideal Skills and Experience: - Proficiency in image editing software such as Adobe Photoshop or Gimp - Sound understanding of color theory and photo manipulation - Prior experience with metallic color rendering and texture work is a plus