Microsoft Access Jobs

I have a Google Sheets-based Project Management Template that needs some adjustments and additional functions. Key Requirements: - Modify existing features to better suit my project management needs - Add automated calculations to streamline data processing - Implement data validation rules to ensure data integrity - Use conditional formatting to enhance visual data representation - Integrate a Google Form to feed data into the spreadsheet - Setup SMS messaging, email alerts, estimates and invoices within the template Ideal Skills: - Proficient in Google Sheets with extensive experience in spreadsheet functionalities - Strong understanding of project management principles - Ability to implement and troubleshoot complex spreadsheet features - Prior experience with integrating Google Form...

Hello, I am looking for an experienced MS Access developer to create a comprehensive database for managing our Service & Product Invoicing Workflow. The database should include the following features: System Instructions for Service & Product Invoicing Workflow Service-Based Transactions Path 1: Contract-Based Services (Milestone Payments & Scheduled Delivery) Inquiry & Quotation: Receive client request, generate quotation, send for approval. Contract & Payment Schedule: Generate contract, define payment terms, no LPO required. Invoicing & Payment Processing: Issue invoice, accept payment, record receipt. Service Execution & Delivery: Deliver service, issue completion report, generate final invoice. Final Payment Collection & Documentation: Issue invoice...

I'm seeking a skilled database developer to enhance our existing MS Access database designed for managing school members' internships and courses abroad. The project includes fixing VBA script issues, improving database forms, and integrating with Excel for data export. Key Tasks: - Improve user interface and data validation of member registration forms - Fix issues causing slow report generation - Enable seamless data export to Excel for school administration purposes Additional Information: - 90% of tables, forms, queries, and reports are complete - Extensive documentation is available - Database platform is MS Access (Office 2016) - Table names are in German, documentary in English Ideal Skills: - Proficient in SQL and database design - Extensive experience with MS Access a...

We are looking for an Excel expert to help us automate and format our guest booking data analysis from a Google Spreadsheet. Our database contains guest details, check-in/check-out dates, booking platforms, meal plans (CP, MAP, AP), and other key details. At the end of each month/year, we need a structured report that clearly shows: ✔️ Booking source/platform-wise data breakdown ✔️ Check-in & check-out details ✔️ Meal plan categorization (CP, MAP, AP) ✔️ Custom reporting in our required format We are facing issues in organizing and extracting data in a way that meets our reporting needs. The ideal freelancer should be experienced in Google Sheets, Excel formulas, pivot tables, macros, or automation techniques to streamline this process. If you have expertise in data formatting, auto...

I'm looking for a expert to help me automate my data entry tasks, specifically for database entries. Ideal Skills and Experience: - Proficient in - Experience in automating data entry tasks - Knowledgeable in database management - Familiar with creating custom workflows - Previous work in task automation is a plus Please check this video first. Then start your cover letter with "I' have checked your attachment.".

I have an of MS Access with a series forms used for data entry and management that connects (with ODBC) to an PostgreSQL database. I'm looking for an experienced web developer to transfer (redesign) these interfaces into a responsive website format that's also mobile and tablet friendly to connect directly to the PostgreSQL database, and scrap the ms access front-end . The design needs to be fancy and modern looking. Key Points: -User authentication - Designing a web interface that replicates the functionality of the MS Access forms for data entry and management. - Ensuring that the website is responsive and works well on mobile and tablet devices. - Data integrity and security should be paramount. - Aesthetic and user-friendly interface design. Will give a sample of php, and ...

I'm looking for a professional who can assess my Task Management Access Database, which I primarily use for recording task completion. The key responsibilities will be: - Modernizing the functionality of the database - Improving the online, exportable reporting capabilities - General enhancements to the database for improved performance and usability The ideal candidate will have: - Extensive experience with Microsoft Access - Proven track record of optimizing and enhancing databases - Excellent understanding of task management processes - Ability to create interactive and user-friendly reporting systems. Please only apply if you can demonstrate relevant experience and skills. Thank you.

Project Description for Freelancer Title: Development of a Production Management Database for Metal Fabrication Facility Overview: We are seeking a skilled freelancer to create a robust database system (preferably cloud-based, like SQL) to manage the operations of our metal fabrication facility. The system will streamline project management, part and assembly lists, outsourcing processes, and production scheduling across multiple machines. Key Features Required: Database Design: Develop a relational database using SQL (preferably hosted on a cloud platform). Ensure the integration of the database with Excel data exported from Tekla Software. Data Management: Capable of managing multiple projects (10 to 50 concurrently). Each project will have its own: Part List Assembly List Outsource...

