Database Management T/F

STUDY
PLAY
A record contains a specific piece of information within a field.
False
The determination of database requirements is part of a process known as systems development.
False
Access 2010 has a number of reserved words, words that have a special meaning to Access. You cannot use these reserved words as field names.
True
The most common type of relationship you will encounter between tables is the many-to-one relationship.
False
Redundancy means storing the same fact in more than one place.
True
The Status bar, located at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the status of certain commands and keys; it also provides controls for viewing the object.
True
Database users typically use standard guidelines for naming tables
False
To change the default printer that appears in the Print dialog box, click File on the Ribbon, click the Print tab in the Backstage view, click Print in the Print gallery, then click the Name box arrow and select the desired printer.
True
When importing data, you have two choices. You can create a new table or add the records to an existing table.
True
Report view allows you to make changes, but it does not show you the actual report.
False
Before creating queries, examine the contents of the tables involved.
True
Most of the time, you will use Layout view to create queries.
False
Microsoft Access does not support wildcards.
False
To enter a number in a criterion, type the number with dollar signs or commas.
False
An OR criterion is true provided each individual criterion is true.
False
You can select values in a list by using the BETWEEN operator
False
When sorting data in a query, the records in the underlying tables (the tables on which the query is based) are not actually rearranged.
True
You need to join the tables; that is, to find records in the two tables that have identical values in matching fields.
True
Because query results are based on the data in the underlying tables, a change to an underlying table would result in a new query answer.
True
Access includes a tool to help you create complex expressions. If you click Build on the shortcut menu, Access displays the Expression Builder dialog box.
True
Although you can make some changes to the database structure in Design view, it is usually easier and better to make these changes in Datasheet view.
False
If you plan to move your data to SQL Server at a later date, use multivalued fields.
False
The Run button causes the updates specified by the query to take place.
True
To specify that a field is to be required, change the value for the Required property from False to True.
False
If you enter the expression, like T?, in the Validation Rule for the State field, the only valid entries for the field will be TN or TX.
True
Using a multivalued lookup field is similar to using a regular lookup field. The difference is that when you drop down the list, the entries all will be preceded by row selectors.
False
You can use multivalued fields in queries just as you can use other fields.
True
In a one-to-one relationship, the matching fields are both primary keys.
True
The availability of a subdatasheet is indicated by an equal sign that appears in front of the rows of a table.
False
To change the order in which records appear, use the Ascending or Descending buttons.
True
YOU MIGHT ALSO LIKE...