management ınformatıonal system access lab axam

  
1. On the table, SalesOrderHeader, provide the grand total of SubTotal at the bottom row of the records. You may need to convert the Short Text into Numeric data attribute for the SubTotal.
2. Set a validation rule on the table SalesOrderHeader such that OrderDate should be earlier than ShipDate and provide an error message when the rule is not kept during the data entry on the OrderDate and ShipDate.
3. Set up a table-based Lookup table for the data field ProductCategoryID of the table ProductSubcategory, that displays the names for the product categories in the table ProductCategory, instead of the numbers.
4. Using the table SalesOrderHeader, set up a query, SalesQ4_query, that displays SalesOrderID, OrderDate, TotalDue, for the orders made in the fourth quarter of year 2001, that is, from Octerber 1st till December 31st, 2001. 
5. We want to know how much were sold by each product in year 2001. Set up a query, SalesByProduct_query, that displays ProductID, Name of the Product, and sum of LineTotal of SalesOrderDetail in the year 2001.
6. Close the SalesByProduct_query from the right side window. In the All Access Objects window, create a new query, SalesByProductWithNoSale_query, by Right-clicking on the SalesByProduct_query, copying, pasting, and renaming. Using Left Join or Right Join, modify the SalesByProductWithNoSale_query, that displays all the products that includes the not-sold products too.
7. Table SalesOrderHeader is set in an inconvenient way because it requires to enter SubTotal, TaxAmt, Freight, and TotalDue individually. These data fields can be readily calculated if we set up a query. Create a query, SalesOrderHeader_extension that displays SalesOrderID, SubTotal (sum of LineTotal of SalesOrderDetail), TaxAmt (8% of LineTotal), Freght (3% of LineTotal), and TotalDue (111% of LineTotal) in Currency format.
8. Using OrderedItems query, set up a crosstab, SaleByCustomerAndProductCategory_crosstab that displays sum of sale amount ([UnitPrice]*[OrderQty]) by each customer and each product category, with the SaleTotal (SaleTotal: [UnitPrice]*[OrderQty]) per customer.

Don't use plagiarized sources. Get Your Custom Essay on
management ınformatıonal system access lab axam
Just from $13/Page
Order Essay
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 20% with the discount code WELCOME