AR Adv DB Units 6-8
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Update query | show 🗑
|
||||
| show | a query that creates a new table by copying selected fields in records from one or more existing tables
🗑
|
||||
| Parameter query | show 🗑
|
||||
| Top values query | show 🗑
|
||||
| show | a query that deletes a group of records matching the criteria you specify from one or more tables
🗑
|
||||
| Find unmatched query | show 🗑
|
||||
| show | a list that relates field values to the records that contain those field values that can quickly locate records
🗑
|
||||
| show | a query that adds selected fields in records from existing tables or queries to the end of another table
🗑
|
||||
| Concatenated expression | show 🗑
|
||||
| Crosstab query | show 🗑
|
||||
| show | a query that adds, changes, or deletes multiple table records at a time
🗑
|
||||
| Find duplicates query | show 🗑
|
||||
| Unbound control | show 🗑
|
||||
| show | appears at the top of the form and is used to display titles, a picture, date/time, etc.
🗑
|
||||
| Label | show 🗑
|
||||
| show | 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 | show 🗑
|
||||
| show | the arrangement of dotted and solid lines in a section that help you position controls precisely in a form or report
🗑
|
||||
| Form footer | show 🗑
|
||||
| Bound control | show 🗑
|
||||
| Calculated control | show 🗑
|
||||
| Special effect property | show 🗑
|
||||
| show | a report section that appears at the top of each page of the report and usually contains column headings, titles, etc.
🗑
|
||||
| show | a report section that appears once at the bottom of a report and usually contains report totals and other summary information
🗑
|
||||
| Report header section | show 🗑
|
||||
| show | a report section that appears at the bottom of each page of a report
🗑
|
||||
| show | 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
🗑
|
||||
| show | a property for a group in a report to keep parts of the group together on the same page
🗑
|
||||
| Label wizard | show 🗑
|
||||
| show | a report section appears after each group of records that usually displays subtotals or counts for the records in that group
🗑
|
||||
| Group header section | show 🗑
|
||||
| show | a pane in a report in which you can modify the grouping fields, sort fields, and calculations for the report
🗑
|
||||
| Custom report | show 🗑
|
||||
| Date function | show 🗑
|
||||
| Can grow property | show 🗑
|
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:
Jame Pearce
Popular Computers sets