Microsoft Access Jobs

I need a Microsoft Access database to generate site-specific construction risk assessment reports. The reports must include: - Details as per the attached word document example Ideal skills and experience: - Proficiency in Microsoft Access - Experience in database design - Familiarity with construction safety protocols I want to be able to create reports similar to the attached word document using prepopulated job steps, hazards and controls with the option to edit the controls for site specifics e.g. worksite may be controlled with temporary fencing or may just use bollards and flagging. I am currently having to cut and paste from previous documents depending on what the hazards are but this requires me to remember previous jobs and what we did. I can populate the actual details/contr...

I need a reliable administrator who can jump in right away and handle ongoing inventory data entry while I am online during Eastern Standard Time. You will be working directly inside our cloud-based inventory platform and supporting spreadsheets, updating stock levels, item descriptions, SKUs, and vendor notes as the information comes in. Accuracy is critical because these figures sync with our e-commerce storefront, so I expect careful double-checking before each save. We move quickly, yet every entry must match the source documents exactly—no rounding or shortcuts. Because this needs to be up and running ASAP, I will hop on a brief call to walk you through the workflow, field naming conventions, and file-sharing setup, then hand over credentials so you can start during the same E...

I have a live database that contains a mix of text, numeric, and coded fields that now shows inconsistencies, typos, and the occasional duplicated record. What I need is a careful set of eyes—and solid data-handling skill—to validate every row, flag or correct anything that falls outside the accepted formats, and leave me with a reliable, production-ready dataset. The work is entirely validation-driven: you will compare stored values against the reference rules I supply, normalise units, fix capitalisation, catch misplaced decimals, and make sure linked fields stay in sync. A portion of it will be manual review, but you’re welcome to speed things up with SQL queries, Excel filters, or any data-wrangling tool you prefer, as long as the final result is accurate. Deliverab...

A complete data cleaning project on a real-world e-commerce sales dataset — 600+ order records that came in with inconsistent formatting, missing values, and duplicate entries. What I did: Audited the raw file and flagged every formatting inconsistency and error Ran a duplicate check — found and removed 101 duplicate entries, leaving 500 verified, unique records Standardized formatting across the sheet: dates, currency, column widths, and headers Converted the cleaned data into a structured Excel Table with a Category Slicer for one-click, interactive filtering Result: The dataset went from unreliable and hard to read to clean, consistent, and genuinely usable — the kind a client can open, trust, and start filtering immediately, with zero explanation needed. This is the...

Project: Transport Management Desktop Software I need a Windows desktop application for my transport business. Main Requirements 1. Enter trip details only once in a Main Register form. 2. Store all records in a database. 3. Search records by Bilty Number, Date, Truck Number, or Customer. 4. Edit and update existing records. 5. Print my custom Bilty in exactly the same format as my current printed bilty with auto data fill from main register. 6. Print my custom Loading Slip using the same stored data. 7. Generate basic reports such as Daily Register, Monthly Register, Customer-wise Report, and Truck-wise Report. 8. Take database backups and restore them when needed. Master Data - Customer details - Truck details - Driver details Printing I will provide scanned copies/photos of my cu...

I run a small, fast-moving operation and I’m looking for reliable help on the administrative side so I can focus on growth. The core of the role is straightforward: keep our data clean, current, and perfectly organised each day. You’ll be working almost exclusively in Microsoft Excel and Google Sheets—importing new records, updating existing ones, running basic checks for accuracy, and preparing simple summary tables that let me see what’s going on at a glance. Because everything we do builds on accurate information, an eye for detail and a habit of double-checking your own work are crucial. Key deliverables • Daily data entry and management of our primary spreadsheets • Consistent file naming and version control so nothing gets lost • Weekly sn...

