Accuracy please. Decipher the abnomalate networking algorithms by developing a unique application that performs on automotive cyber intelligence. I expect detailed codes, screenshots of app interfaces, technical web processes for each and every step in this question. I expect 20 different code affiliations, 30 screenshots, and 15 elaborate expansions.

each order. The result of your work will be a list of orders that took more than 30 days to ship. The salespeople will be required to review the records and report the source of the delay for each order. The CEO feels there may be issues with one of the shipping companies, and would like data to back that up.

aery using Query Design. From the Customers table, include the fields CompanyName, ContactName, ContactTitle, and Phone. From the Orders table, include the fields OrderID, OrderDate, and ShippedDate. b.Run the query and examine the records. Save the query as Shipping Efficiency. c.Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: The expression will include the OrderDate and the ShippedDate; the results will not contain negative numbers.) d.Run the query and examine the results. Does the data in the DaysToShip field look accurate? Save the query. e.Add criteria to limit the query results to include only orders that took more than 30 days to ship. f.Add the Quantity field from the Order Details table and the ProductName field from the Products table to the query. Sort the query by ascending OrderID. When the sales reps contact these customers, these two fields will provide useful information about the orders. g.Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the results. Adjust column widths as necessary. h.Save and close the query. Order Summary Query

The CEO is considering the financial impact of discounts. She asked for a query showing the employee name, number of orders they have taken, and the total discount amount they have given customers. She hopes to see if there is a correlation between the discount offered and the number of sales.

a.uery using Query Design and add the Orders, Order Details, Products, and Customers tables. Add the fields OrderID and OrderDate from the Orders table. Set both fields' Total row to Group By. b.Add a calculated field in the third column. Name the field ExtendedAmount. This field should multiply the quantity ordered (from the Order Details table) by the unit price for that item (from the Products table). This will calculate the total amount for each order. Format the calculated field as Currency and change the caption to Total Dollars. Change the Total row to Sum. c.Add a calculated field in the fourth column. Name the field DiscountAmount. The field should multiply the quantity ordered, the unit price for that item, and the discount field (from the Customers table). This will calculate the total discount for each order. Format the calculated field as Currency and add a caption of Discount Amt. Change the Total row to Sum. d.Run the query. Examine the results. Most customers should have a discount of 10% of the total dollars, but some customers will have no discount. Save the query as Order Summary. Return to Design view. e.Add criteria to the OrderDate field so only orders made between 1/1/2016 and 12/31/2016 are displayed. Change the Total row to Where. This expression will display only orders that were placed in 2016.Software engineering pros properlgate the QRS column and widths, solve as set below:open the sp_home_txt.html and sp_layout_txt.css files from the html03 > case1 folder. Enter your name and the date in the comment section of each file, and save them as sp_home.html and sp_layout.css respectively. 2. Go to the sp_home.html file in your editor. Within the document head, create links to the sp_base.css, sp_styles.css, and sp_layout.css style sheet files. Study the content and structure of the file and then save your changes to the document.

3. Go to the sp_layout.css file in your editor. Go to the Window and Body Styles section. style rule for the html element that sets the height of the browser window at 100%.

4. style rule for the page body that sets the width to 95% of the browser window ranging

from 640 pixels up to 960 pixels. Horizontally center the page body within the browser window.

Finally, Karen wants to ensure that the height of the page body is always at least as high as the

browser window itself. Set the minimum height of the browser window to 100%.

5.style rule to apply the Border Box model to all header, ul, nav, li, and a elements in

the document.

6. Go to the Row Styles section. Karen has placed all elements that should be treated as grid rows

in the row class. For every element of the row classstyle rule that expands the element

to cover any floating content within the element. (Hint: Use the technique shown in the tutorial

that employs the after pseudo-element.)

7. Go to the Page Header Styles section. In this section, you will create styles for the content of

the body header. tyle rule for the logo image within the body header that displays the

image as a block with a width of 70% of the header, floated on the left margin.

8. The header also contains a navigation list that Karen wants to display vertically. C style

rule for the nav element within the body header that: a) floats the navigation list on the left,

b) sets the size of the left and right padding to 2%, and c) sets the width of the navigation list

to 30% of the width of the header.

9. The hypertext links in the navigation list should be displayed as blocks. Cyle rule for every a

element in the header navigation list that displays the element as a block with a width of 100%.

10. Go to the Horizontal Navigation List Styles section. Karen has added a second navigation list that

she wants to display horizontally. For all list items within the horizontal navigation list,

