Unit 14 Vocab - Access L2-4
Order by
12 terms
Terms | Definitions |
|---|---|
 Field Properties | Allow you to further customize a field beyond merely choosing a data type. |
| Field Selectors | At fthe top of a table and contain the field name. They can be used to quickly select a field. |
| Record Pointer | The arrow to the left of the current record. When you move among records in Datasheet view, you are moving the record pointer. |
| Record Selectors | Allows you to quickly select an entire record. They are located on the left side of a records first field. |
| Form Footer | Displays information that remains the same for every record, such as instructions for using the form, for the form. It appears at the bottom of the screen in Form View. |
| Form Header | Displays information that remains the same for every record, such as the title, for the form. It appears at the top of the screen in Form View. |
| Calculated Control | is on a form and uses an expression to generate the data value for a field. For example, on an Orders form, you might use the expression =Unit Cost*Units Ordered to determine Total Unit Cost. |
| Filter | Provide a way to display selected records in a database more easily using queries.They "filter out" the records that do not match the specified criteria. |
| Query | an operation that allows you to combine criteria to perform coplex searches. |
| Referential Integrity | Rules that ensure valid relationshiops between tables and prevent invalid data from being enteres |
| Relationship | Connecting the same field in different tables. |
| Ascending/Descending Sort | Arranges records from A to Z (smallest to largest) or Z to A (largest to smallest) |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.
Set Champions
Scatter Champion
11.2 secs by morgan__mcc
Space Race Champion
1,670 points by aliyaht623
Speller Champion
100% correct by Starr_Sherine
Completed “Learn” mode
cindyloohoolee , WonderfulPeace , Velvet17 , amy_jun , alexis1758 , blue12nike , yuriwing5 , k200204573 , jn200202807 , taniatoledo , aliyaht623 , qufdl1004621 , 200178686 , dreaming_luna0918 , Starr_Sherine (See all 25)