Question 1

An example of a ________ field is a field for sales associates' bonus--.05 multiplied by quarterly sales.

Accepted Answer

A)  multitable 
B)  logical 
C)  numeric 
D)  calculated 
A)  multitable 
B)  logical 
C)  numeric 
D)  calculated

Question 2

Which of the following is NOT a way to create a table in Access?

Accepted Answer

A)  Typing a field name in a column in Datasheet view 
B)  Typing a field name in a row in Design view 
C)  Entering table data into a new row in Datasheet view 
D)  Importing data from another database or application 
A)  Typing a field name in a column in Datasheet view 
B)  Typing a field name in a row in Design view 
C)  Entering table data into a new row in Datasheet view 
D)  Importing data from another database or application

Question 3

Match between columns
                        Premises: Criteria row
delimiter
Table row
Show row
query

Accepted Answer

The Answer of used to set rules that determine which is...

Question 4

A text field may contain numbers,text,and special characters.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ operator,such as the greater than or less than symbol,can be used in a query criterion to limits the results produced by the query.

Accepted Answer

A)  operand 
B)  wildcard 
C)  comparison 
D)  delimiter 
A)  operand 
B)  wildcard 
C)  comparison 
D)  delimiter

Question 6

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

Accepted Answer

A) True 
 B)False

Question 7

How do you launch the Query Wizard and what is the first step of the wizard?

Accepted Answer

Launch the Query Wizard by clicking the

Question 8

A(n)________ verifies data entered into a field and ensures that the data is of the correct type for the field.

Accepted Answer

The answer of A(n)________ verifies data entered into a field...

Question 9

________ are displayed in the Relationships window to establish a relationship between two tables.

Accepted Answer

The answer of ________ are displayed in the Relationships window...

Question 10

If you want to modify a saved query,open the query in ________ view.

Accepted Answer

The answer of If you want to modify a saved...

Question 11

Describe how sort order in an Access table is determined.

Accepted Answer

Soft order in a table is deter

Question 12

Explain the NOT logical operator and provide one example.

Accepted Answer

The NOT logical operator retur

Question 13

Fields can be renamed either in Design view or in Datasheet view.

Accepted Answer

A) True 
 B)False

Question 14

The ________ of the query design grid is used to set the rules that determine which records of a table will be selected.

Accepted Answer

The answer of The ________ of the query design grid...

Question 15

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

Accepted Answer

The answer of The ________ data type should be applied...

Question 16

________ tables are tables that are joined from one table to another through a common field.

Accepted Answer

The answer of ________ tables are tables that are joined...

Question 17

Would you want to save every query that you create? Why or why not?

Accepted Answer

Many queries you create are a one-of-a-k

Question 18

"The primary key of a table plays a significant role when setting relationships." Describe why this statement is true.

Accepted Answer

You cannot join two tables unless a prim

Question 19

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12,2014?

Accepted Answer

A)  12/12/2010 
B)  #12/12/2010# 
C)  Between #12/11/2010# and #12/14/2010# 
D)  12/11/2010 
A)  12/12/2010 
B)  #12/12/2010# 
C)  Between #12/11/2010# and #12/14/2010# 
D)  12/11/2010

Question 20

Referential integrity should be enforced in a database with related tables because it:

Accepted Answer

A)  creates a primary key in every table of a database. 
B)  helps ensure invalid data is not entered into a table. 
C)  makes the database easier to repair. 
D)  helps ensure data is automatically updated. 
A)  creates a primary key in every table of a database. 
B)  helps ensure invalid data is not entered into a table. 
C)  makes the database easier to repair. 
D)  helps ensure data is automatically updated.

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

An example of a ________ field is a field for sales associates' bonus--.05 multiplied by quarterly sales.

Which of the following is NOT a way to create a table in Access?

A text field may contain numbers,text,and special characters.

A(n)________ operator,such as the greater than or less than symbol,can be used in a query criterion to limits the results produced by the query.

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

How do you launch the Query Wizard and what is the first step of the wizard?

A(n)________ verifies data entered into a field and ensures that the data is of the correct type for the field.

________ are displayed in the Relationships window to establish a relationship between two tables.

If you want to modify a saved query,open the query in ________ view.

Describe how sort order in an Access table is determined.

Explain the NOT logical operator and provide one example.

Fields can be renamed either in Design view or in Datasheet view.

The ________ of the query design grid is used to set the rules that determine which records of a table will be selected.

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

________ tables are tables that are joined from one table to another through a common field.

Would you want to save every query that you create? Why or why not?

"The primary key of a table plays a significant role when setting relationships." Describe why this statement is true.

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12,2014?

Referential integrity should be enforced in a database with related tables because it:

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: 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

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