Automated Online Job Finder using MS Access
The System
This is one of my publications involving an automated online job finder using Microsoft Access. For those of you that are unfamiliar with MS Access, MS Access deals with desktop databases. It's a tool for creating customizable database applications. However, companies often do not use MS Access because a cloud database such as Microsoft Azure and Amazon Web Services (AWS) is much more practical and efficient. The study uses the database management features of MS access and applies it to a job finder system to match company preferences.
The applicant would have to provide the necessary academic background information such as Diploma and Transcript of Records (TOR). The host will determine if uploaded information is valid. The company will hand out their desired academic background information and the MS Access will automatically match them to a user that is fit based on their preferences.
The academic information required are your course, year graduated, academic awards and General Weighted Average (GWA), then the company will search for applicants based on these information and matches it on the database.
Defined Relationships
Here are the defined relationships of the project. The relationships were used to utilize the databases such as the account database and link the necessary information from tables to forms.
In MS Access, we utilized tables and queries for the database and relationships while forms for the UI. We also implemented Visual Basic for Applications (VBA) such as simple macros for the buttons to be responsive and linked to each other.
SQL queries
The project utilized SQL queries to link elements in the tables and forms. SQL was also used to match the applicant information and company preferences. The main query utilizes SELECT, FROM and INNER JOIN functions as shown in the image. However, database queries can easily be maneuvered using the User Interface in MS Access.
Conference Approval
The study got approved in an international Industrial Engineering virtual conference on Engineering, Technologies & Applied Sciences category held in Kuala Lumpur, Malaysia. The link for the publication is shown here.