1 / 21

Access Project 2

Access Project 2. Vocabulary/Notes. Query. A simple question represented in a way that Access can understand. Select Query Window. The window is which you can create a query. View Button. Button that tells Access to display the query results. Text Data.

onella
Download Presentation

Access Project 2

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 Project 2 Vocabulary/Notes

  2. Query • A simple question represented in a way that Access can understand

  3. Select Query Window • The window is which you can create a query

  4. View Button • Button that tells Access to display the query results

  5. Text Data • Type the text in the criteria box below the corresponding field name • Criterion – A condition that the records to be included must satisfy

  6. Wildcards • Symbols that represent any character or combination of characters

  7. Asterisk Wildcard (*) • Represents any collection of characters • Example: • H* could stand for what names? • Henry • Hunter • Heidi • Harris

  8. Question Mark Wildcard • Represents any individual character • Example: • T?m could represent what? • Tim • Tom

  9. Parameter Value Query • A query that prompts the input whenever it is run

  10. Comparison Operators • Used when you want to enter a criterion that is not an exact match • > Greater than • < Less than • >= Greater than or equal to • <= Less than or equal to • NOT= Not equal to

  11. Compound Criterion • When you have more than one criterion in which the search must satisfy

  12. AND Criterion • Each individual criterion must be true in order for the compound to be true • Example: Find the clients that have an amount paid greater than $20,000 AND whose trainer number is 48.

  13. OR Criterion • Either criterion must be true • Example: Find the clients that have an amount paid greater than $20,000 OR whose trainer number is 48.

  14. Sort • The order of the results that are displayed • SORT KEY – the field or fields by which the records are sorted

  15. Sorting • Major Key – the more important sort field • Minor Key – the less important sort field

  16. Joining • Join – to find records in the two tables that have identical values in matching fields • Join Line – a line showing matching fields in the two tables indicating that the tables are related • Join Properties – are the properties that indicate which records appear in a join

  17. Property Sheet • The window containing the various properties of the object • The query property sheet is where you go to omit the duplicates in a query

  18. Top-Value Queries • Allows you to quantify results • Allows you to choose how many results you want to show (either the lowest or highest)

  19. Calculated Field • A field that can be computed from other fields • Use the ZOOM box • Every field name must be in its own set of brackets!

  20. Calculating Statistics • Aggregate Function – is a function that performs some mathematical function against a group of records

  21. Grouping • Creating groups of records that share some common characteristics • Example: Find the average amount paid for those clients that had Trainer #42

More Related