Microsoft Access Jobs

I'm seeking an experienced MS Access developer to create a STANDALONE comprehensive database for storing and managing customer information. The database's primary purpose is data storage and retrieval. It should allow me to efficiently search and filter records, and import/export data as needed. Key features required: - Hold customer names and photos of their animals, with an option to indicate if the animal is now deceased - Notes section for each contact, including dates/times of communication - Type and amount of payment for each appointment (e.g., PayPal, Zelle, $75) - Ability to create new customer records - Ability to create new appointment notes -Ability to import excel data Ideal skills and experience: - Proficiency in MS Access - Strong database design and implementa...

I need a Microsoft Access database tool designed for Annual Maintenance records of Customer Assets with service period, cost, Sr. No. etc. The database should track the following information for each piece of equipment: - Serial Number & Model Number - Maintenance History (Installation Date, Warranty Period, AMC Period) - Customer Name, Location, address, asstes installation location etc. - Value of Assets of AMC Contract, prorata basis cost Tracking - Quarterly PMS Service records, Call Records, Spare Part Records. Ideal Skills and Experience: - Proficiency in Microsoft Access, Excel - Experience in designing databases for asset management, AMC Management. - Ability to create custom reports I look forward to your bids!

I'm looking for an Excel expert to redesign and enhance my nutritional calculator. The current tool needs a comprehensive upgrade to improve its user experience, accuracy, and visual appeal. Key areas for improvement include: User Interface: Make it more intuitive and user-friendly. Formulas and Calculations: Ensure accuracy and enhance functionality. Data Visualizations: Add charts, interactive dashboards, and summary tables. Additional features to be integrated: Automated Data Import: Seamlessly pull in data from external sources. Customizable Meal Plans: Allow users to tailor meal plans to their preferences. Printable Reports: Generate user-friendly reports. Ideal Skills and Experience: Advanced Excel proficiency Experience in developing complex formulas and data visualizatio...

I need a comprehensive sales database to track both inbound and outbound sales efforts, with possible integration with Outlook email and potential CRM integration in the future. Database must be accessible from both Mac and Windows platforms The database should track: - Customer contacts and details - Sales activities and follow-ups - Deal stages and sales pipeline - Outreach efforts, times & dates, and results Ideal Skills and Experience: - Experience with database development (Microsoft Access, MySQL, or PostgreSQL) - Familiarity with email integration, particularly Outlook - Understanding of sales processes and data requirements - Potential experience with CRM systems for future integration Please provide samples of similar work.

I need help reconfiguring an Excel document that pulls data from several spreadsheets. Key Tasks: - Reconfigure existing macros to work reliably - Set up calculations and analysis as needed - Ensure daily data updates and refreshes Ideal Skills and Experience: - Proficiency in Excel and Macros - Experience with data integration from multiple spreadsheets - Strong background in data processing and analysis

I'm looking for an experienced professional to help set up the Transvirtual Transport Management System. The project involves system configuration, user training, and data migration. Key features to be set up include: - Fleet management - Driver performance tracking - Carrier management - Customer portal - Job management Ideal Skills and Experience: - Experience with Transvirtual or similar TMS - Strong system configuration skills - Ability to conduct comprehensive user training - Data migration expertise - Background in transport and logistics management

I'm seeking a skilled Microsoft Power Automate expert to design a flow that comprehensively tracks my OneDrive for Business contents. Key Requirements: - The flow should catalogue all files, folders, and subfolders in my OneDrive for Business and relay this information to a Google Sheet. - It should facilitate real-time updates of the Google Sheet in the event of any changes in OneDrive, such as the addition, creation, deletion, movement, or renaming of files or folders. - The data should be formatted according to a custom structure in the Google Sheet as follows: Folder Name, Folder Path, File Name, File Size, Created At, File Link, Folder Link Ideal Skills and Experience: - Proven expertise in Power Automate and Google Sheets. - Prior experience with real-time data synchronizati...

I need a freelancer to enter numerical data into SQL databases. Requirements: - Proficiency in SQL - Experience with database data entry - Attention to detail to ensure accuracy Ideal Skills: - Strong SQL knowledge - Database management experience - Prior data entry work with minimal supervision

I need an MS Access database for storing and managing inventory details. Key requirements: - Data storage and management - Inventory details - Search and filter capabilities - Detailed customer profiles Ideal skills and experience: - Proficiency in MS Access - Experience in database design and implementation - Strong understanding of inventory management systems - Ability to create user-friendly search and filter functionalities - Detail-oriented for developing comprehensive customer profiles Please provide examples of similar work done and ensure a smooth, efficient setup.

I'm seeking an experienced Power BI developer to create real-time reports. Requirements: - Connect to Azure SQL databases using manage identity - Real-time data updates - Focus on sales analysis, financial reporting, and operational efficiency Ideal Skills: - Proficiency in Power BI - Strong SQL knowledge - Experience with real-time data integration - Ability to create interactive, insightful dashboards Looking for quality work within budget constraints.

