
Đã đóng
Đã đăng vào
Thanh toán khi bàn giao
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 multiple embodiment periods (around 30–40 periods during full service). For each embodiment cycle, I will manually enter only: • Embodiment From (Date) • Embodiment To (Date) The system should then automatically calculate and populate: • Total Embodiment Days • Disembodiment From (auto = next day after Embodiment To) • Disembodiment To (auto = day before next Embodiment From) • Total Disembodiment Days ⸻ Example of One Cycle • Embodiment From: 01 Dec 2015 • Embodiment To: 31 Mar 2016 System should auto-calculate: • Total Embodiment Days: (auto calculated) Then automatically: • Disembodiment From: 01 Apr 2016 • Disembodiment To: 31 Jul 2016 • Total Disembodiment Days: (auto calculated) This pattern should continue for all subsequent embodiment periods. ⸻ Automation Requirements • I should only enter Embodiment From and To dates. • All day calculations must be automatic. • Gap periods between two embodiment dates must be treated as disembodiment periods. • System should calculate: • Total Embodiment (Years / Months / Days) • Total Disembodiment (Years / Months / Days) • Total qualifying service automatically. ⸻ User Interface Requirement • When I open an individual’s profile, I should be able to: • View all past embodiment/disembodiment records together. • Enter multiple embodiment periods in one place. • No manual calculation should be required.
Mã dự án: 40227852
17 đề xuất
Dự án từ xa
Hoạt động 19 ngày trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
17 freelancer chào giá trung bình ₹1.259 INR cho công việc này

Hi, I’d be glad to help you build a clean, reliable MS Access database that automatically calculates embodiment and disembodiment service periods without manual work. From your requirements, the key challenge is structuring the data correctly so multiple service cycles per individual calculate gaps, totals, and qualifying service accurately — while keeping the interface simple for daily use. I will design a structured Access system with a master personnel profile, linked embodiment records, and automated queries that calculate service days, gap periods, and cumulative totals instantly. The form interface will allow you to open one soldier’s profile, add dates easily, and view the full service history together — no formulas or calculations required from your side. With 10+ years of development experience, I focus on building practical, low-maintenance systems that are easy to operate even for non-technical users. I’ll also provide clear documentation so your unit can continue using the database confidently long term. Let’s discuss your workflow and I can start building the first working version right away.
₹1.500 INR trong 7 ngày
4,1
4,1

With 7 years of experience in database management, I am the best fit to complete this requirement. I have the relevant skills to create a Military Personnel Service Tracker Database using MS Access. ### How I will complete this project: - Create a database with individual profiles for each personnel - Implement automation logic for embodiment and disembodiment periods - Design a user-friendly interface for easy data entry and viewing ### Tech stack I will use: - MS Access for database creation - SQL for data manipulation and calculations I have worked on similar solutions in the past, making me well-equipped to handle this project efficiently. The roadmap to complete this project involves: 1. Database schema design and implementation 2. Automation logic development for embodiment and disembodiment calculations 3. User interface design for easy data entry and viewing 4. Testing and debugging to ensure accuracy and efficiency By following this roadmap, I will deliver a high-quality Military Personnel Service Tracker Database that meets all your requirements.
₹660 INR trong 7 ngày
0,0
0,0

Hello, I am interested in your data entry project. I have good typing speed, strong attention to detail, and experience working with Excel, Google Sheets, and online forms. I can accurately enter, organize, and verify large amounts of data while maintaining confidentiality. I always follow instructions carefully and complete tasks within deadlines. Clear communication and regular updates are my priority so you always know the project status. I am ready to start immediately and can provide sample work if required. I assure you quality, accuracy, and professional work. Looking forward to working with you and building a long-term professional relationship.
₹1.050 INR trong 7 ngày
0,0
0,0

Hello my name is Andreas and im an CS student from Greece. I would like to help you with your task. Please tell mi if u are interested i can start from now. Thanks, Andreas
₹1.000 INR trong 1 ngày
0,0
0,0

Hello, I have strong experience in Excel and Python data analysis. I can clean, organize, analyze, and visualize your data accurately. I will provide clear insights, well-structured reports, and on-time delivery. Let’s discuss your project requirements and get started immediately.
₹1.050 INR trong 8 ngày
0,0
0,0

Dear Hiring Manager, I am very interested in developing your MS Access database for tracking personnel embodiment and non-embodiment periods within your unit. With a clear understanding of your requirements, I can design a structured, efficient, and fully automated MS Access system that will: • Maintain individual personnel profiles (Army Number, Rank, Name, Enrollment Date) • Allow entry of multiple embodiment periods per individual • Automatically calculate total embodiment days • Automatically determine non-embodiment periods between service cycles • Calculate total qualified service (Years / Months / Days) • Prevent overlapping date entries • Provide a clean and user-friendly interface with master form and subform design • Generate summary reports when required The system will be: ✔ Simple and easy to maintain ✔ Scalable for 445+ personnel ✔ Fully automated (no manual calculations required) ✔ Professionally structured with proper relational database design ✔ Delivered with documentation and usage guidance I will ensure accuracy in date calculations, data integrity, and long-term reliability of the system. If required, I can also provide enhancements such as dashboard summaries and printable service reports. I am confident I can deliver a clean, reliable, and efficient solution tailored exactly to your operational needs. I look forward to discussing your project further. Best regards,
₹1.050 INR trong 7 ngày
0,0
0,0

