Microsoft Access Jobs

I need an Excel expert to blueprint and build a series of robust workbooks that will cover attendance, payroll, accounting, reporting, and general MIS needs. The immediate focus is thoughtful, rock-solid design; automation and long-term maintenance can come later once the structure is locked in. What absolutely must be part of every sheet: • Data validation and error checks that stop bad inputs before they corrupt formulas. • Clear, intuitive conditional formatting so unusual entries and outliers stand out at a glance. Everything should be laid out for easy auditing and future expansion. You’re welcome to lean on Microsoft 365 features—dynamic arrays, structured tables, or Power Query—if they keep the design clean and scalable. When you reply, include concr...

I'm seeking an experienced developer to create a robust Management Information System (MIS) tailored to our needs. Key Requirements: - Handle employee records, inventory details, and a database of trains and coaches. - Automated dashboard alerts for upcoming periodic maintenance. - Media uploads (JPEG, PDF, PNG, etc.) - Database management for employee and inventory records, including stock ledger, staff biodata, and attendance. - Implementation of checklists and other pertinent features. Ideal Skills and Experience: - Strong background in database management systems. - Proficiency in developing automated alert systems. - Experience with media upload functionalities. - Familiarity with creating comprehensive dashboards. Please provide examples of similar projects you've compl...

I need an expert to recover my Outlook data from a backed-up .ost file and fix my Carbonite backup setup. I no longer have access to the original email account, so the OST must be converted and restored into a new Outlook profile. Carbonite must also be reconfigured to back up Outlook correctly moving forward. Scope of Work: Audit & Restore: Access my Carbonite account, locate and restore the Outlook .ost file. Convert OST to PST: Convert the restored OST to a usable PST format using a reliable method. Basic Outlook Integration: Add the PST to my Outlook so emails, folders, and calendar are accessible. Carbonite Configuration: Adjust Carbonite settings to ensure future Outlook data (PST) is included in backups. Constraints & Notes: Timeframe: Must be completed within 1&ndash...

I want to replace several scattered spreadsheets with a single MS Access database that covers three core areas of our shop: quoting, job production, and material tracking. Quoting The quoting module must let us enter customer details and job specs, calculate pricing automatically, then generate a branded PDF quote that can be emailed to the client straight from Access. I am not asking for quote-status tracking at this stage, so the interface should stay focused and streamlined. Job Production After a quote is accepted, I need a smooth hand-off into production: create the work order, place it on a schedule, and allow real-time updates so we can see which jobs are in progress, completed, or waiting. A simple calendar or Gantt-style view is fine as long as filtering by date, machine, ...

I need an experienced Excel VBA developer to automate repetitive tasks. Ideal skills and experience: - Proficient in Excel and VBA - Experience in task automation - Ability to create and manage user forms - Knowledge of integrating VBA with other applications, especially Outlook and Access Please provide examples of previous work.

I am looking for assistance to rebuild an existing Microsoft Access database into a modern application that I can access remotely from anywhere. I currently run my business using a custom Microsoft Access system that includes: -Customer and job management -Job status tracking -Staff assignment per job -Fabric and supplier ordering per job -Attachments (job-related documents and images) -A structured front-end with forms, menus, and reports -VBA modules (including a core “mapping” module that handles business logic and workflows) The goal is to create a new application that: -Can be accessed remotely (desktop, and ideally tablet/mobile) -Supports multiple users safely -Retains the same core workflows and logic as my current system -Replaces the existing VBA “mapping&rdqu...

We are planning to develop an integrated application and desktop software system for a healthcare facility comprising five departments. These departments provide patient care, recommend diagnostic investigations (such as blood tests), and dispense medications. *Key Functional Requirements:* -Multi-Mode Payment Collection*: 3–4 cashiers working in shifts will collect payments via both online and cash methods. -Transaction Tracking & Reporting*: - Department-wise fee collection reports (segregated by online and cash payments) - Cashier-wise collection summaries - Hourly cash collection totals - End-of-day consolidated financial reports - Automated Reporting*: - Hourly reports automatically sent to the admin via email and WhatsApp -User Authentication*: - Secure login ...

