CIT201 Mod 2 and 3
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
Leisac
Popular Computers sets