I need a Power BI expert to help me with a project. Key Tasks: - Fix reports and dashboards - Analyze and visualize data trends Ideal Skills: - Proficiency in Power BI - Experience with SQL and cloud data sources - Strong data visualization skills Note : write PowerBI in the start if your proposal. also my fixed budget is 100INR for couples of small changes. if you can do this with 100% of accuracy please then bid on it otherwise i will report you

Description: I recently copied a Microsoft Access database (.accdb) from my old PC (Windows 10 Pro with Office 365) to a new PC with the exact same setup (also Windows 10 Pro and Office 365). However, the database no longer works properly on the new system. It opens, but certain functions or macros do not work, or I receive error messages. What I Need: I’m looking for someone experienced with Microsoft Access to help me get the database fully working on the new PC. Details: Old environment: Windows 10 Pro, Office 365 New environment: Windows 10 Pro, Office 365 The file was copied directly without changes I can provide the file and screenshots of any error messages Remote access (e.g., AnyDesk or TeamViewer) is possible Goal: The Access database should work on the new PC exact...

I need an Access database file optimized and translated into French. Improvements needed: - Database structure optimization: - Table organization - Relationships and keys - Indexes and queries - Translate the database content into French Ideal skills and experience: - Proficiency in Microsoft Access - Strong understanding of database optimization techniques - Fluent in French, with translation experience - Attention to detail and problem-solving skills Please provide examples of similar work done.

I'm looking for an experienced database developer to build a user-friendly database using existing sales data. An Excel example can be provided. Requirements: - Filter categories: Customer, Consultant, Value, Project Status (Complete, On Hold, Live, etc.) - Ability to generate various charts: Bar, Pie, Line Ideal Skills & Experience: - Strong database management skills - Proficiency in data visualization - Experience with user-friendly interface design - Familiarity with sales data analysis Please provide samples of similar work done. Will be required to sign an NDA

I'm looking for a freelancer to create an Excel-based inventory management system for my service-based business. Each job consumes a specific amount of chemicals, so I need a reliable way to track my current stock levels. Key Features Required: - Stock Level Tracking: Monitor current chemical stocks. - Usage Reports: Detailed reports on chemical usage. - Reorder Level: Alerts when stock reaches a predefined level. - Price per Service: Integrate pricing for each service. Ideal Skills and Experience: - Proficiency in Excel - Experience in developing inventory management systems - Strong analytical skills for creating usage reports - Attention to detail and reliability Please provide samples of previous work and a brief plan on how you will approach this project.

Por favor, regístrate o inicia sesión para ver los detalles.

I'm seeking a senior-level administrative assistant to help streamline my work. Key Responsibilities: - Email management: Organize and prioritize emails. - Scheduling and calendar management: Coordinate appointments and manage schedules. - Data entry: Accurately input and update information. Ideal Skills and Experience: - Proven experience in a similar role. - Proficiency in Microsoft Office Suite and Google Workspace. - Excellent organizational and communication skills. - Ability to work independently and manage multiple tasks. Looking forward to your bids!

I am looking for an experienced C# developer to build a Windows Forms application (WinForms) in Visual Studio 2019, backed by an MS Access database. The application is designed to help a lecturer manage courses, assignments, students, and assessment rubrics, and to mark students based on rubrics. The solution must be simple, clean, and functional, with basic validation and a modular structure following object-oriented programming principles. ⸻ Core Features (Functional Requirements): 1. Lecturer Management • Store lecturer details: name, department, email. 2. Course Management • Add, update, and delete courses. • Each course has: CourseID, name, description. 3. Assignment Management • Assignments linked to a specific course. • Title, description, deadlin...

I need an expert to create Microsoft Power BI dashboards integrated with Revit models for school classroom management. The dashboards should visualize key metrics such as occupancy rates, resource usage efficiency, and spatial distribution. Requirements: - Both internal and external access to dashboards - Data from Revit models, including classroom dimensions and resource utilization Ideal skills and experience: - Proficiency in Power BI - Experience with Revit - Strong data visualization skills - Knowledge of network security for internal/external access

I'm looking for an Excel sheet to streamline farm management. The sheet will be primarily used by the farm manager. Key functions needed: - Crop Tracking: Monitor growth stages, yields, and field assignments. - Financial Management: Budgeting, expense tracking, and profit analysis. - Equipment Maintenance Scheduling: Schedule and track maintenance tasks. Data Visualizations: - Charts and Graphs: Visual representation of crop yields, expenses, etc. - Pivot Tables: Summarize and analyze data efficiently. - Dashboards: Comprehensive overview of farm metrics at a glance. Ideal Skills and Experience: - Proficiency in Excel, especially in advanced functions. - Experience in creating user-friendly and visually appealing spreadsheets. - Background in agriculture or farm management is a plu...

I need various reports created using Crystal Reports from our MIS/SQL database. The reports include: - Financial Reports: Management information reports. - Sales Reports - Inventory Reports Management information reports need to cover: - Employee performance - Operational efficiency - Production reports Ideal Skills and Experience: - Proficiency in Crystal Reports - Experience with SQL databases - Strong understanding of financial, sales, and inventory reporting - Ability to analyze and present management information effectively Looking forward to discussing this project in more detail.

