Microsoft Access Jobs

I need a new Cognos dashboard focused purely on data visualization. The dashboard will pull its figures from our existing SQL databases, so you’ll be working with relational data structures, writing efficient queries, and making sure refreshes stay fast even as record counts grow. The look and feel matter to me: clear charts, intuitive drill-downs, and a layout that lets managers grasp trends at a glance. If you have experience shaping Cognos visualizations with custom prompts, calculated fields, and conditional formatting, that’s exactly the skill set I’m after. Deliverables • A fully functional Cognos dashboard connected to the specified SQL sources • Reusable data modules and any query subjects you create • Brief setup notes so my internal admin ca...

The task is to build an interactive Power BI dashboard that visualises my organisation’s consumption volume. All data sits in a set of Excel spreadsheets and must stay synced automatically, so the model should refresh cleanly whenever new files overwrite the existing ones. Key focus • Showcase yearly comparisons of total consumption, with clear visuals that allow users to spot growth, decline, and outliers at a glance. • Simple slicers or filters for year, product line, and region (the columns are already present in the source files). • A clean layout that can be shared through the Power BI service without additional configuration on my side. Data • Excel workbooks reside in a OneDrive folder; Power BI should connect directly to that location to preserve the...

I need help to make an Excel sheet non-editable. I have already filled in all the details. Requirements: - The main sheet should be view-only, allowing users to view data only. - One specific editable sheet for me or select users. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience with cell locking and permission settings

We are looking to hire a software company that already has an existing Employee Transport / Cab Management Software for managing corporate employee pick-up and drop operations. The requirement is not to build a system from scratch, but to deploy an already developed solution and perform minor customizations based on our operational needs. The system should support key functionalities such as employee transport scheduling, cab allocation, route management, driver management, trip monitoring, and reporting through a centralized admin dashboard. Features like real-time tracking, trip monitoring, and operational reporting will be preferred. The selected vendor will be responsible for software deployment, configuration, minor customization, testing, and implementation, along with providing a ...

I need a reliable way to confirm whether a given high-net-worth individual is associated with my freemasonry verification service. For every millionaire in the list I supply—or that you source—you will provide both a verifiable street or registered business address and an official email address. The end goal is to feed those two data points into a DNS-based lookup flow similar to: Linux / Unix: `dig txt ` Windows: `nslookup -q=txt ` Because I will be running checks from machines on both platforms, the script you deliver must execute cleanly under Bash and PowerShell without any manual tweaks. An auto-detect of the OS with the right call to `dig` or `nslookup` is ideal. Deliverables: • A CSV or SQLite dataset containing each millionaire’s full name, address...

I have an Excel workbook stored on OneDrive that needs a small yet useful enhancement—a form inside the file that can look up a project in our online database and instantly return both customer and project details. When a match is found, the form should auto-populate the relevant cells; when no match exists, every field must remain editable so I can type the information in myself from scratch. The workbook is already on OneDrive, so please design the solution to run smoothly there, whether you choose built-in Excel Forms, a bit of VBA, Power Query, or a lightweight Office Script—whichever you feel is most reliable for cloud use. Key fields will include project ID, customer name, address, phone, project description, and status. All lookups reference our SQL-based database via i...

I need help bringing order to the drilling equipment and the pipes & tubing I regularly pick up at auction. My goal is a mixed system: clear, well-structured spreadsheets for quick on-site data entry paired with a light software solution that can sync those sheets, flag duplicates, and let me run basic reports. Here’s how I picture the workflow: • You’ll design the spreadsheet layout—fields for lot number, purchase date, dimensions, condition, storage location, and resale notes—so my crew can fill it out the moment a pallet arrives. • On the automated side, recommend and configure a user-friendly tool (Excel with Power Query, Airtable, or something similar) that pulls the sheet data, assigns unique IDs, and generates a dashboard I can review every ...

I need help securing an Excel file with a password. Requirements: - Password protection to open the file - Minimum password length of 8 characters Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with password protection features in Excel - Ability to create secure passwords meeting minimum length requirements

I’m working on an older 2011 copy of Microsoft Access and need a quick walk-through on how to locate specific words inside a single text-based table. This is a straightforward, basic search task—no VBA or complex macros—just the most efficient way to filter or query the records so I can spot every occurrence of a given term. If you know the built-in Find, filter, wildcard, or simple query features cold, that’s exactly what I’m after. A short screen-share or a clear set of step-by-step instructions that I can repeat later will do the trick. I won't pay a lot for this task. Please don't ask for more or I'll remove you.

