SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Science Posted 12 Oct 2017 My Price 10.00

I need help ASAP I will pay if I have to. I have done it once and got a 67 on it and I just need it done and sent back to me to upload

Ofce 2016 – myitlab:grader – InstructionsExploring Access Chapter 6 Capstone HomeworkEX16_AC_CH06_GRADER_CAP_HW - Northwind Product AnalysisProject Description:You have been asked to modify a database that tracks driver data and insurance details. You willupdate, add to, and delete records from tables. You will also create queries that aggregate data,Fnd unmatched, and repeating values.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Access. Open the downloaded Access database namedexploring_a06_Grader_h1. Save the database asexploring_a06_Grader_h1_LastFirst.02Create a select query that includes the CategoryID and CategoryName ±rom theCategories table and the UnitPrice and ProductName ²elds ±rom the Products table(in that order). Run the query and note the CategoryIDs ±or Beverages and Dairy.83Add the appropriate CategoryID criterion to limit the query output to onlybeverages. Convert the query to an update query. Update the UnitPrice ±orbeverages only by increasing it by 5 percent.104Update the UnitPrice ±or dairy products only by increasing it by 4 percent. Run thequery. Save the query asUpdate Prices. Close the query.105Create a select query that identi²es all o± the discontinued products. Include all²elds ±rom the Products table.86Convert the select query to a make table query. Name the new tableDiscontinued Products. Run the query. Save the query asMake DiscontinuedProducts Table. Close the query.67Make a copy o± the Make Discontinued Products Table query and save it asAppend Discontinued Products Table. Open the Append Discontinued ProductsTable query in Design view. Convert the make table query to an append query. Thequery will append to the Discontinued Products table.88Modi±y the criteria to add the Boston Crab Meat product to the DiscontinuedProducts table, using the SupplierID ±rom the Products table. Remove the criteriarelated to the Discontinued ²eld. Run the query, save it, and then close it.49Make a copy o± the Append Discontinued Products Table query and save it asDelete Discontinued Products. Open the Delete Discontinued Products query inDesign view. Convert the append query to a delete query.8Updated: 06/06/20161EX16_AC_CH06_GRADER_CAP_HW_Instructions.docx
Background image of page 1
View the Answer
Ofce 2016 – myitlab:grader – InstructionsExploring Access Chapter 6 Capstone HomeworkStepInstructionsPointsPossible10ModiFy the criteria to delete the discontinued products, as well as the record ForBoston Crab Meat using its SupplierID (Hint: There will be two criteria). Run, save,and close the query.811Open the Pro±t query in Design view and add the LastName ±eld From theEmployees table to the last column oF the design grid. Run, save, and close thequery.412Use the query wizard to create a crosstab query based on the Pro±t query thatshows total pro±t by LastName (row heading) and CategoryName (columnheading). Name the queryProft_Crosstab.813ModiFy the query to display CategoryName as a row heading ±eld and LastName asa column heading ±eld. Run, save, and close the query.614Create a query to ±nd out iF any oF the products have no current order details. Addall oF the ±elds From the Products table to the results. Save the query asProductsWith No Orders. Run the query and close it.1215Save the database. Close the database, and then exit Access. Submit the databaseas directed.0Total Points100Updated: 06/06/20162EX16_AC_CH06_GRADER_CAP_HW_Instructions.docx
Background image of page 2

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Oct 2017 10:10 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)