I am looking for a data entry professional to help me manage customer information sourced from online forms. The information will need to be entered into a database, so experience with database entry is essential. Key Requirements: - Input customer information from online forms into a database - Ensure accuracy and confidentiality of customer information - Experience in database entry is a must - Attention to detail and ability to maintain data integrity Ideal Skills: - Proficiency in database management - Strong attention to detail - Experience handling customer information - Commitment to confidentiality and data security

I'm seeking an MS Access and Excel expert to assist with managing pipe welding data and generating reports. Key Responsibilities: - Manage various types of welding-related data, including but not limited to: - Welding schedules - Quality control records - Welders' performance metrics - Generate insightful reports on a daily and monthly basis: - Daily welding summary - Monthly performance report Ideal Skills: - Proficient in MS Access and Excel - Experience in data management and report generation - Familiarity with welding-related data is a plus

I need a Power BI dashboard built that pulls data from five different MS lists. The data includes fleet management info, hazard/incident reports, and feedback (compliments/complaints). Key Requirements: - The dashboard should be able to be sliced by date (month and year) and region. - Visualization: I specifically want to see line graphs. - The dashboard should filter by region and month/year. Ideal Skills and Experience: - Proficient in Power BI - Experience with MS lists - Data visualization skills - Familiarity with fleet management data is a plus.

I'm looking to create a Microsoft Word add-in that assists with reviewing contracts and agreements for compliance issues. Features: - Two buttons: Scan and Review - Scan button: Uploads the text to an AI API - Review button: Highlights text in three categories (red for high risk, yellow for medium risk, green for low or no risk) based on the AI's response. The AI should specifically analyze the text for compliance issues and potential risks within contracts and agreements. I don't have a specific AI API in mind, so I'm open to suggestions. The add-in should work seamlessly with Microsoft Word, supporting the uploading of formatted text. Ideal Skills: - Proficiency in developing Microsoft Word add-ins - Experience with AI APIs - Understanding of compliance and risk ...

I'm looking for a data visualization expert to create a Power BI dashboard from my Excel database. This dashboard should be able to visualize product performance over time using various types of graphs. Key Requirements: - Use of Bar charts, Pie charts, and Line graphs - Incorporation of a date range picker for adjusting the time period of the visualizations - Replication of 5-6 graphs across 10-12 sheets Ideal Skills: - Proficiency in Power BI - Experience with Excel data manipulation - Strong understanding of data visualization techniques Please reach out if you have the necessary skills and experience.

I need an expert in WinUI 3 and Kiosk Mode setup. The task is to configure my WinUI 3 application to run in Kiosk Mode. Specific requirements will be addressed at a later stage. Ideal Skills: - Proficiency in WinUI 3 - Experience with Kiosk Mode configuration - Familiarity with Windows operating system settings and restrictions - Ability to understand and implement specific client requirements Please note that I have skipped some questions as I am still finalizing the project details.

I require a proficient MS Access 2021 developer to modify my form and subform. The goal is to enable data entry in the main form, subsequently navigating to the subform for further entries. Key Requirements: - Upon clicking the Save button, both main and subform data should be saved to the reference table. - Pressing the ESC key should result in no data being saved. - The subform should use all default fields without the need for specific alterations. - No record validation rules are necessary for the main form. Ideal Skills: - Extensive experience with Microsoft Access 2021. - Proficiency in form and subform design and modification. - Ability to implement simple control functions (e.g., Save button, ESC key). - Understanding of data saving processes within Access. Freelancers with a ...

I'm looking for a data visualization expert to create a Power BI dashboard from my Excel database. This dashboard should be able to visualize product performance over time using various types of graphs. Key Requirements: - Use of Bar charts, Pie charts, and Line graphs - Incorporation of a date range picker for adjusting the time period of the visualizations - Replication of 5-6 graphs across 10-12 sheets Ideal Skills: - Proficiency in Power BI - Experience with Excel data manipulation - Strong understanding of data visualization techniques Please reach out if you have the necessary skills and experience.

I'm looking for a seasoned developer to create a simple yet effective application in Microsoft Access for managing customer details. The application will cater to both individual clients and businesses, and it will be a multi-user system. Key Features: - 5-10 tables to store various data points - 5-10 forms for data entry and customer management - 5-10 reports for insights and analytics - An API connection with our back-office system - Capability to populate a Fillable PDF form (specifically, our Account Opening form) Essential Functionalities: - Efficient search and filter options for locating customers - Import/export options for customer data - Automated notifications for important updates or reminders Data Storage: The tables will primarily hold: - Personal information of ou...

