Microsoft Access Jobs

I need a small desktop tool that pulls test results from my existing Microsoft Access database, funnels the data through Excel where the calculations and layouts already live, and then exports a polished Chemicals Tests Analysis Report as a PDF at the click of a button. Everything must run seamlessly inside the Office environment—VBA, Access macros, or an embedded .NET add-in are all acceptable as long as the final workflow is fast and maintenance-friendly. The interface can remain simple: a form where I choose the batch, confirm the parameters, and hit “Create Report”; the program should handle all data joins, call the Excel template, populate it, and save or print the finished PDF. Key deliverables • Automated routine that connects to the current Access tables...

I have several business-critical Excel spreadsheets that I want transformed into clear, interactive dashboards inside Power BI. The job starts with connecting those workbooks, cleaning and modelling the tables so they refresh smoothly, and then designing visuals that let any stakeholder spot trends, outliers and KPIs at a glance. You’ll have freedom over DAX measures and layout as long as the end result meets these acceptance points: • One unified data model that auto-updates when the source files are replaced in the same folder • At least three slicer-driven report pages combining charts, tables and cards for quick drill-downs • Clear colour styling and titles so non-technical users understand every visual without extra guidance • A short hand-off note exp...

I’m looking for an experienced FP&A / Financial Modeling professional to help rebuild and improve several of my monthly reporting files. The current files are functional but need to be cleaned up, streamlined, and redesigned to make the reporting more insightful, easier to maintain, and visually clearer for management review. What I need help with: Rebuilding and organizing existing monthly reporting workbooks Improving structure, formulas, and overall workflow Designing cleaner dashboards and management reporting views Recommending better ways to present KPIs, trends, and financial performance data Automating repetitive reporting tasks where possible Creating scalable templates that can grow with the business Ideal candidate: Strong FP&A background Advanced Excel Exper...

I have a finished Word document that explains an introductory database course project. I now need that content presented as a PowerPoint deck with more than 20 slides. The text should be transferred faithfully; each major heading or section in the document should become its own slide or short sequence of slides so the flow remains clear to students. Please keep the styling simple but polished: use one consistent font family and a unified colour palette across every slide. No extra visual-aid design, animations, or heavy graphic work is required—clarity and uniformity are the priority. Any tables, code snippets, or diagrams already in the Word file should appear on the corresponding slides, formatted so they are easy to read when projected. Deliverables: • Editable .pptx file c...

I need a dependable right-hand who can keep our customers happy while ensuring day-to-day admin work never slips through the cracks. Your core focus will be customer service—specifically resolving issues and complaints and keeping every customer account up to date—using the same simple toolkit we already rely on: email and shared spreadsheets. Beyond that main responsibility, you’ll also lend support with light sales follow-ups, basic CRM data entry, report writing, order processing, and occasional coordination with our logistics partners. Good written and spoken English is essential because most interactions happen through email or quick calls, and clear communication keeps both our customers and internal team on the same page. Basic computer literacy is all that&rsqu...

I'm seeking an experienced Power BI specialist to create a dashboard focused on procurement metrics. The data will be sourced from Excel spreadsheets. Key Requirements: - Dashboard Creation: Design and develop a comprehensive Power BI dashboard. - Data Integration: Pull and integrate data from multiple Excel spreadsheets. - Visualization: Create clear and insightful visualizations for procurement KPIs. Ideal Skills: - Proficiency in Power BI - Expertise in Excel data manipulation - Strong data visualization skills - Experience with procurement metrics is a plus Please provide samples of similar work. Looking forward to your bids!

I need a specialist who can take my SAP GRC landscape from blank-slate to production-ready. The scope covers both Access Control and Process Control. Access Control I expect full configuration of User Access Management as well as Risk Analysis and Remediation. That means defining the ruleset, activating workflow for provisioning, setting up firefighter / emergency access, and proving the risk analysis reports show clean, actionable data. Process Control On the Process Control side I want Compliance Management, Policy Management, and Control Monitoring up and running. This includes creating the master data (sub-processes, controls, surveys), integrating with ECC/S4 for automated control tests, and publishing policies so they are visible in the work center. Integration & documenta...

