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
- Can you please solve this. Thanksarrow_forwardcan you solve this pleasearrow_forwardIn the previous homework scenario problem below: You have been hired by TechCo to create and manage their employee training portal. Your first task is to develop a program that will create and track different training sessions in the portal. Each training session has the following properties: • A session ID (e.g., "TECH101", "TECH205") • A session title (e.g., "Machine learning", "Advanced Java Programming") • A total duration in hours (e.g., 5.0, 8.0) • Current number of participants (e.g., 25) Each session must have at least a session ID and a total duration and must met the following requirements: • The maximum participant for each session is 30. • The total duration of a session must not exceed 10 hours. • The current number of participants should never exceed the maximum number of participants. Design an object-oriented solution to create a data definition class(DDC) and an implementation class for the session object. In the DDC, a session class must include: • Constructors to…arrow_forward
- In the previous homework scenario problem below: You have been hired by TechCo to create and manage their employee training portal. Your first task is to develop a program that will create and track different training sessions in the portal. Each training session has the following properties: • A session ID (e.g., "TECH101", "TECH205") • A session title (e.g., "Machine learning", "Advanced Java Programming") • A total duration in hours (e.g., 5.0, 8.0) • Current number of participants (e.g., 25) Each session must have at least a session ID and a total duration and must met the following requirements: • The maximum participant for each session is 30. • The total duration of a session must not exceed 10 hours. • The current number of participants should never exceed the maximum number of participants. Design an object-oriented solution to create a data definition class(DDC) and an implementation class for the session object. In the DDC, a session class must include: • Constructors to…arrow_forwardSend me the lexer and parserarrow_forwardHere is my code please draw a transition diagram and nfa on paper public class Lexer { private static final char EOF = 0; private static final int BUFFER_SIZE = 10; private Parser yyparser; // parent parser object private java.io.Reader reader; // input stream public int lineno; // line number public int column; // column // Double buffering implementation private char[] buffer1; private char[] buffer2; private boolean usingBuffer1; private int currentPos; private int bufferLength; private boolean endReached; // Keywords private static final String[] keywords = { "int", "print", "if", "else", "while", "void" }; public Lexer(java.io.Reader reader, Parser yyparser) throws Exception { this.reader = reader; this.yyparser = yyparser; this.lineno = 1; this.column = 0; // Initialize double buffering buffer1 = new char[BUFFER_SIZE]; buffer2 = new char[BUFFER_SIZE]; usingBuffer1 = true; currentPos = 0; bufferLength = 0; endReached = false; // Initial buffer fill fillBuffer(); } private…arrow_forward
- Create 2 charts using this data. One without using wind speed and one including max speed in mph. Write a Report and a short report explaining your visualizations and design decisions. Include the following: Lead Story: Identify the key story or insight based on your visualizations. Shaffer’s 4C Framework: Describe how you applied Shaffer’s 4C principles in the design of your charts. External Data Integration: Explain the second data and how you integrated it with the Halloween dataset. Compare the two datasets. Attach screenshots of the two charts (Bar graph or Line graph) The Shaffer 4 C’s of Data Visualization Clear - easily seen; sharply defined• who's the audience? what's the message? clarity more important than aestheticsClean - thorough; complete; unadulterated, labels, axis, gridlines, formatting, right chart type, colorchoice, etc.Concise - brief but comprehensive. not minimalist but not verboseCaptivating - to attract and hold by beauty or excellence does it capture…arrow_forwardHow can I resolve the following issue?arrow_forwardI need help to resolve, 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,