Microsoft Access Jobs

I'm looking for an experienced Visual Basic developer to create custom functions for data manipulation. The primary data source will be databases. Key Requirements: - Develop Visual Basic macros to create custom functions. - Primarily focused on data manipulation tasks. - Interaction with various databases. Ideal Skills and Experience: - Proficiency in Visual Basic. - Strong experience with database interactions. - Expertise in developing custom functions for data manipulation. Please provide examples of similar work done and your approach to this task.

I'm looking for an expert to clean sales data. The data is currently in Excel/CSV files. Key tasks will include: - Removing duplicates - Fixing errors - Standardizing formats Ideal skills and experience: - Proficiency in Excel/CSV - Experience in data cleaning - Attention to detail Please provide examples of similar work done.

I'm seeking an experienced Microsoft Access developer to create a comprehensive database solution for my needs. The project requires: - Data Entry Forms: User-friendly forms for accurate data input. - Custom Reports: Generate insightful, tailored reports. - Accounting Functionality: Integrate accounting features for financial tracking. Ideal Skills and Experience: - Proficiency in Microsoft Access. - Strong background in database design and management. - Experience in creating custom reports and data entry forms. - Familiarity with accounting principles and integration within Access. Please provide samples of similar work done.

We are an overseas recruitment company that recruits over 5,000 candidates annually for various clients across the Gulf region. We are looking to hire a freelancer who can design advanced Excel sheets tailored to our recruitment processes. The ideal candidate will have experience in creating comprehensive management reports and tracking systems for large-scale recruitment operations. Responsibilities: Design Excel sheets to manage candidate information, visa statuses, and deployment details. Create client-wise and project-wise reports to track recruitment progress. Implement tracking for visa expiry and other important candidate milestones. Ensure data accuracy and maintain confidentiality. Requirements: Proven experience in advanced Excel functionalities (e.g., pivot tables, macros, com...

I need help resolving a SQL connection error that's preventing users from accessing the database through an Access front-end on a Hyper-V terminal running Windows Server 2003. Requirements: - Diagnose and fix the connection error - Work on Windows Server 2003 and Hyper-V - Experience with SQL and Access integration - Provide clear communication and updates Specific error messages will be provided upon engagement.

I'm seeking an experienced developer to create and structure a comprehensive legal database primarily containing statutes and regulations. Key requirements include: - Extensive database of statutes and regulations - Robust search and filter options - Document upload and storage capabilities - User access control for security Ideal skills and experience: - Background in legal tech or database management - Experience with developing secure, user-friendly databases - Familiarity with legal documents, especially statutes and regulations - Strong organizational and technical skills The primary users will be lawyers, so the interface must be intuitive and efficient. Please provide examples of similar projects you've completed.

**My Expertise Includes:** * Data Cleaning & Preparation:** Removing duplicates, handling missing values, and formatting raw data for analysis. * Data Sorting & Filtering:** Organizing data using advanced Excel features like custom sorts, filters, and formulas. * Data Analysis:** Using Pivot Tables, formulas (VLOOKUP, INDEX-MATCH, IF, SUMIFS, etc.) to derive insights. * Data Visualization:** Creating charts, graphs, and dashboards in **Excel, Power BI** to present data clearly. * Dashboard Design:** Building interactive and professional dashboards for tracking KPIs, trends, and reports. * Excel Automation:** Creating **macros, buttons, and formulas** to automate repetitive data tasks. * Report Generation:** Generating weekly/monthly reports, summaries, and data-driven presentation...

I'm looking for an Excel application to streamline my inventory management with an integrated order management system. Essential Features: - Inventory management with order management capabilities - Order tracking functionality - Comprehensive customer database Ideal Skills and Experience: - Advanced proficiency in Excel - Experience in developing inventory management systems - Strong understanding of order management processes - Ability to create user-friendly interfaces within Excel Please provide samples of similar work done.

I'm seeking an experienced developer to create a Management Information System (MIS) for the Food Corporation of India (FCI). The primary goal of this project is data management and reporting. Key Requirements: - Integrate multiple data sources: inventory databases, financial records, and employee records. - Generate comprehensive data reports, specifically: - Inventory status reports - Employee activity reports Ideal Skills and Experience: - Proficiency in database management and reporting tools. - Strong background in developing MIS systems. - Experience with data integration from various sources. - Ability to create user-friendly dashboards and reports. Please provide examples of previous similar work.

I need an experienced 9 professional to assist with: Data Entry: Inputting financial data accurately. Generating Reports: Creating comprehensive financial reports. Managing Inventory: Overseeing and updating inventory records. Customization: Tailoring 9 to fit my specific needs. Ideal Skills and Experience: Proficiency in 9 Experience with data entry, report generation, and inventory management Customization skills for 9 Attention to detail and accuracy

Microsoft Access or a stand alone Database Application with Dynamic Tables & Forms for a construction estimating service. The application will calculate costs & percentages of all labour, material & plant hire required for building projects. *************** CONDITIONS OF PROJECT **************** -Completion Date - Friday 4th July, 2025 -Daily communication updates required from day 1 to completion date -IP (Intellectual Property) agreement to be signed, dated & sent to me before starting project so that all work completed belongs to me. -IF YOU CANNOT MEET ALL THE ABOVE CONDITIONS, DO NOT BID ************************************************************** 1.0 REFERENCE TABLE DESIGNS I have created some sample table designs you need to follow & code to my requirements; 1...

Experience Level: Expert Industry: Fintech Overview: We're a fast-moving fintech company looking for a WordPress Developer to help us upgrade our website with a modern, dynamic, and scalable content system. The right candidate will create a clean, credible site that supports press releases, live RSS feeds, regulatory file updates, and custom job listings — all easy to manage from the backend. This is a high-visibility project with potential for ongoing work. Requirements: • WordPress Expert • Strong attention to frontend & backend quality • Clear communicator • Quick turnaround times • Ability to create static and dynamic webpages (Ex: PHP) • Ability to create database tables & web-based update forms using SQL or MS Access (Ex: press rele...

I'm looking for an experienced Tally developer to customize multiple modules, specifically Inventory Management, Accounting and Finance, and Payroll Management. Key requirements: - User Interface Changes for Inventory Management: Specifically, dashboards and visualizations. Ideal skills and experience: - Proficiency in Tally and its various modules. - Strong experience in customizing Tally, particularly with UI changes. - Ability to create intuitive dashboards and visualizations. - Attention to detail and a problem-solving mindset. Please provide examples of previous Tally customization work.

I'm seeking an expert in Microsoft 365, particularly Power Automate and Power BI, to enhance our department's efficiency. Key Responsibilities: Integrate various Microsoft 365 applications (e.g., Excel, Outlook, Word, Teams) Set up and maintain Power Automate flows to streamline: - Approval workflows - Data entry and updates - Email notifications and reminders Build and maintain Power BI dashboards for internal reporting, focusing on operational metrics Implement basic automation scripts to reduce manual tasks Collaborate with our team to understand workflow needs and deliver efficiency-enhancing solutions Ideal Skills and Experience: - Proficiency in Microsoft 365 suite - Expertise in Power Automate and Power BI - Strong analytical and problem-solving skills - Exper...

I am looking to hire an experienced freelancer with a deep understanding of Microsoft Office Suite, particularly Excel, to handle our company's documentation and records on a daily basis. These files primarily include spreadsheets, databases, and reports. Your main tasks will involve: - Preparing, managing, and maintaining these documents daily. - Ensuring that all records are up to date and accurate. Relevant skills and experiences include: - Proven experience in data entry, document management, and administrative support. - High proficiency in Microsoft Office Suite, especially in handling and maintaining Excel spreadsheets and Access databases. - Attention to detail, ability to work independently, and commitment to meet daily deadlines. I encourage all eligible candidates wh...

### **Project Title:** Microsoft Access Setup – Import Sales Data from Excel/CSV and Create Customer Lookup & Marketing Views --- ### **Project Description:** We are a retail business ending our subscription to a cloud-based POS system. We have exported our full sales history, product catalog, and customer list in Excel and CSV formats. We are looking for a freelancer to help us build a user-friendly Microsoft Access database (Office 365 version) that enables us to: * Preserve and manage sales history * Easily search and view customer purchase records * Support future marketing segmentation --- ### **Data Available (Excel/CSV):** * Sales Transactions (date, items, quantity, price, payment type, etc.) * Customer List (name, contact details, customer ID) * Product Catalog ...

Microsoft Access or stand alone Database Applica on with Dynamic Tables & Forms for a building estimating service. The application will calculate costs & percentages of all labour, material & plant hire required for building projects. **1.0 Reference Table Designs** I have created some reference table designs you need to follow & code to my requirements; 1.1 main estimate work sheet 1.2 price file 1.3 recipes 1.4 reports **2.0 Main Table Designs & Coding** 2.1 esmate work sheet 2.2 pricing by price file 2.3 pricing by unit rates/ factors (from esmate sheet historical data) 2.4 recipes 2.5 reports for internal & external use 2.6 application must also include a quote, invoice & receipt feature with my business logo **3.0 Functions & Features Req...

I'm looking for a skilled developer to create an internal Database Management System (DMS) for my Expert Network company. This system is crucial for managing our operations and ensuring efficiency in our workflows. The DMS should have the following functionalities: - Expert Sourcing and Screening: Ability to source, screen, and manage a pool of experts. - Expert Rating and Feedback: A system for rating experts and providing feedback. - Project Tracking and Management: Tools to track and manage various projects. - Company Wise Insights and Notes: A section for storing company-wide insights and notes. Ideal skills and experience: - Proven experience in developing Database Management Systems or CRMs. - Strong understanding of expert networks and project management. - Ability to incorpo...

I'm looking for a freelancer to help me find a project report from a job completed in 2023. The document is essential for my records and needs to be retrieved urgently. The ideal candidate should have: - Experience with document retrieval - Familiarity with freelancer.com platform - Ability to work quickly and efficiently

I need help managing financial transactions in Tally, specifically invoicing. Requirements: - Expertise in Tally ERP - Experience in setting up and managing invoices - No need for customized invoice templates Ideal Skills and Experience: - Proficiency in Tally and financial data management - Strong invoicing setup and management skills - Attention to detail and accuracy

I need assistance with an Excel spreadsheet. The task involves removing a pivot table and converting it into a regular table. Requirements: - Remove the existing pivot table. - Convert the data into a regular table with standard formatting. - No data highlighting is required. Ideal Skills and Experience: - Proficiency in Excel, particularly with pivot tables and table formatting. - Attention to detail to ensure accurate data conversion. - Ability to deliver clean and organized spreadsheets. Looking forward to your bids!

I need a comprehensive sales data analysis for Walmart, focusing on product categories, customer demographics, and sales regions. The analysis should highlight sales trends over time. Requirements: - Set up a Hive database on a cloud-based platform. - Create business and analytics queries tailored to the analysis. - Provide insights on sales trends over time. - Present findings in a structured PowerPoint presentation. Additional Instructions: - Cite all sources used for the project, including data, code, and tools.

I need a comprehensive HR management system for my small company. The system should include: - Employee database: A centralized database to store employee information. - Payroll management: Automate salary calculations, deductions, and generate payslips. - Attendance tracking: Monitor employee attendance, leaves, and absences. The system should support role-based access control to ensure data security and privacy. Ideal skills and experience: - Proven experience in developing HR management systems. - Strong understanding of payroll and attendance tracking mechanisms. - Expertise in implementing role-based access control. - Familiarity with database management and user interface design. Please provide samples of similar work done. Looking forward to your proposals!

I'm seeking an experienced database administrator to set up an SQL database accessible over the internet for multiple users. Key Requirements: - Admin and user roles for access control - Authentication via username and password Ideal Skills and Experience: - Proficiency in SQL and database security - Experience with user access control and authentication methods - Ability to configure secure internet access for databases Please provide examples of similar work done.

Task for the Freelancer Goal: Modify the Excel file so that: Operator Leader uses the original file offline (no changes to their workflow). Agents fill data online in their assigned sheets, which auto-updates the master file. Steps to Implement: Preserve the Original File: - No structural changes (same tabs, formulas, formatting). - Operator Leader continues editing as usual (desktop file). Agent Access Setup: Method 1 (Best): Use Microsoft 365 (OneDrive/SharePoint): - Upload the file to OneDrive/SharePoint. - Use Power Automate (or Power Query) to sync each agent’s input to the master file. - Share individual sheets as separate files (agents see only their sheet). Data Protection: - Agents can only add new rows/data (lock historical cells with sheet protection). Track change...

Need to build an ai agent in copilot studio Implement adaptive pricing 1. Gather competitive pricing data Copilot helps in gather pricing information from competitor websites and marketplaces. Microsoft Copilot icon Microsoft 365 Copilot Chat1 Prompt: Compare the price of one unit of product #12345 across U.S. retail websites 2. Sales data analysis Copilot helps analyze sales data to identify trends, such as which products are selling well at current prices and which are not. Excel icon Copilot in Excel Prompt: Create charts to analyze the provided sales data to identify trends in product performance. Include insights on sales volume, revenue generated, and any correlations with price fluctuations. Copilot helps compare pricing strategy options against costs to ensure margin struct...

I need a consultant to migrate emails from Microsoft Outlook to Apple Mail on my MacBook. It's crucial to retain the existing folder structure during the transfer, as I have a complex setup with 2200 folders in Outlook. Key Requirements: - Migrate all emails while preserving the folder structure - Experience with both Microsoft Outlook and Apple Mail - Attention to detail to ensure a smooth transition Ideal Skills: - Expertise in email migration - Familiarity with Mac systems - Strong organizational skills Looking forward to your proposals!

I'm looking for a reliable and detail-oriented freelancer to assist with various tasks, including: Data Entry: - Form filling tasks Online Research: - Gathering information on specified topics Virtual Assistance: - Managing tasks to help streamline my workflow, including Microsoft Access database management Ideal Skills and Experience: - Familiarity with Microsoft Access is a must - Experience with data entry and online research - Strong organizational skills and attention to detail - Ability to follow instructions and deliver quality results on time I am eager to grow and learn more, and I hope to find someone who can help me achieve that. Thank you for considering my project!

I'm looking for a professional to design a Microsoft Access database for managing my model train inventory, incorporating a barcode scanner and AI integration. Key Requirements: - Database should have tables to capture: - Barcode scans for train model, manufacturer, and condition - AI-powered image recognition to identify train models, manufacturers, conditions, and values. - AI Integration: Combination of pre-trained and custom models preferred - Additional Functionalities: - Inventory tracking - User access control Ideal Skills and Experience: - Proficiency in Microsoft Access - Experience with barcode scanning technology - Knowledge in AI and image recognition - Database design and implementation - Strong background in inventory management systems

I need to migrate our medium-sized on-prem Exchange environment (51-500 mailboxes) to Office 365. This should be done via hybrid configuration, and I would like to decommission the on-prem Exchange after the move. Requirements: - Migrate all emails, contacts, and calendars - No third-party tools or plugins involved Ideal Skills and Experience: - Extensive experience with Exchange and O365 - Strong knowledge of hybrid configurations - Proven track record with similar migrations - Ability to decommission on-prem systems post-migration Please provide a detailed plan and timeline.

I need assistance with querying a database to retrieve product names based on quantity within a fixed range. Requirements: - Access a database (format unknown, may require investigation) - Filter products by quantity within a provided fixed range (e.g., 10-20) - Return a list of product names Ideal Skills and Experience: - Familiarity with database querying - Experience with various database types - Ability to work with fixed range filters

I'm looking for a skilled developer to create a panel management system using the MERN stack. The platform should include: 1. **Panel Upload Interface** - Upload Excel files to parse and save into a database. - Fields: panel ID, size, location, status, etc. 2. **Panel Modification Workflow** - Update panel status (e.g., “Pending,” “Modified”) via worker or supervisor input. - Unique identifier for each panel via serial number. 3. **Pallet Management** - Assign "Ready" panels to pallets. - Generate pallet ID and store panel-to-pallet mapping. 4. **Handover Summary Generation** - Downloadable reports per pallet including panel list, readiness timestamp, and handover status. 5. **User Roles & Permissions** - Admin: Full a...

I need a WhatsApp integration with my Excel worksheet to send fee reminders. Requirements: - Use Microsoft Excel - Send reminders manually from a template - Templates should be customizable for each student Ideal Skills: - Proficiency in Excel - Experience with WhatsApp integration - Ability to create customizable message templates Database may also need to created, if required.

I need assistance organizing, managing, and storing office documents using a document management software. Requirements: - Systematic organization for easy and quick reference - Access control for secure document handling Ideal Skills: - Experience with document management software - Strong organizational skills - Familiarity with access control features

Ich möchte von einem bestehenden CRM System, das auf MS Access basiert auf Dollibar wechseln, und brauche hierfür Unterstützung