Microsoft Access Jobs

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

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

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

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

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