Question 1

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Accepted Answer

A) True 
 B)False

Question 2

Access uses ________ to speed up the sorting or filtering process.

Accepted Answer

The answer of Access uses ________ to speed up the...

Question 3

Match the recommended field types with their examples:
i. AutoNumber
II. OLE
III. Hyperlink
IV. Yes / No
v. Attachment

Accepted Answer

A)  An email address 
B)  Multiple pictures 
C)  An object created by another program 
D)  When the answer can be either True or False 
E)  Very useful for Primary keys 
A)  An email address 
B)  Multiple pictures 
C)  An object created by another program 
D)  When the answer can be either True or False 
E)  Very useful for Primary keys

Question 4

Use the ________ data type when you want to store multiple pictures in your records.

Accepted Answer

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

Question 5

What field property helps to make sure that correct data is entered?

Accepted Answer

A)  Validation text 
B)  Validation rule 
C)  Format 
D)  Required 
A)  Validation text 
B)  Validation rule 
C)  Format 
D)  Required

Question 6

For security purposes you want to have data redundancy in your tables.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Which logical operator would return the fewest records?

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  NOR 
A)  AND 
B)  OR 
C)  NOT 
D)  NOR

Question 9

What field property increases the speed at which searches can be performed?

Accepted Answer

A)  Indexed 
B)  Allow Zero Length 
C)  Required 
D)  Result Type 
A)  Indexed 
B)  Allow Zero Length 
C)  Required 
D)  Result Type

Question 10

You cannot create a relationship between two tables unless there is at least one ________ key.

Accepted Answer

The answer of You cannot create a relationship between two...

Question 11

Access provides a wizard for easily importing Excel data into Access.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

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

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 15

The ________ key is what guarantees that a record is unique.

Accepted Answer

The answer of The ________ key is what guarantees that...

Question 16

Match the following terms with their description:
i. "And" condition
II. "Or" condition
III. Null
IV. Comparison Operator
v. Criteria

Accepted Answer

A)  Blank field value 
B)  Examples include: >, , = 
C)  Returns only records that meet all criteria 
D)  Determines which records are selected 
E)  Returns records meeting any criteria 
A)  Blank field value 
B)  Examples include: >, , = 
C)  Returns only records that meet all criteria 
D)  Determines which records are selected 
E)  Returns records meeting any criteria

Question 17

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.

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Access uses ________ to speed up the sorting or filtering process.

Match the recommended field types with their examples: i. AutoNumber II. OLE III. Hyperlink IV. Yes / No v. Attachment

Use the ________ data type when you want to store multiple pictures in your records.

What field property helps to make sure that correct data is entered?

For security purposes you want to have data redundancy in your tables.

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

Which logical operator would return the fewest records?

What field property increases the speed at which searches can be performed?

You cannot create a relationship between two tables unless there is at least one ________ key.

Access provides a wizard for easily importing Excel data into Access.

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

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

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

The ________ key is what guarantees that a record is unique.

Match the following terms with their description: i. "And" condition II. "Or" condition III. Null IV. Comparison Operator v. Criteria

What is not true about the hyperlink data type?

Common Features

Access: Introduction to Powerpoint

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 3: Access: Tables and Queries in Relational Databases

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Access uses ________ to speed up the sorting or filtering process.

Match the recommended field types with their examples: i. AutoNumber II. OLE III. Hyperlink IV. Yes / No v. Attachment

Use the ________ data type when you want to store multiple pictures in your records.

What field property helps to make sure that correct data is entered?

For security purposes you want to have data redundancy in your tables.

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

Which logical operator would return the fewest records?

What field property increases the speed at which searches can be performed?

You cannot create a relationship between two tables unless there is at least one ________ key.

Access provides a wizard for easily importing Excel data into Access.

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

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

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

The ________ key is what guarantees that a record is unique.

Match the following terms with their description: i. "And" condition II. "Or" condition III. Null IV. Comparison Operator v. Criteria

What is not true about the hyperlink data type?

Common Features

Access: Introduction to Powerpoint

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters