Busy. Please wait.

show password
Forgot Password?

Don't have an account?  Sign up 

Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
Didn't know it?
click below
Knew it?
click below
Don't know (0)
Remaining cards (0)
Know (0)
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

NP Access 5

ampersand A concatenation operator that joins text expressions.
Append Only A field property for a Long Text field that lets you edit the field value and, when set to Yes, causes Access to keep a historical record of all versions of the field value.
concatenation The process of joining two or more text fields or characters encapsulated in quotes.
crosstab A query that uses aggregate functions to perform arithmetic operations on the values of one database field and displays the results in a spreadsheet format.
Crosstab Wizard Query wizard that allows the user to choose the field that will be calculated for each row and column intersection.
field validation rule Setting A rule to prevent a user from entering an unacceptable value in a field by comparing user input to a constant or to a set of constants.
find duplicates query A select query that finds duplicate records in a table or query.
Find Unmatched Wizard A wizard that guides you through the steps for creating a find unmatched query.
IIf (Immediate If) function A function that test a condition and returns one of two values based on whether the condition being tested is true or false.
In comparison operator A comparison operator that defines a condition with a list of two or more values for a field.
Input Mask Wizard An Access tool that guides you in creating a predefined format for a field.
IsNull function A function that tests a field value or an expression for a null value; if the field value or expression is null, the result is true; otherwise, the result is false.
Like comparison operator A comparison operator that selects records by matching field values to a specific pattern that includes one or more wildcard characters.
list-of-values match A selection of records whose value for the designated field matches one of two or more simple condition values.
lookup field A field that lets the user select a value from a list of possible values to enter data into the field.
Not logical operator A logical operator that negates a criterion or selects records for which the designated field does not match the criterion.
Object Dependencies pane A task pane that displays a collapsible list of the dependencies among the objects in an Access database; you click the list’s expand indicators to show or hide different levels of dependencies.
parameter query A query that displays a dialog box that prompts the user to enter one or more criteria values when the query is run.
pattern match A selection of records with a value for the designated field that matches the pattern of a simple condition value.
property propagation An Access feature that updates control properties in objects when you modify a table field property.
Structured Query Language A standard language used in querying, updating, and managing relational databases.
table validation rule A rule that compares one field value in a table record to another field value in the same record to verify their relative accuracy
Text Format property A field property for a Long Text field that determines whether you can format the field contents (Rich Text setting) or cannot format the field contents (Plain Text setting).
Top Values property A query property that lets you limit the number of records in the query results to a specific number or percentage.
trusted folder A folder on a drive or network that you designate as trusted and where you place databases you know are safe
Validation Rule property A field property value that specifies the valid values that users can enter in a field.
Validation Text property A field property value that will be displayed in a dialog box if a user enters an invalid value for the field.
0 Input mask character for a digit only with entry required.
# Input mask character where digit, space, or a plus or minus sign can be entered and entry is optional.
? Input mask character where letter only can be entered and entry is optional.
L Input mask character where a letter only must be entered and entry is required.
A Input mask character where a letter or digit must be entered and entry is required.
9 Input mask character for digit or space and entry is optional. Often used for area code on phone number.
Field Properties pane Pane in bottom of Design view where you can enter extra information, such as validation rules or input masks.
Number An input mask may be created for any field with the Short Text or ____ data type.
Table Only these Access object(s) may be used when creating a lookup field to select values.
-1 Yes/No field values are stored with this value if it is checked.
0 Yes/No field values are stored with this value if it is unchecked.
True What value will be returned if a field is empty when the IsNull function is used?
Rich Text Changing a long text field to this format will allow font options, such as color and bold.
Null Refers to blank fields
Backup Before saving and compacting an important database, it is a good idea to save a copy as a:
Created by: skindawg



Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!

"Know" box contains:
Time elapsed:
restart all cards