Final answer:
To modify the Increase Type field to use a lookup list with Merit and COLA, you would use the Lookup Wizard in Design view. This will allow you to set up the list to limit inputs to only those values without needing a separate table or complex expressions.
Step-by-step explanation:
To modify the Increase Type field to use a lookup list with Merit and COLA in a single column and limit the field to values in the list only, you would select option B) Use the "Lookup Wizard" to set up the lookup list. The steps involved in using the Lookup Wizard for setting up a lookup list typically include:
- Entering Design view for the database table that contains the IncreaseType field.
- Selecting the IncreaseType field and clicking on the Lookup Wizard tool which can be located in the Data Type column or via the field properties.
- Following the steps in the Lookup Wizard, where you will specify that you want the lookup column to look up the values in a list.
- Entering Merit and COLA as the desired options in the provided area.
- Defining whether multiple values are allowed (if relevant) and setting the option to limit the field to the values in the list.
- Saving the table design changes and testing the lookup list by viewing the table in Datasheet view and using the dropdown for the Increase Type field.
By following these steps, you can ensure that the Increase Type field will only accept either Merit or COLA as valid inputs, as specified in the lookup list you created using the Lookup Wizard. This method provides a simple way to manage predefined data without needing a separate table or complex expressions.