As a bridging tool, this Access undergraduate award database is designed to compile academic raw data retrieved from central student information system to be in align with current university standards on student awards/scholarships, to effectively sort, filter, and select potential candidates for 25 pre-academic session awards provided by the Department of Chemical & Biological Engineering and APSC. With only a few clicks, the access interface would enable users to shortlist students in orders based on various award criteria. Also, this database is linked with a departmental SharePoint site to get all the data synced and communicated among the award committee.