Question 1

A primary key field CANNOT be deleted.

Accepted Answer

A) True 
 B)False  False

Question 2

New fields are added to a table in Design view.

Accepted Answer

A) True 
 B)False  True

Question 3

What does referential integrity do?

Accepted Answer

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 
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 B

Question 4

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

Accepted Answer

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

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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:

Accepted Answer

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. 
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 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT a field property?

Accepted Answer

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

Question 12

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

Accepted Answer

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. 
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.

Question 13

You can use the Query ________ to create a query.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

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

A primary key field CANNOT be deleted.

New fields are added to a table in Design view.

What does referential integrity do?

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

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.

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

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:

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

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

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

Which of the following is NOT a field property?

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

You can use the Query ________ to create a query.

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

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

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

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

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

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

Introduction to Access: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters