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

Consider the following database for some store: Customers (cid, cname, city, discount)Agents (aid, aname, city, percent)Products (pid, pname, city, quantity, price)Orders (ordno, mon, cid, aid, pid, qty, dollars) The relation Customers records the ID (cid), name (cname), location (city) of each customer and a discount percentage (discount) for this customer. The relation Agents records the ID (aid), name (aname), location (city) of each agent and a transaction fee (percent) charged by this agent. The relation Products lists the ID (pid), name (pname), location (city), quantity and price of available products. And finally, the relation Orders contains a unique order number (ordno), the month (mon), customer (cid), agent (aid), product (pid), quantity (qty) of each order as well as the total value (dollars) of the transaction. 1. Express the following query in SQL (a) List customers (names) who do not have discounts but purchased at least one product of price greater than $50. (b) Find…

Consider the following relational schema and briefly answer the questions that follow: Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct_time: integer) Dept(did: integer, budget: real, managerid: integer) a. Define a table constraint on Dept that will ensure that all managers have age > 30. b. Write SQL statements to delete all information about employees whose salaries exceed that of the manager of one or more departments that they work in. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates.

Consider the following relations: Student(snum: integer, sname: string, rmajor: string, level: string, age: integer) Class(cname: string, meets_at: time, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. 2. Express each of the following integrity constraints in SQL unless it is implied by the primary and foreign key constraint; if so, explain how it is implied. If the constraint cannot be expressed in SQL, say so. For each constraint, state what operations (inserts, deletes, and updates on specific relations) must be monitored to enforce the constraint. (a) Every faculty member must teach at least two courses. (b) Every student must be enrolled in the course called 'Math101'. (c) A student cannot add more than two courses at a time…

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