I need our existing database portal to gain a simple “Export” button that lets me pull user data straight into both CSV and Excel formats. The export should all fields on the internal portal. The database is with SQL.. Once generated, the files must download instantly to the browser—no email sends or cloud hand-offs. Key deliverables • Add front-end control to trigger the export • Server-side code that queries the user table, extracts those three columns, and streams the result as CSV and .xlsx • Basic success / error messaging and a quick read-me so my in-house dev can maintain it I’ll provide portal access and a staging database as soon as we start, and I’m happy to clarify table names or column mappings. Looking forward to a clean, we...

I’m looking for reliable support that keeps our spreadsheets and data reports up-to-date every single day. Your main responsibility will be entering new figures, double-checking accuracy, and filing the refreshed documents in the correct cloud folders before the close of business. Alongside that core duty, I’ll rely on you to triage my inbox for anything related to those reports and schedule follow-ups directly on my calendar so deadlines never get missed. Light design help—think tweaking a report header in Canva or cleaning up a slide in PowerPoint—will arise from time to time, but the data entry and document management remain the top priority. Tools you should already feel at home with: Google Sheets or Excel for data handling, Drive for document organizatio...

My current Notion workspace needs a fully-structured CRM database that can track every deal as it moves through the sales pipeline. The focus is database setup and management: I want a clean relational architecture, intuitive views for reps (table, Kanban, timeline), and properties such as stage, value, probability, close date, next action, and owner. A concise dashboard that rolls up totals by stage and highlights stalled deals will round out the build. Please set everything up directly in my workspace and leave clear instructions—or a short Loom video—so I can maintain and expand it later. Deliverables • Ready-to-use CRM database template in my Notion workspace • Sales pipeline board with customizable stages and filtered views • Written or video wal...

I have a full list of current stock-on-hand that sits in another piece of software, and I need every quantity replicated inside my Tally inventory module. Only the quantities matter; product names, codes, and other information are already in Tally. Here’s what I need from you: • Export or copy the existing quantity figures from the source system (I can supply a CSV or database dump if that helps). • Enter or import those figures into Tally so that each item shows the correct closing balance. • Run a quick reconciliation report to prove that the totals in Tally match the source data exactly. Accuracy is critical—one wrong number can throw out my entire stock valuation—so I’m looking for someone who knows their way around Stock Journals, Physical ...

I have a full list of current stock-on-hand that sits in another piece of software, and I need every quantity replicated inside my Tally inventory module. Only the quantities matter; product names, codes, and other information are already in Tally. Here’s what I need from you: • Export or copy the existing quantity figures from the source system (I can supply a CSV or database dump if that helps). • Enter or import those figures into Tally so that each item shows the correct closing balance. • Run a quick reconciliation report to prove that the totals in Tally match the source data exactly. Accuracy is critical—one wrong number can throw out my entire stock valuation—so I’m looking for someone who knows their way around Stock Journals, Physical ...

I have a full list of current stock-on-hand that sits in another piece of software, and I need every quantity replicated inside my Tally inventory module. Only the quantities matter; product names, codes, and other information are already in Tally. Here’s what I need from you: • Export or copy the existing quantity figures from the source system (I can supply a CSV or database dump if that helps). • Enter or import those figures into Tally so that each item shows the correct closing balance. • Run a quick reconciliation report to prove that the totals in Tally match the source data exactly. Accuracy is critical—one wrong number can throw out my entire stock valuation—so I’m looking for someone who knows their way around Stock Journals, Physical ...

I manage a proprietary data system that needs a dependable hand for ongoing data entry and light analysis. Most of the work involves keying records directly into our custom-built database via a web interface, double-checking for accuracy, and running quick summary queries so I can spot trends in real time. Here’s what I need from you: • Enter new records as they arrive, keeping formatting and field naming consistent with our existing structure. • Validate each entry against source documents before submission. • Generate simple reports or pivot-style views when I request them so I can track volume, error rates, or category distributions. You will be given secure credentials, walkthrough videos of the interface, and a data dictionary outlining every field and i...

