Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Open the Sales Rep table in Design view 2. Add a Lookup field, Job Type, to the Sales Rep table. The field should appear
1. Open the Sales Rep table in Design view 2. Add a Lookup field, Job Type, to the Sales Rep table. The field should appear after the Sales Rep ID field. The field will contain data on the job classification for a sales representative. The job types are PT, FT, and ST. In the description column of this field, make notes: PT (Part Time), FT (Full Time), and ST (Seasonal Time). Save these changes to the struc- ture. (Notes: you would create a dropdown list using the three values PT, FT, and ST for this new filed Job Type. Users can choose ONLY one of three values from the list for each record) 3. Create an update query and change all the entries in the Job Type column to PT: Save the query as Job Type Update Query 4. Open the Sales Rep table and make the following changes. You can use either the Find button or Filter By Selection (if necessary) to locate the records to change: a. Change the Job type for sales representatives 125,465, 512, 678 to FT b. Change the Job type for sales representatives 101 and 287 to ST c. Change the name of sales representative 475 to Leon. Tommy 1. Open the Sales Rep table in Design view 2. Add a Lookup field, Job Type, to the Sales Rep table. The field should appear after the Sales Rep ID field. The field will contain data on the job classification for a sales representative. The job types are PT, FT, and ST. In the description column of this field, make notes: PT (Part Time), FT (Full Time), and ST (Seasonal Time). Save these changes to the struc- ture. (Notes: you would create a dropdown list using the three values PT, FT, and ST for this new filed Job Type. Users can choose ONLY one of three values from the list for each record) 3. Create an update query and change all the entries in the Job Type column to PT: Save the query as Job Type Update Query 4. Open the Sales Rep table and make the following changes. You can use either the Find button or Filter By Selection (if necessary) to locate the records to change: a. Change the Job type for sales representatives 125,465, 512, 678 to FT b. Change the Job type for sales representatives 101 and 287 to ST c. Change the name of sales representative 475 to Leon. Tommy
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started