Access Project 2
This guide provides an overview of queries in Microsoft Access, focusing on how to create simple questions that Access can process. Key concepts include the Query Window, using criteria with text data, wildcards (such as the asterisk * and question mark ?), and the importance of comparison operators. Learn about compound criteria using AND and OR logic, sorting results, joining tables, and the significance of calculated fields and aggregate functions. This resource is ideal for users seeking to improve their query-building skills in Access.
Access Project 2
E N D
Presentation Transcript
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 • Type the text in the criteria box below the corresponding field name • Criterion – A condition that the records to be included must satisfy
Wildcards • Symbols that represent any character or combination of characters
Asterisk Wildcard (*) • Represents any collection of characters • Example: • H* could stand for what names? • Henry • Hunter • Heidi • Harris
Question Mark Wildcard • Represents any individual character • Example: • T?m could represent what? • Tim • Tom
Parameter Value Query • A query that prompts the input whenever it is run
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
Compound Criterion • When you have more than one criterion in which the search must satisfy
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.
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.
Sort • The order of the results that are displayed • SORT KEY – the field or fields by which the records are sorted
Sorting • Major Key – the more important sort field • Minor Key – the less important sort field
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
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
Top-Value Queries • Allows you to quantify results • Allows you to choose how many results you want to show (either the lowest or highest)
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!
Calculating Statistics • Aggregate Function – is a function that performs some mathematical function against a group of records
Grouping • Creating groups of records that share some common characteristics • Example: Find the average amount paid for those clients that had Trainer #42
