This template serves as a reference for interviewers who frequently conduct job application interviews. Some recruiters screen applicants for a wide range of job titles or roles, so it would be helpful to have a database of interview questions and sample answers. Keep interview questions for a wide range of job titles in one database. Put all of the questions in the Questions table and the sample answers for each question in the Sample answers table. It’s that simple. Try out this template by looking into the following tables and views to find out more about what it can do.

Questions

You’ll find every interview question listed in this table. Multiple answers or sample interview responses from the Sample answers table can be linked to a question record or row in this table. Red borders are visible on the left side of every question row without corresponding answer examples.

Fields

• ID. An autogenerated unique identifier for this interview question record or row.
• Department. This field is linked to the Departments table and shows which department this question is most relevant to.
• Role. This field is linked to the Titles table and shows which title or role this question is most relevant to.
• Question. This is a long text field that accommodates an entire interview question along with details and other explanations supporting this question.
• Prepared by. This field is linked to the Employees table, indicating the employee who came up with this question.
• Type. This is a single select field for specifying the type of interview question this record is. By default, an interview question could be any of the following: Behavioral; Situational; Communication; or, Skill-based.
• Notes. Any additional remarks or comments pertaining to this question.
• Date added. The date and time this interview question was added to the database.
• Date updated. The most recent date and time this interview question was modified.
• Answer count. This is a formula that counts the number of sample answers this question has in the database.
• Related answers. This field is linked to the Sample answers table and shows all of the sample interview responses related to this question. This field is hidden by default.
• Department for sorting. A formula field that creates a plain text copy of the Department field. This field is used for sorting records. This field is hidden by default.
• Role for sorting. A formula field that creates a plain text copy of the Role field. This field is used for sorting records. This field is hidden by default.

Views

• All questions. Displays all interview questions without filters, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
• Questions for Assistant Recruiters. Displays interview questions for the Assistant Recruiter role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
• Questions for Associate Quality Assurance Engineers. Displays interview questions for the Quality Assurance Engineer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
• Questions for Customer Service Officers. Displays interview questions for the Customer Service Officer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
• Questions for Software Engineers. Displays interview questions for the Software Engineer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
• Add a question. Displays a form view that facilitates adding new interview questions to this table.
• By type. Displays a kanban view of all the interview questions stacked by Type.

Sample answers

All of the sample answers to interview questions are stored and organized in this table. The questions, or more specifically the Question ID field, are used to group the rows. Background colors make it easy to see which groups of sample answers go together. Feel free to create a separate view for each group of questions.

Fields

• ID. An autogenerated unique identifier for this sample answer record or row.
• Question ID. This field is linked to the Questions table and shows which interview question this sample answer is for.
• Question. A lookup field that returns the actual interview question based on the Question ID field.
• Answer. A long text field for the sample answer or response to a linked question, as well as details and other explanations to back up their answer.
• Date added. The date and time this sample answer was added to the database.
• Date updated. The most recent date and time this sample response was modified.
• Group bgcolor. This is a formula field that is used to automatically assign group colors to sample interview answers. These group colors are used as each group’s background colors to make it easy to tell which answer groups are which. This field is hidden by default.
• Question ID for sorting. A formula field that creates a plain text copy of the Question ID field. This field is used for sorting records. This field is hidden by default.

Views

• All answers. Displays all sample interview answers without filters, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
• Add answer. Displays a form view that facilitates adding new sample answers.

Employees

In the Employees table, you can find contact information for every person in your organization. Most of the other tables in this database are linked to this table. Feel free to add or remove fields from this table to make it fit or meet the security policy of your organization.

Fields

• Full name. A formula field that returns the employee’s full name.
• Photo. The employee’s photograph.
• Last name. The employee’s last name.
• First name. The employee’s first (given) name.
• Middle initial. The employee’s middle initial.
• Title. This field is linked to the Titles table, indicating the employee’s current title or position in the organization.
• Department. This field is linked to the Departments table, which indicates the department the employee belongs.
• Office location. This field is linked to the Office locations table, indicating the location of the employee’s office.
• Local extension number. The employee’s local or extension number based on the organization’s trunk line.
• Phone number. The employee’s current phone or mobile number.
• Email. The employee’s email address.
• Address. The employee’s home address.
• Zip code. The mailing zip code of the employee’s home address.
• Remarks. This field is for recording any notes or remarks about the employee.
• Start date. The date the employee joined the organization.
• End date. The date the employee left the organization. This is used when the employee is inactive or has left the organization.
• Status. The employment status of the employee.
• Is active. A checkbox that indicates whether the employee is still with the organization or not.

Views

• All employees. Displays all employees without any filters, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Add new employee. Displays a form view for the purpose of simplifying the entry of basic contact information for employees.
• Active employees. Displays a gallery of all active employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Full-time employees. Displays a gallery of all active, full-time employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Part-time employees. Displays a gallery of all active, part-time employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Seasonal employees. Displays a gallery of all active, seasonal employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Temporary employees. Displays a gallery of all active, temporary employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
• Employees by status. Displays a kanban view of active employees stacked by Status.

Titles

You can keep track of a list of job roles and their descriptions with this table. As an example, this template has a list of titles for a business that develops software.

Fields

• Name. The position name.
• Level. A single select field specifying the position’s level in the hierarchy of roles.
• Description. A description of the title, which may include position specifics and responsibilities.
• Employee count. A formula field that counts the number of interviewees with this title.
• Related employees. This field is linked to the Employees table, identifying all employees or staff members using this title. This field is hidden by default.

Views

• All titles. Displays all the titles or staff designations in an organization without any filters.
• Business analysis. Displays all titles related to business analysis.
• Quality assurance. Displays all titles related to quality assurance.
• Software engineering. Displays all titles related to software engineering.
• Human resources. Displays all titles related to human resources or recruitment.
• Executive. Displays all titles related to the company’s executives.
• By level. Displays a kanban view of all titles stacked by Level.

Departments

There are various kinds of departments, like those that deal with finance, law, human resources, advertising, etc. It’s common for these departments to work together to accomplish business tasks in large and medium-sized companies. Update this table as needed to make it work for your business.

Fields

• Name. The name of the department.
• Description. A short description of the department.
• Employee count. A formula field that counts the number of interviewees under this department.
• Is active. A checkbox that indicates whether the department is active or not.
• Related employees. This field is linked to the Employees table, indicating all employees assigned to the current department. This field is hidden by default.

Views

• All departments. Displays all departments sorted in alphabetical order by Name from A to Z.
• Active departments. Displays a gallery of active departments arranged in alphabetical order by Name from A to Z.

Office locations

As your business grows, so will your office. There’s a good chance that your office will grow into new places and spaces. With this table, you can keep track of where your offices are.

Fields

• Location. The name or identifier of the specific location.
• Photo. A photograph of the building or office room identifying this location.
• Floor. This specifies the building level or floor where the office room is located.
• Street. This is the street where this office is located.
• City. This is the city where this office is located.
• State. This is the state where this office is located.
• Zip code. The mailing zip code of this office location.
• Phone number. The main or trunk line phone number of this location.
• Employee count. A formula field that counts the number of active employees in this location.
• Related employees. This field is linked to the Employees table, identifying all employees or staff members assigned to this location. This field is hidden by default.

Views

• All locations. Displays all the locations of the organization’s offices without any filters sorted by Location in alphabetical order from A to Z.
• Locations. Displays a gallery of the organization’s offices.