Please write formulas/criteria needed to make these adjustments.

e Create External Deta Database Tools Help Table Fields Table O Tell me what you want to do Using the last assignment do the following: Note: Do not enter dashes for the IDNo or a period for the Mi. Make sure that a format is used for these fields. Create the following select queries: the amount over 25,000 , it is 10%. 2. Each individual will receive a base salary of 5.500 which is calculated in the Total salary. 3. Add one more column called Totalsalary. Ereate an update an update query calculating TotalSalary which is based on the Commission and the base salary. Upload the Access file to BlackBoard. Duest Tueschay November 15, 2.022 at 4:20PM e Create External Deta Database Tools Help Table Fields Table O Tell me what you want to do Using the last assignment do the following: Note: Do not enter dashes for the IDNo or a period for the Mi. Make sure that a format is used for these fields. Create the following select queries: the amount over 25,000 , it is 10%. 2. Each individual will receive a base salary of 5.500 which is calculated in the Total salary. 3. Add one more column called Totalsalary. Ereate an update an update query calculating TotalSalary which is based on the Commission and the base salary. Upload the Access file to BlackBoard. Duest Tueschay November 15, 2.022 at 4:20PM