Create two queries: one for the sales department and one for male children born 1977-1979.

Here are the steps to complete the tasks: 1. Create a query for sales department members: 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 you want to include in the query (e.g., all fields by double-clicking the asterisk * or specific fields like Name, Department). Step 5: In the Criteria row for the Department field, type "Sales". 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 sales as the query name and click OK. 2. Create a query for male children born between 1977 and 1979: 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 Children's details table and click Add, then Close. Step 4: Double-click on the fields you want to include (e.g., Name, Gender, Date of Birth or Year of Birth). Step 5: In the Criteria row for the Gender field, type "Male". Step 6: In the Criteria row for the Date of Birth (or Year of Birth) field, type Between #1/1/1977And #12/31/1979# (if it's a date field) or Between 1977 And 1979 (if it's a year field). Step 7: Click Run in the Results group on the Design tab to view the query results. Step 8: Click Save on the Quick Access Toolbar or File > Save. Type BOYS as the query name and click OK. 3. Create a simple form using the Autoform:Tabular wizard for the personal details table: Step 1: Select the personal details table in the Navigation Pane. Step 2: Go to the Create tab on the ribbon. Step 3: In the Forms group, click Form Wizard. Step 4: In the Form Wizard dialog, ensure personal details is selected under Tables/Queries. Click the >> button to move all available fields to the Selected Fields list. Click Next. Step 5: Choose Tabular as the layout for your form. Click Next. Step 6: Select a style of your choice. Click Next. Step 7: Type Personal input form as the title for your form. Step 8: Click Finish. Step 9: (Based on the provided procedure) If the form is not already tabular, go to the Arrange tab, and in the Control Layout group, click Tabular. 4. Add four new records to the personal details table: Step 1: Open the Personal input form you just created. Step 2: Navigate to a new, blank record. This is usually done by clicking the New (blank) record button (often a right arrow with an asterisk) in the record navigation bar at the bottom of the form. Step 3: Enter the data for your first new record into the respective fields. Step 4: Repeat Step 2 and Step 3 three more times to add a total of four new records. 5. Create forms for the other three tables using the Form Wizard: Repeat the following steps for each of the three additional tables (e.g., Table A, Table B, Table C). Step 1: Go to the Create tab on the ribbon. Step 2: In the Forms group, click More Forms, then select Form Wizard. Step 3: In the Form Wizard dialog, choose the specific table you are to use (e.g., Table A) from the Tables/Queries dropdown list. Click OK. Step 4: Click the >> button to move all available fields to the Selected Fields list. Click Next. Step 5: Select Tabular as the layout for your form. Click Next. Step 6: Select a style of your choice. Click Next. Step 7: Type a descriptive name for the form (e.g., Table A Form). Step 8: Click Finish. Send me the next one 📸