Question 1

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

Accepted Answer

The answer of In table relationships, the foreign key of...

Question 2

Match between columns Premises: =25 >25 <25 <>25 >=25

Accepted Answer

The Answer of Less than 25 and Equals 25 and is...

Question 3

Which wildcard character matches a single character in the same position as the wildcard?

Accepted Answer

A) (?) 
B) (*) 
C) ([]) 
D) ([!]) 
A) (?) 
B) (*) 
C) ([]) 
D) ([!])

Question 4

Match between columns
                        Premises:  .rtf
.txt
Hierarchy
Template
 Master

Accepted Answer

The Answer of Organization of text into levels of importance is...

Question 5

What is the suggested data type for a street address?

Accepted Answer

A) Long Text 
B) Number 
C) OLE Object 
D) Short Text 
A) Long Text 
B) Number 
C) OLE Object 
D) Short Text

Question 6

The ________ relationship requires a junction table for it to function properly.

Accepted Answer

many-to-ma

Question 7

The Enforce Referential Integrity box should normally be checked.

Accepted Answer

A) True 
 B)False

Question 8

When does the validation rule check the entered data?

Accepted Answer

A) As soon as it is typed into the field 
B) When the user exits the field 
C) When the table or form is saved 
D) When the table of form is closed 
A) As soon as it is typed into the field 
B) When the user exits the field 
C) When the table or form is saved 
D) When the table of form is closed

Question 9

Access does not require that every table has a primary key.

Accepted Answer

A) True 
 B)False

Question 10

The first step in creating a query is selecting the fields you need.

Accepted Answer

A) True 
 B)False

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

Which wildcard character matches a single character in the same position as the wildcard?

What is the suggested data type for a street address?

The ________ relationship requires a junction table for it to function properly.

The Enforce Referential Integrity box should normally be checked.

When does the validation rule check the entered data?

Access does not require that every table has a primary key.

The first step in creating a query is selecting the fields you need.

Access: Introduction to Access

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters

Exam 2: Access: Tables and Queries in Relational Databases

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

Which wildcard character matches a single character in the same position as the wildcard?

What is the suggested data type for a street address?

The ________ relationship requires a junction table for it to function properly.

The Enforce Referential Integrity box should normally be checked.

When does the validation rule check the entered data?

Access does not require that every table has a primary key.

The first step in creating a query is selecting the fields you need.

Access: Introduction to Access

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters