When you first open the database, Access displays the Welcome form. To prevent this form from displaying the next time you open the database, clear the Show Welcome when this database is opened check box. Close the Welcome form to begin using the database. To make sure all the database content is enabled, in the Message Bar, […]
In this article we will discuss Inventory Management System and will cover two things; Quantity and its Price (In and Out). In this version we will cover the following items, Items detail Purchase; Items Received Sale: Items Issued Stock Invoice MS Excel users have greate advantage that they dont need any software or other application […]
In last post we have build a successful school management system, and Now we are going to introduce School Examination Result System totally built in MS Excel. In this case the following three sheet will work to present a complete result of a student. Dont mint the data on one sheet because when you get […]
Fee collection sheet is very simple to use. fee entry will be done with only single input of Admission No (Student ID). See below “vlookup” formula has been inserted and when you will enter the Admission number of concern student, his fee entry will be made automatically. In above picture, ADM18-14 input fetched its related information from […]
This is the first sheet that is very important for the rest of evaluation and calculation. You can not calculate anything unless the completion of this sheet. In this first sheet you will find the following important headings Admission No. Student Name Guardian Class Fee Contact Gender DOB (Date of Birth) Admission Date You can […]
We will manage three sheets in this File, as seen below. Staff Member Database In this sheet, we will input data about staff, i.e. ID No. Employee Name Designation Joining Date Basic Pay Deduction Allowance Net Salary We will now give the name of staff member data table (Range). In this case Staff Data table […]
PL Account have two Main Side. that will display all the information about school cash flow. Revenue Side that contains all those entries which involve CASH IN Expense Side that contains all those entries which involve in CASH OUT
The following is the snapshot of inner side of school fee card of a student. On inner side of this card, there are two side, one have fee schedule of whole of the year and other side describes student detail (Name, Class, Guardian, and fee value) You can change it according to requirements. Right side […]
I have tried to construct and cover every financial aspect related to school, and I am sure you will get help from it. In this group of excel files, You will find; Staff Management Student Database Management School Fee Collection Staff Salary management Student Fee Card Management Profit and Loss Account Sheet School Examination and […]
Advance School Management System is a powerful user-friendly and responsive System Available for all type of schools. will work on Phone, Laptop, Tabs, monitors – any screen size and designed as per user’s perspective with multiple MIS reports & multiple logins. Advance School Management System Core Features ADMIN PANEL Admin panel includes the following featured; […]
