Question 1

What field property would allow the user to enter two quote marks with nothing between them ("")into a field with a Short Text data type?

Accepted Answer

A) Required 
B) Indexed 
C) Allow Zero Length 
D) Allow Null Length 
A) Required 
B) Indexed 
C) Allow Zero Length 
D) Allow Null Length

Question 2

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 3

How many characters can be stored in a field with a Long Text data type?

Accepted Answer

A) 1,000 
B) 12,256 
C) Unlimited 
D) 64,000 
A) 1,000 
B) 12,256 
C) Unlimited 
D) 64,000

Question 4

What is not true about the hyperlink data type?

Accepted Answer

A) It can store the URL for a web page. 
B) It can store the path to a file. 
C) The hyperlink becomes active anytime you hover over it. 
D) It can store the path to a folder. 
A) It can store the URL for a web page. 
B) It can store the path to a file. 
C) The hyperlink becomes active anytime you hover over it. 
D) It can store the path to a folder.

Question 5

What data type assigns the next consecutive number to new records?

Accepted Answer

A) Number 
B) AutoNumber 
C) IncreaseNumber 
D) Integer 
A) Number 
B) AutoNumber 
C) IncreaseNumber 
D) Integer

Question 6

The ________ guides you through query design with a step-by-step process.

Accepted Answer

The answer of The ________ guides you through query design...

Question 7

In a query,the sort order,when sorting on multiple fields,is determined by the field order from left to right.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Number
Short text
Currency
Long text
Data/Time

Accepted Answer

The Answer of Phone number and Financial information and A is...

Question 9

Multitable queries inherit their relationships and you cannot change those in the query.You need to open the Relationships window to make any changes.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Null
"Or" condition
"And" condition
Criteria
Comparison Operator

Accepted Answer

The Answer of Blank field value and Examples include: >,<,<>,= is...

Question 11

Match between columns
                        Premises: OLE
Yes/No
Attachment
Hyperlink
AutoNumber

Accepted Answer

The Answer of Multiple pictures and When the answer can is...

Question 12

What is not one of the six guidelines for designing tables?

Accepted Answer

A) Store data in as large of number of parts as possible 
B) Determine the primary keys 
C) Link the tables on related fields 
D) Think of what needs you might have in the future 
A) Store data in as large of number of parts as possible 
B) Determine the primary keys 
C) Link the tables on related fields 
D) Think of what needs you might have in the future

Question 13

Which field property helps a user know why an entry error was generated?

Accepted Answer

A) Validation Text 
B) Validation Rule 
C) Expression 
D) Error Code 
A) Validation Text 
B) Validation Rule 
C) Expression 
D) Error Code

Question 14

Checking the Cascade Delete Related Records checkbox assures that ________.

Accepted Answer

A) you cannot delete related records if they have more than one foreign key records 
B) you cannot delete a primary key record if it has related records 
C) all records will be deleted in related tables if you delete the primary key in the primary table 
D) all primary keys will be deleted if you delete related records 
A) you cannot delete related records if they have more than one foreign key records 
B) you cannot delete a primary key record if it has related records 
C) all records will be deleted in related tables if you delete the primary key in the primary table 
D) all primary keys will be deleted if you delete related records

Question 15

Which option would this wildcard,"H[!oe]" not display?

Accepted Answer

A) House 
B) Hat 
C) His 
D) Humming 
A) House 
B) Hat 
C) His 
D) Humming

Question 16

To limit the number of records displayed when a query is run you add ________.

Accepted Answer

A) sorting 
B) criteria 
C) less fields 
D) less tables 
A) sorting 
B) criteria 
C) less fields 
D) less tables

Question 17

"lastName" is an example of ________.

Accepted Answer

A) Camel case 
B) Pascal case 
C) a typing error 
D) a naming convention that is not recommended because of possible compatibility issues 
A) Camel case 
B) Pascal case 
C) a typing error 
D) a naming convention that is not recommended because of possible compatibility issues

Question 18

What is not true about the Caption property?

Accepted Answer

A) It allows labels to be more readable than field names. 
B) It displays at the column head instead of the field name. 
C) It is used in both forms and reports. 
D) The Pascal case is preferred in this property. 
A) It allows labels to be more readable than field names. 
B) It displays at the column head instead of the field name. 
C) It is used in both forms and reports. 
D) The Pascal case is preferred in this property.

Question 19

Use the ________ data type when you do not know how much text space will be required.

Accepted Answer

The answer of Use the ________ data type when you...

What field property would allow the user to enter two quote marks with nothing between them ("")into a field with a Short Text data type?

What is the suggested data type for a street address?

How many characters can be stored in a field with a Long Text data type?

What is not true about the hyperlink data type?

What data type assigns the next consecutive number to new records?

The ________ guides you through query design with a step-by-step process.

In a query,the sort order,when sorting on multiple fields,is determined by the field order from left to right.

Multitable queries inherit their relationships and you cannot change those in the query.You need to open the Relationships window to make any changes.

What is not one of the six guidelines for designing tables?

Which field property helps a user know why an entry error was generated?

Checking the Cascade Delete Related Records checkbox assures that ________.

Which option would this wildcard,"H[!oe]" not display?

To limit the number of records displayed when a query is run you add ________.

"lastName" is an example of ________.

What is not true about the Caption property?

Use the ________ data type when you do not know how much text space will be required.

Office 365 Common Features

Introduction to Access

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 3: Tables and Queries in Relational Databases

What field property would allow the user to enter two quote marks with nothing between them ("")into a field with a Short Text data type?

What is the suggested data type for a street address?

How many characters can be stored in a field with a Long Text data type?

What is not true about the hyperlink data type?

What data type assigns the next consecutive number to new records?

The ________ guides you through query design with a step-by-step process.

In a query,the sort order,when sorting on multiple fields,is determined by the field order from left to right.

Multitable queries inherit their relationships and you cannot change those in the query.You need to open the Relationships window to make any changes.

What is not one of the six guidelines for designing tables?

Which field property helps a user know why an entry error was generated?

Checking the Cascade Delete Related Records checkbox assures that ________.

Which option would this wildcard,"H[!oe]" not display?

To limit the number of records displayed when a query is run you add ________.

"lastName" is an example of ________.

What is not true about the Caption property?

Use the ________ data type when you do not know how much text space will be required.

Office 365 Common Features

Introduction to Access

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters