Microsoft Access Jobs

Título del proyecto Interoperabilidad Historia Clínica Electrónica – SQL Server 2008 / Access 2003 Descripción Busco freelance para adaptar un sistema de salud existente desarrollado en SQL Server 2008 (compatibilidad 80) y Access 2003, para cumplir la Resolución 1888 de 2025 (Colombia) sobre interoperabilidad de la Historia Clínica Electrónica (HCE). El desarrollo debe permitir generar y exponer el Resumen Digital de Atención en Salud (RDA) a partir de la información clínica ya almacenada, garantizando interoperabilidad con otros actores del sector salud. Alcance Construcción del RDA desde la base de datos actual. Formato interoperable (XML o JSON según lineamientos). Implementación de u...

I have two Excel report sheets and need help merging and comparing data between them. The final output should be a clean, automated dashboard that presents the results clearly.

Saya memiliki kumpulan data pelanggan yang perlu dipindahkan ke format database terstruktur menggunakan Microsoft Office (Access, Excel—atau alat serupa yang kompatibel). Ruang lingkup pekerjaan: • Menyalin dan menata data pelanggan dari dokumen sumber menjadi tabel database dengan kolom standar (nama, alamat, nomor telepon, email, dsb.). • Melakukan pembersihan dasar—misalnya konsistensi huruf kapital, penghapusan spasi ganda, serta validasi format nomor telepon dan email. • Menyerahkan file database final beserta panduan singkat cara membuka dan menambah data baru. Target saya adalah data rapi, siap dipakai untuk aktivitas pemasaran dan layanan pelanggan. Saat mengajukan penawaran, mohon jelaskan pengalaman relevan Anda di pekerjaan serupa—...

