click below
click below
Normal Size Small Size show me how
CIT201 Mod 2 and 3
Term | Definition |
---|---|
T or F - When using text data as criteria, you must enter the text data in quotation marks. | F - Access will add the quotation marks automatically |
Wildcard ? | Represents any one character |
Wildcard * | Represents any number of characters |
T or F - J* used as text data criteria will match the following: Johnstown, Jonestown, Jamestown | T |
T or F - MA?? will match all of the following MA88, MAeh, MA777 | F - It will only match MA88 and MAeh. |
Parameter Query | Query that asks for input whenever it is used |
What must be used to enclose the prompt of a parameter query? | [] - square brackets |
T or F - To use a number as criteria, you may enter $4,000 for example. | F - You must enter only numbers in the field, no special characters like a $ or , |
What are the comparison operators? | >, <, >=, <=, NOT |
compound criteria | Criteria that must satisfy more than one criterion and is created using AND and OR |
AND operator | Special criteria that involves a range of values in a single field |
BETWEEN operator | Special criteria that allows you to select values in a given range |
IN operator | Special criteria that allows you to select a list of values |
Sort | Allows you to order the records in a certain order |
Major key | Also called the Primary sort key and must be to the left when ordering the fields |
Minor key | Also call the secondary sort key and must be to the right when ordering the fields |
Property Sheet | Window containing various properties of the object |
Top Values Query | Allows you to show on a specified number or percentage of records and can be accomplished by using the Return box on the Design tab |
Join | Necessary to find records in two separate tables, must have identical values in matching fields. Also called an inner join. |
export | copy tables or queries from an Access database to another application, such as Excel. |
Delimited file | Each record is on a separate line and the fields are separated by a special character called a delimiter. |
Individual record calculation | Adding the values on fields for one record |
Group calculation | Adding all the values in a particular field for all of the records |
List at least 3 Access built-in statistics | COUNT, SUM, AVG, MAX, MIN, STDEV, VAR, FIRST, and LAST |
Grouping | Creating groups of records that share some common characteristic. |
Crosstab Query | A query that calculates a statistic for data that is grouped by two different types of information. |
Split form | Form that allows you to simultaneously view both simple form and datasheet views of the data. |
Filter | Allows you to show records that satisfy criterion, not just a single record like Find. Four types of filters: Filter by Selection, Common Filters, Filter by Form, and Advanced Filter/Sort |
Toggle Filter button | Toggles between filtered and unfiltered displays of the records in the table |
Lookup field | Allows user to select from a list of values when updating the contents of the field |
Multivalued field | Field that can contain more than 1 value |
Action query | Allows you to add, delete, or change data in multiple rows of a table. Examples : Update query, Append query, Delete Query, and Make-table query. |
Update query | Allows you to make the same change to all records that meet some defined criteria. |
Delete query | Allows you to delete all records that meet some defined criteria. |
Append query | Add the results of a query to an existing table |
Make-table query | Add query results to a new table |
Validation Rules | Rules a user must follow when entering data that ensures the entry of valid data |
Validation text | Message that appears if a user attempts to violate a validation rule |
Default value | Value displayed in a field before the user begins entering data |
Format | Affects the way data is displayed in a field |
Format symbol | Special symbol entered in the fields Format property box. |
> | Format symbol that will change lowercase letters to uppercase when used with the Short Text data type. |
Referential Integrity | Property that ensures that the value in a foreign key must match that of another table's primary key |
Foreign key | Field in a field in one table whose values are required to match the primary key of another table |