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

Scenario Ecommerce order management is the back-end process for managing and fulfilling online orders. This includes everything from order routing and printing shipping labels to returns and subscription management and order history revenue generated etc. Suppose you are given a task to complete this module for an online clothing store. Q Admin should be given an option on login to see the total sale and profit gained, also Which Category Got Most profit as shown below. Category Total Sold Revenue Generated Profit gain Jackets 356 2,492,000 747,600 Blazer 785 471,000 188,400

In order to complete the term project for your introductory engineering class, you will need to create a PowerPoint presentation of a certain length and deliver it to the class at the time and date specified by your professor.

Scenario: The Best Events Company organizes events, and business is booming, so much so that they need your help to manage their service. They want you to create a software system to manage their employees, clients, suppliers, and events. A part of their software requirement is given below. You are required to do a self-study on how event-organizing companies work and create a design for managing the company's functions. In addition to the requirements below, you are encouraged to add more attributes and functionalities to the system. The company has different types of employees, such as, Sales Managers, Salespersons, Marketing Managers, Marketers, Accountants, Designers and Handymen. Some details required for employees include name, employee ID, department, job title, basic salary, age, date of birth, and passport details are also stored in the system. The table below provides a glimpse of how employees are managed. It is clear from the table that Susan Meyers manages both Shyam…

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 - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Solution Summary: The author demonstrates how to create a table using MS Access.

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

Solution Summary: The author demonstrates how to create a table using MS Access.

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