Project Title MS Access CRM + Quoting + Line-Level Costing + Production Workflow (multi-user ready, split DB planned) Goal Build a complete Microsoft Access application from zero that manages: Leads → Customers → Projects → Quotes → QuoteLines (each line can have its own version v1/v2…) Line-level costing and part-level breakdown Approvals, revisions, release to production Production machine lists and phase tracking Task management for all roles Document/file linking with a standardized folder structure Reports (Quote PDF, Production Pack PDF, KPIs) Role-based login + menu + permissions Designed to be split (FE/BE) for multiple concurrent users. 1) Data Model (developer must create all tables + relationships) 1.1 Master tables Users UserID (PK, Aut...

I’m looking to acquire two complete, tutor-led courses that I can upload directly to our learning-management system: • A 7-hour Power BI program that dives deeply into Data Visualization—covering everything from choosing the right chart to designing interactive dashboards and publishing them to Power BI Service. • A 10-hour Advanced Excel program that takes a truly comprehensive approach, weaving together advanced formulas, dynamic arrays, pivot-based analysis, and the day-to-day tricks professionals rely on. Both courses must already be fully recorded in HD video with clear audio and on-screen demonstrations. I’ll need the accompanying syllabus, exercise files, assessments (if available), and the licensing terms that allow us to host the content on our priva...

I need an experienced SQL professional who can take customer data sitting on a remote SQL Server and refresh the corresponding tables on our in-house server every day. The transfer must be reliable, consistent, and handled through SQL Server Management Studio (SSMS), as that is already part of our workflow and permissions model. Your job will be to analyse the source schema, map it cleanly to our destination tables, set up the daily pull / push routine, and keep concise logs so I can trace each run at a glance. Data consistency checks, graceful error handling, and verification reports are essential because the customer records drive several downstream apps on our side. The engagement is straightforward: configure the process, prove a few consecutive successful runs, document the step...

I need a solid, one-week turnaround on a VBA solution inside Microsoft Access that links our on-premise Horizon MRP Plus database to the cloud-hosted Easy System platform (). The goal is full invoice-data automation: pull the records from Horizon, transform them to the JSON schema required by Easy System, then push and retrieve them through an SFTP endpoint. All work happens inside an existing Access front-end—tables, queries, and forms are already in place, and I can share the current VBA modules that handle local processing. What is missing is the external hand-off and the return feed, plus robust logging so accounting can see exactly what went out and what came back. Key points you’ll tackle: • Write or extend VBA routines that assemble invoice headers, line items, an...

I’m looking for a Microsoft Exchange specialist who can jump into my on-premises Exchange Server 2016 environment, identify the configuration errors that are holding it back, correct them, and then guide the full in-place upgrade to Exchange Server SE. Scope of work • Audit the existing Exchange 2016 setup (mail flow, certificates, virtual directories, receive/send connectors, Active Directory integration). • Document every configuration error you find, explain the root cause, and apply the required fixes. • Prepare the environment for Exchange SE: schema/AD prep, hardware and OS checks, prerequisite installation. • Perform the upgrade, migrate all databases and services, and keep downtime to an absolute minimum. • Run post-upgrade validation&mda...

I need a concise technical blueprint that shows exactly how to print in Cityworks environment at through SQL Server Management Studio. The goal is to make sure a field on the form "DUP. BAD CHECK “ L-If a Bad Check fee (L-BADCHECK) is attached to a case, it's owed. Status, type, etc. do not matter. Same for L-DUPLCTE. L-DUPBC - this is either or both a bad check fee and a duplicate fee from historic records (Pre-migration) 30 - BC 20 - Dupe 50 - Both (Rare, if it exists) the Cityworks front-end application, then landing it in the back-end SQL database on a batch schedule. You’ll be working with: • Cityworks PLL (latest build) • Microsoft SQL Server 2019 + SSMS What I expect from you: • A clear, step-by-step document that maps Citywor...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

Saya memiliki kumpulan data pelanggan yang perlu dipindahkan ke format database terstruktur menggunakan Microsoft Office (Access, Excel—atau alat serupa yang kompatibel). Ruang lingkup pekerjaan: • Menyalin dan menata data pelanggan dari dokumen sumber menjadi tabel database dengan kolom standar (nama, alamat, nomor telepon, email, dsb.). • Melakukan pembersihan dasar—misalnya konsistensi huruf kapital, penghapusan spasi ganda, serta validasi format nomor telepon dan email. • Menyerahkan file database final beserta panduan singkat cara membuka dan menambah data baru. Target saya adalah data rapi, siap dipakai untuk aktivitas pemasaran dan layanan pelanggan. Saat mengajukan penawaran, mohon jelaskan pengalaman relevan Anda di pekerjaan serupa—...

Saya memiliki kumpulan data pelanggan yang perlu dipindahkan ke format database terstruktur menggunakan Microsoft Office (Access, Excel—atau alat serupa yang kompatibel). Ruang lingkup pekerjaan: • Menyalin dan menata data pelanggan dari dokumen sumber menjadi tabel database dengan kolom standar (nama, alamat, nomor telepon, email, dsb.). • Melakukan pembersihan dasar—misalnya konsistensi huruf kapital, penghapusan spasi ganda, serta validasi format nomor telepon dan email. • Menyerahkan file database final beserta panduan singkat cara membuka dan menambah data baru. Target saya adalah data rapi, siap dipakai untuk aktivitas pemasaran dan layanan pelanggan. Saat mengajukan penawaran, mohon jelaskan pengalaman relevan Anda di pekerjaan serupa—...

I’m a concrete subcontractor who recently brought Trimble FieldLink into our workflow and now I need a focused trainer to get both my field crew and project managers up to speed. Scope of the sessions • Layout and Measurement – hands-on use of the RTS to stake footings, slabs, embeds and anchor bolts with live tolerances. • Point Creation and Management – building and editing point files directly from our Revit/CAD models and exporting accurate as-built data. • Software Integration & Data Management – smooth import / export between FieldLink, Tekla, Revit and our estimating database, plus naming conventions and file hygiene. Audience & format Field workers need practical job-site walkthroughs; project managers need the back-office wo...

I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest. The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply: • a sample of the Word template • the SQL schema with column descriptions • a small set of completed rows so you can confirm formatting Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry match...

Data entry, Email management, Assignments help, checking helping assistance Spreadsheet management, Database updates, Form processing

I need a brand-new Microsoft Access file that lets our small church keep all giving information in one place. The database should open with a simple membership form where I can manually add or update each giver’s name, address and contact details. Every giver must have a unique ID so that offerings entered later will always link back to the correct person. A second form will record each offering. When I choose the member’s name, the form should automatically pull in their ID; I then select the fund from a drop-down list that starts with Tithe, Building Fund, Missions, Mercy Ministries and Other. I also need the option to add new fund names on the fly without touching the table design, plus a memo area for special notes. From these two tables I want to run three practical repo...

I need the full set of customer-related records lifted from my SQL database and dropped into a single worksheet that follows a template I’ll send you. The database holds tables for customers, payments, customer relations, sales and units. Your job is to write the necessary SQL (views, joins or stored procedures—whatever is most efficient), run it, and populate the template with: • each customer’s name and contact details • their complete purchase history and account status • the matching payment, sales and unit information Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the proce...

Project Overview We have an existing Microsoft Access [Year2019/ 365] application currently split into a front-end and back-end. We need to migrate the back-end data to SQL Server Express to improve stability and multi-user performance. The front-end must remain in Access and be optimized to work efficiently with the new SQL back-end. Key Tasks & Responsibilities Database Migration: Upsize all tables from the Access .accdb/.mdb file to a SQL Server Express instance. Data Integrity: Ensure all primary keys, foreign keys, and relationships are correctly mapped and enforced in SQL Server. Table Linking: Use ODBC to link the Access front-end to the new SQL Server tables. Query Optimization: Identify and convert "heavy" Access queries into SQL Server Views or Stored Procedures...

I need help moving pure numbers from my SQL databases into a clean, ready-to-use file. I will provide read-only credentials plus a mapping sheet that tells you exactly which tables and columns feed each field in the template. Your task is to run simple SELECT queries, copy the resulting figures, and paste them into the template without introducing even a single typo. The dataset is sizeable (several thousand rows), but it is straightforward—no calculations or analysis required, just precise data entry. A basic comfort level with SQL will make the process faster, yet nothing beyond standard SELECT statements is expected. Deliverables • Completed template file (.xlsx) filled with the requested numeric values • A brief note listing any missing or suspicious entries y...

I have an Access database for managing information about friends and relatives. I use this to automatically address snail mail for birthday cards & Christmas letters etc., generate monthly birthday lists, record gifts given, and various other things. It is not a particularly good design but it serves my purposes. I have developed a few queries to create address labels in various formats. The queries work fine for couples but it gets a bit tricky to NOT include a partner if they have passed on or separated etc. It is tricky because I want to keep the information about everybody even after they have passed, but I don't want to include their name when addressing a card or letter to the remaining partner. I would rather not re-write the database and am looking for someone to creat...

We have an MS Access application (connected to MS SQL Server) that has been developed over the last 8 years. We need an MS Access developer to add features and fix errors. It is used for reporting (predefined filters on tables), sending emails, generting printouts and recording data that our ERP is not flexible enough to accept. The application needs improvements in database design (table normalisation, indexes), bug fixes, removing dead code/reports/forms and adding new features.

I'm seeking an experienced developer to integrate Paperless document management with n8n and Nextcloud. Key Requirements: - Seamless integration of Paperless with n8n workflows and Nextcloud - Experience with document management systems and automation - Ability to set up and customize workflows for efficient document handling Ideal Skills: - Proficiency in Nextcloud and n8n - Strong background in Paperless and document management - Experience with workflow automation Please provide details about your relevant experience.

I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest. The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply: • a sample of the Word template • the SQL schema with column descriptions • a small set of completed rows so you can confirm formatting Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry match...

I have a set of sales data stored in several Excel/CSV files and I need it transformed into an interactive Power BI dashboard that clearly highlights sales trends. Please connect directly to the spreadsheets (no databases or APIs involved), model the data as needed, and build a report that lets me explore performance over time as well as by product, region, or any other logical dimension you uncover. The key visualisations I want are: • Line charts to show month-over-month movement • Bar charts for quick category comparisons • Pie charts where a proportional view makes sense Feel free to add slicers and drill-throughs so I can filter by date ranges, territories, or product lines without refreshing the data source every time. Clean formatting, consistent colour usag...

I need a comprehensive, secure, and user-friendly hospital file system designed specifically for patient records. The system should be tailored for use by doctors, nurses, and administrative staff. Key Requirements: - Secure access control - Intuitive user interface - Comprehensive patient record tracking Ideal Skills and Experience: - Experience in designing secure database systems - Proficiency in UX/UI design - Knowledge of healthcare data management Please provide samples of similar work done.

I have a set of sales data stored in several Excel/CSV files and I need it transformed into an interactive Power BI dashboard that clearly highlights sales trends. Please connect directly to the spreadsheets (no databases or APIs involved), model the data as needed, and build a report that lets me explore performance over time as well as by product, region, or any other logical dimension you uncover. The key visualisations I want are: • Line charts to show month-over-month movement • Bar charts for quick category comparisons • Pie charts where a proportional view makes sense Feel free to add slicers and drill-throughs so I can filter by date ranges, territories, or product lines without refreshing the data source every time. Clean formatting, consistent colour usag...

I want a straightforward Microsoft Access + Word solution that lets me record both project and client details once, store full subcontractor profiles (company, contact, and service information), and then press a button to create a clean subcontract document in Word. Inside Access I need two user-friendly forms: one for the project/client record and another for the subcontractor record. The tables behind them should stay relational so every future project can reuse an existing subcontractor without re-typing data. A merge routine—VBA is fine—should feed a Word template that I can edit at any time. Before the final contract is generated, Word should prompt for project start and end dates, payment terms, and scope of work; those answers must land in the correct clauses autom...

I’m consolidating three very different data feeds—structured PDFs, live Excel workbooks, and a SQL database—into one clear, interactive dashboard geared toward our department-level leadership team. The end product must let a manager glance at it and immediately understand current performance, trends, and outliers without hunting through raw files. Data feeds • PDFs arrive weekly and follow a consistent layout. • Excel sheets are updated daily and already sit on SharePoint. • The SQL database (Azure) holds transactional records and updates in real time. Scope of work You will design the data-prep flow that extracts and normalises each source, then build the visual layer. KPI definitions are still evolving, so the layout needs to be flexible enough to...

I’m looking for reliable, part-time help that can keep our records spotless while stepping in as first-line tech support when something goes wrong. The core of the role is data entry—capturing customer details, updating spreadsheets, cross-checking accuracy, and preparing clean reports for upload. Because we deal with live systems, I also need someone who’s comfortable with technical support. When a user reports a glitch, you’ll diagnose software issues, adjust basic network settings, or walk them through a quick hardware check to get them back on track. You can set your own hours as long as daily tasks are cleared before the close of business. All work is remote, and I’m happy to communicate through the tools you prefer—Zoom, Slack, or email are p...