Create one web page and two data sources. The web page will be a product page. O

Question

Create one web page and two data sources. The web page will be a product page. One of the data file will contain the product information that will display on the product page. The other data file will contain order information. Details for the product page and the data files are listed below. Product Page - The colors, font styles, etc. should match those used in your previous lab assignments and should be handled with external CSS. Only minimal inline styling is acceptable and only when necessary to override styling from the external CSS file.

Sort options above the product information to allow the user to sort the products by:
Product ID - Ascending
Product ID – Descending
Product Name – Ascending
Product Name - Descending
Product Price – Ascending
Product Price _Descending

All products must be listed in an organized fashion on the page and should be sorted by Product Name in ascending order when the page loads. Pull the product information for the products (you need at least 10) from the data source file, which you will create yourself. You will need to show a product ID, product name/description, price, and picture for each product, along with an input element for each product in which the user may specify a Quantity to purchase (allow only whole numbers greater than or equal to 0).
Submit and Cancel buttons at the bottom of the page
Submit – Confirms with the message, “Are you sure you want to submit your order?” If confirmed, create a data file containing product ID and quantity for each product with a selected quantity > 0. If the user does not confirm, no action is necessary.
Clear – confirms with the message, “Are you sure you want to cancel?” If confirmed, clear the selected quantities. If the user does not confirm, no action is necessary.
Data File - json file: You will need to create a data file containing all product information. All products should be related to your product theme. Include an image, product ID, product name/description, and price for each product. For uniformity, each image must have the same dimensions when loaded in the page.

Explanation / Answer

In Excel 2013, you can interface with heaps of information sources. These incorporate the accompanying:
SQL Server tables
SQL Server Analysis Services 3D squares
Purplish blue Marketplace information
OData information
XML information
Get to information
Content document information
To bring information into Excel, you can utilize existing associations, or you can make your own particular associations. Existing associations can be put away on your PC or in a focal area, for example, a SharePoint site.
Preferably, you'll approach an arrangement of existing information associations in a site, for example, a Business Intelligence Center site, that you can use to work with information in Excel. This is particularly useful on the off chance that you plan to distribute an exercise manual to a records library in a Business Intelligence Center site. Commonly, a SharePoint executive designs such areas as put stock in areas in Excel Services. This makes it feasible for you and others to invigorate information in your exercise manuals to see the most current data.
To utilize a current information association in Excel
In Excel, on the Data tab, pick Existing Connections.
Pick Browse for More to open the Select a Data Source discourse box.
Indicate the area of the information source that you need to utilize, select the information source, and after that pick Open.
On the Import Data page, pick how you need to see the information, and after that pick OK.
The choices that are accessible rely on upon the specific information source that you are utilizing. For instance, you may make an information table, a PivotChart report, a PivotTable report, or a Power View sheet.
In the event that you don't have a current association or you need to make another association, you can without much of a stretch do this in Excel. You'll ordinarily need to know the name of the area, (for example, a server or a site) where the information is put away and what validation strategy that you ought to use to associate with the information. For instance, to make an association with a table that is put away in SQL Server, you should know the name of the server, the database, and table that you need to utilize, and what accreditations are utilized to interface with the information.
To make and utilize another information association in Excel
In Excel, on the Data tab, in the Get External Data gathering, pick one of the accompanying choices:
Look over Access to utilize information that is put away in an Access database.
Look over Web to utilize information from an inside or outside site.
Look over Text to utilize information that is put away in a content record.
Look over Other Sources to utilize information that is accessible in SQL Server, SQL Server Analysis Services, Azure Marketplace, OData, a XML record, or information that is accessible through a custom supplier.
The Data Connection Wizard opens.
Indicate the data that is required for each progression of the Data Connection Wizard, and afterward click Finish.
On the Import Data page, pick how you need to see the information, and after that pick OK.
The choices that are accessible rely on upon the specific information source that you are utilizing. For instance, you may make an information table, a PivotChart report, a PivotTable report, a Power View sheet, or simply the information association.
For more definite data about how to make information associations, see Share information associations by utilizing Excel and Excel Services (SharePoint Server 2013).
After you have made an Excel exercise manual that utilizations outer information and perspectives, for example, PivotChart reports, PivotTable reports, or Power View sees, you can impart that exercise manual to others by utilizing a site, for example, a SharePoint site. Contingent upon your condition, the outside information associations that are utilized as a part of your exercise manual won't not be upheld. Regardless of whether an outer information association is bolstered decides if information revive is accessible for the exercise manual and whether the exercise manual is visible in a program window

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.