Deck 2: Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Question 1

When using Datasheet view,what determines sort order when sorting more than one field?

A) The order is determined from right to left.
B) The order is determined from left to right.
C) The order is determined by the first selected field to the last selected field.
D) The order is determined by the last selected field to the first selected field.

Answer 1

B

Question 2

Data from a table imported from Excel must be modified in Excel.

Answer 2

False

Question 3

When creating a multitable query,in the top section of the query design,you use ________ lines to connect common fields in related tables.

A) join
B) relationship
C) common field
D) connection

Answer 3

A

Question 4

Which of the following is NOT a row displayed when using the Query Design view?

A) Criteria
B) Sort
C) Field
D) Record

Question 5

To add fields from multiple tables to the query grid,you can drag the field name from a table to the Field row,or you can:

A) right-click the field name and select Add to Query from the menu.
B) double-click the field name.
C) select the field name, click Copy, then click in the Field row, and click Paste.
D) select the field name, click Move, then click in the Field row, and click Paste.

Question 6

Table modification may be needed after an Excel spreadsheet has been imported such as:

A) renaming a field.
B) changing the font size.
C) changing the font type.
D) updating hyperlinks.

Question 7

A primary key field CANNOT be deleted.

Question 8

When using Design view,a query can only be sorted on a single criteria.

Question 9

The relationship between bank customers and their accounts would be ________.

A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question 10

To count the number of records that satisfy a query,you click the Total button and select Count in the Total row in the query grid.

Question 11

You can use the Query ________ to create a query.

A) Wizard
B) Pane
C) Panel
D) Table

Question 12

Which of the following is NOT a field property?

A) Author
B) Field Size
C) Format
D) Caption

Question 13

When importing an Excel spreadsheet the column headings in Excel become the field names in Access.

Question 14

New fields are added to a table in Design view.

Question 15

What does referential integrity do?

A) Allows users to delete records in tables
B) Prevents the entry of a foreign key unless the primary key exists in the related table
C) Prevents data from being edited or deleted
D) Allows unrelated fields to be modified

Question 16

The ________ property is used to create an informative label that appears at the top of a table column in Datasheet view.

A) text
B) caption
C) description
D) required

Question 17

The maximum size of a field formatted for short text data is ________.

A) 25
B) 100
C) 255
D) 300

Question 18

When using Design view to enter text in the Criteria row,Access will place ________ around the text.

A) parentheses ( )
B) quotation marks " "
C) brackets [ ]
D) braces { }

Question 19

The Query Wizard is an Access tool to help create queries.