click below
click below
Normal Size Small Size show me how
Access
CH 2: Tables and Queries in Relational Databases
Term | Definition |
---|---|
AND logical operator | Returns only records that meet all criteria. |
AutoNumber | A number data type that is generated by Access and is incremented each time a record is added. |
Calculated field | Produces a value from an expression of function that references one or more existing fields. |
CamelCase notation | Uses no spaces in multiword field names but uses uppercase letters to distinguish the first letter of each new word. |
Caption property | Used to create a more readable label that appears in the top row in Datasheet view and in forms and reports. |
Cascade Delete Related Records | An option that directs Access to automatically delete all records in related tables that match the primary key that is deleted from a primary table. |
Cascade Update Related Fields | An option that directs Access to automatically update all foreign key values in a related table when the primary key value table is modified an a primary table. |
Constant | A value that does not change. |
Criteria row | A row in the Query Design view that determines which records will be selected. |
Data redundancy | The unnecessary storing of duplicate data in two or more tables. |
Data type | Determines the type of data that can be entered and the operations that can be performed on that data. |
Date arithmetic | The process of adding or subtracting one data from another, or adding or subtracting a constant from a date. |
Delimiter | A special character that surrounds the criterion's value. |
Field property | A characteristic of a field that determines how a field looks and behaves. |
Foreign key | A field in one table that is also primary key of another table. |
Field row | A row in the Query Design view that displays the field name. |
Indexed property | Setting that enables quick sorting in primary key order and quick retrieval based on the primary key. |
Multitable qiery | Contains two or more tables. It enables you to take advantage of the relationships that have been set in your database. |
NOT logical operator | Returns all records except the specified criteria. |
Null | The term Access uses to describe a blank field. |
Number data type | A data type that can store only numerical data. |
One-to-many relationship | A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table. |
OR logical operator | Returns records meeting any of the specified criteria. |
Query | Enables you to ask questions about the data stored in a database and then provides the answers to the questions by providing subsets or summaries of data. |
Query Design view | Enables you to create queries; the Design view is divided into two parts - the top portion displays the tables and the bottom portion (known as the query design grid) displays the fields and the criteria. |
Query sort order | Determines the order of records in the query's Datasheet view. |
Referential integrity | Rules in a database that are used to preserve relationships between tables when records are changed. |
Related tables | Tables that are joined in a relationship using a common field. |
Run comand | Used to produce query results (the red exclamation point). |
Select query | A type of query that displays only the records that match criteria entered in Query Design view. |
Short text data type | A text field that can store up to 255 characters but has a default field size of 50 characters. |
Show row | A row in the Query Design view that controls whether the field will be displayed in the query results. |
Simply Query Wizard | Provides dialog boxes to guide you through the query design process. |
Sort row | A row in the Query Design view that enables you to sort in ascending or descending order. |
Table row | A row in Query Design view that displays the data source. |
Validation rule | Prevents invalid data from being entered into a field. |
Wildcard | A special character that can represent one or more characters in the criterion of a query. |
All of the following are suggested guidelines for table design except: | Avoid data arithmetic. |
Which of the following determines the type of data that can be entered and the operations that can be performed on that data? | Data type. |
When entering, deleting, or editing table data: | The table must be in Dtasheet view. |
When importing data into Access, which of the following statements in true? | You can assign a primary key while you are importing Excel data. |
The main reason to enforce referential integrity in Access is to: | Keep invalid data from being entered into a table. |
An illustration of a one-to-many relationship would be: | Customer may have multiple orders. |
A query’s specifications providing instructions about which records to include must be entered: | Criteria row of the query design grid. |
When adding criteria to the query design view: | Nothing () |
It is more efficient to make a copy of an existing query, rather than create a new query when which of the following is true? | The existing query and the new query use the same tables and fields. |
Which of the following is true for the Query Wizard? | No criteria can be added. |
A special character that can represent one or more characters in the criterion of a query. | Wilchart |
A characteristic of a field that determines how a field looks and behaves. | Field property |
Returns only records that meet all criteria. | AND logical function |
A row in the Query Design view that determines which records will be selected. | Criteria row |
Determines the type of data that can be entered and the operations that can be performed on that data. | Data type |
Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports. | Caption property |
Enables you to ask questions about the data stored in a database. | Query |
The term Access uses to describe a blank field. | Null |
A data type that is a number that automatically increments each time a record is added. | AutoNumber |
The unnecessary storing of duplicate data in two or more tables. | Data redundancy |
A data type that can store only numerical data. | Number data type |
A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table. | One-to-many relationship |
A field in one table that is also the primary key of another table. | Foreign key |
An option that directs Access to automatically update all foreign key values in a related table when a primary key value is modified in a primary table. | Cascade Update Related Fields |
Rules in a database that are used to preserve relationships between tables when records are changed. | Referential Integrity |
Uses no spaces in multiword field names, but uses uppercase letters to distinguish the first letter of each new word. | CamelCase notation |
A row in the Query Design view that enables you to reorder data in ascending or descending order. | Sort row |
Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database. | Multitable query |
Returns records meeting any of the specified criteria. | OR logical operator |
Provides dialog boxes to guide you through the query design process | Simple Query Wizard |
Table | A storage location in a database that holds related information. Made of records which are made up of a number of fields. |
Text data type | can store either text or numerical characters. |
Comparison operator | such as equal (=), not equal (<>), greater than (>), less than (<), greater than or equal to (>=), or less than or equal to (<=), can be used in the criteria of a query. |
Query sort operator | determines the order of records in the query's Datasheet view. |
Run command | the red exclamation point is used to produce the query results |
Multi-table query | contains two or more tables. It enables you to take advantage of the relationships that have been set in your database. |
Related tables | tables that are joined in a relationship using a common field. |