Access Vocabulary Terms Lesson 3
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Query | database object that lets you aks the database about the data it contains
🗑
|
||||
Condition (Criterion) | a way of telling the query which data you are interested in seeing
🗑
|
||||
Simple Query Wizard | asks you what data you want to seee by letting you select options in dialog boxes
🗑
|
||||
Sort | when you view field values in ascending or descending order from A to Z or smallest to largest
🗑
|
||||
Filter | temporarily displays records in a datasheet based on the condition that you specify
🗑
|
||||
Filter By Selction | you select a field value in a datasheet and click the Selection button in Sort & Filter group on the Home tab
🗑
|
||||
Filter By Form | click Advance button in the Sort & Filter group in the Home tab; displays records that have more values based on values stored in one or more fields
🗑
|
||||
AutoFilter | a menu that opens when you click the arrow on the right side of a field selector
🗑
|
||||
Relationship | database management system that lets you connect the data in the tables
🗑
|
||||
Common Field | field that appears in both tables, has the same data types and contains the same values
🗑
|
||||
One-To-Many Relationship | one record in the first table records the second table
🗑
|
||||
Foreign Key | common field in the related table
🗑
|
||||
Referential Integrity | protects the data in tables to make sure data is not accidentally deleted or changed
🗑
|
||||
Subdata Sheet | contains the related records in orders talbe
🗑
|
||||
Multable Queries | a queries that are based on more than one table
🗑
|
||||
And Operator | selects records that match all of two or more conditions in query
🗑
|
||||
Or Operator | selects records that match at least one of two or more conditions in a query
🗑
|
||||
Total Row | counts number of values in a column
🗑
|
||||
Calculated Field | a field displays a value that is calculated using other fields in the query
🗑
|
||||
Expression | the calculation in a calculated field
🗑
|
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:
Tradams
Popular Computers sets