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

Question

ScanSolve AI Tutor · Accepted Answer

Here are the steps to complete the tasks:

1. Create a query for sales department members:

Go to the Create tab on the ribbon.
In the Queries group, click Query Design.
In the Show Table dialog box, select the personal details table and click Add, then Close.
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).
In the Criteria row for the Department field, type "Sales".
Click Run in the Results group on the Design tab to view the query results.
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:
Go to the Create tab on the ribbon.
In the Queries group, click Query Design.
In the Show Table dialog box, select the Children's details table and click Add, then Close.
Double-click on the fields you want to include (e.g., Name, Gender, Date of Birth or Year of Birth).
In the Criteria row for the Gender field, type "Male".
In the Criteria row for the Date of Birth (or Year of Birth) field, type Between #1/1/1977# And #12/31/1979# (if it's a date field) or Between 1977 And 1979 (if it's a year field).
Click Run in the Results group on the Design tab to view the query results.
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:
Select the personal details table in the Navigation Pane.
Go to the Create tab on the ribbon.
In the Forms group, click Form Wizard.
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.
Choose Tabular as the layout for your form.
Click Next.
Select a style of your choice.
Click Next.
Type Personal input form as the title for your form.
Click Finish.
(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:
Open the Personal input form you just created.
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.
Enter the data for your first new record into the respective fields.
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).
Go to the Create tab on the ribbon.
In the Forms group, click More Forms, then select Form Wizard.
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.
Click the >> button to move all available fields to the Selected Fields list.
Click Next.
Select Tabular as the layout for your form.
Click Next.
Select a style of your choice.
Click Next.
Type a descriptive name for the form (e.g., Table A Form).
Click Finish.

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

Step-by-step solution

Go to the `Create` tab on the ribbon.

In the `Queries` group, click `Query Design`.

In the `Show Table` dialog box, select the `personal details` table and click `Add`, then `Close`.

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`).

In the `Criteria` row for the `Department` field, type `"Sales"`.

Click `Run` in the `Results` group on the `Design` tab to view the query results.

Click `Save` on the Quick Access Toolbar or `File > Save`.

Go to the `Create` tab on the ribbon.

In the `Queries` group, click `Query Design`.

In the `Show Table` dialog box, select the `Children's details` table and click `Add`, then `Close`.

Double-click on the fields you want to include (e.g., `Name`, `Gender`, `Date of Birth` or `Year of Birth`).

In the `Criteria` row for the `Gender` field, type `"Male"`.

In the `Criteria` row for the `Date of Birth` (or `Year of Birth`) field, type `Between #1/1/1977# And #12/31/1979#` (if it's a date field) or `Between 1977 And 1979` (if it's a year field).

Click `Run` in the `Results` group on the `Design` tab to view the query results.

Click `Save` on the Quick Access Toolbar or `File > Save`.

Select the `personal details` table in the Navigation Pane.

Go to the `Create` tab on the ribbon.

In the `Forms` group, click `Form Wizard`.

In the `Form Wizard` dialog, ensure `personal details` is selected under `Tables/Queries`.

Choose `Tabular` as the layout for your form.

Select a style of your choice.

Type `Personal input form` as the title for your form.

Click `Finish`.