I'm seeking an MS Access expert to develop detailed reports based on Excel format production data. Key Requirements: - Proficient in MS Access with a strong understanding of report generation - Able to analyze and interpret production data - Capable of creating detailed, comprehensive reports Ideal Skills and Experience: - Extensive experience with MS Access - Strong data analysis skills - Prior experience creating production reports is a plus

I need eight (8) financial reports generated in MS Access using VBA. These reports should be formatted in a clear and concise tabular format. I require: - Profit and Loss statements - Balance Sheets - Four different types of Profit and Loss statements and Balance Sheets using different data sets Ideal Skills: - Proficiency in MS Access and VBA - Strong understanding of financial reporting - Experience with creating tabular reports - Across tab queries Please, only apply if you have the necessary skills and experience to deliver this project.

I'm seeking a skilled professional to modify my existing MS Access database. The primary focus will be to enhance the performance of the database. Key Requirements: - Database Design: Expert-level understanding and implementation of optimal database design principles. - Modification of Existing Database: Experience in modifying existing databases to meet specific performance-related criteria. - Performance Improvement: Proven track record of improving database performance. Your bid should reflect your experience with MS Access and your ability to deliver a high-performing database.

I am seeking an expert in database design and VBA scripting for Microsoft Access. The project will primarily focus on: - Designing a comprehensive database: This includes creating tables and establishing relationships. - Programming: Specifically, I need assistance with VBA scripting to enhance the functionality of the database. Ideal candidates should possess extensive experience in Microsoft Access, with a strong background in database design and VBA programming. Please provide examples of similar projects you've completed.

I'm seeking an experienced professional to assist with migrating my current Tableau setup to PowerBI. The primary motivation behind this switch is cost reduction, as PowerBI offers more budget-friendly options. Key Details: - Current Tableau Dataset: The size of my current Tableau dataset is less than 1 GB, so this shouldn't pose a significant challenge. - Data Sources: My data is primarily sourced from SQL databases. Ideal Skills and Experience: - Proficient in both Tableau and PowerBI - Strong SQL database handling skills - Experience in cost-effective data handling and visualization - Understanding of Microsoft product integration - Excellent communication and project management skills

I need an expert in FileMaker Pro to assist in migrating my existing FileMaker Pro system to a new dedicated Windows Server. The task involves transferring all data, applications, and associated configuration with minimal downtime. Key Requirements: - Comprehensive migration of the FileMaker Pro system to the new server - Transfer of all data, applications, and associated configurations - Ensuring minimal downtime during the migration process Ideal Skills: - Expertise in FileMaker Pro - Strong understanding of Windows Server - Proven track record in server migrations Please reach out if you can help with this project.

I'm looking for a data visualization expert to create a Power BI dashboard from my Excel database. This dashboard should be able to visualize product performance over time using various types of graphs. Key Requirements: - Use of Bar charts, Pie charts, and Line graphs - Incorporation of a date range picker for adjusting the time period of the visualizations - Replication of 5-6 graphs across 10-12 sheets Ideal Skills: - Proficiency in Power BI - Experience with Excel data manipulation - Strong understanding of data visualization techniques Please reach out if you have the necessary skills and experience.

I'm looking for a professional who can help me with a project involving auto-populating data into Microsoft Word forms. Key requirements: - Sourcing form data directly from a database to populate Microsoft Word documents Ideal skills and experience: - Proficiency in Microsoft Word - Experience working with databases - Ability to create automated processes for data entry

I'm in need of a highly skilled Dynamic 365 Developer for a long-term, remote position with US shift hours. The primary focus of this role will be system integration, so a strong background in this area is crucial. Key Responsibilities: - Integrating with other Microsoft products - Connecting internal systems - Integrating with third-party applications Skills & Experience: - 6-8 years in Dynamic 365 development - Proven experience in system integration - Expertise in integrating with other Microsoft products and third-party applications - Strong problem-solving skills Please note, the hiring process will consist of two rounds of interviews. Interested candidates are encouraged to share their CVs.

