Microsoft Access Jobs

I have a large set of customer information stored in a database, and I need it cleaned, structured, and exported into professional-looking spreadsheets so my team can work with it easily. All of the data is already digital—no paper scanning involved—but the current tables are messy, contain duplicates, and use inconsistent field names. You’ll connect to the database directly (whether it’s MySQL, PostgreSQL, or Microsoft SQL Server—the exact engine can be confirmed once we start) and pull every customer record. From there, I’m expecting: • One master Excel or CSV file with clear, human-readable headers • Removal of duplicates and obvious data entry errors • Consistent formatting for dates, phone numbers, and addresses • A brief...

I need an experienced Power BI specialist who can dive straight into an urgent KPI dashboard build for our Bedford-based business. The model must pull live and historical data from three different sources—Excel files stored in SharePoint, our on-premise SQL databases, and several Online APIs—and blend them into a single, well-structured data model. The core story the dashboard must tell is operational efficiency: utilisation rates, throughput times, downtime causes, cost per unit, and any other DAX measures you know will help management spot bottlenecks quickly. Alongside that operational narrative I also want space for two high-level sales indicators—total revenue and sales growth rate—so leadership can see in one view how internal performance is affecting topline...

I have a busy shared Outlook mailbox and want every incoming message to be handled automatically. Using Power Automate, I need two core flows: one that sorts new mail into clear, searchable categories, and another that converts those messages into actionable tasks displayed on a live dashboard my whole team can access. The solution must sit entirely within Microsoft 365—leveraging Outlook and Power Automate—so there’s no third-party dependency and everything remains secure under our existing tenancy. If you feel a lightweight Teams tab or similar surface makes sense for the dashboard, I’m open to that, but the priority is a clean, real-time task list everyone on the team can see without extra licences or log-ins. Please build, test, and document the setup, then ...

I have a rich set of sales data that needs to be explored beyond basic reports. My goal is to uncover efficiency-focused insights—think conversion speed, revenue per call, rep productivity—and present them in an interactive, executive-ready format. You may use Tableau, Power BI, or a mix of both if it helps surface the story in the clearest way. The raw data arrives as daily CSV exports, but I can also grant read-only access to the underlying SQL database if a live connection is preferable. Once the data model is clean, I’d like a series of drill-through dashboards that let stakeholders slice performance by region, product line, and individual rep, complete with trend indicators and shareable links. Deliverables • A tidy, well-documented data model (joins, calcul...

I need help transferring a large set of mixed data—text and numbers—into one clean master file. The material arrives from two places: a batch of digital files and a couple of online databases to which I will grant read-only access. Inside the download folder you will find Excel spreadsheets, PDF documents, and Word files, each holding portions of the information. I will supply a template spreadsheet that shows the exact column order, data-type notes, and sample rows. Your job is to: • Extract every required field from each source without altering spelling, number formatting, or date style • Populate the template accurately and completely • Flag any unclear or missing values for quick clarification • Return the finished master file along with a short ...

I am looking for a sharp, proactive Executive Assistant who can keep my workday running smoothly. Your core responsibilities will center on three areas: • Calendar management – owning my schedule end-to-end so meetings are confirmed, conflicts are resolved before they happen, and I always know what’s next • Email correspondence – triaging the inbox, drafting clear replies, and flagging anything that needs my direct attention • Reviewing and coordinating team tasks – checking deliverables for completeness and accuracy, then nudging teammates to stay on target Occasional travel planning may crop up, but the day-to-day focus is on flawless coordination rather than booking flights. Attention to detail is non-negotiable; a single missed meeting or...

I have several structured Excel sheets that hold our current service records. I need every row from those files accurately entered into our live service database, preserving all field relationships and ensuring there are no duplicates. You may work directly in the database interface or prepare a clean CSV/SQL file for me to review before we import—whichever is faster for you while still keeping the data intact. The key for me is accuracy and consistency: each service line in the spreadsheet must map to the correct table and column, and any reference keys need to stay usable once the data is inside the system. After you finish, please run a quick spot-check with me so we can confirm totals and sample entries match what’s in the spreadsheet. Let me know: • the database pla...