1 / 8

Access Quiz

Access Quiz. Query 1: What is the total for each order? List OrderID and Order Total. Summing for distinguished column of number column. Distinguished column: OrderID Number column: calculated field: [quantity]*[price] Need group by Sum for calculated field. Query 2:.

carnig
Download Presentation

Access Quiz

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Access Quiz

  2. Query 1: What is the total for each order? List OrderID and Order Total. • Summing for distinguished column of number column. • Distinguished column: OrderID • Number column: calculated field: [quantity]*[price] • Need group by • Sum for calculated field

  3. Query 2: • Selecting subset of rows based on value of one field • Use Group By • Use where in field which is used for selection. • Enter condition under criteria.

  4. Query 3: • Selecting subset of rows based on value of one field and existence of relationship • Use Group By • Use where in field which is used for selection. • Enter condition under criteria.

  5. Query 4 • Select subset of rows based on a reference field and a property of count of a field C • choose reference field • use group by • select Count for C field • express property in Criteria

  6. Query 5 • Query 1 composed twice • Additional pattern: LastName not unique. Use ID to disambiguate but don’t show it. Let’s call this the Disambiguation Pattern.

  7. Query 6 • Averaging of distinguished number field • Choose number field to be averaged • Group By • Choose Avg • In this case distinguished number field is calculated by another query!

  8. Query 7 • Select subset of rows based on reference field and property of calculated field. The property itself involves a query. • choose reference field and calculated field • Group by • use where in calculated field • express property under criteria

More Related