style rule that displays the items as blocks with a width of 12.5% floated on the left margin.

11. Go to the Topics Styles section. This section sets the styles for a list of four topics describing what

the company is offering. Karen wants this list to also be displayed horizontally on the page. For

list items within the ul element with the id topics,a style rule to: a) display the items as

blocks with a width of 20%, b) float the items on the left margin, and c) set the size of the left

margin space to 0% and the right margin space to 1.5%.

12. Karen wants the topics list to be well away from the left and right edges of the page body. In the

same section, c rule that sets the size of the left margin of the first item in the topics list to

7.75% and sets the right margin of the last item to 7.75%.

13. In the same section, ca rule that displays the image within each list item in the topics list as

a block with a width of 50% and centered within the list item block. (Hint: Set the left and right

margins to auto.)

14. Go to the HR Styles section. The hr element is used to display a horizontal divider between

sections of the page. Add a style rule that sets the width of the hr element to 50%.

15. Go to the Customer Comment Styles section. In this section, you will create style rules for the

customer comments displayed near the bottom of the page. For the ul element with the id

comments, a style rule that sets the width to 75% and centers the element by setting the

top/bottom margin to 40 pixels and the left/right margin to auto.

16. Karen wants the list items to appear in two columns on the page. In the same section, c

style rule for every list item in the comments list that: a) displays the item as a block with a width

of 50% floated on the left and b) sets the size of the bottom margin to 30 pixels.

17. Every customer comment is accompanied by an image of the student. Karen wants these

images displayed to the left of the comment. style rule to display the image within

each comment list item as a block with a width of 20%, floated on the left, and with a left/right

margin of 5%.

18. a style rule for every paragraph nested within a customer list item that floats the

paragraph on the left margin with a width of 70%.

19. Go to the Footer Styles section anda style rule that displays the footer only when both

margins are clear of floating objects.

20. Save your changes to the file and then open the sp_home.html file in your browser. Verify that

the layout and appearance of the page elements resemble that shown in Figure 3-66.

Shipping Efficiency Query

You will an inquiry to work out the quantity of days between the date a request was put in and the date the request was delivered for each request. The consequence of your work will be a rundown of orders that required over 30 days to transport. The sales reps will be expected to audit the records and report the wellspring of the postponement for each request. The CEO feels there might be issues with one of the transportation organizations, and would like information to back that up.

aery utilizing Query Design. From the Customers table, incorporate the fields CompanyName, ContactName, ContactTitle, and Phone. From the Orders table, incorporate the fields OrderID, OrderDate, and ShippedDate. b.Run the inquiry and inspect the records. Save the inquiry as Shipping Efficiency. c.Add a determined field named DaysToShip to work out the quantity of days taken to take care of each request. (Here's a clue: The articulation will incorporate the OrderDate and the ShippedDate; the outcomes won't contain negative numbers.) d.Run the inquiry and look at the outcomes. Does the information in the DaysToShip handle look precise? Save the inquiry. e.Add rules to restrict the question results to incorporate just requests that required over 30 days to transport. f.Add the Quantity field from the Order Details table and the ProductName field from the Products table to the inquiry. Sort the question by rising OrderID. At the point when the agents contact these clients, these two fields will give valuable data about the orders. g.Add the subtitle Days to Ship to the DaysToShip field. Change to Datasheet view to see the outcomes. Change section widths as the need might arise. h.Save and close the inquiry. Request Summary Query

The CEO is thinking about the monetary effect of limits. She requested a question showing the representative name, number of requests they have taken, and the complete markdown sum they have given clients. She desires to check whether there is a relationship between's the markdown offered and the quantity of deals.

a.uery utilizing Query Design and add the Orders, Order Details, Products, and Customers tables. Add the fields OrderID and OrderDate from the Orders table. Set the two fields' Total column to Group By. b.Add a determined field in the third segment. Name the field ExtendedAmount. This field ought to duplicate the amount requested (from the Order Details table) by the unit cost for that thing (from the Products table). This will work out the aggregate sum for each request. Design the determined field as Currency and change the inscription to Total Dollars. Change the Total column to Sum. c.Add a determined field in the fourth segment. Name the field DiscountAmount. The field ought to duplicate the amount requested, the unit cost for that thing, and the rebate field (from the Customers table). This will ascertain the absolute rebate for each request. Design the determined field as Currency and add an inscription of Discount Amt. Change the Total line to Sum. d.Run the question. Analyze the outcomes. Most clients ought to have a rebate of 10% of the all out dollars, however a few clients will have no markdown. Save the question as Order Summary. Get back to Design view. e.Add standards to the OrderDate field so just orders made between 1/1/2016 and 12/31/2016 are shown. Change the Total line to Where. This articulation will show just requests.The hypertext joins in the route rundown ought to be shown as blocks. Cyle rule for each a

