Microsoft Access Jobs

I need a Tableau workbook built right away that connects directly to our SQL databases and lets our analysts dig into the data on-the-fly. The core purpose is data exploration, so the dashboard should encourage quick filtering, drill-downs, and ad-hoc questioning rather than fixed executive summaries. You will receive read-only credentials to the SQL server plus a brief on the key tables and relationships. From there, I’m looking for an interactive dashboard (or set of sheets) that surfaces trends, outliers, and correlations in a way that invites further questioning. I haven’t locked in specific chart types yet, so feel free to choose the visuals—bar, line, heat map, or anything else—that best reveal insights. Because time is critical, please: • Build t...

I need a single, well-structured spreadsheet that lets me catalogue our construction options as product listings and instantly see how any upgrade affects the price. For every option I must be able to store the base description, the base price, and one or more upgrade costs. Toggling an upgrade (via checkbox, dropdown, or similar) should recalculate the option’s price and roll the difference into a running project total so I can show clients the impact in real time. Please build this in Excel or Google Sheets—whichever you’re most comfortable with—using clear formulas and clean formatting. The file should arrive fully unlocked, with an instruction tab, and ready for me to add or delete options without breaking the calculations. A quick test set of sample data is ...

I need a seasoned Power BI developer who can wire up data from our SQL databases and a series of Excel workbooks, then transform those sources into clean, reliable models. From there, you will build a polished suite of interactive reports plus an executive-level dashboard that surfaces the metrics our leadership cares about most: sales performance, customer satisfaction, and overall financial health. The finished work must feel effortless to the end user—executives should get an at-a-glance pulse, while sales and operations teams can drill down for detail. Think sleek navigation, consistent visual language, smart use of DAX, and refresh schedules that keep numbers current without manual intervention. Deliverables • Robust data model connected to SQL and Excel sources, do...

I need an Excel template to manage my cafe. It's crucial for tracking sales and expenses, managing inventory, and staff scheduling. Requirements: - Sales and expense tracking - Inventory management - Staff scheduling Ideal Skills and Experience: - Proficiency in Excel - Experience in creating templates for business management - Understanding of cafe operations I need this done ASAP.