1. Admin Panel: Login: - Admin login functionality with username and password for secure access. Dashboard: - Manage Students: - Add new students with their details (name, email, etc.). - View student records. - Update student scores (Listening, Grammar & Written Expression, and Reading). - View calculated total score and CEFR level. - Update Scores: - Input Listening, Grammar & Written Expression, and Reading scores for each student. - Generate and Download Results: - After updating the scores, admins can generate a PDF report for each student showing their detailed scores and CEFR level. 2. Scoring Formula The total score will be calculated using the following formula: Total Score = (Listening Score + Grammar Score + Reading Score) ÷ 3 × 10 3. CEFR...

I'm seeking an expert in Boomi who can facilitate system alerts and synchronize data between our ERP system and Slack. Key Responsibilities: - Enable real-time data sync between our ERP system and Slack - Automate system alerts to notify our team on Slack Ideal Skills and Experience: - Proven experience with Boomi and ERP systems - Strong knowledge of Slack and its integration capabilities - Excellent problem-solving skills to troubleshoot any integration issues - Ability to automate system alerts effectively This project will enhance our operational efficiency by keeping our team updated with system alerts and facilitating seamless data flow between our ERP system and Slack.

I need assistance converting PDF documents into MRT reports for financial reporting purposes.15 PDF files to be converted to MRT files to be accessed via Stimulsoft environment. Key requirements: - Converting PDF data into MRT format specifically for financial reporting - Convert PDFs to MRT with a focus on making the data suitable for HR report generation. - Ensure the MRT files accurately reflect employee information present in the PDFs. Please note that while I have not specified a preferred format for the financial reports or a level of detail, I would appreciate a freelancer who is able to provide both summary and detailed data in a combination of tabular and graphical formats. Your skills in data conversion and financial analysis will be key to completing this project successful...

I am in need of a skilled paralegal to assist me in preparing for a civil case. The primary focus of this project will be related to handling discovery documents. Ideal skills and experience for the job: - Prior experience in civil law cases - Excellent understanding of discovery processes - Proficient in document preparation and filing - Strong organizational skills - Detail-oriented

I'm seeking a skilled data analyst or business intelligence expert to create Power BI reports for our Microsoft AX 2012 Warehouse Management System. Specific Requirements: - Order Processing Reports: We need comprehensive, insightful reports that track and analyze our order processing metrics. - Stock Quantities Reports: This report should primarily focus on our inventory levels, specifically stock quantities. - Summary View: The stock quantities report should be presented in a summary view, not a detailed item view or location-based view. Ideal Skills and Experience: - Proficiency in Power BI and Microsoft AX 2012 is essential. - Previous experience in creating warehouse management system reports would be a significant advantage. - Strong analytical skills and attention to detail...

I'm looking for an expert in Service Titan to assist with setting up and optimizing my existing account. Key Tasks: - Implement and configure the following functionalities: - Scheduling and Dispatch - Invoicing and Payments - Customer Management - Migrate essential data including: - Customer data - Previous invoices - Job history Ideal Skills: - Extensive experience with Service Titan - Proficiency in data migration - Strong understanding of scheduling, invoicing and customer management systems Please note, we already have an existing Service Titan account. Looking forward to your proposal.

Land Consolidation Software. Reorganization of land owners and parcels. SQL based software. It will create result tables and reports by matching between tables. It will have CAD integration using VB Script. It will be able to produce Access based results.

I'm looking for someone to create student ID cards. The cards will need to include the student's name and photo, as well as their ID number and class/grade. Key Responsibilities: - Creating Student ID Cards: The ID cards should be designed to be professional and functional. - Maintaining a Database: A database will need to be maintained for all the ID cards created. - Scanning & Cropping: Student photos will need to be scanned and cropped appropriately for the ID cards. Ideal Skills: - Graphic Design: Prior experience in ID card design will be a plus. - Data Management: Exceptional database management skills are required. - Attention to Detail: Should have a keen eye for detail to ensure accuracy.

I'm facing a critical issue with permissions on Office 365 Teams. I'm currently unable to share documents on teams through any means - channels, direct messages, or external sharing. This is impacting my team's collaboration and productivity. Skills and Experience Required: - Proficiency in troubleshooting Office 365 Teams - Understanding of Office 365 permissions system - Ability to resolve document sharing issues - Excellent communication skills for updates and clarifications

I need assistance setting up a new email on Outlook and migrating historical data from my current email. Key Requirements: - Set up a new email address on Outlook - Save historical emails into a PST file Ideal Skills: - Experience with Outlook - Proficient in data migration and email setup - Familiarity with PST file creation