Microsoft Access Jobs

I already have a working estimating spreadsheet program with extensive data base. I now need to add further columns to improve the estimating spreadsheet. Here is what I’m looking for: • Add to the current spreadsheet with additional information i have. • Display the information from a data base. • Make sure the new calculations pick up the same input data fields • Provide clear, concise documentation of every new function and a short change-log so I can track what was modified. • Include a small sample project or test file showing the results of the new time calculations against known benchmarks; this will be the acceptance criterion. The existing program is stable and I have full source control access; you will receive a Git branch to work in. ...

I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistently; if you uncover ga...

I'm looking for a skilled developer to build a comprehensive customer database platform. The platform is intended to serve multiple purposes including: - Storing contact information - Managing customer interactions - Tracking sales and orders Key features of the database should include: - Ability to add new contacts via manual entry or importing from files - Storing a variety of information such as: - Personal details (name, address, phone) - Customer preferences and history - Contract information - Sales information Ideal skills and experience: - Experience in database design and development - Familiarity with data import functionalities - Strong understanding of data privacy and security - Ability to create user-friendly interfaces for manual data entry Please provide e...

I have a raw CSV that needs to become a streamlined analysis workbook. The goal is to bring the data into Excel, shape it into a named table, and layer on the tools I use most—Advanced Filters, Conditional Formatting, and PivotTables—so I can slice, summarise, and visualise the information quickly. Here’s the flow I want to see inside the final file: • Import the CSV and convert it to a properly sized, named table. • Build an Advanced Filter (criteria on a separate sheet) so I can isolate records by multiple fields. • Apply a multi-level sort to any filtered view to keep results in logical order. • Add conditional formatting that highlights key exceptions or trends; rules should be easy for me to adjust later. • Demonstrate converting th...

I have several months of raw sales data sitting in mixed Excel/CSV files and a small SQL dump. I need that information cleaned, organised, and explored so we can finally see what the numbers are really telling us. After the data is trustworthy, I want to zero-in on three priorities: revenue trends over time, customer acquisition and retention behaviour, and sales performance broken down by region. Power BI is my preferred canvas for the visuals. Please build an interactive dashboard that lets managers slice by date, product line, and region while keeping the layout simple enough for non-technical teammates. If you also know Tableau or advanced Excel, great, but the .pbix file is the deliverable that matters most. Once the dashboard is live, I’ll need a short narrative (one-to-two p...

I have a backlog of information that must be transferred quickly and accurately into an online database. The task is strictly data entry—no analysis or design work—so your attention to detail and consistency are what matter most. Here’s what the job involves: • Receive raw worksheets, PDFs, or scanned notes from me. • Enter each record into the designated fields of the database interface I provide. • Double-check for typos, duplicate records, and missing values before submitting. Although my main focus is database entry, if you feel comfortable with light spreadsheet clean-up or transcription, let me know—I may have additional work later. Deliverable: a fully populated database table that matches my source files 100 % in content and order, ...

I’m building a fresh information-capture and approval system inside Microsoft 365 and I want the whole flow—from form submission to final approval notice—running hands-free. You’ll start from a clean slate, designing Microsoft Forms that feed directly into Microsoft Lists, then wiring everything together with Power Automate so that: • data lands in the right columns without manual touch • approvals route to the correct people in sequence • email or Teams alerts fire at each stage, including rejection or completion messages I’ll provide the field requirements, user roles, and any branding assets for the form. You’ll translate that into a well-structured list, create the associated flows, test end-to-end, and hand over concise docume...

We are looking for a contract Data Engineer with hands-on experience in Microsoft Fabric to support pipeline development and data movement activities. You will help me: 1) Develop and manage data pipelines using Microsoft Fabric 2) Perform data loading and data migration activities 3) Ensure reliable and efficient data flow across systems Required Skills: 1) Strong experience with Microsoft Fabric 2) Proven experience in pipeline development 3) Hands-on exposure to data loading and data migration projects

Responsible for providing administrative and operational support using Microsoft Office applications to ensure efficient day-to-day business operations. Handles documentation, data management, reporting, and communication tasks while maintaining accuracy, confidentiality, and professionalism. Key Responsibilities: Create, edit, and format documents using Microsoft Word Prepare spreadsheets, reports, and data analysis using Microsoft Excel (formulas, pivot tables, charts) Design professional presentations using Microsoft PowerPoint Manage emails, calendars, and meetings using Outlook Maintain and organize digital files and records Input, update, and verify data with a high level of accuracy Generate regular reports and summaries for management Coordinate schedules, meetings, and de...

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...

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 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...