CH 2: Tables and Queries in Relational Databases
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 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.
🗑
|
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:
TroyIS2241
Popular Computers sets