Enter Data into All Employee ID#'s Using a Form

[LonnieCAR]

I have a database that I need to update before my company gets audited on Monday. I need to enter all the required training courses for employees but the current form in the system merely allows you to pull down by employee ID# and enter them one-by-one. Is there a simple way to enter a course for all employees (like 50+) without having to do each course one-by-one? I have like 25 courses.Thank you. 

[burrina]

You can do so using a Update Query. Just add the table(s) to your query and add the appropriate fields and criteria.

[June7]

If you need to batch create a set of records, think you need an INSERT SELECT action sql.

Or maybe just copy/paste will work for this one-time requirement.

Build a query that uses the Employees table and the Courses table. Don't link them in the query. This will result in a Cartesian relationship - every record of each table will join to each record of other table - resulting in every possible combination of employees and courses. Use this query as source for the INSERT SELECT sql or copy/paste records.