Microsoft Access Jobs

I have a detailed psychosocial-hazard risk matrix in Excel, yet my external clients find it clunky. I want that content transformed into a streamlined WHS / Psychosocial Hazard Management system that is fully compliant with Australian Government requirements and incorporates TOOCs coding from end to end. The platform must let each client log in, complete assessments, and instantly see their risk profile without touching a spreadsheet. To achieve that, these elements are non-negotiable: • Risk assessment forms that replicate (and improve on) the logic of the current matrix • User-management so I can create, suspend, or edit client accounts myself • Reporting that delivers standard, fully-customisable, and real-time analytic views, exportable to PDF/Excel for audit p...

I'm seeking an expert to develop SQL document templates specifically for Comarch Optima. The templates will be used to generate essential business documents such as: - Order Confirmations - Invoices - Packing Lists Ideal Skills and Experience: - Proficiency in SQL and Comarch Optima - Experience in creating SQL templates for business document generation - Familiarity with handling financial, inventory, and customer data Please provide examples of similar work done. Looking forward to your bids!

I have a set of records that must be keyed directly into our Microsoft SQL Server database. Everything needs to be done by hand—no automated import tools—so each field is checked for accuracy as it goes in. Here is how the work will flow: • I supply the table schema, any lookup lists, and clear formatting rules. • You receive the source files and a secure connection to the database. • As you enter each record, you verify mandatory fields, follow the naming conventions, and flag anything that does not align with the guidelines. • When the batch is complete, you run a quick count against my control totals so we know everything landed where it should. The goal is simple: a clean, fully populated SQL Server table with zero duplicates and no missing...

I want to rebuild my Service-based company’s books in Tally from the ground up so every future report comes out clean and reliable. The job covers three tightly linked pieces of work: 1. Create a fresh, well-structured book of accounts in Tally, including accurate opening balances. 2. Map all necessary taxation ledgers so GST and other statutory obligations flow automatically into P&L and Balance Sheet. 3. Organise inventory inside Tally—stock items, units of measure and godowns—so the system tracks quantities and values in real time. The software is already installed and in daily use; what I need is an expert who can reconfigure it properly, migrate the existing data and leave me with a rock-solid chart of accounts. When everything is in place I would like: •...

Project Title: Software Development for Barcode-Based Product Information & Invoice Generation Project Description: We are looking for an experienced software developer to design and develop a system that can generate and manage barcodes for products. Objective: To create a software solution that: Generates unique barcodes for each product displayed, Stores detailed product information (e.g., product name, code, specifications, price, images, etc.). Allows scanning of the barcode to instantly retrieve product details. Enables quick generation of Photo offers (with product image and details) Key Features Required: Barcode generation (printable format) Barcode scanning functionality (via scanner or mobile device) Product database management system Upload and link product images Automatic...

Project Title: Software Development for Barcode-Based Product Information & Invoice Generation Project Description: We are looking for an experienced software developer to design and develop a system that can generate and manage barcodes for products. Objective: To create a software solution that: Generates unique barcodes for each product displayed, Stores detailed product information (e.g., product name, code, specifications, price, images, etc.). Allows scanning of the barcode to instantly retrieve product details. Enables quick generation of Photo offers (with product image and details) Key Features Required: Barcode generation (printable format) Barcode scanning functionality (via scanner or mobile device) Product database management system Upload and link product images Automatic...

I am writing to express my interest in your project regarding the consolidation of multiple Excel files into a master spreadsheet. I understand that for your system, precision, naming conventions, and data integrity are non-negotiable. Why I Am the Right Fit for This Task: I don’t just "copy and paste." I treat data entry as a technical process to ensure your system receives clean, error-free uploads: Data Scrubbing: I will use functions like TRIM and CLEAN to remove stray spaces and hidden characters that often cause upload errors. Format Integrity: I will ensure that SKUs and Descriptions remain as text, while Quantities and Prices are strictly maintained in Number/Currency format without losing decimal precision. Attention to Detail: I will proactively fl...

I'm seeking assistance to synchronize my Apple devices (iPhone and iPad) with Outlook on my Microsoft laptop. I need to sync the following data across all devices: - Emails - Contacts - Calendars Ideal skills and experience: - Expertise in Apple and Microsoft ecosystems - Proficiency in Outlook and Apple devices - Experience with email and data synchronization Please ensure all my data is seamlessly integrated and accessible on all devices. Looking forward to your bids!

I need a production-ready, web-based HR Management System that unifies three core areas: • Time & Attendance – real-time clock-in/out, leave management, overtime tracking, and the ability to record salary advances. • Payroll Processing – automated calculations tied to the attendance data, statutory deductions, and downloadable payslips. • Employee Management – smooth onboarding/offboarding workflows, performance reviews, and secure document storage for contracts, IDs, and policies. Security, role-based access, audit logs, and a responsive interface are must-haves. I’m open on the tech stack as long as it is modern, scalable, and well documented; propose what you do best and outline any frameworks or cloud services you plan to use. Deliver...

I need one reliable professional who feels equally at home beside a horizontal machining centre and in front of a spreadsheet. On the shop-floor you will: • Handle complete HMC machine setup and calibration, including tooling offsets and fixture alignment. • Keep the machine running smoothly during every cycle, watching tolerances, collecting in-process measurements and flagging any quality issues before they become scrap. At the desk you will: • Record the production and inspection figures you just gathered, inputting them accurately into my Google Sheets-based log. • Keep our small parts-tracking database tidy and current so anyone can pull real-time inventory and job-status reports. I will share the existing setup sheets, inspection templates and databas...

