Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


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.

Remove ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

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




share
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

Adv Dbase Units 6-8

AR Adv DB Units 6-8

QuestionAnswer
Update query a query that changes selected fields from selected records in one or more tables bases on the criteria you specify
Make–table query a query that creates a new table by copying selected fields in records from one or more existing tables
Parameter query a query that displays a dialog box to prompt you to enter one or more criteria values when you run the query
Top values query a query property that lets you limit the number of records in the query results of a specific number or percentage (for example
Delete query a query that deletes a group of records matching the criteria you specify from one or more tables
Find unmatched query a select query that finds all records in a table or query that have no related records in a second table or query
Index a list that relates field values to the records that contain those field values that can quickly locate records
Append query a query that adds selected fields in records from existing tables or queries to the end of another table
Concatenated expression an expression used to combine text fields together (for example: LastName & " " & FirstName)
Crosstab query a query that performs aggregate function calculations on the values of one database field and display the result in a spreadsheet format
Action query a query that adds, changes, or deletes multiple table records at a time
Find duplicates query a select query that finds repeated records in a table or query
Unbound control a control that is not connected to a field in the database and that is used to display controls such as text, lines, rectangles, and graphics
Form header appears at the top of the form and is used to display titles, a picture, date/time, etc.
Label an unbound control that displays text
Tab order the order in which you move from control to control, or change the focus, in a form when you press the Tab key
Detail section the main body of a form or report in which you place bound, unbound and calculated controls
Design grid the arrangement of dotted and solid lines in a section that help you position controls precisely in a form or report
Form footer appears at the bottom of a form
Bound control a conrol that is connected, or bound, to a field in the database based on the record source
Calculated control a control that displays the result of an expression
Special effect property a property that you use to specify the type of special effect applied to a control in a form or report. Choices are chiseled, etched, flat, raised, shadowed, and sunken
Report page header section a report section that appears at the top of each page of the report and usually contains column headings, titles, etc.
Report footer section a report section that appears once at the bottom of a report and usually contains report totals and other summary information
Report header section a report section that appears once at the top of the report and usually contains titles, logos, etc.
Report page footer section a report section that appears at the bottom of each page of a report
Hide duplicates property a property that you use to hide a control in a report when the field's value is the same as the one before it
Keep together property a property for a group in a report to keep parts of the group together on the same page
Label wizard a tool that asks the user a series of questions and then creates a mailing label report based on the answers
Group footer section a report section appears after each group of records that usually displays subtotals or counts for the records in that group
Group header section a report section appears before each group of records that usually displays the group name and the sort field value for the group
Group, Sort and Total pane a pane in a report in which you can modify the grouping fields, sort fields, and calculations for the report
Custom report a report you create
Date function a function that returns the current date
Can grow property a property that controls the appearance of a control or section in a form or report when printed or previewed; when set to Yes, the control or section expands to fit the data
Created by: Jame Pearce