Microsoft Access Jobs

I’m replacing an ageing in-house tool that stores all client records and produces our invoices. I can walk you through the current system on a live demo or video recording so you see exactly how it works today and what pain points we need to fix. The core purpose of the rebuild is straightforward: handle invoicing while acting as a searchable, secure database for every transaction and customer profile we keep. Key capabilities I must have from day one: • Automated invoice generation so staff never touch a calculator again • Fully customizable invoice templates that let us swap logos, colours and legal text on demand • Robust data import/export to move historic records in and to let accountants pull data out in common formats • User access control with role-...

I want to turn our sales figures into a clear, interactive story in Power BI. Right now there is no central data source, so the first step will be helping me collect and structure the raw sales data—whether that means pulling CSV exports from our ecommerce platform, connecting to our CRM API, or setting up a small database that we can refresh automatically. Once the data is in place, you’ll handle the cleaning, transformation and modelling in Power Query and DAX, then design an engaging report that lets managers spot trends, compare product lines and track performance over time. I’m open to whichever mix of bar, line, pie or other visuals best conveys the insights, and I value your creative recommendations here. Deliverables I need from you: • A refreshable d...

I’m kicking off a proof-of-concept around Google’s new Gemini multimodal model and need an experienced hand to get the fundamentals right. Your task is to spin up a small yet extensible codebase that: • Authenticates through Google AI Studio • Accepts text (and ideally image) prompts • Returns structured JSON responses • Stores key metadata in Postgres I’d like the logic wrapped in a clean REST service so my in-house team can drop it straight into our existing stack. Python is preferred, but Node.js is fine if that’s where you shine. Please containerise everything—one `docker compose up` should bring the service online and fire a successful Gemini request using the API key I’ll supply. Deliverables • Dockerised re...

Whenever I try to move my structural model from the CAD/analysis program into Bentley RCDC I hit a wall—the import stops with the message “unable to read analysis data.” it seems related to reading analysis database using Microsoft access database engine. I need an expert who understands both the source CAD/analysis package (, based platforms or similar) and Bentley RCDC to trace the problem, and solve compatibility problems. File analysis done on STAAD PRO 2025, RCDC 2023. Have other files done in same versions capable of opening. No errors in the STAAD PRO .ANL analysis file. Acceptance criteria • The original geometry, loads and combinations remain intact. • A short note (or screen recording) shows the steps so I can repeat the fix on future projects. ...

I have several Excel workbooks that track daily sales and purchase activity. I need a specialist who can turn this raw data into meaningful MIS outputs—cleaning what is there, analysing it for trends, and presenting the results in interactive dashboards that management can use immediately. Your core tasks will be: • Import and organise the existing Excel-based data so calculations remain automated when new rows are added. • Perform thorough trend analysis on both sales and purchasing figures, highlighting seasonality, growth patterns and any anomalies that deserve attention. • Build visually clear dashboards (Power Query / PivotTables / slicers / charts) that let users drill from a high-level view down to individual transactions. Acceptance criteria: • All f...

I have product-detail inventory records stored in a database and I need them transformed into a clean, analysis-ready Excel workbook. Every numerical field—prices, dimensions, weights, reorder points—must follow one consistent format and unit, with invalid or mismatched entries corrected or flagged. I’ll share the database export and the column-naming convention I already use; your task is to extract, standardize and lay everything out so the sheet is immediately usable for look-ups, pivots and reporting. Deliverables • A single .xlsx file containing all product-detail inventory data, fully standardized • A brief changelog or notes sheet summarising the validation rules, assumptions and any issues found Accuracy and consistency are critical. If you prefer ...

I’m looking for reliable support with the full run of our daily HR administration. The bulk of the work centres on two areas that urgently need tightening up: attendance and leave. Right now everything is logged manually in paper sheets or basic Excel tabs, so I need you to rebuild this into a smarter workbook that: • calculates working hours automatically from in-out times, • refreshes attendance data in real time (as soon as new rows are entered), and • produces clear monthly summaries I can forward straight to management. Alongside that core file, you’ll handle routine HR tasks—entering new-hire data, maintaining personnel records, tracking leave balances, and preparing official letters or notices. Accurate payroll data will flow from the cleaned...

My application suddenly stopped reaching its underlying database and any direct connection attempt times out or throws generic “unable to access database” errors. Credentials have not changed and the server process appears to be running, so I suspect something deeper—possibly configuration, permission conflicts, or corruption—but I need fresh eyes to pinpoint and resolve it quickly. You will start by investigating the connection path end-to-end, identify the exact obstacle, then apply the safest fix to restore full read/write access without data loss. Please document the steps you take and any changes you make so I can keep the system stable going forward. To jump in, let me know which diagnostic checks you would run first and any information you need from me (log...

I need a detail-oriented specialist to take charge of a large batch of customer information currently sitting in Microsoft SQL Server database files. The work is twofold: first, bring new test records into the existing schema without breaking referential integrity; second, audit what is already there, flag inconsistencies, and correct them so the dataset is ready for stress-testing upcoming features. You will be working directly inside SQL Server, so fluency with T-SQL, bulk insert methods, and data validation queries is essential. Accuracy matters more than speed; I want every imported row, every updated field, and every deleted duplicate backed by a quick note or script so I can trace changes later. Deliverables (all discrete and specific): • Clean, de-duplicated customer ta...

I have a small data-processing routine that needs to live inside Power Automate. The source is Excel (or Google Sheets) files—no databases or cloud apps for now—so the job is simply to create a clean, reusable flow that picks up the sheet, applies the logic I will supply, and outputs the processed rows back to a destination we agree on. Here is what I need from you: • A new Power Automate workflow that connects to the Excel/Google Sheets connector, pulls the data, applies the mapping or transformation rules I provide, and writes the results. • Clear comments inside the flow so I can adjust it later. • A brief hand-off note (or quick Loom/video) that explains the trigger, each action, and any prerequisite permissions. Everything will be built in my Microsoft 36...

I’m looking for an extra pair of expert hands to keep several integrated security environments running smoothly. Day to day you will dip into CCTV/NVR platforms, Genetec-based VMS, Windows workstations and servers, access control panels, and the supporting LAN. When something misbehaves I’ll count on you to isolate the fault, correct it, and record exactly what was done so the fix is repeatable. Beyond urgent tickets, I also need periodic system reviews: checking firmware levels, validating camera coverage, confirming storage retention, spotting bandwidth bottlenecks, and flagging any compliance gaps. The insights you gather should flow into clear Excel reports, updated SOPs, and other technical documentation that management can act on. If you apply, highlight the depth of yo...

I recently replaced my phone and lost the Microsoft Authenticator configuration that protects my Outlook email account. Since the app was my only two-factor method, I’m now locked out. I need someone who knows the ins and outs of Microsoft Authenticator, Outlook sign-in security, and account recovery workflows to guide me through regaining full access. The focus is strictly on recovering the account, not on setting up new devices or general troubleshooting. We’ll work together in real time (screenshare or chat—whatever you recommend) to: • Navigate Microsoft’s recovery pages • Prove ownership with any backup codes or alternative verification routes that may still be available • Re-establish two-factor authentication on my new phone once ac...