a. Creating Table: Step 1: Open MS Access from your computer. Take a blank desktop database . Screenshot of MS Access Step 2: Give the database name as “BOM” and click the “Create” option. Screenshot of MS Access Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button. Screenshot of MS Access

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Benefits of using arrays as instance variables: What are the advantages of incorporating arrays as instance variables within a class? Initializing and managing arrays: How do you initialize and manage arrays within class constructors and mutators (setters)? Example of using arrays as instance variables: Share an example where you have used arrays as instance variables and discuss its application in a real-world scenario. Common mistakes with arrays as instance variables: What are some common mistakes to avoid when working with arrays as instance variables? Information hiding violations: What is the potential violation of information hiding when using arrays as instance variables? How can this be resolved?

Do you think that computers should replace teachers? Give three references with your answer.

Is online learning or face to face learning better to teach students around the around the world? Give reasons for your answer and provide two references with your response. What are benefits of both online learning and face to face learning ? Give two references with your answer. How does online learning and face to face learning affects students around the world? Give two references with your answer.

Answer 2

Expert Solution & Answer

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Answer 8

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Answer 9

Chapter AE, Problem AE7.2

Explanation of Solution

a.

Creating Table:

Step 1: Open MS Access from your computer. Take a blank desktop database.

Screenshot of MS Access

Step 2: Give the database name as “BOM” and click the “Create” option.

Screenshot of MS Access

Step 3: To create a table, click “CREATE” from the menu bar and then choose “Table” from the options. A table, named “Table1” will be created. Right click “Table1” and then select “Design view” from the list. A new window pops up. Enter the table name as “PART” and then click “Ok” button.

Screenshot of MS Access

Answer 10

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Answer 11

Explanation of Solution

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Answer 12

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Answer 13

Explanation of Solution

c.

Writing “Level 2” and “Level 3” queries:

Create another “Query design” and write the below “Level 2” query.

Query “level 2”: SELECT * FROM PART WHERE (Level <> "2");

After writing the query save it by pressing “Ctrl+S” and name it as “Level 2”.

Screenshot of MS Access

Right click “Level 2” and then choose “Datasheet View” to view the result.

Screenshot of MS Access

Answer 14

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Answer 15

Explanation of Solution

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Answer 16

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Answer 17

Explanation of Solution

e.

Creating Subform/ Subreport:

Step 1: Right click “Bill of Materials” form and choose “Design View” from the list.

Screenshot of MS Access

Step 2: Choose “DESIGN” from the menu bar and then select “Subform/ Subreport” option as shown below.

Screenshot of MS Access

Step 3: Drag the mouse and create a box as shown below.

Screenshot of MS Access

Step 4: After leaving the mouse, a SubFrom Wizard appears. Choose the category as shown below and click “Next” button.

Screenshot of SubForm Wizard

Step 5: Select “Level 2” and then move all the fields to the other side as shown below...

Answer 18

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Answer 19

Explanation of Solution

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

Answer 20

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Answer 21

Explanation of Solution

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

Answer 22

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Answer 23

Explanation of Solution

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

Answer 24

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Answer 25

Explanation of Solution

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access

Answer 26

Expert Solution & Answer

Answer 27

Expert Solution & Answer

Answer 28

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 29

Ch. AE - Prob. AE1.1 Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - Prob. AE3.2 Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - Prob. AE5.1 Ch. AE - Prob. AE5.2

Explanation of Solution

Explanation of Solution

b. Writing Query: Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it. Screenshot of MS Access Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

Explanation of Solution

Explanation of Solution

d. Bill of Materials Form: Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below. Screenshot of MS Access Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

Explanation of Solution

Explanation of Solution

f. Creating Subform: Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it. Screenshot of MS Access Step 2: Add the Subform and link the fields as shown below. Close the tab after completing. Screenshot of MS Access

Explanation of Solution

g. Open “Bill of Materials” form: After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”. Screenshot of MS Access Screenshot of MS Access

Explanation of Solution

h. The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below. Result of “Level 1” query is shown below. Screenshot of MS Access Result of “Level 2” query is shown below...

Explanation of Solution

i. Bill of Materials result: Screenshot of MS Access Screenshot of MS Access Screenshot of MS Access

Want to see the full answer?

Chapter AE Solutions

b.

Writing Query:

Step 1: Select “CREATE” option from the menu bar and then choose “Query Design” from it.

Screenshot of MS Access

Step 2: Close the “Show Table” dialog box and click “SQL View” from the top left corner. A query form gets displayed as shown below...

d.

Bill of Materials Form:

Step 1: To open form, click “CREATE” option from the menu bar and then select “Form” from it as shown below.

Screenshot of MS Access

Step 2: Click and delete “QuantityRequired” and “PartOf” fields form it...

f.

Creating Subform:

Step 1: Right click and open “Level 2 Subform” as shown below. Set it to “Design View” to add a Subform in it.

Screenshot of MS Access

Step 2: Add the Subform and link the fields as shown below. Close the tab after completing.

Screenshot of MS Access

g.

Open “Bill of Materials” form:

After opening the form, it looks like “FIGURE AE-8”. Click “ENTER” button on the keyboard to view the fields from “FIGURE AE-8”.

Screenshot of MS Access

Screenshot of MS Access

h.

The added new items gets reflect in the queries “Level 1”, “Level 2”, and “Level 3” and it is shown below.

Result of “Level 1” query is shown below.

Screenshot of MS Access

Result of “Level 2” query is shown below...

i.

Bill of Materials result:

Screenshot of MS Access

Screenshot of MS Access

Screenshot of MS Access