I’m an Operation Senior Administrator with a strong customer service background. I have 14years of administration experience. Over the years I have developed a diverse range of skills and undertaken numerous development causes which enables me to become a competent and knowledgeable asset to any team. I’m excited to bring my skills to a dynamic role like this.
₹1.050 INR trong 7 ngày
0,0
0,0

Hii, Greetings of the day !! Myself Tarun Patel, I'd seen your project details. I have 5+ years of experience in Microsoft office. I am very glad to work with you. Let's go for quick conversation on mail id. Thanks & Regards Tarun Patel
₹1.500 INR trong 7 ngày
0,0
0,0

Hello, I can design a structured MS Access database with proper relationships between personnel profiles and embodiment records. The system will automatically calculate embodiment and disembodiment days, qualifying service, and display complete service history per individual using forms and queries. I will ensure clean interface, automated date calculations, and accurate reporting as per your requirement. Please clarify whether summary reports (per year or overall service) are required as well.
₹1.300 INR trong 6 ngày
0,0
0,0

Hello sir, I can deliver a fully functional desktop application to manage personnel profiles with automatic embodiment/disembodiment calculations. The interface will be simple, clean, and easy to use, and I can provide it as a ready-to-use .exe file. Would you prefer the data stored in CSV, MySQL, or either?
₹1.199 INR trong 3 ngày
0,0
0,0

Hello, I would be happy to help you create the MS Access database for your unit. I understand that you need a well-structured database where each individual has a separate profile and all embodiment and disembodiment periods are calculated automatically. I am a Computer Science student with good knowledge of MS Office tools and database fundamentals. I can design the required tables, set up relationships, create forms/subforms for easy data entry, and implement automatic date calculations using queries. I pay strong attention to accuracy and will ensure the system is simple to use and properly tested. I am willing to learn and adapt to any specific format you prefer and will provide sincere and timely work. I would appreciate the opportunity to work on this project. I am ready to start immediately and can deliver within the required timeline. Thank you.
₹600 INR trong 7 ngày
0,0
0,0

Hi, this is exactly the kind of structured Access database I build. Your use case is clear and practical: individual profiles, multiple service periods per person, and automatic calculation of embodiment, disembodiment, and qualifying service without manual work. This is straightforward to implement cleanly in MS Access with proper table relationships, forms for easy data entry, and queries that calculate service time accurately across all cycles. I will build you a simple profile screen where you can open any soldier’s record, enter embodiment “From” and “To” dates in one place, and instantly see all past periods, disembodiment gaps, total embodiment time, total disembodiment time, and total qualifying service calculated automatically in years, months, and days. No formulas to touch, no manual math, no risk of breaking anything. The system will handle 400+ personnel smoothly and is designed so you can keep using it year after year without becoming complex or slow. I’ll also include basic protections so dates can’t overlap and mistakes are flagged before saving. This is easy for me to build, and I’m confident I’m the right person for this because I focus on simple, reliable database structures that actually get used daily, not overengineered systems. If you want, I can also add clear visual summaries at no extra cost so you can instantly see totals and service trends per individual or for the whole unit.
₹1.000 INR trong 3 ngày
0,0
0,0

Hello, I can design a clean and well-structured MS Access database to manage military personnel service records as you described. The solution will include: • A structured database with clear tables for personnel details and service records • Easy-to-use forms for data entry and updates • Simple queries and reports to retrieve service information when needed • Clear field naming and logical organization so the database is easy to maintain I focus on accuracy, clarity, and making the system practical for daily use rather than overcomplicating it. I can deliver a first working version within 2–4 days, with adjustments based on your feedback. Looking forward to working with you.
₹900 INR trong 4 ngày
0,0
0,0

Hello, I can build a structured and automated MS Access database for managing embodiment and disembodiment records for your unit (approx. 445 personnel). The system will include: • Individual profile table (Army No, Rank, Name, Date of Enrollment) • Proper relational design (separate Personnel & Service Period tables) • You only enter: Embodiment From & To dates • Automatic calculation of: – Total Embodiment Days – Auto Disembodiment From (next day) – Auto Disembodiment To (day before next embodiment) – Total Disembodiment Days • Automatic summary per individual: – Total Embodiment (Y/M/D) – Total Disembodiment – Total Qualifying Service • User-friendly form to enter multiple cycles in one screen • Validation to prevent overlapping dates The database will be lightweight, organized, and easy to maintain. I can start immediately.
₹950 INR trong 1 ngày
0,0
0,0

Haldwani, India
Thành viên từ thg 2 13, 2026
₹600-1000 INR
$30-250 USD
₹1500-12500 INR
₹750-1250 INR/ giờ
₹1500-12500 INR
$30-250 USD
₹1500-12500 INR
£3000-5000 GBP
₹400-750 INR/ giờ
$30-250 USD
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
$10-30 USD
$250-750 USD
$250-750 USD
₹1500-12500 INR
$250-750 USD
$10-40 USD
$3000-5000 USD
₹600-1500 INR