I am consolidating several business processes onto Microsoft Power Platform and need a hand finishing two connected pieces: First, a set of Power Automate flows that pull and push data to Business Central, apply business rules, and notify users at key points. Second, a model-driven Power Apps application that sits on Dataverse, offers a clean data-entry experience, and launches those same flows in the background so work can move forward automatically. Key functionality required • Data entry form that validates and writes to Dataverse • Workflow automation triggered by create or update events Integration touchpoints Business Central for source and destination data, Flowgear for any non-native connectors, and Microsoft Fabric later for analytics. The core build needs to ...

I want an HSE dashboard that gives me a clear, real-time picture of our safety performance, with the main focus on monitoring safety incidents. The tool must capture and display three incident categories—Workplace injuries, Near-misses and Equipment failures—so I can compare trends side-by-side instead of jumping between separate reports. Key metrics that need to sit front and center are our Incident frequency rates, current Severity levels and an at-a-glance view of any Root cause analysis already completed. Visual cues that highlight spikes or severe events will help me direct corrective actions quickly. I’m open to whichever platform you prefer—Power BI, Tableau or a well-structured Excel model—as long as the result is interactive, easy to update from a s...

I need help pulling mixed data—both text and numbers—directly from several online databases and entering it into a clean, well-structured Microsoft Office file. Accuracy and attention to detail are critical: every value must match the source exactly, and all fields must stay consistently formatted for easy filtering and analysis later. Here’s what I expect: • Access each specified online database (I’ll provide URLs and login credentials). • Copy or export the required records, double-checking for completeness. • Enter the information into a single Microsoft Excel workbook, organizing it by the headings I supply. • Apply basic data-cleaning steps—remove duplicates, standardize date formats, and verify numeric precision. • Deliv...

I need a professional who can directly access Euroclear and supply custodian receipt reports for a forthcoming series of high-value trades involving bonds, LEI-linked issues and SPDR instruments. The task is strictly about producing a detailed report, with a particular focus on Ownership details so that my compliance desk can confirm settlement eligibility before execution. Scope of work – Retrieve the official custodian receipts from Euroclear (no secondary data feeds). – Compile the information into a clear, verifiable dossier: a signed PDF plus an editable spreadsheet. – Highlight Ownership details for every line item; other sections can follow the standard Euroclear layout. – Validate the data against the Euroclear reference file prior to delivery to en...

I rely on a dependable computer operator who can keep my day-to-day information flowing smoothly. Your core focus will be accurate data entry from spreadsheets into our internal system, following the field formats I provide and flagging any inconsistencies on the spot. Beyond the numbers, you will maintain tidy digital real estate: organise project folders, apply the correct sharing permissions for each team, and schedule regular backups with simple recovery checks so nothing ever goes missing. While files move around, you will also keep an eye on basic system-health dashboards, notifying me of storage thresholds, unusual CPU spikes, or service interruptions before they slow us down. Deliverables • All assigned spreadsheet records entered and verified each day • Folder stru...

I need a reliable freelancer to pull a blend of text and numerical information from several specified online sources and enter it directly into our live database. You will receive secure database access, complete field guidelines, and a short orientation video so you understand the required structure before you begin. Accuracy is critical; each record must match the formatting rules I provide and all values need to be double-checked for consistency. You should already be comfortable working inside a web-based database interface or with SQL tools, and able to keep a clear audit trail of changes. When the assignment is complete I’m expecting the database to be fully populated, error-free, and ready for immediate reporting use.

Our purchasing spreadsheet is already central to daily operations, yet it has grown bulky and harder to trust as the numbers scale. I need it streamlined and future-proof so the team can generate purchasing requirements in minutes, not hours. Here is what matters most: • Structure
 – Reorganise the underlying data tables so information flows logically and stays error-free. – Clean up or rebuild formulas and functions that have become overly complex or redundant. – Refresh the user interface with clear input areas, intuitive navigation, and protective safeguards for critical cells. • New capabilities
 – Introduce automated calculations that trigger on data entry, eliminating manual copy-pasting. – Build advanced filtering so we ...

Saya mencari seorang ahli jaringan yang dapat menyusun proposal komprehensif untuk peningkatan infrastruktur jaringan kami, dengan penekanan khusus pada kecepatan dan kinerja. Lingkup yang saya butuhkan meliputi: • Audit singkat kondisi jaringan saat ini (topologi, perangkat aktif, jalur komunikasi). • Rekomendasi teknis peningkatan – perangkat keras, konfigurasi, dan arsitektur yang diusulkan. • Proyeksi peningkatan throughput serta metrik performa lain yang relevan. • Estimasi biaya perangkat & lisensi beserta timeline implementasi bertahap. • Rencana mitigasi risiko dan strategi rollback bila diperlukan. Proposal harus ditulis jelas, mudah dipahami tim manajemen non-teknis, namun tetap menyertakan detail teknis yang cukup untuk tim TI i...