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
EBK USING MIS
- Task 3. i) Compare your results from Tasks 1 and 2. j) Repeat Tasks 1 and 2 for 500 and 5,000 elements. k) Summarize run-time results in the following table: Time/size n String StringBuilder 50 500 5,000arrow_forwardCan you please solve this without AIarrow_forward1. Create a Vehicle.java file. Implement the public Vehicle and Car classes in Vehicle.java, including all the variables and methods in the UMLS. Vehicle - make: String model: String -year: int + Vehicle(String make, String, model, int, year) + getMake(): String + setMake(String make): void + getModel(): String + setModel(String model): void + getYear(): int + set Year(int year): void +toString(): String Car - numDoors: int + numberOfCar: int + Car(String make, String, model, int, year, int numDoors) + getNumDoors(): int + setNumDoors (int num Doors): void + toString(): String 2. Create a CarTest.java file. Implement a public CarTest class with a main method. In the main method, create one Car object and print the object using System.out.println(). Then, print the numberOfCar. Your printing result must follow the example output: make Toyota, model=Camry, year=2022 numDoors=4 1 Hint: You need to modify the toString methods in the Car class and Vehicle class!arrow_forward
- CHATGPT GAVE ME WRONG ANSWER PLEASE HELParrow_forwardHELP CHAT GPT GAVE ME WRONG ANSWER Consider the following implementation of a container that will be used in a concurrent environment. The container is supposed to be used like an indexed array, but provide thread-safe access to elements. struct concurrent_container { // Assume it’s called for any new instance soon before it’s ever used void concurrent_container() { init_mutex(&lock); } ~concurrent_container() { destroy_mutex(&lock); } // Returns element by its index. int get(int index) { lock.acquire(); if (index < 0 || index >= size) { return -1; } int result = data[index]; lock.release(); return result; } // Sets element by its index. void set(int index, int value) { lock.acquire(); if (index < 0 || index >= size) { resize(size); } data[index] = value; lock.release(); } // Extend maximum capacity of the…arrow_forwardWrite a C program using embedded assembler in which you use your own function to multiply by two without using the product. Tip: Just remember that multiplying by two in binary means shifting the number one place to the left. You can use the sample program from the previous exercise as a basis, which increments a variable. Just replace the INC instruction with SHL.arrow_forward
- R languagearrow_forwardQuestion 1 (15 Points) Inheritance: In this question, we are going to create a new subclass of the SimpleGeometricObject class, named Triangle. Create a SimpleGeometricObject.java and Copy the source code of the SimpleGeometricObject class from the following link: https://liveexample.pearsoncmg.com/html/SimpleGeometricObject.html TASK 1: Create a Triangle class that extends the SimpleGeometricObject class in Eclipse, following the below UML diagram. + base:double = 5 + height:double = 10 Triangle + Triangle() + Triangle(newBase: double, newHeight: double) + getArea(): double + setBase(): void + setHeight(): void + getBase(): double + getHeight(): doublearrow_forwardQuestion 2 (10 Points): String vs. StringBuilder Create a Question2.java file and finish the following tasks: Task 1. a) Create a 1D array of integers to store 50 integers. b) Store values from 0 to 49 in the array you just created. c) Create a new String Object using no-arg constructor. d) Using for loop to add the array elements one by one to the String (one per loop iteration) Hint: to append an element to a String, use the + operator. e) Output the String on the console. Record and display a run-time it took to append all integers to the String (record run-time of 1.d.)). Please submit a screenshot. The screenshot should match the following example: 012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 it took 196708 nanoseconds to append 50 integers to the String.| Hint: You can use the following statements to record run-time. long begin, end, time; // we will measure time it took begin = System.nanoTime(); //we measure in nanoseconds. // put…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,