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
- module : java q1 and q2 in image Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and platform assignments. Requirements 1. Add Train Schedule, Cancel Scheduled Train, View Train Schedules and Platform Management 2. Concurrency Handling with Multithreading i.e Use threads to…arrow_forwardmodule : java Question 1: (40 MARKS) E-Hailing Bicycle Management System Case Study:An e-hailing company that rents out bicycles needs a system to manage its bicycles, users, and borrowing process. Each user can borrow up to 2 bicycles at a time, specifically for families with children 18 years or below. The system must track the bicycles (name, make, type, and availability) and users (name, ID, and borrowed bicycles). The company also wants to ensure that the system uses a multidimensional array to store information about the bicycles. Requirements: Add and View Bicycles: Borrow Bicycles: Return Bicycles Display Borrowed Bicycles and Search for a bicycle Create a menu-driven program to implement the above. Sample Output: Add Bicycle View All Bicycles Borrow Bicycle Return Bicycle View Borrowed Bicycles Search Bicycle ExitEnter your choice:arrow_forwardthis module is java 371. please answer all questions correctly , include all comments etc and follow all requirements. Question 1: (40 MARKS) E-Hailing Bicycle Management System Case Study:An e-hailing company that rents out bicycles needs a system to manage its bicycles, users, and borrowing process. Each user can borrow up to 2 bicycles at a time, specifically for families with children 18 years or below. The system must track the bicycles (name, make, type, and availability) and users (name, ID, and borrowed bicycles). The company also wants to ensure that the system uses a multidimensional array to store information about the bicycles. Requirements: Add and View Bicycles: Borrow Bicycles: Return Bicycles Display Borrowed Bicycles and Search for a bicycle Create a menu-driven program to implement the above. Sample Output: Add Bicycle View All Bicycles Borrow Bicycle Return Bicycle View Borrowed Bicycles Search Bicycle ExitEnter your choice: Question 2…arrow_forward
- this module is java 371. please answer all questions correctly , include all comments etc and follow all requirements. Question 1: (40 MARKS) E-Hailing Bicycle Management System Case Study:An e-hailing company that rents out bicycles needs a system to manage its bicycles, users, and borrowing process. Each user can borrow up to 2 bicycles at a time, specifically for families with children 18 years or below. The system must track the bicycles (name, make, type, and availability) and users (name, ID, and borrowed bicycles). The company also wants to ensure that the system uses a multidimensional array to store information about the bicycles. Requirements: Add and View Bicycles: Borrow Bicycles: Return Bicycles Display Borrowed Bicycles and Search for a bicycle Create a menu-driven program to implement the above. Sample Output: Add Bicycle View All Bicycles Borrow Bicycle Return Bicycle View Borrowed Bicycles Search Bicycle ExitEnter your choice: Question 2…arrow_forwardwhat are some available cloud components, types, delivery models, and configurations in web services and cloud computing? thanksarrow_forwardI would like to get information to know features about the following concepts: 1. Anything as a Server (XaaS) 2. Block Storage 3. WebSocketarrow_forward
- Please answer JAVA OOP problem below: You are working at a university that tracks students. Each student is identified by their name and faculty advisor. Each faculty advisor is identified by their name, department, and maximum number of students they can advise. Using solid OO design principles, create a modular program that implements all the classes for the problem and also creates an implementation class that gathers user input for one student and then prints out the information gathered by creating the appropriate data definition and implementation classes. All data must be validated. I have given the code so far: Implementation: import javax.swing.JOptionPane; public class Implementation { public static void main(String[] args) { FacultyAdvisor facultyAdvisor = new FacultyAdvisor("Sharmin Sultana", "IT", 30); Student student = new Student("John", facultyAdvisor); JOptionPane.showMessageDialog(null, student.toString()); } } Student: public…arrow_forwardExercise 1 Function and Structure [30 pts] Please debug the following program and answer the following questions. There is a cycle in a linked list if some node in the list can be reached again by continuously following the next pointer. #include typedef struct node { int value; struct node *next; } node; int 11_has_cycle (node *first) if (first == node *head { NULL) return 0;B = first; while (head->next != NULL) { if (head == first) { return 1; } head head->next; } return 0; void test_11_has_cycle() { int i; node nodes [6]; for (i = 0; i < 6; i++) nodes [i] .next = NULL; nodes [i].value i; } nodes [0] .next = &nodes [1]; nodes [1] .next = &nodes [2]; nodes [2] .next = &nodes [3]; nodes [3] .next = & nodes [4]; nodes [4] .next = NULL; nodes [5] .next = &nodes [0]; printf("1. Checking first list for cycles. \n Function 11_has_cycle says it hass cycle\n\n", 11_has_cycle (&nodes [0]) ?"a":"no"); printf("2. Checking length-zero list for cycles. \n Function 11_has_cycle says it has %s…arrow_forwardcheckpoint exercice for my students for Amortized Analysisarrow_forward
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education