Microsoft Access Jobs

I have a live SQL Server database that I want to surface in an interactive Power BI dashboard. At the moment everything sits in raw tables; there is no existing model, measures, or visuals. Your task is to connect directly to the SQL Server instance, shape the data in Power Query, build a clean star-schema model, write the necessary DAX, and design a set of clear, mobile-friendly reports. The finished dashboard should refresh on a schedule and be simple enough for non-technical users to filter, slice, and export key metrics to Excel when needed. I will supply connection details, field definitions, and a short list of business questions the dashboard must answer as soon as we start. If additional calculated columns or lookup tables are required, please create them inside the .pbix so ev...

I need one or more Excel-based project management templates that I can drop straight into my daily workflow. The focus is on clean, reusable layouts that rely only on basic formulas and functions—think SUM, IF, conditional formatting, simple date math—so anyone on the team can follow what’s happening without touching VBA, macros, or pivot tables. The end result should make it effortless to plan tasks, track progress, monitor deadlines, and see at a glance where a project stands. A clear, logical sheet structure and good cell protection rules are just as important to me as the formulas themselves, because these files will be shared widely. Deliverables • An unlocked master template and a protected “ready-to-use” version • Brief in-sheet notes or a...

I need a Power BI dashboard for financial reporting. It will connect to an SQL database and focus on cash flow statements. need someone in denver, co area. Requirements: - Connect Power BI to SQL database - Visualize cash flow statements - Create intuitive, interactive dashboard - Provide insights for financial decision-making Ideal Skills & Experience: - Expertise in Power BI - Strong SQL knowledge - Financial reporting experience - Dashboard design proficiency Looking for a freelancer who can deliver a professional and insightful dashboard within budget.

I am moving several critical datasets for an established business and need a meticulous pair of hands to finish the job quickly and flawlessly. The work involves extracting the current information, transforming it where necessary, and loading it into our new system while double-checking for completeness. We are talking about customer records, product details, financial figures—the whole stack—so every field must reconcile perfectly with the source. Speed matters; I’d like the migration wrapped up as soon as humanly possible without sacrificing reliability. If you live and breathe spreadsheets, SQL, CSV manipulation, or similar ETL tools and you enjoy documenting each step for audit purposes, you’ll fit right in. Deliverables • Fully migrated datasets in the...

I'm looking for a skilled developer to create a file management software application for Windows. The app should be designed to optimize file organization and retrieval. Core functionalities should include: - User-friendly interface for easy navigation - Efficient file sorting, searching, and retrieving - Secure user authentication for personalized access - Robust data handling capabilities Ideal skills and experience: - Proficiency in Windows application development - Strong background in file management systems - Experience with user authentication protocols - Familiarity with creating intuitive user interfaces Looking forward to your bids!

I need a PowerBI specialist who can jump in right away and turn my Excel data into a polished, interactive report I can put directly in front of a customer. The focus is on visualising customer segments, so slicers, dynamic charts, and an intuitive layout are essential. You’ll be working solely with an Excel workbook (no SQL or cloud connectors for this phase), but the finished PBIX should be designed with best-practice modelling so it can scale if I add other sources later. I’ll provide the raw file and a brief on the key customer attributes I want highlighted; your job is to transform it into a clear, presentation-ready dashboard that refreshes cleanly when the data is updated. Deliverables • PowerBI (PBIX) file with data model, visuals, and measures • A sha...

I already run our home-care clinic with a fairly complex Excel workbook and now need the same functionality, reliability, and ease of use in Google Sheets so the team can collaborate in real time. The current file covers three main areas: patient tracking, financial management, and staff scheduling/maintenance. For every patient we record medical history, appointment schedules, medication details, insurance information, diagnoses, and monthly reminders. On the staff side the workbook logs shift calendars and tracks training completion. The Google Sheets version must: • replicate all formulas, conditional formatting, data-validation rules, and pivot summaries • include simple drop-downs or protected ranges that prevent accidental edits • offer at-a-glance dashboards fo...

I already run our home-care clinic with a fairly complex Excel workbook and now need the same functionality, reliability, and ease of use in Google Sheets so the team can collaborate in real time. The current file covers three main areas: patient tracking, financial management, and staff scheduling/maintenance. For every patient we record medical history, appointment schedules, medication details, insurance information, diagnoses, and monthly reminders. On the staff side the workbook logs shift calendars and tracks training completion. The Google Sheets version must: • replicate all formulas, conditional formatting, data-validation rules, and pivot summaries • include simple drop-downs or protected ranges that prevent accidental edits • offer at-a-glance dashboards fo...

I already run our home-care clinic with a fairly complex Excel workbook and now need the same functionality, reliability, and ease of use in Google Sheets so the team can collaborate in real time. The current file covers three main areas: patient tracking, financial management, and staff scheduling/maintenance. For every patient we record medical history, appointment schedules, medication details, insurance information, diagnoses, and monthly reminders. On the staff side the workbook logs shift calendars and tracks training completion. The Google Sheets version must: • replicate all formulas, conditional formatting, data-validation rules, and pivot summaries • include simple drop-downs or protected ranges that prevent accidental edits • offer at-a-glance dashboards fo...

