Microsoft Access Jobs

I need a secure, internal database for my company to track medical expert witnesses and their case histories. Key Requirements: - Case history tracking: Document and retrieve details on cases each expert has worked on. - Access restricted to company employees. Ideal Skills and Experience: - Database design and development - Experience with secure access controls - Familiarity with case management systems

Build a single Power BI dashboard that pulls data live from my Excel workbooks and our SQL database, then turns that information into clear insights about customer demographics and customer satisfaction. The data model should merge both sources seamlessly, handle refresh schedules, and expose relationships that let me slice results by date, region, product line, and any other key fields you uncover. Inside the report, I want bar charts for quick comparisons, pie charts for proportional breakdowns, and line graphs that reveal trends over time—each fully interactive with tooltips, drill-through, and cross-filtering. Supply the finished .pbix file, document any custom DAX logic, and publish a ready-to-share version to Power BI Service (or show me how in a brief hand-off call). Whe...

I need reliable support handling every aspect of our customer-data intake. The work revolves around transferring, updating, and verifying records that arrive as Excel spreadsheets, scanned paper documents, or information captured through online forms. You’ll work primarily in Microsoft Excel to clean and normalise each batch, then move the validated records into our database management system, cross-checking for duplicates and completeness before you sign them off. Accuracy is critical because these entries feed directly into our customer-facing tools and reporting dashboards, so I expect a careful eye for detail as well as the discipline to maintain consistent naming conventions and field formats. Turnaround time matters: once a file or scan is shared, I’d like it entered ...

I need a custom database solution to manage sales data and customer contact details. This database should be able to generate one-page reports and spreadsheets tailored to my needs, which I will send to my clients weekly. Key Requirements: - Manage and store large amounts of sales data - Handle customer contact details - Generate customizable one-page reports and spreadsheets - Allow multiple users on the database entering and researching at the same time - Able to create PDF, Excel, Label custom reports Ideal Skills and Experience: - Experience in database design and management - Proficiency in report generation and data visualization - Strong understanding of sales data and customer information handling - Ability to create user-friendly interfaces for easy data access and report genera...

I want a sleek, self-refreshing Power BI dashboard that pulls customer counts from two sources—an Excel file and our Databricks environment—and visualises the 12-month trend for each line of business across Brand A, Brand B and Brand C. The core visual should be clean line charts with a rolling monthly view, allowing users to toggle brands or drill down by product line without losing the last-year perspective. You will work with my existing Databricks SQL endpoint (I’ll share the cluster URL and credentials) and a locally stored Excel workbook. I need the model set up so both sources refresh automatically through the Power BI gateway and any new month appended to either source rolls straight into the visuals. Deliverables • A .pbix file containing the data model, r...

ONLY APPLY IF YOU ARE ABLE TO ATTEND IN PERSON I need an IT specialist to assist IN PERSON at our ROCKINGHAM OFFICE to troubleshoot various IT issues with Microsoft Office Business Suite. Requirements: - Upgrade existing setup of Microsoft Office for Business - Troubleshoot current setup issues Ideal Skills and Experience: - Proficient in Microsoft Office applications (Word, Excel, Outlook) - Strong troubleshooting skills - Experience with setup and upgrading of Microsoft Office

I need ongoing help updating customer information inside our web-based database. I’ll supply the raw data—mostly CSV exports and the occasional scanned form—and ask you to log in to the CRM, locate the correct record or create a new one, then enter or amend names, addresses, phone numbers and email addresses exactly as provided. Accuracy is more important than speed; every field must match the source file and any uncertainty should be flagged for review rather than guessed. You should be comfortable working in English, navigating spreadsheets in Excel or Google Sheets, and moving efficiently through a browser-based CRM. Secure handling of private customer records is essential; access credentials will be issued once we have an NDA in place. Deliverables • All ...

My main Outlook data file (.ost) suddenly refuses to open, and every quick-fix I have tried has failed. I need someone who knows the inner workings of Microsoft Outlook data structures to bring the file back to life and return all my mail, contacts, and folders exactly as they were. Here is what you should know: • The file belongs to Microsoft Outlook (desktop). • The problem is simple but critical—I cannot open the OST at all; Outlook stops with an error each time. • I already attempted the usual ScanOST/ScanPST utilities and a couple of demo recovery tools, but nothing produced a usable result. What I need from you 1. Diagnose the corruption and recover the full mailbox data. 2. Supply a working file I can open directly in Outlook, or a clean PST/OST export c...

I have several Excel spreadsheets that contain our students’ information and I need every record transferred accurately into our central database. The files are already digital, so the task is purely data entry and verification—no transcription from paper is required. What matters most to me is complete accuracy, consistent formatting and a quick turnaround. You’ll receive the Excel workbooks, a short field-mapping guide that shows where each column belongs in the database, and sample finished entries for reference. Once you finish, I’ll spot-check a random selection of records for correctness and formatting consistency; if everything looks perfect, the project is complete.

I need an experienced Siemens SIMATIC PCS 7 / WinCC engineer to build a read-only connector from an existing PCS 7 DCS system to an existing Excel MIS workbook. The plant already uses PCS 7/WinCC and the Excel workbook already contains formulas and a management dashboard. The goal is to automatically extract selected DCS values and populate only the approved Excel input cells without modifying plant-control logic. The freelancer should first review the actual PCS 7 setup and recommend the safest supported method, such as Siemens-generated Excel/CSV export, OPC UA/OPC DA, OpenPCS 7, Process Historian, WinCC archives, or another approved read-only interface. Scope includes: identify the correct PCS 7/WinCC data-access method; map approximately 50–100 required tags/parameters to Exc...

I have a collection of plain-text information that needs to be transcribed quickly and without errors. Your task is to key in this text exactly as it appears, preserving spacing, capitalization, and any special characters. Speed is useful, but accuracy is essential; I will be running spot checks against the originals. The source files are ready to share once we start. I am flexible on the final output medium—Excel, Word, or an online database—so let me know which environment you are most comfortable using and I can prepare the templates. Deliverable: • A clean, fully entered text dataset returned in the agreed-upon format, free of typos and layout issues. If you have previous experience handling large volumes of text and can demonstrate a solid error-checking process, I...

Saya memerlukan sebuah database terstruktur untuk merekam Kegiatan Pelaksanaan dan Pengeluaran Biaya di lapangan. Fokusnya sederhana—saya cukup bisa memasukkan data harian, lalu menarik laporan ringkas kapan saja. Lingkup pekerjaan: • Rancang skema tabel yang memuat minimal: tanggal kegiatan, deskripsi singkat pekerjaan, nama petugas, rincian biaya, serta kolom lampiran (foto/bukti). • Buat antarmuka input yang mudah diisi—boleh berbasis Excel, Google Sheets, atau aplikasi database ringan seperti Airtable; pilih solusi yang cepat saya pelajari. • Sertakan filter dasar dan template laporan (mis. rekap mingguan/per bulan) agar saya dapat melihat total biaya serta daftar kegiatan secara real-time. • Lengkapi dengan panduan penggunaan singkat agar tim lap...