I run a small, fast-moving operation and I’m looking for reliable help on the administrative side so I can focus on growth. The core of the role is straightforward: keep our data clean, current, and perfectly organised each day. You’ll be working almost exclusively in Microsoft Excel and Google Sheets—importing new records, updating existing ones, running basic checks for accuracy, and preparing simple summary tables that let me see what’s going on at a glance. Because everything we do builds on accurate information, an eye for detail and a habit of double-checking your own work are crucial. Key deliverables • Daily data entry and management of our primary spreadsheets • Consistent file naming and version control so nothing gets lost • Weekly sn...

I run a small, fast-moving operation and I’m looking for reliable help on the administrative side so I can focus on growth. The core of the role is straightforward: keep our data clean, current, and perfectly organised each day. You’ll be working almost exclusively in Microsoft Excel and Google Sheets—importing new records, updating existing ones, running basic checks for accuracy, and preparing simple summary tables that let me see what’s going on at a glance. Because everything we do builds on accurate information, an eye for detail and a habit of double-checking your own work are crucial. Key deliverables • Daily data entry and management of our primary spreadsheets • Consistent file naming and version control so nothing gets lost • Weekly sn...

I have a set of tables sitting in a SQL Server database that need to be brought into Excel quickly and accurately for further work. This is a straightforward data-entry assignment: query the required fields in SQL Server, transfer them into a clean Excel workbook, and make sure each column matches the same naming and formatting conventions already in the database. No analysis or automation is required at this stage—just precise extraction and organised entry. Please be comfortable writing basic SELECT statements in T-SQL, handling any null or special-character values that appear, and double-checking row counts so the Excel file mirrors the source exactly. Deliver one Excel file (XLSX) with data correctly populated and ready for downstream use.

I need an automated Google Sheets setup for my plumbing business. Currently, I manage everything manually in Google Sheets, and I'm looking to streamline the process. I want to automate the following tasks: - Sales Receipts - Estimates - Invoices Additionally, the automated sheet should include: - Customer Database - Inventory Tracking - Payment Tracking Ideal Skills and Experience: - Proficiency in Google Sheets - Experience in creating automated spreadsheets - Familiarity with business management needs, especially for plumbing or similar trades

I run a small, fast-moving operation and I’m looking for reliable help on the administrative side so I can focus on growth. The core of the role is straightforward: keep our data clean, current, and perfectly organised each day. You’ll be working almost exclusively in Microsoft Excel and Google Sheets—importing new records, updating existing ones, running basic checks for accuracy, and preparing simple summary tables that let me see what’s going on at a glance. Because everything we do builds on accurate information, an eye for detail and a habit of double-checking your own work are crucial. Key deliverables • Daily data entry and management of our primary spreadsheets • Consistent file naming and version control so nothing gets lost • Weekly sn...

I have a set of tables sitting in a SQL Server database that need to be brought into Excel quickly and accurately for further work. This is a straightforward data-entry assignment: query the required fields in SQL Server, transfer them into a clean Excel workbook, and make sure each column matches the same naming and formatting conventions already in the database. No analysis or automation is required at this stage—just precise extraction and organised entry. Please be comfortable writing basic SELECT statements in T-SQL, handling any null or special-character values that appear, and double-checking row counts so the Excel file mirrors the source exactly. Deliver one Excel file (XLSX) with data correctly populated and ready for downstream use.

Cuento con una aplicación de gestión escrita en Visual Basic 5 que trabaja sobre una base de datos Access 97. Quiero modernizarla sin perder funcionalidad, añadiendo de forma prioritaria la facturación electrónica que será obligatoria en 2027. La actualización también debe incluir un módulo de correo electrónico completamente integrado. Necesito que permita: • Enviar recibos y facturas directamente desde la aplicación. • Gestionar boletines informativos a los clientes. • Adjuntar archivos de cualquier tipo (PDF, XLS, imágenes, etc.). Una vez cubierta la parte de e-mail, quiero habilitar el envío de notificaciones mediante la API de WhatsApp Business, con plantillas editables y...