Microsoft Access Jobs

We are seeking detail-oriented freelancers to support our e-commerce business operations by maintaining accurate inventory records, updating business documents, and managing day-to-day operational data. The project primarily focuses on organizing product information, updating inventory movement, maintaining sales records, and ensuring business data remains accurate and well-structured using Microsoft Excel and Microsoft Word. Project Responsibilities: • Maintain and update inventory records • Record incoming and outgoing stock • Update sales and product information • Prepare and organize Microsoft Excel spreadsheets • Maintain Microsoft Word documents and reports • Verify data accuracy and perform quality checks • Organize business records and digital d...

I need a comprehensive monthly end cash balance report. The report should include: - Cash Flow Statement - Balance Sheet Format: Excel Spreadsheet PowerBI dashboard Detail Level: Both summary and detailed breakdown Ideal Skills and Experience: - Proficiency in Excel - Strong accounting knowledge - Experience creating financial reports -PowerBi Dashboard visualization

I need an interactive Power BI dashboard that pulls its data directly from a set of Excel workbooks I will supply. The core of the job is to connect to those sheets, model the data cleanly, and design compelling visuals that let me slice and drill down without having to touch the underlying files. You are free to suggest the most meaningful charts and KPIs once you see the data, but the refresh must remain one-click simple: whenever I replace the source Excel files, the dashboard should update automatically. If you think an additional source—such as a SQL database or an online service—would improve insights later on, please note it in your proposal; for now everything needs to function with Excel alone. Deliverables: • A fully-functional .pbix file linked to my Excel da...

**Project Title: Outlook PST File Recovery Specialist Needed – 37 GB Corrupted File** I am looking for an experienced data recovery specialist who can recover a corrupted Microsoft Outlook PST file. The PST file is approximately **37 GB**. Microsoft Outlook reports that the file is corrupted and cannot open it properly. I have already tested three different PST recovery programs, but each one was only able to recover approximately **1 GB of data**. Therefore, I am not looking for someone who will simply run common commercial recovery software. I need a specialist with proven experience in: * Recovering large and severely corrupted Outlook PST files * Repairing damaged PST structures * Recovering emails, folders, attachments, contacts, calendar items, and other Outlook data * Wor...

I need assistance in streamlining and automating various aspects of my photography business. This includes building forms, setting up database queries, and automating workflow processes. Key Tasks: - Building Booking Forms: Create comprehensive booking forms to capture client information efficiently. - Setting Up Database Queries: Establish database queries to manage and retrieve client data seamlessly. - Automating Workflow Processes: Implement automation to streamline tasks and improve overall efficiency. Ideal Skills and Experience: - Experience in form building and database management - Proficiency in workflow automation tools - Background in managing data for service-based businesses, preferably in the photography industry I have tables and basic forms started as a guideline to hel...

I'm looking for an expert to automate WhatsApp for my real estate business. The automation should: - Send property listings - Schedule property viewings - Answer common questions Integration Requirements: - Use of database and AI for syncing with spreadsheets Ideal Skills and Experience: - Experience with WhatsApp automation tools - Familiarity with real estate workflows - Proficiency in database management and AI integration - Strong communication skills Looking forward to your bids!

I need a clean, ready-to-use Excel file that lets me organise mobile numbers for my business contacts. I will be recording each contact’s name, company, designation, primary mobile number and a few optional fields such as email, city and short notes. The sheet must be simple for day-to-day data entry yet professional enough to filter, sort or search quickly when the list grows. Practical touches like data-validation on the mobile column (to ensure only 10-digit numbers), drop-downs for city or category, and conditional formatting for duplicates will help a lot. I’d also like a summary tab that instantly shows the total number of contacts and highlights any missing key details. Deliverable: one Excel workbook (.xlsx) that opens without macros on Microsoft 365, already formatte...

I want to give our in-house Microsoft Access application a cleaner, more intuitive interface without touching its underlying tables, queries, or core VBA logic. The test assignment will be a single form; once that looks and feels right we will apply the same treatment to the rest of the system. What needs attention • General layout—better alignment, comfortable spacing and padding, and clearer grouping of related fields. • Navigation—smarter use of tabs so users reach the data they need in fewer clicks. • Visual polish—modern button styles with meaningful icons, consistent font types and sizes, and a cohesive color scheme that reinforces hierarchy and readability. I will supply the current .accdb, a style guide of our corporate colors, and notes on ...

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