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
- How can I type the Java OOP code by using JOptionPane with this following code below: public static void sellCruiseTicket(Cruise[] allCruises) { //Type the code here }arrow_forwardDraw a system/level-0 diagram for this scenario: You are developing a new customer relationship management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary. Example of what a level-0 diagram looks like is attached.arrow_forwardWhat is the value of performing exploratory data analysis in designing data visualizations? What are some examples?arrow_forward
- Draw a level-0 diagram for this scenario: You are developing a new customer relationship management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary.arrow_forwardDraw a context diagram for this scenario: You are developing a new customer relationship Management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in. the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary.arrow_forwardWrite a complete Java program named FindSumAndAverage that performs the following tasks in 2-D array: Main Method: a. The main() method asks the user to provide the dimension n for a square matrix. A square matrix has an equal number of rows and columns. b. The main() method receives the value of n and calls the matrixSetUp() method that creates a square matrix of size n and populates it randomly with integers between 1 and 9. c. The main method then calls another method named printMatrix() to display the matrix in a matrix format. d. The main method also calls a method named findSumAndAverage() which: • Receives the generated matrix as input. • Calculates the sum of all elements in the matrix. • Calculates the average value of the elements in the matrix. • Stores these values (sum and average) in a single-dimensional array and returns this array • e. The main method prints the sum and average based on the result returned from findSumAndAverage()). Enter the dimension n for the square…arrow_forward
- The partial sums remain the same no matter what indexing we done to s artial sum of each series onverges, * + s of each series to the series or show 12. (1)+(0)+(0)+(+1)+ 17, " (F) + (F) + (F)(F)(- 18. 19. 1 #20. (三)+(三)-(三)+(3) 20 (9)-(0)-(0)-- 10 +1 2.1+(男)+(男)+(罰)+(鄂 9 T29 x222-끝+1-23 + -.... Repeating Decimals 64 Express each of the numbers in Exercises 23-30 as the m integers. 23. 0.23 = 0.23 23 23... 24. 0.234 = 0.234 234 234. 25. 0.7 = 0.7777... 26. 0.d = 0.dddd... where d is a digit natio of own s converges or * 27. 0.06 = 0.06666.. 28. 1.4141.414 414 414... 29. 1.24123 = 1.24 123 123 123... 30. 3.142857 = 3.142857 142857. Using the ath-Term Test In Exercises 31-38, use the ath-Term Test for divergence to show that the series is divergent, or state that the test is inconclusive 8arrow_forwardCPS 2231 Computer Programming Homework #3 Due Date: Posted on Canvas 1. Provide answers to the following Check Point Questions from our textbook (5 points): a. How do you define a class? How do you define a class in Eclipse? b. How do you declare an object's reference variable (Hint: object's reference variable is the name of that object)? c. How do you create an object? d. What are the differences between constructors and regular methods? e. Explain why we need classes and objects in Java programming. 2. Write the Account class. The UML diagram of the class is represented below (10 points): Account id: int = 0 - balance: double = 0 - annualInterestRate: double = 0.02 - dateCreated: java.util.Date + Account() + Account(id: int, balance: double) + getId(): int + setId(newId: int): void + getBalance(): double + setBalance(newBalance: double): void + getAnnualInterestRate(): double + setAnnualInterest Rate (newRate: double): void + toString(): String + getDataCreated(): java.util.Date +…arrow_forwardTHIS IS NOT A GRADING ASSIGNMENT: Please only do lab 2.2 (bottom part of the first picture) For that Lab 2.2 do: *Part 1 (do the CODE, that's super important I need it) *Part 2 *Part 3 I also attached Section 2.5.2 which is part of the step 1 so you can read what is it about. Thank you!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,