Others

Assign the Same Learning Tasks to Every Employee in Microsoft Access

Jason MillerJason Miller Nov 13, 2026 868 views

Question details

The user needs to assign the same learning assessments to every employee while keeping each assignment and completion record separate.

Assign the Same Learning Tasks to Every Employee in Microsoft Access
Product
Microsoft Access Task Management template
Device & OS
not provided
Scenario
Every employee must complete a common set of learning assessments, and reports must show outstanding assessments for each employee.
Observed behavior
The template assigns tasks to individual contacts. Each employee needs a separate task record for every required assessment so completion status can be tracked independently.
Before you start

Open the database and check the actual table and field names for task titles, assigned contacts, and completion status. Confirm that each employee has a contact record with a unique ID and that the assigned-contact field stores that ID.

Solution 1Recommended

Create reusable learning assignments and append separate tasks for each employee

Use a master list of assessments to generate employee-specific task records without entering every task manually.

Keep the assessment definitions in a LearningAssignments table, but store each employee's assigned assessment in the Tasks table. Separate Tasks records allow one employee to finish an assessment without marking it complete for anyone else.

The example query assumes Tasks has TaskTitle and AssignedTo fields, LearningAssignments has an Assignment field, and AssignedTo stores a single numeric contact ID. Substitute the names used in your database and include any other required task fields.

1
Create the assessment list

In Access, select Create > Table Design and create a table named LearningAssignments. Add an AutoNumber primary key and a Short Text field named Assignment, then save the table and enter one row for each required assessment.

2
Find the employee's contact ID

Open the Contacts table in Datasheet View and locate the employee's unique ID. Use this stored ID rather than the employee's display name when populating the assigned-contact field.

3
Create the append query

Select Create > Query Design, close the Add Tables or Show Table dialog if it appears, and switch to View > SQL View. For an employee whose contact ID is 1, enter: INSERT INTO Tasks (TaskTitle, AssignedTo) SELECT Assignment, 1 AS AssignedTo FROM LearningAssignments; Replace 1 with the actual employee ID and adjust the table and field names to match your database.

4
Run the query for each employee

On the Query Design tab, select Run and confirm the append operation. Check the new rows in Tasks, then change the employee ID in SQL View and run the query for each remaining employee. Run it only once per employee for the same assessment set to avoid duplicate assignments.

5
Track completion and report outstanding work

Open the task form or Tasks table and update completion on each employee's individual task record. Select Create > Query Design, add Tasks and Contacts, and join the assigned-contact field to the contact ID. Include the employee name, task title, and completion field; set criteria to exclude completed tasks using your database's actual status values. Use Create > Report Wizard with that query to group outstanding assessments by employee.

Create reusable learning assignments and append separate tasks for each employee
Check required fields and assignment field types: If Access rejects the append, inspect Tasks in Design View for required fields, validation rules, or a multivalued AssignedTo field. The sample query is for a single numeric employee ID; a multivalued assignment field requires a different approach.
Free Microsoft Office alternative

Track Employee Learning Assessments in WPS Spreadsheet

WPS Office is a free, lightweight, easy-to-use alternative for spreadsheet-based assessment tracking—not a replacement for Access database queries. Its familiar interface and Microsoft Excel format compatibility make it easy to move an exported task list into a tracker with one row per employee and assessment.

Track employee, assessment, due date, and completion status in separate spreadsheet rows.Filter the status column to review incomplete assessments by employee.Open, edit, and save Microsoft Excel .xlsx and .xls files.Move Access data into WPS Spreadsheet through an Excel or CSV export; WPS does not run Access append queries or edit .accdb databases.
microsoft office alternative - wps office

Frequently Asked Questions

Why does each employee need a separate record for the same assessment?

Completion belongs to an employee's assignment, not just the assessment title. Create one Tasks record for each employee-assessment combination and store the employee's ID with it so status updates remain independent.

Can I reuse the append query for another employee?

Yes. Open the query in SQL View, replace the numeric value before AS AssignedTo with the next employee's contact ID, and select Run. Check that the same assessment set has not already been assigned to that employee before running it again.

What if my Tasks table does not have a TaskTitle field?

Open Tasks in Design View and identify the field that stores the task name. Replace TaskTitle in the INSERT INTO field list with that field name. Use square brackets around names containing spaces, such as [Task Title].

How do I show employees who have not completed their assessments?

Select Create > Query Design and join Tasks to Contacts through the employee ID. Add employee name, task title, and completion status, then filter out completed records using the values stored in your completion field. Build a report from that query with Create > Report Wizard.

Can WPS Office run this Access append query?

No. Run the append query in Microsoft Access. For spreadsheet-based tracking, export the task data from Access using External Data > Excel or a text/CSV export, then open the exported file in WPS Spreadsheet.