I need an Access 2000 program migrated to work with Windows 11. The program is currently used for data entry and storage, generating reports, and custom forms. Key Requirements: - Migrate Access 2000 without altering existing functionality - Maintain current data structure, can be local or on a shared network Ideal Skills & Experience: - Proficiency in Microsoft Access, especially legacy versions - Experience with Windows 11 compatibility issues - Strong background in database migration and integrity maintenance Please ensure the migrated program functions seamlessly on Windows 11 with no changes to current features.

Administrative worker Changewyx Provides administrative activities, prepares databases, communicates with tenants and other partners

I already run our home-care clinic with a fairly complex Excel workbook and now need the same functionality, reliability, and ease of use in Google Sheets so the team can collaborate in real time. The current file covers three main areas: patient tracking, financial management, and staff scheduling/maintenance. For every patient we record medical history, appointment schedules, medication details, insurance information, diagnoses, and monthly reminders. On the staff side the workbook logs shift calendars and tracks training completion. The Google Sheets version must: • replicate all formulas, conditional formatting, data-validation rules, and pivot summaries • include simple drop-downs or protected ranges that prevent accidental edits • offer at-a-glance dashboards fo...

I need my existing financial data pulled into a single, clean workbook that can project my business performance on an annual basis. All historical numbers are already captured in a series of scattered sheets; they simply need to be migrated, reconciled, and then used as the backbone for a forward-looking model. The finished file must automatically generate: • Revenue forecasts • Expense estimates • Cash-flow projections Please keep the structure intuitive—separate tabs for raw data, assumptions, calculations, and a clear summary dashboard. A template-style design that lets me tweak key drivers (growth rates, margins, tax, etc.) and immediately see the impact on each projection would be ideal. Microsoft Excel is my default tool, though I’m open to Google S...

My Microsoft Access database already generates customer notifications and PDF invoices, but the current Outlook-based routine fails too often. I’d like clean, well-commented VBA that switches the send function over to MailSend’s or other commercial service so every email—text body plus optional attachment—goes out reliably (about 1 000 per month). Gmail and other free services require painful authentication and we are not interested. Here is what I need from you: a self-contained VBA module (or class) that authenticates once to MailSend, Brevo or other reliable Platform and sends single messages, accepts parameters for subject, plain-text body, file path(s) for attachments, and returns any error detail back to my calling code. The routine must work from within a s...

I need a full-stack developer to turn my consolidated specification into a production-ready mobile application that runs smoothly on both iOS and Android. The goal is simple yet demanding: give our team a real-time view of everything that happens across multiple godowns and let them move, count, and bill stock without ever opening a laptop. Core flow • Maintain a clean Product Master with opening balances. • Record every Stock In (purchase or receiving) and every Stock Out (sales billing—no vendor or customer data needed). • Enable lightning-fast Stock Transfers between godowns and instantly reflect the change everywhere. • Show a Real-Time Dashboard so staff see today’s quantities at a glance. • Capture every action in an immutable audit log. ...

Our SMP requires remote administrative assistance to keep daily records accurate and documents well-presented. All work happens inside Microsoft Office and Google Workspace, so you must already feel at home with Word, Excel, Sheets, Docs, and Drive; macros or advanced formulas are a plus but not mandatory. A background of roughly 1–3 years in a similar administrative post has proven to give the right balance of independence and willingness to follow our established SOPs. The typical flow involves logging into our shared cloud folders, updating spreadsheets, tidying up weekly summaries, and handing the files back on the same day. When the school calendar demands it you may also help draft report cards or send brief notices to parents through our Gmail groups—tasks that come wit...

I’m looking to put our scattered business information in order and would like a data specialist who can take ownership of the full management cycle—from bringing raw files together to handing back a clean, reliable dataset with clear reporting. Most of the information currently lives in spreadsheets, yet I’m open to smarter solutions such as a relational database, Power Query automations, or even a lightweight CRM if it keeps us organised. Here’s what will make the project a success for me: • An initial audit that reveals what data we have, what’s missing, and how best to structure it. • A consolidation plan that tackles duplicates, inconsistent formats, and validation rules before any major work begins. • Implementation of the agreed pro...

For the next two to three weeks I need an experienced auditor to verify every piece of IT equipment across our office and record the results directly into our existing asset-management software. You will have full access to the system on day one, so proficiency with standard asset-tracking platforms is essential; no new tool purchase is required on our side. Scope of work • Physically locate and tag all laptops, desktops, servers, networking gear and peripherals • Confirm and correct serial numbers, asset IDs, locations and user assignments in the software • Flag discrepancies or missing items immediately so we can investigate while you are still onsite • Capture any supporting photos and attach them to the asset records Deliverables 1. A fully updated, reconcil...