
Suoritettu
Julkaistu
Maksettu toimituksen yhteydessä
My goal is to keep day-to-day attendance simple and centralised inside Microsoft Access. The database needs three core modules: 1) Employee check-in / check-out A single, easy form for manual entry that time-stamps arrivals and departures. Employees will be selected from a dropdown fed by a master staff table; the form should automatically calculate total hours and flag missing punches. While our current workflow is manual, I would like the table design to be flexible enough so we could later add RFID or biometric fields without rebuilding the whole structure. 2) Leave management Vacation, sick days and other absences must be logged against each employee and deducted from their entitlement balance. Accrual rules are straightforward—one line per leave type with start-date, end-date and reason—but the logic that keeps the balances accurate is essential, so VBA or well-built queries will be needed here. 3) Reporting & analytics • Daily attendance reports that can be printed or exported to Excel • Monthly summary reports showing hours worked, overtime and leave taken • Real-time alerts: the moment a scheduled employee has not checked in by a given time, an on-screen prompt or automatic e-mail should fire I will provide current staff lists and our holiday policy; you handle table design, relationships, forms, queries, reports and any VBA. A clean switchboard or navigation pane that guides non-technical users through the process is important, and the final file must open in Access 2016+ with no missing references. Acceptance will be based on: • Zero data-integrity errors during test entries • All three report types matching sample layouts I will supply • Alert firing accurately in a live test If you have built similar Access databases, please tell me which features you tackled and how you approached alerts. Source file (.accdb) is the only deliverable; no installers required.
Projektin tunnus (ID): 40389917
19 ehdotukset
Etäprojekti
Aktiivinen 18 päivää sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
19 freelancerit tarjoavat keskimäärin $91 USD tätä projektia

If you want the BEST Microsoft Access DEVELOPER leading this simple and centralized daily time and attendance control project in Microsoft Access for you, contact me right now, as I have dozens of successfully completed MS Access projects! I will deliver all 3 modules working perfectly, but I will develop and deliver them in stages. Talk to me TODAY!
$100 USD 1 päivässä
6,6
6,6

السلام عليكم ،،، I can build a complete Microsoft Access attendance system with check-in/out, leave management, and automated reporting—fully structured, user-friendly, and ready for real use. Includes forms, queries, reports, VBA alerts (late check-in/email), and a clean navigation menu—designed for future expansion (RFID/biometric ready). 10+ years Advanced Access experience, Certified VBA Programmer, MBA.
$65 USD 2 päivässä
6,4
6,4

Hello! I'm an experienced database developer with a strong track record building robust MS Access solutions. I understand your attendance system requirements and can deliver all three core modules: check-in/check-out, leave management, and comprehensive reporting with real-time alerts. My Approach: • Database Design: I'll create a normalized, scalable structure that accommodates future RFID/biometric integration without rebuilding • Employee Module: Clean dropdown-fed form with automatic timestamp calculations, hours totaling, and missing punch flags • Leave Management: Robust VBA logic to track accrual balances, enforce entitlement limits, and maintain data integrity across leave types • Reporting Suite: Professional daily, monthly, and real-time alert reports; all exportable to Excel with polished formatting • User Experience: Intuitive switchboard navigation for non-technical users; Access 2016+ compatible with zero missing references I've built similar attendance databases with complex VBA alert mechanisms including email notifications. I guarantee zero data integrity errors and will match your sample report layouts precisely. The deliverable will be a production-ready .accdb file ready to use immediately. Ready to discuss your staff list and holiday policy to ensure accuracy. Let's build something reliable!
$100 USD 1 päivässä
6,5
6,5

Professional Access VBA developer ready to develop the required application with the following modules: # Employee check in/out ready for RFID usage - $200 - 2 days (basic reports included) # Leave management with pay deductions calculation - $300 - 3 days # Reporting & analytics $200 - 3 days 50% downpay, 50% on final acceptance. Regards.
$200 USD 2 päivässä
5,1
5,1

السلام عليكم I have carefully read your job description and understand you need a MS Access Attendance System I have done many projects previously, you will never lose the deadline and we will never disagree about money at all. By hiring me, you will have a quick response, high quality, and great communication.
$50 USD 1 päivässä
4,6
4,6

Hello! This project sounds like a great opportunity to streamline your team's attendance, leave management, and reporting needs with an efficient Access solution. My approach focuses on building a clear, user-friendly interface that seamlessly integrates all core modules: Employee check-in/out (with flexible future expansions), Leave management (accurate accrual tracking with user-friendly interfaces), and detailed reporting (including real-time alerts for missed checks). I'll leverage best practices and my expertise in Access to deliver a robust system meeting your specific needs. Let's discuss the details of this project further to explore how I can provide value through clear, functional modules, reliable data integrity, and customized reporting.
$100 USD 5 päivässä
4,0
4,0

