Creating a survey with pre-populated data

Question

Goal: to create an employee survey with pre-population user-defined data.

I have 100 staff with a variety of different equipment. I would like to build a personalised survey which list all of the equipement they have on file and asks them to confirm/deny that they have that equipment. I have created surveys before using Forms, but as I beleieve I can only gather information and not populate the survey with custom information from Excel/Access etc.

Any ideas how I can achive this within the 365 suite.

Thanks,

Answer 1

In Access this would be a simple binary many-to-many relationship type between employees and equipment. Such a relationship type is modelled by an EmployeeEquipment table which resolves the relationship type into two one-to-many relationship types between an Employees table and the EmployeeEquipment table, and the Equipment table and the EmployeeEquipment table.

The EmployeeEquipment table would have foreign keys EmployeeID and EquipmentID, referencing the primary keys of Employees and Equipment respectively. It might have other columns rep[resenting attributes of the relationship type such as the dates between which the equipment is held by the employee for instance.

You might like to take a look at DatabaseBasics.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

This little demo file illustrates, amongst other things, how different relationship types are modelled in Access. The section on 'entering data via a form/subforms' includes a simple contacts form which illustrates how the relationship type between contacts and employers is represented in the user interface by means of a subform which is based on the ContactEmployers table which models the many-to-many relationship type between contacts and employers as described above.