(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`.

Open the `Personal input form` you just created.

Navigate to a new, blank record.

Enter the data for your first new record into the respective fields.

Repeat Step 2 and Step 3 three more times to add a total of four new records.

Go to the `Create` tab on the ribbon.

In the `Forms` group, click `More Forms`, then select `Form Wizard`.

In the `Form Wizard` dialog, choose the specific table you are to use (e.g., `Table A`) from the `Tables/Queries` dropdown list.

Click the `>>` button to move all available fields to the `Selected Fields` list.

Select `Tabular` as the layout for your form.

Select a style of your choice.

Type a descriptive name for the form (e.g., `Table A Form`).

Click `Finish`.

Still stuck on this one?

More Computer Science Questions

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

Step-by-step solution

Go to the Create tab on the ribbon.

In the Queries group, click Query Design.

In the Show Table dialog box, select the personal details table and click Add, then Close.

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).

In the Criteria row for the Department field, type "Sales".

Click Run in the Results group on the Design tab to view the query results.

Click Save on the Quick Access Toolbar or File > Save.

Go to the Create tab on the ribbon.

In the Queries group, click Query Design.

In the Show Table dialog box, select the Children's details table and click Add, then Close.

Double-click on the fields you want to include (e.g., Name, Gender, Date of Birth or Year of Birth).

In the Criteria row for the Gender field, type "Male".

In the Criteria row for the Date of Birth (or Year of Birth) field, type Between #1/1/1977# And #12/31/1979# (if it's a date field) or Between 1977 And 1979 (if it's a year field).

Click Run in the Results group on the Design tab to view the query results.

Click Save on the Quick Access Toolbar or File > Save.

Select the personal details table in the Navigation Pane.

Go to the Create tab on the ribbon.

In the Forms group, click Form Wizard.

In the Form Wizard dialog, ensure personal details is selected under Tables/Queries.

Choose Tabular as the layout for your form.

Select a style of your choice.

Type Personal input form as the title for your form.

Click Finish.

(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.

Open the Personal input form you just created.

Navigate to a new, blank record.

Enter the data for your first new record into the respective fields.

Repeat Step 2 and Step 3 three more times to add a total of four new records.

Go to the Create tab on the ribbon.

In the Forms group, click More Forms, then select Form Wizard.

In the Form Wizard dialog, choose the specific table you are to use (e.g., Table A) from the Tables/Queries dropdown list.

Click the >> button to move all available fields to the Selected Fields list.

Select Tabular as the layout for your form.

Select a style of your choice.

Type a descriptive name for the form (e.g., Table A Form).

Click Finish.

Still stuck on this one?

More Computer Science Questions

Go to the `Create` tab on the ribbon.

In the `Queries` group, click `Query Design`.

In the `Show Table` dialog box, select the `personal details` table and click `Add`, then `Close`.

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`).

In the `Criteria` row for the `Department` field, type `"Sales"`.

Click `Run` in the `Results` group on the `Design` tab to view the query results.

Click `Save` on the Quick Access Toolbar or `File > Save`.

Go to the `Create` tab on the ribbon.

In the `Queries` group, click `Query Design`.

In the `Show Table` dialog box, select the `Children's details` table and click `Add`, then `Close`.

Double-click on the fields you want to include (e.g., `Name`, `Gender`, `Date of Birth` or `Year of Birth`).

In the `Criteria` row for the `Gender` field, type `"Male"`.

In the `Criteria` row for the `Date of Birth` (or `Year of Birth`) field, type `Between #1/1/1977# And #12/31/1979#` (if it's a date field) or `Between 1977 And 1979` (if it's a year field).

Click `Run` in the `Results` group on the `Design` tab to view the query results.

Click `Save` on the Quick Access Toolbar or `File > Save`.

Select the `personal details` table in the Navigation Pane.

Go to the `Create` tab on the ribbon.

In the `Forms` group, click `Form Wizard`.

In the `Form Wizard` dialog, ensure `personal details` is selected under `Tables/Queries`.

Choose `Tabular` as the layout for your form.

Type `Personal input form` as the title for your form.

Click `Finish`.

(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`.

Open the `Personal input form` you just created.

Go to the `Create` tab on the ribbon.

In the `Forms` group, click `More Forms`, then select `Form Wizard`.

In the `Form Wizard` dialog, choose the specific table you are to use (e.g., `Table A`) from the `Tables/Queries` dropdown list.

Click the `>>` button to move all available fields to the `Selected Fields` list.

Select `Tabular` as the layout for your form.

Type a descriptive name for the form (e.g., `Table A Form`).

Click `Finish`.