How do I create queries in MS Access to add new fields and combine fields from multiple tables?

Here are the steps to complete the tasks: QUERY ONE: Creating queries with new fields Step 1: Go to the Create tab on the ribbon. Step 2: In the Queries group, click Query Design. Step 3: In the Show Table dialog box, select the personal details table and click Add, then Close. Step 4: Double-click on the fields Paynum, Forename, Department, and Birthdate to add them to the query grid. Step 5: In the next empty field column in the query grid, type Age: Date()-[Birthdate] in the Field row. Step 6: Click Run in the Results group on the Design tab to view the query results. Step 7: Click Save on the Quick Access Toolbar or File > Save. Type Personnel ages as the query name and click OK. QUERY TWO: Create another select query using fields from various tables Step 1: Go to the Create tab on the ribbon. Step 2: In the Queries group, click Query Design. Step 3: In the Show Table dialog box, select personal details, Appointment, and Payments tables. Click Add for each, then Close. Step 4: Double-click on the following fields to add them to the query grid: • From personal details: Paynum, Surname, Department • From Appointment: Appointed, Salary • From Payments: Tax, Medical aid, Pension Step 5: In the next empty field column in the query grid, type NET SALARY:[SALARY]-[TAX]-[MEDICAL AID]-[PENSION] in the Field row. Step 6: Click Run in the Results group on the Design tab to view the query results. Step 7: Click Save on the Quick Access Toolbar or File > Save. Type net salaries as the query name and click OK. QUERY THREE: CREATING CROSSTAB QUERIES Step 1: Go to the Create tab on the ribbon. Step 2: In the Queries group, click Query Wizard. Step 3: Select Crosstab Query Wizard and click OK. Step 4: In the first step of the wizard, select Table: personal details and click Next. Step 5: For the row heading, select Nationality and click Next. Step 6: For the column heading, select Department and click Next. Step 7: For the calculation, select Paynum and choose Count as the function. Ensure Yes, include row sums is selected. Click Next. Step 8: Type Department by nationality summary as the query name. Step 9: Click Finish to view the results. QUERY FOUR: CREATING ACTION (UPDATE) QUERY Step 1: Go to the Create tab on the ribbon. Step 2: In the Queries group, click Query Design. Step 3: In the Show Table dialog box, select the appointment table and click Add, then Close. Step 4: In the Query Type group on the Design tab, click Update. Step 5: Double-click on the Salary field to add it to the query grid. Step 6: In the Update To row for the Salary field, type [salary]*1.15. Step 7: Click Run in the Results group on the Design tab. A warning message will appear indicating that you are about to update records. Click Yes to proceed. Step 8: Open the appointment table to verify that the salaries have been increased by 15%. That's 2 down. 3 left today — send the next one.