Microsoft Access Jobs

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-oriented, reliable ...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macros, and strong...

I am in need of an expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer sho...

Χρειάζομαι άτομο για τη δημιουργία database σε excel

I'm seeking a developer to integrate our company's workflow with Office 365, specifically focusing on automation of task assignments. This integration aims to increase our team's productivity. Key Responsibilities: - Designing and implementing a system that seamlessly integrates with Office 365. - Automating task assignments using the platform's functionalities. - Ensuring smooth and efficient workflow within our team. The Ideal Candidate Should Have: - Proven experience in Office 365 integration. - Strong understanding of task assignment automation. - Ability to design and implement a user-friendly system. - Excellent communication skills for updating and consulting with our team.

Seeking a skilled developer capable of quickly creating a robust asp.net-based e-commerce web application. The application demands the following features: - Product listing - Shopping cart - Payment gateway - Admin access to data Data should be stored in MS Access 2007. As the design is not yet finalized, possessing a keen eye for detail and themes that resonate with users will be highly valued. This project is time-sensitive and must be completed within 1 day. Proficiency in Visual Basics and experience in speedy application development is sought after.

I require an accomplished and engaging speaker who can effectively communicate the content of a book I authored on managing acute, chronic kidney disease plus, home hhd through holistic and modified lifestyle approaches. Key Responsibilities: - Presenting on the main topics of the book: diet modifications, stress management techniques, and the importance of regular medical check-ups - Promoting understanding and personal growth related to chronic kidney disease management Ideal Candidate Attributes: - In-depth knowledge of chronic kidney disease - Strong background in motivational and inspirational speaking - Expertise in personal growth, self-help, and lifestyle modification - Experience in preparing and delivering presentations to diverse audiences - Familiarity with the NYC s...

I'm searching for an experienced programmer who is well versed in both MS Access and Visual Basic. Your Responsibilities: • Assist with MS Access / Visual Basic programming and tutoring sessions • Work without a pressing deadline, allowing us to focus on quality learning and product creation Skills Needed: • An extensive background in programming, specifically with MS Access and Visual Basic • Optimal: Solid understanding of Datanorm and ZUGFeRD • Exceptional patience and communication skills to aid in the tutoring portion of this project. Though there isn't a deadline, we should strive for steady progress. If you're an expert in these areas, I'd love to learn from you. You should solve individual tasks alone, but also with me online using...

I'm in need of an experienced expert who can help set up my Office 365 software to perform the key functions of my business. With this tool, I aim to better my business operations and increase productivity. The selected freelancer will need to: - Implement Office 365 software for a team size of 1-10. - Ensure smooth functionality for email and communication service. - Arrange document storage and sharing capabilities. - Effectively set up collaboration and project management tools. - Enable Teams calling setup for seamless communication. Ideal skills and experience for this job include deep understanding of Office 365, its setup and functionalities, and proven experience in integrating such a tool for businesses. An understanding of small team operations would be beneficial.

I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manage multiple tas...

I'm experiencing some issues with my Access database. The data seems to be missing or incorrect. Moreover, I need to add new functionality. The additional function is generating reports. Although I haven't specified the type of reports, I expect freelancers bidding for this project to possess experience in various types of reporting functions. Skills required are: - Proficiency in Microsoft Access - Experience in fixing data errors - Expertise in implementing reporting functions in a database It's crucial that the freelancer grasps the issues and rectifies them, and demonstrates an understanding of database reports functions to add onto the system. Bids from freelancers with relevant experience and skills are welcomed.

**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate collaboration and knowledge sharing ...

need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later

I'm on the hunt for a vibrant, knowledgeable Microsoft SQL trainer for my client who can help me elevate skills to an intermediate level. Fluent Tamil communication is a must as I feel most comfortable learning in this language. Key Learnings Expected: - Database Creation: Learn how to build an efficient and well-structured database from scratch. - Querying and Managing Data: Gain expertise in extracting, manipulating, and managing data. - Advanced SQL Concepts: Explore more sophisticated SQL concepts to comprehend the language's full capabilities. Ideal Freelancer's Profile: - Experienced MS SQL tutor with a strong understanding of database creation, handling data, and advanced SQL topics. - Proficiency in teaching in Tamil. - Proven experience in educating and simplify...

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowledge of financia...

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

As a thriving e-commerce platform, our daily operations depend heavily on efficient inventory management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal ...

I am seeking a Python expert with extensive experience in MS Access database management. The project involves merging and transforming existing MS Access databases. Key Tasks: - Database Merging: You will be required to merge multiple MS Access databases into a single, coherent database. - Data Transformation: The data within these databases will need to be transformed to fit the new structure. - Query Optimization: Your role will also include optimizing queries to ensure efficient data retrieval and manipulation. Key Objectives: My main goal is to facilitate easier data management through this process. The end result should be a well-structured, consolidated database that is optimized for performance. Ideal Skills: - Proficiency with Python and MS Access - Extensive experience in data...