I need assistance with entering data from Word documents into a database. Key Requirements: - Transfer data accurately from Word documents to a database - Familiarity with database systems (MySQL, PostgreSQL, or SQLite) - Attention to detail and speed Ideal Skills and Experience: - Experience with data entry and database management - Proficiency in Word and at least one database system - Strong organizational skills Please provide your relevant experience and estimated time to complete the task.

I'm looking for someone who can share access to a ChatGPT Pro account. Requirements: - Must allow general usage and queries Ideal Skills and Experience: - Familiarity with ChatGPT - Open to sharing account access securely

I'm looking for a skilled developer to improve an old Excel 2003 model. The current system uses VBA to read and collect live data via DDE links, but is slow and needs an upgrade. Requirements: - Collect live data into an SQL database or other similar database - Generate new files after 18,016 data points (approx. every 4 hours) - Each 500 points equals one period (4 minutes) - Display data as per the attached Excel format Ideal Skills: - Proficiency in C++ or Microsoft Visual Basic - Experience with SQL databases - Strong understanding of data collection and real-time monitoring systems Open to ideas and suggestions from coders on how to enhance this setup.

I'm seeking a Computer Science Graduate with expertise in Microsoft Access and SQL. The tasks include designing a simple database (up to 5 tables), writing SQL queries, and performing data analysis and reporting. Ideal Skills and Experience: - Proficiency in Microsoft Access - Strong SQL skills - Experience in database design - Data analysis and reporting skills - Computer Science graduate or equivalent experience - Ms Access

I'm seeking a skilled nutritionist to create diet plans tailored for children, focusing on their general nutritional needs. The ideal candidate should have a strong background in pediatric nutrition and diet plan creation. Key Responsibilities: - Develop comprehensive diet plans for children, ensuring they meet general nutritional requirements. - Work-from-home flexibility. Ideal Skills and Experience: - Extensive knowledge in nutrition and dietetics, specifically for children. - Experience in diet plan creation. - Strong understanding of general nutrition principles. - Excellent communication skills for potential virtual consultations.

I'm in need of a comprehensive Recruitment Dashboard primarily for the HR team, but for the hiring managers to access. The main goal of this tool is to effectively track candidate applications and their work preferences and availability to match temporary vacancies. I work in talent sourcing and currently use Microsoft 365, including Microsoft Forms, Excel (SharePoint-hosted), and Microsoft Bookings. I collect candidate data via Forms—including name, skills, availability, work preferences, experience, and training dates, and store it in an Excel file. I want to: 1. Build a Power BI dashboard for hiring managers with the ability to filter by candidate name, availability, work preference, training availability, skills, and experience. 2. Implement Power Automate flows to impro...

I'm looking for a proficient Excel expert to create and manage an inventory management system for me. The data to be handled pertains to my inventory. Key Features: - The system should facilitate order processing. - It should be capable of sending automated alerts for low stock levels across all items. Ideal Skills and Experience: - Extensive experience with Microsoft Excel - Proficiency in designing inventory management systems - Ability to implement automated alert systems

I'm looking for an Excel template that can assist with daily accounting tasks involved with expense tracking, invoice management, and budget forecasting. This template will need to be updated on a daily basis. Ideal freelancer should have: - Proficiency in Microsoft Excel - Previous experience in creating accounting Excel templates - Understanding of basic accounting principles - Ability to create simple tables and calculations in Excel Please note, the complexity of the template should be basic, involving simple tables and calculations only.

I'm looking for a professional who can seamlessly integrate my Google Sheets with Power BI. The main aim of this project is to facilitate automated reporting. Key Requirements: - Integration of Google Sheets with Power BI for automated reporting purposes. - Importing inventory data from Google Sheets into Power BI. - Ensuring that Power BI is updated with production data regularly. Ideal Skills: - Proficient in Power BI and Google Sheets. - Experience in handling and reporting inventory data. - Understanding of setting up automated reporting systems. Please note that the frequency of data updates in Power BI corresponds with the production data.

I'm looking for a seasoned Power BI Developer to create a comprehensive dashboard focusing on customer behavior. The project involves using website analytics data and presenting it through various visualizations. Key Requirements: - Proficient in Power BI for dashboard creation and data visualization. - Experienced in using DBeaver for database management. - Strong SQL skills for querying and fetching data from multiple tables. - Ability to analyze data and present insights clearly. The ideal freelancer will be able to utilize charts, graphs, and KPIs to create a visualization that tracks customer behavior effectively.

Looking for an experienced Excel/VBA developer to build a user-friendly Excel application with the following features: Scope of Work: 1. Search Functionality: • A clean, dashboard-style interface in Excel to search and view records. • Filters, sorting options, and easy navigation for the data. 2. Data Modification: • Users can modify existing records or add new data directly from the Excel interface. • Any add, modify, or delete actions must trigger a password prompt before proceeding. 3. Password Protection: • A custom password prompt should secure all actions involving data modification. • The password should be securely stored and not easily bypassed. 4. Backend Storage: • All data should be stored and synced with a Microsoft Access database (....