I need a reliable pair of hands to pull pure text records from several subscription-based online databases and enter them into my existing spreadsheet template. All information is already digitised; the task is to extract, copy—or when necessary, retype—the text exactly as it appears, then slot it into the correct columns without introducing errors or extra formatting. I will give you direct links, login credentials, and a sample of completed rows so you can mirror the structure and naming conventions. The only thing that matters to me is accuracy and consistency: every entry must match the source word for word, and each field must be kept in the same order throughout the file. A quick spot-check should find zero discrepancies. Deliverable • Updated spreadsheet (Ex...

I have a collection of text and numerical records coming directly from several online databases. Your task is to pull that mixed data and reshape it so every cell matches the structure of my master template. Here’s the workflow I envision: you access the databases through the credentials I provide, export or copy the raw records, then carry out thorough data formatting—standardising dates, trimming whitespace, fixing capitalisation, aligning numeric precision, and slotting each field into my column order. The finished file should arrive back to me as a clean, ready-to-use Excel or CSV document with no stray characters or mismatched headers. A quick pivot-table or sort test on your side to confirm everything lines up is enough; I’m not asking for deep verification, j...

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

We are looking for an experienced instructor/course creator to develop a complete MS Access Course in Hindi, suitable for beginners and intermediate learners. The course will be used for our computer institute and online platforms, so full commercial rights are required. The course must be: • Faceless (screen recording only) • High-quality 1080p output • Clear voiceover in Hindi • Practical, example-based, and structured lesson-wise A strict IP Ownership Agreement must be signed before starting the project. Course Requirements: • Total Duration: 8–10 hours • Language: Hindi • Content Type: Screen recording + voiceover • Topics must cover: Introduction to MS Access Database concepts Tables creation & relationships Queries (Simple, Advan...

I need an organized project template to streamline our workflow and enhance business development. I need help designing a format and structure in Asana. This project is Asana-specific. This template should cover: Task Management: Track and manage tasks efficiently. Communication: Facilitate seamless team communication. File Sharing: Organize and share files easily. Additionally, I require a well-structured portfolio report format in Excel. We are a small business and will have 10 or so users on the project management program. Ideal Skills and Experience: - Proficiency in Microsoft Office Suite - Experience with Asana or similar project management tools - Strong organizational skills - Excel expertise for report creation

I want to turn Excel into a lightweight dashboard that fetches key fundamentals for any US-listed company I enter. Beyond what Excel provides natively, the sheet needs to pull items such as free cash flow, long-term debt, EPS, and other basic line-items that appear for free on services like Yahoo Finance or Alpha Vantage. The data should refresh in two ways—automatically on a schedule and manually with a button—so I can choose between hands-off updates or ad-hoc pulls whenever I’m in the mood to analyse a new ticker. Whether you use Power Query, VBA, Office Scripts, or a mix, the final workbook must stay portable, require no paid API keys, and let me add additional metrics later with minimal fuss. Deliverables • An unlocked .xlsx/.xlsm containing: –...

I have a client who is an individual taxpayer who missed the original deadlines and now need to regularise two years of Income Tax Returns. The work involves application with the Delhi jurisdictional officer and, once approval is granted, completing the e-filing of my ITR for both FY 2022-23 and FY 2023-24. Deliverables I expect: • Lodge the condonation-of-delay request in Delhi, including any follow-up until acceptance • Prepare and e-file accurate ITRs for FY 22-23 and FY 23-24 on the Income-tax portal • Provide acknowledgement copies, computation sheets, and any communication received from the department Once everything is accepted, I’d like a brief summary of the steps taken and final status for my records.

I am setting up a small-scale information system and need hands-on help with the database side of things. The technical focus is clearly on database management—designing simple tables, defining relationships, writing basic SQL queries, and showing me how to keep everything tidy and backed up. Because I’m still at the beginner stage, I’m looking for someone who can walk me through each step patiently, explain core concepts such as normalization, indexing, and basic security practices, and leave me with clear, reusable examples (scripts, ER diagrams, short notes). Soft skills matter as much as the technical ones. I value clear communication, the ability to break down problems into manageable pieces, and a collaborative attitude that encourages questions. If you can pair co...

I am setting up a small-scale information system and need hands-on help with the database side of things. The technical focus is clearly on database management—designing simple tables, defining relationships, writing basic SQL queries, and showing me how to keep everything tidy and backed up. Because I’m still at the beginner stage, I’m looking for someone who can walk me through each step patiently, explain core concepts such as normalization, indexing, and basic security practices, and leave me with clear, reusable examples (scripts, ER diagrams, short notes). Soft skills matter as much as the technical ones. I value clear communication, the ability to break down problems into manageable pieces, and a collaborative attitude that encourages questions. If you can pair co...

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

We are looking for an experienced instructor/course creator to develop a complete MS Access Course in Hindi, suitable for beginners and intermediate learners. The course will be used for our computer institute and online platforms, so full commercial rights are required. The course must be: • Faceless (screen recording only) • High-quality 1080p output • Clear voiceover in Hindi • Practical, example-based, and structured lesson-wise A strict IP Ownership Agreement must be signed before starting the project. Course Requirements: • Total Duration: 8–10 hours • Language: Hindi • Content Type: Screen recording + voiceover • Topics must cover: Introduction to MS Access Database concepts Tables creation & relationships Queries (Simple, Advan...

URGENT licensed PI with honest intentions.. I need to set up view-only access to (fiances) entire Dropbox account for 1 users. Requirements: - Configure access for 1 users - Set up view-only permissions for entire account Ideal skills and experience: - Experience with Dropbox account management - Familiarity with permission settings and user access controls - Attention to detail to ensure correct setup

I need an Excel-based dashboard, powered by clear, maintainable macros, to turn raw operational data into an at-a-glance performance story. The workbook should pull in the data I provide, refresh with a single button, and present the results in a clean, board-ready layout that highlights three core KPI groups: • Efficiency metrics • Productivity metrics • Quality metrics Beyond the tables and charts, I want thoughtful touches—conditional formatting that calls out exceptions, slicers or dropdowns to filter by date and department, and an overall design that feels modern rather than cluttered. All formulas and VBA code must be unlocked and well-commented so I can tweak them later. Deliverables • A macro-enabled Excel file (.xlsm) with dynamic visuals fo...

I run a business that pays staff every week and I want the entire payroll cycle handled accurately and on time—right from data coming in to compliant reports going out. The scope covers three core areas: • Processing payroll calculations for each weekly run, including gross-to-net, overtime, deductions, and any off-cycle adjustments. • Managing all tax, statutory and regulatory compliance steps so filings, submissions, and end-of-year forms are correct. • Providing SAP technical muscle—configuration and customization of the payroll schema and rules, smooth system integration with our HR and finance modules, plus ongoing troubleshooting whenever issues surface. I’ll supply the raw employee data and cut-off dates; you return finalized pay results, audit...

I'm seeking help to resolve an Excel crashing issue. Excel crashes when I try to set the print area and also occasionally when opening other Excel files. Requirements: - Diagnose and fix the crashing issue - Ensure Excel is stable for regular use Ideal Skills: - Experience with Excel troubleshooting - Knowledge of system compatibility and performance issues Please provide a detailed plan and any relevant experience.

I need a Microsoft Form to track law enforcement patrol logs. The form should automatically delete data after a specified timer expires. Requirements: - Log details: Officer ID and name, locations patrolled, type of patrol - Ability to set a timer for data deletion Ideal skills: - Proficiency in Microsoft Forms - Experience with data management and timers Looking for a freelancer who can ensure data security and integrity.

I need a Microsoft Access solution that reproduces my “IMPORT ENTRY SUMMARY” workflow from end to end. The database must hold product, supplier and shipment details, then return a single-screen summary view of the four charges I actually pay—import duty, VAT, excise duty and the customs processing fee—every time a new entry is saved. To make this work smoothly, please: • Build properly normalised tables for all lookup information (tariff codes, rates, suppliers, products, shipments, currencies). • Create one calculation query that fetches the correct percentages, applies them to the declared customs value and pushes the totals straight back to the form. • Design a data-entry form bound to that query. Editable fields should sit in the centre of t...

I need a single Excel file that lets me log daily expenses through a clean, form-style interface. The front sheet should present five input fields—Date, Expense Category, Remark, Amount, and Mode of Payment—and push each entry to a hidden or separate Data tab so the log stays tidy. Expense category and Mode of Payment shall be pre-defined list which can be populated even while using the form entry. e.g. original list may contain Credit Card and Saving A/C as predefined list. But, I should be able to add GPay as new mode of payment through form entry and next time it should be readily available in list I work across the Excel mobile apps on iOS and Android as well as Excel Online in a browser, so every formula, data-validation list, and button must stay fully functional on tho...

I maintain a Microsoft Access application and now need it to email invoices directly from the database. Every email should be built on-the-fly from data fields that are already stored in the relevant tables—customer name, contact details, itemised billing lines, and clear payment instructions. The goal is to press a button (or run a macro) and have Access gather the records, format the message, and send it without any manual copy-and-paste work. I am open to Outlook automation, CDO, or another method you find reliable, as long as it works from within Access and keeps everything inside the existing workflow. A clean, modular VBA solution with comments is ideal so I can tweak the template later if needed. I tried to use Microsoft Outlook as a function inside the invoice generating co...

We have a Microsoft Access application that creates about 500 monthly invoices and saves saves as pdf files to be emailed to the customers We need to add a code or create an API to send these invoices to our customers

I’m streamlining the way my team analyses Material Management, Inventory and Procurement data coming out of SAP MM. Right now everything is exported manually and re-worked in multiple spreadsheets; I’d like one robust Excel solution that pulls the SAP MM data directly, cleans it, and turns it into clear, refreshable reports. Here’s what I have and what I need from you: • Current situation: Live SAP MM environment with standard tables and existing query variants. The raw extracts are already available; integration with Excel is required so the data can be refreshed without repeat manual effort. • Goal: A single workbook (or small set of linked workbooks) that automatically imports the latest SAP MM data, performs the necessary transformations, and displays us...