29 terms

Access 2016 Comprehensive, 1e Ch 2

STUDY
PLAY

Terms in this set (...)

Special character that can represent one or more characters in the criterion of a query
Wildcards
Characteristic of a field that determines how it looks and behaves.
Field property
Returns only records that meet all criteria
AND condition
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 understandable label than a field name label that displays in the top row in Data sheet view and in forms and reports.
Caption property
Enables you to ask questions about the data stored in a database and provides
answers to the questions in a datasheet.
Query
The term Access uses to describe a blank field.
Null
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
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 the 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
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 condition
Provides a step-by-step guide to help you through the query design process.
Simple Query Wizard
When the primary key value is deleted in a primary table, Access will automatically delete all foreign key values in a related table.
Cascade Delete Related Records
Uses greater than(>), less than ( <), greater than or equal to (>= ), and less than or equal to (<=),etc. to limit query results that meet these criteria.
Comparison operators
All of the following are suggested guidelines for table design except:
(a) Include all necessary data.
(b) Store data in its smallest parts.
(c) Avoid date arithmetic.
(d) Link tables using common fields.
Avoid date arithmetic
Which of the folloWing determines how the field names can be made more readable in table and query datasheets?
(a) Field size
(b) Data type
(c) Caption property
(d) Normalization
Caption property
When entering, deleting, or editing input masks:
(a) The table must be in Design view.
(b) The table must be in Datasheet view.
(c) The table may be in either Datasheet or Design view.
(d) Data may only be entered in a form.
The table must be in Design view
With respect to importing data into Access, which of the following statements is true?
(a) The Import Wizard works only for Excel files.
(b) The Import Wizard is found on the Create tab.
(c) You can assign a primary key while you are importing Excel data.
(d) Imported table designs cannot be modified in Access.
You can assign a primary key while you are importing Excel data
The main reason to set a field size in Access is to:
(a) Limit the length of values in a table.
(b) Make it possible to delete records.
(c) Keep your database safe from unauthorized user s.
(d) Keep misspelled data from being entered into a table.
Limit the length of values in a table.
An illustration of a one-to-many relationship would be:
(a) An employee listed in the Employees table earns a raise so the Salaries table must be updated.
(b) A customer may have more than one account in an accounts table.
(c) Each employee in an Employees table has a matching entry in the Salaries table.
(d) An employee leaves the company so that when he is deleted from the Employees table, his salary data will be deleted from the Salaries table.
A customer may have more than one account in an accounts table
A query's specifications as to which tables to include must be entered on the:
(a) Table row of the query design grid.
(b) Show row of the query design grid.
(c) Sort row of the query design grid.
(d) Criteria row of the query design grid.
Table row of the query design grid
When adding date criteria to the Query Design view, the dates you enter must be delimited by:
(a) Parentheses ( ).
(b) Pound signs (# ).
(c) Quotes(" ").
(d) At signs (@).
Pound signs (#)
It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?
(a) The existing query contains only one table.
(b) The existing query and the new query use the same tables and fields.
(c) The existing query and the new query have the exact same criteria.
(d) The original query is no longer being used.
The existing query and the new query use the same tables and fields
Which of the following is true for the Query Wizard?
(a) No criteria can be added as you step through the Wizard.
(b) You can only select related tables as a source.
(c) Fields with different data types are not allowed.
(d) You are required to summarize the data.
No criteria can be added as you step through the Wizard