Hello, I have read your job description and I am interested in your job post.I am ready to start now. Please send me a message to discuss more about your project, Can you please give me a chance I am a Senior Software Developer with over 8+ years of experience in designing and developing scalable web and desktop applications. I specialize in Microsoft technologies and delivering high-quality, secure, and performance-driven applications. My Expertise: Backend Development:ASP.NET, ASP.NET Core, MVC, Web API, WebForms,Laravel, WCF Services Programming Languages:C#, Php Frontend Development:JavaScript,Angular, React, TypeScript jQuery, AJAX, HTML, CSS Database Technologies:SQL Server, MySQL Reporting Tools:Crystal Reports, RDLC, SSIS, SSRS
$25 USD 7 päivässä
3,2
3,2

Hi there, I can build this Microsoft Access attendance system for you in a clean, structured, and fully scalable way, ensuring it stays simple for daily use but strong enough for future upgrades (RFID/biometric integration without redesign). My approach: 1) Employee Check-in / Check-out Normalized table structure (Employees, AttendanceLog, TimeEntries) Form-based manual punch system with dropdown employee selection Automatic timestamp capture + hours calculation via queries/VBA Validation rules to detect missing check-in/out records Future-ready fields for RFID/biometric integration (no redesign needed later) 2) Leave Management Structured leave table (type, dates, reason, status) Accrual logic using queries + VBA validation Auto-deduction from entitlement balance Prevent overlapping or invalid leave entries 3) Reporting & Alerts Daily attendance report (print/export to Excel) Monthly summaries (hours, overtime, leave breakdown) Real-time alert system using VBA: Scheduled check-in monitoring Email notification (Outlook automation) On-screen prompt for missing attendance UI / UX Clean Access navigation form (switchboard-style) Simple, non-technical workflow for staff usage Role-friendly structure (admin-ready if needed later) I’ve built similar HR attendance + leave tracking systems in Access with automation and reporting layers, so I can deliver this quickly and cleanly. Ready to start immediately. Best regards, JP
$250 USD 7 päivässä
1,0
1,0

Hey , looking over what you need for Visual Basic, Data Management, Database Administration, Microsoft Access, SQL, Database Programming, Database Design and Data Entry, I noticed you’re in a perfect spot to use a specific approach that completely eliminates the usual headaches people run into with these types of projects. Most freelancers will just do the bare minimum, but they completely miss a small structural tweak that actually makes the final result run flawlessly and saves you a ton of time. I’m not here to just bid and wait. I’ve already visualized the fix for that one specific gap in your project that usually drags these projects out for weeks, and keep you from looping back for revisions later. If you’re serious about getting this done right the first time without the back-and-forth, hit me up in the chat, and I’ll show you exactly what I mean I guarantee it’ll be the most helpful 5 minutes of your day and will take the entire weight of this project off your shoulders.
$65 USD 4 päivässä
3,3
3,3

Hi, I can easily DO your work IN 24 HOURS, DM me now to get started, PRICE NEGOTIABLE 100% Work satisfaction is provided
$35 USD 1 päivässä
0,0
0,0

Hello, I am Cindy Viorina, an Access developer with experience building staff rostering and attendance systems. I understand you need a single Access (.accdb) file with three modules: check-in/out form that time-stamps and computes hours with missing-punch flags and extensible fields for RFID/biometric IDs; leave management that records types, dates and adjusts entitlements via robust VBA and queries; and reporting with printable/Excel-exportable daily and monthly summaries plus real-time on-screen or email alerts. I will design normalized tables, enforce relationships, create forms and a clean switchboard, implement VBA for balance accruals and alert routines, and deliver reports matching your samples. I will ensure Access 2016+ compatibility and zero data-integrity errors during tests. I am available to communicate in real time in your time zone and can provide a simple demo within 12 hours of start. Q1: Do you want accruals prorated by hire date or simple monthly accruals? (Proposal) Q2: Do you prefer alerts as on-screen prompts only or email as well? (Proposal) Q3: Will overtime be calculated automatically or entered manually? (Proposal) Which employees or departments should be prioritized for the initial testing so I can pre-load realistic sample data? Best regards, Cindy Viorina
$10 USD 1 päivässä
0,0
0,0

Yes, I can help you. I am the right individual to help you with your attendance control system project in the Access database. I am very good at designing database solutions and have worked extensively with user interfaces. I like practical solutions; simple but covering all of the client's requirements. I work fast because I have a lot of experience in the field. I have more than 500 hours of experience in training, certifying and lecturing in all phases of Access. Please take a look at my projects at: https://www.freelancer.com/u/Cupilo. If you hire me you will not regret it. Just contact me. Thank you. Camilo
$300 USD 20 päivässä
0,0
0,0

Doha, Qatar
Maksutapa vahvistettu
Liittynyt huhtik. 22, 2026
$10-30 USD
₹12500-37500 INR
₹75000-150000 INR
$15-25 USD/ tunnissa
$10-90 USD
₹750-1250 INR/ tunnissa
$1500-3000 USD
₹600-1500 INR
₹12500-37500 INR
$15-25 USD/ tunnissa
$30-250 CAD
$250-750 USD
₹12500-37500 INR
₹100-400 INR/ tunnissa
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR/ tunnissa
$15-25 USD/ tunnissa
$15-25 USD/ tunnissa