In this particular project, I require a freelancer with keen MS Access development and design skills. The primary tasks will be: 1. Code Refactoring: I need the existing code of the MS Access project to be analyzed, enhanced, and optimized. You should ensure that code complexities are addressed and improved for better efficiency. 2. Main Menu Design: After improving the code, you will need to revamp the Main Menu. Presently, it provides navigation to different forms, displays relevant information, and initiates the running of queries/reports. I'm aiming for a clean, minimalistic design to make it more user-friendly and efficient. Skill Set: - Advanced knowledge and expertise in MS Access. - Proven experience in code refactoring and menu design. - Strong UI/UX skills, with a good u...

I am looking for an expert who can assist in creating and optimizing Microsoft Forms. The focus would be on: - Developing surveys and questionnaires for data collection. The job also requires proficiency in QR code creation that will serve for: - Collecting registration-related information. The forms should be user-friendly and accessible via both desktop/laptop computers and mobile devices. Ideal Skills: - Expertise in creating and managing Microsoft Forms. - Proven track record in QR code generation and implementation. - Strong understanding of user experience on different platforms (desktop/laptop, mobile).

I am looking for an experienced Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer database efficient!

I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficiency: The successful fre...

I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and collaboration skills

I am looking for a detail-oriented freelancer to help convert my existing Excel spreadsheet data into a database format. Requirements: - Import and convert Text Data from Excel Spreadsheets to Database format - Accurate and efficient data entry skills required - Prior experience with Excel and database formatting is a must - The candidate should have an eye for detail and be well-versed in data management By the end of the project, I expect all data from the Excel spreadsheet to be neatly structured and readily accessible in the new Database.

I'm in need of a data entry specialist to assist in the creation of a new database. The primary task will be to input text data from digital files. Key responsibilities include: - Accurate and efficient data entry of text information - Organizing data to ensure it's ready for database implementation - Ensuring data integrity and consistency Ideal skills for this project include: - Proficiency in data entry - Attention to detail - Familiarity with database management - Excellent organizational skills The goal of this project is to have a comprehensive and well-structured database, primarily populated with the text data provided. Please pitch your relevant experience and approach for this task.

I am in search of a highly-skilled MS Excel expert who can help me organize my small business through meticulous data entry and intelligent formulas. The ideal candidate will be skilled in: - Invoice creation - Payment receipt tracking - Maintaining project-wise details The work will involve managing an Excel sheet with less than 100 columns and rows. When creating invoices and payment receipts, you'll need to manage data fields such as: - Customer Name - Service/Product - Amount - Invoice Number - Date - Tax - Customer Address - Payment Method - Invoice Due Date Expertise in Excel's calculation and analysis functions will be especially valuable for this job. This opportunity is perfect for those with a knack for data organization and attention to detail.

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

In this project, I'm seeking a Power BI expert's assistance to accomplish the following: - Development of data visualization using Power BI - Creation of intuitive dashboards and comprehensive reports I will provide data from classified sources, particularly Excel spreadsheets and SQL databases. Your task will be to integrate these platforms and generate compelling, easy to understand visualizations. The primary KPIs needed in the dashboard and reports will focus on: - Sales revenue: I'm interested in monthly, quarterly, and annual trends - Customer satisfaction: We'll track this through a set of predefined parameters. Your ability to illustrate complex data in a user-friendly manner will be paramount. Prior experience with interpreting sales data and customer fee...

I am a commercial cleaning business employee based in the UK. I'm looking to have a Microsoft Access database built to help manage various aspects of my business. Ideal Skills and Experience: - Proficiency in Microsoft Access database development - Understanding of the commercial cleaning business operations - Knowledge of database design and implementation Key Features: - **Employee Database**: - Store employee contact information - Track employee work schedules - Monitor employee performance - Manage Payroll - **Client Databases**: - Store client contact information - Track client preferences for tailored services - Ability to generate client reports - **Alert System**: - Employee task reminders: to ensure tasks are completed on time - Client appointment rem...

Making a Excel based data model (based on some raw tables), will have to make a similar version of existing data model (that will be shared) by the end of Thursday (11th April) i..e in 2/3 days Existing model attached! Currently I have excel with tables of information

Hola Freelancers! Tengo un cliente que le dejaron un desarrollo finalizado y sin soporte ya hace mas de 10 años, este desarrollo ha funcionado bien hasta ahora que se tiene una nueva necesidad. El desarrollo es un programa para el manejo de una produccion en una empresa textil, el programa se ejecuta bajo Microsoft Acces 2003, se tiene completo acceso a las bases de datos, no hay restricciones en él. Lo que se necesita: Al ejecutar una consulta en el programa, este arroja cierta información (), pero si se crea un usuario nuevo en el servidor, este usuario no es capaz de hacer las consultas ejecutando el mismo programa (). Lo ideal seria que se revisara por remoto tanto el usuario que funciona y el que no, para ver si se pueden dejar funcionales los nuevos usuarios qu...

I am seeking an experienced individual who can assist in completing a lab for me on Microsoft Access efficiently and effectively. The tasks include: - Creating basic queries for specific data retrieval - Designing the lab project in Design View - Ensuring the results of created queries match my specified desired outcomes Ideal candidates should have a considerable amount of experience in these areas and are to demonstrate this in their application. Your hands-on experience and proficiency in working with Microsoft Access labs will be crucial to your success in this project. It is vital that you understand the importance of accurate data and its role in ensuring coherent and logical lab reports.