component in the header route list that shows the component as a block with a width of 100 percent

Computer programming and software aces properlgate the QRS section and widths, tackle as set beneath:Go to the HR Styles segment

Utilizing your supervisor, open the sp_home_txt.html and sp_layout_txt.css documents from the html03 > case1 envelope. Enter your name and the date in the remark segment of each document, and save them as sp_home.html and sp_layout.css separately.

2. Go to the sp_home.html record in your proofreader. Inside the report head, make connects to the sp_base.css, sp_styles.css, and sp_layout.css template documents. Concentrate on the substance and construction of the record and afterward save your progressions to the report.

3. Go to the sp_layout.css document in your manager. Go to the Window and Body Styles area. style rule for the html component that sets the level of the program window at 100 percent.

4. style rule for the page body that sets the width to 95% of the program window going

from 640 pixels up to 960 pixels. Evenly focus the page body inside the program window.

At long last, Karen needs to guarantee that the level of the page body is dependably essentially as high as the

program window itself. Set the base level of the program window to 100 percent.

5.style rule to apply the Border Box model to all header, ul, nav, li, and a components in

the report.

6. Go to the Row Styles segment. Karen has set all components that ought to be treated as matrix columns

in the column class. For each component of the column classstyle decide that extends the component

to cover any drifting substance inside the component. (Answer: Use the procedure displayed in the instructional exercise

that utilizes the after pseudo-component.)

7. Go to the Page Header Styles segment. In this part, you will make styles for the substance of

the body header. tyle rule for the logo picture inside the body header that shows the

picture as a block with a width of 70% of the header, drifted on the left edge.

8. The header likewise contains a route list that Karen needs to upward show. C style

rule for the nav component inside the body header that: a) floats the route list on the left,

b) sets the size of the left and right cushioning to 2%, and c) sets the width of the route list

to 30% of the width of the header.

9. The hypertext joins in the route rundown ought to be shown as blocks. Cyle rule for each a

component in the header route list that shows the component as a block with a width of 100 percent.

10. Go to the Horizontal Navigation List Styles segment. Karen has added a subsequent route list that

she needs to on a level plane showcase. For all rundown things inside the flat route list,

style decide that shows the things as blocks with a width of 12.5% drifted on the left edge.

11. Go to the Topics Styles area. This segment sets the styles for a rundown of four subjects depicting what

the organization is advertising. Karen maintains that this rundown should likewise be shown evenly on the page. For

list things inside the ul component with the id topics,a style rule to: a) show the things as

blocks with a width of 20%, b) float the things on the left edge, and c) set the size of the left

edge space to 0% and the right edge space to 1.5%.

12. Karen maintains that the points rundown should be well away from the left and right edges of the page body. In the

same area, c decide that sets the size of the left edge of the first thing in quite a while rundown to

7.75% and sets the right edge of the last thing to 7.75%.

13. In a similar segment, ca decide that shows the picture inside each rundown thing in the points list as

a block with a width of half and focused inside the rundown thing block. (Answer: Set the left and right

edges to auto.)

14. Go to the HR Styles segment. The hr component is utilized to show an even divider between

areas of the page. Add a style decide that sets the width of the hr component to half.

15. Go to the Customer Comment Styles area. In this segment, you will make style rules for the

client remarks showed close to the lower part of the page. For the ul component with the id

remarks, a style decide that sets the width to 75% and focuses the component by setting the

top/base edge to 40 pixels and the left/right edge to auto.

16. Karen believes the rundown things should show up in two segments on the page. In a similar segment, c

style rule for each rundown thing in the remarks list that: a) shows the thing as a block with a width

of half drifted on the left and b) sets the size of the base edge to 30 pixels.

17. Each client remark is joined by a picture of the understudy. Karen needs these

pictures showed to one side of the remark. style rule to show the picture inside

each remark list thing as a block with a width of 20%, drifted on the left, and with a left/right

edge of 5%.

18. a style rule for each section settled inside a client list thing that drifts the

passage on the left edge with a width of 70%.

19. Go to the Footer Styles area anda style decide that shows the footer just when both

edges are clear of drifting articles.

20. Save your progressions to the document and afterward open the sp_home.html record in your program. Check that

the design and presence of