Explanation of Solution
a.
Creating Table:
Step 1: Open MS Access from your computer. Take a blank desktop
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
Want to see the full answer?
Check out a sample textbook solution
Chapter AE Solutions
Using MIS (10th Edition)
- Question: Finding the smallest element and its row index and column index in 2D Array: 1. Write a public Java class min2D. 2. In min2D, write a main method. 3. In the main method, create a 2-D array myArray with 2 rows and 5 columns: {{10, 21, 20, 13, 1}, {2, 6, 7, 8, 14}}. 4. Then, use a nested for loop to find the smallest element and its row index and column index. 5. Print the smallest element and its row index and column index on Java Consolearrow_forward(using R)The iris data set in R gives the measurements in centimeters of the variables sepal length and width andpetal length and width, respectively, for 50 flowers from each of 3 species of iris, setosa, versicolor, andvirginica. Use the iris data set and the t.test function, test if the mean of pepal length of iris flowers isgreater than the mean of sepal length.The iris data set in R gives the measurements in centimeters of the variables sepal length and width andpetal length and width, respectively, for 50 flowers from each of 3 species of iris, setosa, versicolor, andvirginica. Use the iris data set and the t.test function, test if the mean of pepal length of iris flowers isgreater than the mean of sepal length.arrow_forwardRecognizing the Use of Steganography in Forensic Evidence (4e)Digital Forensics, Investigation, and Response, Fourth Edition - Lab 02arrow_forward
- Write a Java Program to manage student information of a university. The Javaprogram does the following steps:a) The program must use single-dimensional arrays to store the studentinformation such as Student ID, Name and Major.b) The program asks the user to provide the number of students.c) The program asks the user to enter the Student IDs for the number of studentsand stores them.d) The program asks the user to enter the corresponding names for the numberof students and stores them.e) The program then asks the user to provide the corresponding major for thestudents and stores them.f) The program then should display the following options:1. ID Search2. Major Enrollment3. Exitg) On selecting option 1, the user can search for a student using Student ID. Theprogram asks the user to enter a Student ID. It then should print thecorresponding student’s details such as Name and Major if the user providedStudent ID number is present in the stored data. If the user’s Student IDnumber does not…arrow_forward(a) Algebraically determine the output state |q3q2q1q0> (which is a 4-qubitvector in 16-dimensional Hilbert space). Show all steps of your calculations. (b) Run a Qiskit code which implements the circuit and append threemeasurement gates to measure the (partial) output state |q2q1q0> (which is a 3-qubit vector in 8-dimensional Hilbert space). this is for quantum soft dev class, you can use stuff like Deutsch Jozsa if u wantarrow_forwardWrite a C++ program that will count from 1 to 10 by 1. The default output should be 1, 2, 3, 4, 5, 6 , 7, 8, 9, 10 There should be only a newline after the last number. Each number except the last should be followed by a comma and a space. To make your program more functional, you should parse command line arguments and change behavior based on their values. Argument Parameter Action -f, --first yes, an integer Change place you start counting -l, --last yes, an integer Change place you end counting -s, --skip optional, an integer, 1 if not specified Change the amount you add to the counter each iteration -h, --help none Print a help message including these instructions. -j, --joke none Tell a number based joke. So, if your program is called counter counter -f 10 --last 4 --skip 2 should produce 10, 8, 6, 4 Please use the last supplied argument. If your code is called counter, counter -f 4 -f 5 -f 6 should count from 6. You should count from first to last inclusively.…arrow_forward
- Write a program that will count from 1 to 10 by 1. The default output should be 1, 2, 3, 4, 5, 6 , 7, 8, 9, 10 There should be only a newline after the last number. Each number except the last should be followed by a comma and a space. To make your program more functional, you should parse command line arguments and change behavior based on their values. Argument Parameter Action -f, --first yes, an integer Change place you start counting -l, --last yes, an integer Change place you end counting -s, --skip optional, an integer, 1 if not specified Change the amount you add to the counter each iteration -h, --help none Print a help message including these instructions. -j, --joke none Tell a number based joke. So, if your program is called counter counter -f 10 --last 4 --skip 2 should produce 10, 8, 6, 4 Please use the last supplied argument. If your code is called counter, counter -f 4 -f 5 -f 6 should count from 6. You should count from first to last inclusively. You…arrow_forwardWas What is the deference betwem full At Adber and Hold?arrow_forwardI need help making this EER diagram in Chen Notation.arrow_forward
- In Java I have an input in a text file that I can't submit here. So, please use it as input.txtarrow_forwardPerceptual acuity, according to Ram Charan, explains how Ted Turner became the first CEO to recognize the potential of 24-hour news and thereby created CNN. a) True b) Falsearrow_forwardAs described in Learning from Mistakes, the failure of the A380 to reach its sales goals was due to Multiple Choice: a) misunderstanding of supplier demands. b) good selection of hotel in the sky amenities. c) changes in customer demands. d) lack of production capacity.arrow_forward
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
New Perspectives on HTML5, CSS3, and JavaScriptComputer ScienceISBN:9781305503922Author:Patrick M. CareyPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Microsoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,