Microsoft Access Jobs

I need a production-ready, web-based HR Management System that unifies three core areas: • Time & Attendance – real-time clock-in/out, leave management, overtime tracking, and the ability to record salary advances. • Payroll Processing – automated calculations tied to the attendance data, statutory deductions, and downloadable payslips. • Employee Management – smooth onboarding/offboarding workflows, performance reviews, and secure document storage for contracts, IDs, and policies. Security, role-based access, audit logs, and a responsive interface are must-haves. I’m open on the tech stack as long as it is modern, scalable, and well documented; propose what you do best and outline any frameworks or cloud services you plan to use. Deliver...

I'm looking for someone to redesign multiple Excel worksheets we use for project management. Key Requirements: - Better organization: Restructure existing data for clarity. - Additional functionalities: Implement new features (e.g., automated calculations, dynamic charts). - Experience with Excel, particularly in project management contexts. - Ability to create user-friendly, efficient layouts. Ideal Skills: - Advanced Excel skills - Strong project management knowledge - Proficient in creating organized and functional spreadsheets Please provide samples of previous work.

I need one reliable professional who feels equally at home beside a horizontal machining centre and in front of a spreadsheet. On the shop-floor you will: • Handle complete HMC machine setup and calibration, including tooling offsets and fixture alignment. • Keep the machine running smoothly during every cycle, watching tolerances, collecting in-process measurements and flagging any quality issues before they become scrap. At the desk you will: • Record the production and inspection figures you just gathered, inputting them accurately into my Google Sheets-based log. • Keep our small parts-tracking database tidy and current so anyone can pull real-time inventory and job-status reports. I will share the existing setup sheets, inspection templates and databas...

I need a cohesive set-up that lets us capture customer data in Microsoft Access and explore it visually in Power BI. Power BI The .pbix should focus on interactive visuals that let users slice, drill, and pivot customer metrics, while still giving me the flexibility to rearrange or add charts later. I will provide sample data; please structure the model so future tables can be dropped in without breaking relationships. MS Access Build an .accdb that enforces clean data from the start: intuitive entry forms, field-level and form-level validation rules, and a handful of custom reports that mirror what the dashboard will show. The database will be the single source of truth feeding Power BI, so referential integrity is critical. Deliverables • Power BI file with interactive, f...

I'm looking for an Excel expert to create a comprehensive dashboard for managing construction projects. The dashboard should track the following key metrics: - Project Progress - Budget vs Actual Costs - Resource Allocation - Baseline vs Actual Progress - Remaining Works - Milestones - Risks The ideal freelancer should have: - Advanced Excel skills - Experience in project management, particularly in the construction industry - Ability to create user-friendly and visually appealing dashboards - Strong analytical skills to ensure accurate data representation Please provide samples of previous work.

I have a live online database filled with numerical records that must be captured, verified for accuracy, and migrated into the templates I provide. You will work on an hourly basis: log in, pull each figure, double-check it matches the source, then paste it into the target sheet or form. Consistency and precision are essential, so familiarity with spreadsheets such as Excel or Google Sheets will help you move quickly while keeping error rates low. I will track progress in real time and release hours as long as the numbers you input reconcile perfectly with the database totals. If you spot discrepancies, flag them in the comments column rather than guessing. Deliverable: • Updated spreadsheet (or form) showing every assigned row completed, with notes on any anomalies you found...

I need a robust asset management database designed to track the location of physical assets like equipment and machines. Essential Features: - Real-time tracking of asset location - Maintenance history logging - Asset condition reports - Detailed asset movement logs - Current asset status updates - Tracking for both serialized and non-serialized assets - End-of-life tracking - Fault reporting - Comprehensive logs of actions taken (who did what and when) - Asset location data The ideal candidate should have experience in database design and management, particularly with real-time tracking systems. Familiarity with asset management protocols and strong attention to detail is essential.

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I already have a working Microsoft Access file that stores classes, participants, teachers and hosts for our school-trip programme. What I need now is a set of practical refinements that will let our office staff spend less time wrestling with data and more time focusing on the children. 1. Improved data-entry and registration forms • One clean form for new trip registrations that captures student details, emergency contacts and essential medical information in a logical flow. • Auto-fill and look-ups wherever possible so teachers are not re-typing the same names or addresses each term. • A printable version of this form that doubles as the parental consent sheet. 2. Advanced reporting & export tools • A ready-to-print registration/attendance l...