I need a cohesive set-up that lets us capture customer data in Microsoft Access and explore it visually in Power BI. Power BI The .pbix should focus on interactive visuals that let users slice, drill, and pivot customer metrics, while still giving me the flexibility to rearrange or add charts later. I will provide sample data; please structure the model so future tables can be dropped in without breaking relationships. MS Access Build an .accdb that enforces clean data from the start: intuitive entry forms, field-level and form-level validation rules, and a handful of custom reports that mirror what the dashboard will show. The database will be the single source of truth feeding Power BI, so referential integrity is critical. Deliverables • Power BI file with interactive, f...

I'm looking for an Excel expert to create a comprehensive dashboard for managing construction projects. The dashboard should track the following key metrics: - Project Progress - Budget vs Actual Costs - Resource Allocation - Baseline vs Actual Progress - Remaining Works - Milestones - Risks The ideal freelancer should have: - Advanced Excel skills - Experience in project management, particularly in the construction industry - Ability to create user-friendly and visually appealing dashboards - Strong analytical skills to ensure accurate data representation Please provide samples of previous work.

I have a live online database filled with numerical records that must be captured, verified for accuracy, and migrated into the templates I provide. You will work on an hourly basis: log in, pull each figure, double-check it matches the source, then paste it into the target sheet or form. Consistency and precision are essential, so familiarity with spreadsheets such as Excel or Google Sheets will help you move quickly while keeping error rates low. I will track progress in real time and release hours as long as the numbers you input reconcile perfectly with the database totals. If you spot discrepancies, flag them in the comments column rather than guessing. Deliverable: • Updated spreadsheet (or form) showing every assigned row completed, with notes on any anomalies you found...

I need a robust asset management database designed to track the location of physical assets like equipment and machines. Essential Features: - Real-time tracking of asset location - Maintenance history logging - Asset condition reports - Detailed asset movement logs - Current asset status updates - Tracking for both serialized and non-serialized assets - End-of-life tracking - Fault reporting - Comprehensive logs of actions taken (who did what and when) - Asset location data The ideal candidate should have experience in database design and management, particularly with real-time tracking systems. Familiarity with asset management protocols and strong attention to detail is essential.

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I already have a working Microsoft Access file that stores classes, participants, teachers and hosts for our school-trip programme. What I need now is a set of practical refinements that will let our office staff spend less time wrestling with data and more time focusing on the children. 1. Improved data-entry and registration forms • One clean form for new trip registrations that captures student details, emergency contacts and essential medical information in a logical flow. • Auto-fill and look-ups wherever possible so teachers are not re-typing the same names or addresses each term. • A printable version of this form that doubles as the parental consent sheet. 2. Advanced reporting & export tools • A ready-to-print registration/attendance l...

I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance. Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags: • Overcharged hours • Duplicate charges • Unusual expenses • Fraudulent billing Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time. Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work. Deliverables 1. One Excel file (.xlsx) containing: &nd...

I’m looking for a sleek, easy-to-read dashboard that turns my financial data into clear revenue insights. You’ll start with a spreadsheet (or database connection, if you prefer) that contains historical revenue broken down by month, product line, and region. From there, I want an interactive visual that highlights total revenue, month-over-month and year-over-year changes, plus a simple trend line. An optional alert for any dip greater than 10 % would be a nice touch. I’m flexible on the platform—Power BI, Tableau, or Google Data Studio all work as long as I can refresh the figures without fuss. Once we kick off, I’ll supply sample data and branding colours so you can match the look and feel to the company style. Deliverables: • Fully functional dashboa...

I need a seasoned Tally user to build a complete book of accounts focused on inventory management and to configure the system so I can pull accurate financial reports any time I need them. The company file has to be set up from scratch in Tally (ERP 9 or Prime), with every stock item, godown, and unit of measure properly mapped to the chart of accounts. What has to happen: • Create the inventory-centric ledger structure, enter opening balances, and enable stock tracking features. • Configure voucher types, taxation ledgers, and cost centres so that monthly profit-and-loss, balance-sheet, and stock-summary reports generate correctly without extra adjustments. • Provide a brief hand-over guide and one remote walkthrough so I know exactly how to enter day-to-day inventor...

Conduct a full review and remediation of the Microsoft Intune environment, including policy restructuring, update conflict resolution, and device preparation for upcoming user deployments. 1. Environment & Policy Remediation Audit and clean up Intune policies Review all current policy assignments (user-targeted vs. device-targeted). Correct misapplied user-level controls that caused policy conflicts on shared devices (“Intune storm” issue). Reassign policies appropriately to prevent future multi-user conflicts. Break up monolithic policies Split large policies (~20 settings in a single policy) into smaller, granular configurations. Ensure individual settings can be modified or exempted without impacting unrelated controls. Create structured Intune groups Implement...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortless. The focus is on robust reporting and analytics rather than a one-off dashboard, so the solution should be scalable and easy for me to refresh whenever new spreadsheets arrive. If you’re interested, send a detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I...

I need a keycard access control system installed at the entrance doors of our office building. Ideal Skills and Experience: - Experience with access control systems, specifically keycard systems - Familiarity with office building security requirements - Ability to work independently and ensure proper installation - Attention to detail to guarantee all access points are securely managed Please provide a detailed proposal including your experience, approach to the project, and estimated timeline.

Necesito diseñar e implementar una base de datos que centralice la información de producción, clientes e inventario de mi negocio. Todavía no he decidido si conviene un modelo relacional (SQL) o no relacional (NoSQL), así que valoro tu recomendación según escalabilidad, costo y facilidad de mantenimiento. Alcance que tengo en mente: • Modelado del esquema para datos de producción, clientes e inventarios, asegurando integridad y relaciones claras. • Funciones básicas de consulta y reporte: totales de producción por periodo, niveles de stock en tiempo real y resumen de clientes activos. • Documentación breve que detalle la estructura, credenciales genéricas, instrucciones de respaldo y c&oa...