I need an Excel sheet to record users for applications access review. The data should be organized in a pivot table for detailed analysis. This project involves an Applications Access Review, starting with two applications containing sensitive information. The goal is to clean up user access by gathering a list of users from each department in the company. These users will be reviewed, categorized, and unnecessary access will be eliminated. You need to record the following information: - User ID and names - Access levels and permissions - Last access date - Department - Inactive user And any other information that you recommend Ideal skills and experience: - Proficiency in Excel, especially with pivot tables - Experience in data organization and management - Attention to detail

The goal of this project is to improve warehouse and logistics operations through accurate data management, shipment tracking, inventory control, and process optimization. The freelancer will deliver: - Custom Excel templates for daily operations, inventory management, shipment tracking, and MIS reporting. - Automated dashboards and reports using Excel formulas, Pivot Tables, and charts. - Process optimization suggestions to enhance productivity and reduce delays. - A tracking system for order status, rider performance, and inventory accuracy. - Data analysis support to identify operational issues and improve workflow efficiency. - Easy-to-use formats for daily use by warehouse and logistics teams.

Every time I open VisionPoint to create a new purchase order, “ghost” line-items appear—records that were never added, don’t show on the printed PO, yet linger in the database and stop me from saving. The problem started the moment I tried entering a fresh purchase order and now happens on every single attempt. I need someone who knows their way around VisionPoint’s backend (tables, data integrity routines and any related SQL/Visual FoxPro utilities) to: • Locate the underlying cause of these ghost items. • Clean the current data so no phantom records remain. • Validate that new purchase orders save and print correctly without introducing more stray records. • Provide a brief summary of what was fixed so I can prevent a repeat. If ...

I already have a fully-built Power BI report that pulls our Balance Sheet and Profit & Loss, but some numbers are off. I’ve traced the issues to data discrepancies in the Assets and Liabilities sections of the Balance Sheet and similar discrepancies flowing through to the P&L. Here’s what I need from you: • Open the existing .pbix, trace the data sources, queries, and measures, and identify why the Assets and Liabilities figures are wrong. • Apply the same rigorous check to the P&L so every figure aligns with our source ledger. • Once everything reconciles, deliver a clean, version-controlled .pbix file with all discrepancies fixed and clearly documented. I work in a standard Microsoft stack (SQL Server + Excel feeds), so familiarity with Pow...

I need to retire my old Microsoft Access commission-tracking database and move everything to a cloud-based interface that staff can reach from any browser. You will start with the full Access file (forms, queries, VBA, and data) and rebuild the same business logic online. Two elements must make the jump intact: • Customizable commission calculations that let me change rates, tiers, and effective dates without touching code. • Built-in reporting and analytics so managers can slice results by salesperson, product line, and period, then export to Excel or PDF. Beyond those, I’m happy to discuss best practices—user authentication, audit trails, or dashboards—if they fit naturally into the new architecture. I have no fixed preference for the front-end stack; f...

I need an organized individual to review and update my 5000 contacts and add new contacts as they come in with notes. The initial work will be supported by me to help focus/delete certain contacts. Eventually will want regular support, probably monthly to update the latest contacts. Key Tasks: - Validate existing contacts - Find new positions/companies for outdated contacts - Update spreadsheet/contact card - Capture new business cards with notes - Enter new contacts into Apple database Ideal Skills & Experience: - Proficiency with Apple & Outlook Contacts - Strong attention to detail - Experience managing and organizing databases - Ability to provide a detailed project proposal, how will you go about validating the contact, find new details if required, not use too much time on...

I need a Microsoft Access document to track important data, specifically to import from Excel files. Key requirements: - Ability to import data from Excel (XLS/XLSX) files - User-friendly interface for data tracking - Secure and organized data storage Ideal Skills and Experience: - Proficiency in Microsoft Access - Experience with data import from Excel - Strong database design skills - Attention to detail and data accuracy Please provide samples of previous Access projects if available.

Make a professional banking app in Microsoft access format. Currency preferably in (K) Zambian kwacha It should be able to collect customer, account, and transaction details e.g. bank statements, loan details.