In: Computer Science
Identify the steps you would take to create a one-field table named Titles that could be used to constrain the values in the Title field of the Employees table to the existing values in that field.
• Create a select query from the Employees table with only the Title field.
• Group the records by the Title field and set an ascending sort order on the Title field.
• Change the query into a make-table query to make a table named Titles, and then run the query.
• Open the Employees table and add Lookup properties to the Title field that constrain its values to the Title field in the Titles table.