I have a backlog of customer details—names, contact information, purchase dates, and subscription preferences—that must be moved into a single database and left ready for report-driven analysis. You will receive several Excel/CSV files and a blank table in my cloud SQL environment (similar to a CRM schema). Your job is to map each column, enter the records accurately, normalise phone and date formats, weed out duplicates, and then upload the final file. Once the import is finished I want to run clean pivot reports and summary dashboards, so consistency is critical. If you have experience handling customer datasets that later feed analytics tools, tell me about it in your bid; that experience alone is what I’ll weigh most heavily when choosing a freelancer. Deliverables ...

All of my financial records are currently stored in several Excel/CSV files, and I need every transaction moved into Tally without re-typing a single line. The goal is a reliable import sheet that Tally will accept on the first pass, so the work focuses on accurate field mapping and clean data transformation rather than data entry. Scope • Analyse the Excel/CSV structure, map each column to the correct Tally ledger, voucher, cost centre or stock item field. • Build a Tally-ready import sheet (or set of sheets) that I can load through the built-in import function. • Flag and resolve any data issues—date formats, duplicate voucher numbers, ledger naming clashes—before the test import. • Provide a short hand-off note so I can reuse the same mapping tem...

I’m looking for reliable support that keeps our spreadsheets and data reports up-to-date every single day. Your main responsibility will be entering new figures, double-checking accuracy, and filing the refreshed documents in the correct cloud folders before the close of business. Alongside that core duty, I’ll rely on you to triage my inbox for anything related to those reports and schedule follow-ups directly on my calendar so deadlines never get missed. Light design help—think tweaking a report header in Canva or cleaning up a slide in PowerPoint—will arise from time to time, but the data entry and document management remain the top priority. Tools you should already feel at home with: Google Sheets or Excel for data handling, Drive for document organizatio...

I'm looking for a developer to create a quotation-making software for Windows. Requirements: - Must include a client database. - Quotations should be saved locally on the computer. - A save button is mandatory. Ideal skills and experience: - Proficiency in Windows application development. - Experience with database integration. Please provide samples of similar work.

I have a backlog of customer details—names, contact information, purchase dates, and subscription preferences—that must be moved into a single database and left ready for report-driven analysis. You will receive several Excel/CSV files and a blank table in my cloud SQL environment (similar to a CRM schema). Your job is to map each column, enter the records accurately, normalise phone and date formats, weed out duplicates, and then upload the final file. Once the import is finished I want to run clean pivot reports and summary dashboards, so consistency is critical. If you have experience handling customer datasets that later feed analytics tools, tell me about it in your bid; that experience alone is what I’ll weigh most heavily when choosing a freelancer. Deliverables ...

I have a backlog of customer details—names, contact information, purchase dates, and subscription preferences—that must be moved into a single database and left ready for report-driven analysis. You will receive several Excel/CSV files and a blank table in my cloud SQL environment (similar to a CRM schema). Your job is to map each column, enter the records accurately, normalise phone and date formats, weed out duplicates, and then upload the final file. Once the import is finished I want to run clean pivot reports and summary dashboards, so consistency is critical. If you have experience handling customer datasets that later feed analytics tools, tell me about it in your bid; that experience alone is what I’ll weigh most heavily when choosing a freelancer. Deliverables ...

I’m seeking reliable support on a part-time, fully remote basis to keep our database clean, up-to-date, and properly structured. The core of the role is data entry focused on database management rather than simple spreadsheet work or one-off form filling. What you’ll actually do • Log in to our cloud-hosted system daily (or as scheduled) • Enter, verify, and correct records, ensuring field formats and naming conventions stay consistent • Run quick sanity checks and basic deduplication routines • Document any anomalies or patterns that need deeper review Tools you’ll touch We work with Google Sheets as a staging area and then push everything into Airtable and occasionally MySQL, so familiarity with at least one of those platforms—and comfo...

Need a popup form built in Microsoft Access that will enable a user to add, edit, or delete associations between two tables that are stored in a third.