The last time I posted something concerning the Database Project was when I discuss on the general organisation of the project, in its entirety! By then, the whole project was in the design stage. But now, God willing, a lot of things are on ground; including the entire database.
I have designed all the related tables, created queries that will go through them, design reports that will assist in obtaining relevant data from the tables, and finally, each and every section of the database that requires data entry have been gifted with a simple form for the data entry job. A more detailed explanation is provided below:
1. Tables: There are four sections that made up the database, entirely. The Students Records Register contains all the relevant data fields in the table, including a little information about the parents/guardians. Then comes the Staff Records Register, which is a table containing relevant fields about each and every staff of the school; whether a teacher or a non-academic staff. There is also a table for the financial records of the School. This table includes both the income and the expenditure aspects of the school. I call it Finance Records. The last table contains a list of all account codes representing income or expenditure and the nature of both. This is the Account Codes Table.
2. Queries: Using the Design Query tool in Access, I designed some query samples based on the little data I entered as a test, and it worked fine. I have a query template for each and every table designed.
3. Reports: I also designed a sample report for data contained in the finance table, especially. However, I decided to use my query template in designing the forms. This assisted me in no small major. Though such reports are subject to the data available in the tables, they are handy and can be tweaked around to make some changes.
4. Forms: I have a form for data entry for all the tables. For some tables (like the income and expenditure), I used the query mode to create a data entry form for them. But in some other cases, like that of the Students Records Register, I used the raw table for the form design.
Pending Issues
Before I proceed with the real live-data-entry, I would like to make some changes to the background of some of these objects created. I need to tweak the properties of all the tables data types; setting validation and making some defaults fields enhancement. And since almost all the forms are simple in nature, I need to retouch them, change the layout and arrangement of the forms. Likewise the report templates created. I need to make some changes. In the final analysis, will want to look at macros and what activity I need them to carry out. I also want to create a user entry and a very good switchboard to enhance user friendly interface.
Keep checking the entries!
I have designed all the related tables, created queries that will go through them, design reports that will assist in obtaining relevant data from the tables, and finally, each and every section of the database that requires data entry have been gifted with a simple form for the data entry job. A more detailed explanation is provided below:
1. Tables: There are four sections that made up the database, entirely. The Students Records Register contains all the relevant data fields in the table, including a little information about the parents/guardians. Then comes the Staff Records Register, which is a table containing relevant fields about each and every staff of the school; whether a teacher or a non-academic staff. There is also a table for the financial records of the School. This table includes both the income and the expenditure aspects of the school. I call it Finance Records. The last table contains a list of all account codes representing income or expenditure and the nature of both. This is the Account Codes Table.
2. Queries: Using the Design Query tool in Access, I designed some query samples based on the little data I entered as a test, and it worked fine. I have a query template for each and every table designed.
3. Reports: I also designed a sample report for data contained in the finance table, especially. However, I decided to use my query template in designing the forms. This assisted me in no small major. Though such reports are subject to the data available in the tables, they are handy and can be tweaked around to make some changes.
4. Forms: I have a form for data entry for all the tables. For some tables (like the income and expenditure), I used the query mode to create a data entry form for them. But in some other cases, like that of the Students Records Register, I used the raw table for the form design.
Pending Issues
Before I proceed with the real live-data-entry, I would like to make some changes to the background of some of these objects created. I need to tweak the properties of all the tables data types; setting validation and making some defaults fields enhancement. And since almost all the forms are simple in nature, I need to retouch them, change the layout and arrangement of the forms. Likewise the report templates created. I need to make some changes. In the final analysis, will want to look at macros and what activity I need them to carry out. I also want to create a user entry and a very good switchboard to enhance user friendly interface.
Keep checking the entries!