I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance. Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags: • Overcharged hours • Duplicate charges • Unusual expenses • Fraudulent billing Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time. Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work. Deliverables 1. One Excel file (.xlsx) containing: &nd...

I’m looking for a sleek, easy-to-read dashboard that turns my financial data into clear revenue insights. You’ll start with a spreadsheet (or database connection, if you prefer) that contains historical revenue broken down by month, product line, and region. From there, I want an interactive visual that highlights total revenue, month-over-month and year-over-year changes, plus a simple trend line. An optional alert for any dip greater than 10 % would be a nice touch. I’m flexible on the platform—Power BI, Tableau, or Google Data Studio all work as long as I can refresh the figures without fuss. Once we kick off, I’ll supply sample data and branding colours so you can match the look and feel to the company style. Deliverables: • Fully functional dashboa...

I need a seasoned Tally user to build a complete book of accounts focused on inventory management and to configure the system so I can pull accurate financial reports any time I need them. The company file has to be set up from scratch in Tally (ERP 9 or Prime), with every stock item, godown, and unit of measure properly mapped to the chart of accounts. What has to happen: • Create the inventory-centric ledger structure, enter opening balances, and enable stock tracking features. • Configure voucher types, taxation ledgers, and cost centres so that monthly profit-and-loss, balance-sheet, and stock-summary reports generate correctly without extra adjustments. • Provide a brief hand-over guide and one remote walkthrough so I know exactly how to enter day-to-day inventor...

Conduct a full review and remediation of the Microsoft Intune environment, including policy restructuring, update conflict resolution, and device preparation for upcoming user deployments. 1. Environment & Policy Remediation Audit and clean up Intune policies Review all current policy assignments (user-targeted vs. device-targeted). Correct misapplied user-level controls that caused policy conflicts on shared devices (“Intune storm” issue). Reassign policies appropriately to prevent future multi-user conflicts. Break up monolithic policies Split large policies (~20 settings in a single policy) into smaller, granular configurations. Ensure individual settings can be modified or exempted without impacting unrelated controls. Create structured Intune groups Implement...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortless. The focus is on robust reporting and analytics rather than a one-off dashboard, so the solution should be scalable and easy for me to refresh whenever new spreadsheets arrive. If you’re interested, send a detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I...

I need a keycard access control system installed at the entrance doors of our office building. Ideal Skills and Experience: - Experience with access control systems, specifically keycard systems - Familiarity with office building security requirements - Ability to work independently and ensure proper installation - Attention to detail to guarantee all access points are securely managed Please provide a detailed proposal including your experience, approach to the project, and estimated timeline.

I have a backlog of financial figures that must be transferred accurately into working spreadsheets and then reflected in our existing SQL database. The spreadsheets will be the primary source, so precision in every cell—dates, currency formats, formulas, and cross-sheet references—is essential before the data is pushed to the database. You will receive scanned source documents, the current Excel template, and credentials to a staging schema in our SQL environment. Once each spreadsheet is complete and vetted for errors, the corresponding tables in SQL need to be updated so that our reporting dashboards stay in sync. Deliverables • Completed Excel workbook with all financial data correctly entered and formatted • SQL script (or direct upload) that mirrors the sp...

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

I already have a working estimating spreadsheet program with extensive data base. I now need to add further columns to improve the estimating spreadsheet. Here is what I’m looking for: • Add to the current spreadsheet with additional information i have. • Display the information from a data base. • Make sure the new calculations pick up the same input data fields • Provide clear, concise documentation of every new function and a short change-log so I can track what was modified. • Include a small sample project or test file showing the results of the new time calculations against known benchmarks; this will be the acceptance criterion. The existing program is stable and I have full source control access; you will receive a Git branch to work in. ...

I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistently; if you uncover ga...

I'm looking for a skilled developer to build a comprehensive customer database platform. The platform is intended to serve multiple purposes including: - Storing contact information - Managing customer interactions - Tracking sales and orders Key features of the database should include: - Ability to add new contacts via manual entry or importing from files - Storing a variety of information such as: - Personal details (name, address, phone) - Customer preferences and history - Contract information - Sales information Ideal skills and experience: - Experience in database design and development - Familiarity with data import functionalities - Strong understanding of data privacy and security - Ability to create user-friendly interfaces for manual data entry Please provide e...