Access Chapter 2 Flashcards
Wildcard
A special character that can represent one or more characters in the criterion of a query.
Field Property
A characteristic of a field that determines how a field looks and behaves.
AND Logical Operator
Returns only records that meet all criteria.
Criteria Row
A row in the Query Design view that determines which records will be selected.
Data Type
Determines the type of data that can be entered and the operations that can be performed on that data.
Caption Property
Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports.
Query
Enables you to ask questions about the data stored in a database.
Null
The term Access uses to describe a blank field.
AutoNumber
A data type that is a number that automatically increments each time a record is added.
Data Redundancy
The unnecessary storing of duplicate data in two or more tables.
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.
Foreign Key
A field in one table that is also the primary key of another 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 is modified in a primary table.
Referential Integrity
Rules in a database that are used to preserve relationships between tables when records are changed.
CamelCase Notation
Uses no spaces in multiword field names, but uses uppercase letters to distinguish the first letter of each new word.
Sort Row
A row in the Query Design view that enables you to reorder the data in ascending or descending order.
Multitable Query
Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.
OR Logical Operator
Returns records meeting any of the specified criteria.
Simple Query Wizard
Provides dialog boxes to guide you through the query design process.
All of the following are suggested guidelines for table design except:
Avoid data arithmetic
All of the following are suggested guidelines for table design
- Include all necessary data.
- Store data in its smallest parts.
- Link tables using common fields.
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 Datasheet view.
When importing data into Access, which of the following statements is 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 a
Customer may have multiple orders.
A query’s specifications providing instructions about which records to include must be entered on the
Criteria row of the query design grid.
When adding Value criteria to the Query Design view, the value you enter must be delimited by
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.