1. Create a new query in Query Design View with the following details:
   1. Add the Client and ClientSoftware tables.
   2. Add the ClientName and ProjectStart fields from the Client table and the SoftwareCode field from the ClientSoftware table.
   3. Set the criteria for the SoftwareCode field (using the 'in' keyword) to only include the software codes ONBD, RECR, and SCRE.
   4. Using the expression builder, create a new field named IsCorp.
   5. Within the expression builder, use the iif function to populate the IsCorp with 'True' if the client name contains 'Corporation' and 'False' if not.
   6. Save the query as CorporateNewHireClients and run the query. Close the CorporateNewHireClients query.