Access VBA Projects
- Microsoft Access (All Versions)
Deep expertise on All Objects of MS Access (SQL Queries, Views Macros, VBA Modules, Forms, Tables, Reporting)
- SQL Server
- Microsoft Excel (All Versions)
Types of Projects We have done
- Build complete Application for Doctor’s Office management
A comprehensive Patient and Doctor database application to centralize all records and manage Doctors’ appointments, billing, payments, records, and centralize detailed reporting with auto generated PDFs. Built a point and click menu driven system.
- Design and Upgrade/Migration
Complete design of MS Access database from start to finish along with upgrade to newer versions from 1997 onwards all the way to 2016. Migration from excel or other sources as well as migration from Access to MS SQL or MySQL.
- Task Management System
Tasks Add/Edit Delete, Tasks Calendar, Task Conversation, User Login, and Task Sorting, Filtering and Reporting as per Need.
- Contacts Management System
Add/Edit/Delete Contacts, User Management and Rights, Filtering Sorting and Reporting
- Project Management System
Project Management, Project Tasks, Project Conversation, Project Assignments, Project Users, User Rights, Filtering Sorting and Reporting
- Accounts Management
Chart of Accounts, Genera Journal, Balance Sheets, and Accounts Based on Categories and Types, Attachments, Budget, User Login, User Rights, Sorting, Filtering and Reporting.
- Stock/Inventory Maintenance
List of Items, Inventory, Items Demand, Inventory in Hand, User Management, Sorting, Filtering and Reporting
- Vehicle Registration System
Vehicle Registration with Vehicle No, License No, Issuing Authority, Owner Info, User Login, User Management, Sorting, Filtering and Reporting.
- Auto Maintenance System
Auto Vehicle Registration, Maintenance Schedule, Maintenance Due, Maintenance Type, User Login, Sorting, Filtering, Reporting.
- School/College Management
Student/Teacher/Employee Registration, Attendance System, Assets Management, Monthly Testing Reports, Fees Management, User Management, Sorting, Filter and Reporting.
- Hospital Management
Patient Registration, Medicine Inventory, Assets Management, Employee Enrolment, User Management, Sorting, Filtering, Reporting
- User Management System
Add/Edit/Delete Users, User Level, User Rights and Reporting
- Student Management
Student Registration, Student Attendance, Fees Management, Testing Reports, Semester Details, Sorting, Filtering and Reporting.
- Library Management System
Books Registration, Reader Registration, Books Issuance and Receiving, Books catalogue, Sorting, Filter and Reporting.
- Charity Management System
Charity/Donor/Dependent/Carer/Employee Management, Activity Management, Donations, Appeals, Rewards, User Management, Rights Management, Sorting, Filtering and Reporting.
- Store Management
Items List, Sales Men catalogue, Item Inventory, Sales, Sales Return, Claims, Accounts Management, Sorting, Filter and Reporting.