Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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

AccessReview1and2

Advanced Computer Applications

QuestionAnswer
A field type that stores dollar amounts Currency
Placing records in a specified order Sorting
Used to limit the records displayed to those that meet certain criteria Query
A field designated to contain unique data Primary key
A wild card character that matches any number of characters or no character at all Asterisk
A wild card character that matches any one character or no character at all Question mark
The bottom area in Query Design view where you set criteria, sort, etc. Design grid
The Show field in Query Design view means that the field will be: Visible
Criteria in Query Design that means a field is empty Null
When created Calculated Fields, the field names go in these: Brackets
In a Parameter Query, the "pop up text" to prompt for the user to enter data should be put in: Brackets
When sorting on multiple fields, the primary sort field should be listed at the: Left
Add this to a Query Design if you need to do math on a field or to group by: Total row
Display an on-screen preview of what the report will look like when printed. Print preview
When running queries for dollar amounts, be sure to leave these off (in Design View criteria): Dollar signs
To delete a table from Query Design view that you do not need, right click it and pick: Remove table
This operator allows you to search for a range of values in one field. Between
To calculate statistics for only those records that satisfy certain criteria, select this as the entry in the Total row for the field, and then enter the criterion in the Criteria row. Where
To create a crosstab, click this button on the Create tab. Query wizard
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in: Brackets
To find all clients whose names begin with Br, enter this in the Criteria row: Br*
To find all individuals whose name is Tonya or Tanya, enter this in the Criteria row: T?nya
You can create calculated fields more easily using this: Expression builder
Created by: skindawg
Popular Business sets

 

 



Voices

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:
Retries:
restart all cards