Creating a survey with pre-populated data

Paul Bolton 1 Reputation point
2022-09-07T14:33:35.76+00:00

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,

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
810 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ken Sheridan 2,666 Reputation points
    2022-09-07T23:41:19.113+00:00

    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.

    0 comments No comments