Question 1

The value of a field containing no information is a ____ value.

Accepted Answer

A) blank 
B) zero 
C) concatenated 
D) null 
A) blank 
B) zero 
C) concatenated 
D) null

Question 2

To avoid the display of a security warning when opening a database,place the database ____.

Accepted Answer

A) on a flash drive 
B) only on a hard drive 
C) in an external folder on an external drive 
D) in a trusted folder 
A) on a flash drive 
B) only on a hard drive 
C) in an external folder on an external drive 
D) in a trusted folder

Question 3

Crosstab queries may use which of the following aggregate functions?

Accepted Answer

A) Like 
B) Not 
C) Var 
D) Between 
A) Like 
B) Not 
C) Var 
D) Between

Question 4

The standard naming convention prefix tag for a query used to identify the object type is ____.

Accepted Answer

A) Query 
B) QURY 
C) qry 
D) QRY# 
A) Query 
B) QURY 
C) qry 
D) QRY#

Question 5

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

Accepted Answer

A) Find Duplicates Query Wizard 
B) Crosstab Query Wizard 
C) Simple Query Wizard 
D) Find Unmatched Query Wizard 
A) Find Duplicates Query Wizard 
B) Crosstab Query Wizard 
C) Simple Query Wizard 
D) Find Unmatched Query Wizard

Question 6

In an input mask,the letter ____ indicates that a letter or digit must be entered,and the entry is required.

Accepted Answer

A) A 
B) a 
C) C 
D) L 
A) A 
B) a 
C) C 
D) L

Question 7

A select query that finds duplicate records in a table or query.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation 
A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 8

The calculated expression =City &"," &State &" " &ZipCode is an example of ____.

Accepted Answer

A) concatenation 
B) ampersand 
C) AutoFilter 
D) a parameter query 
A) concatenation 
B) ampersand 
C) AutoFilter 
D) a parameter query

Question 9

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu.____________________

Accepted Answer

A) True 
 B)False

Question 10

Carlos has developed a database for his organic farm.The farm sells organic produce and meat.In addition to the retail sales of his products,he offers cooking demonstrations five times each month for a small fee.The demonstrations are limited to 10 people.The database contains the following tables: Products,ProductPrices,ProductCosts,Suppliers,Customers,and CookingDemos.The Products,Product Prices,Product Costs and Suppliers tables are related using the ProductID field.The Customers and CookingDemos tables are related on the CustomerID field.Carlos needs to make some decisions using his database.Determine the best method for Carlos to use to achieve the results he wants.
-Carlos has decided to market his cooking demonstrations based on his most abundant products.To do that he needs to know the quantity of each product by category (such as beef,green vegetables,peppers,etc. )Because each product in the Products table is assigned a category in the Category field,he will create a query that lists the categories in rows in the datasheet and the product totals as columns in the datasheet when the query is run.Which type of query will Carlos create?

Accepted Answer

A) crosstab query 
B) parameter query 
C) simple query 
D) top values query 
A) crosstab query 
B) parameter query 
C) simple query 
D) top values query

Question 11

Validation Rules are entered in the ____

Accepted Answer

A) Navigation Pane 
B) datasheet 
C) dependent object 
D) Field Properties Pane 
A) Navigation Pane 
B) datasheet 
C) dependent object 
D) Field Properties Pane

Question 12

A field data type that allows text values to be entered up to 65,535 characters.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation 
A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 13

A field that allows the user to select a value from a list of possible values to enter data in the field.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation 
A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 14

The Top Values query property allows the user to limit the number of records in the query results by using a preset value,by entering an integer,or by selecting a(n)____________________.

Accepted Answer

The answer of The Top Values query property allows the...

Question 15

TheLike comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*,?,#)in a query.____________________

Accepted Answer

A) True 
 B)False

Question 16

Marie works for a busy pediatrician's office.The practice has a sophisticated database for all records and information that pertain to the practice.The doctor for whom she works is participating in an academic study,and she needs a report that lists the patient's name,date of birth,and the names of parents or guardians.The doctor would like to see the patient's full name in the format Lastname,Firstname even though they are separate fields in the database.She would also like to see the data for the fields Mother,Father,and Guardian,regardless of whether or not data is actually entered in those fields.  Based on the doctor's requirements for the report,Marie must create a query on which to base the report.
-Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] &"," [FirstName].  This expression is an example of ____.

Accepted Answer

A) IsNull 
B) concatenation 
C) nonnull 
D) an expression using a logical operator 
A) IsNull 
B) concatenation 
C) nonnull 
D) an expression using a logical operator

Question 17

Joining two or more fields in a calculated field using an expression such as =Title &" "&FirstName &" " &LastName is an example of concatenation.____________________

Accepted Answer

A) True 
 B)False

Question 18

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

Accepted Answer

A) Like 
B) While 
C) Between 
D) In 
A) Like 
B) While 
C) Between 
D) In

Question 19

Carlos has developed a database for his organic farm.The farm sells organic produce and meat.In addition to the retail sales of his products,he offers cooking demonstrations five times each month for a small fee.The demonstrations are limited to 10 people.The database contains the following tables: Products,ProductPrices,ProductCosts,Suppliers,Customers,and CookingDemos.The Products,Product Prices,Product Costs and Suppliers tables are related using the ProductID field.The Customers and CookingDemos tables are related on the CustomerID field.Carlos needs to make some decisions using his database.Determine the best method for Carlos to use to achieve the results he wants.
-Carlos needs to decide which cooking demonstrations to offer next month.He would like to offer his five most popular demonstrations.Which method would be best for Carlos to use to find this information from his database?

Accepted Answer

A) use a calculated field in the CookingDemo table to calculate how many people signed up for each demonstration 
B) manually count the number of people who attended each demonstration 
C) create a top values query based on the field in the CookingDemo table that lists the number of participants 
D) create a pattern match in a query based on the Customer table 
A) use a calculated field in the CookingDemo table to calculate how many people signed up for each demonstration 
B) manually count the number of people who attended each demonstration 
C) create a top values query based on the field in the CookingDemo table that lists the number of participants 
D) create a pattern match in a query based on the Customer table

Question 20

An input mask property cannot be changed after the Input Mask Wizard closes.

Accepted Answer

A) True 
 B)False

The value of a field containing no information is a ____ value.

To avoid the display of a security warning when opening a database,place the database ____.

Crosstab queries may use which of the following aggregate functions?

The standard naming convention prefix tag for a query used to identify the object type is ____.

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

In an input mask,the letter ____ indicates that a letter or digit must be entered,and the entry is required.

A select query that finds duplicate records in a table or query.

The calculated expression =City &"," &State &" " &ZipCode is an example of ____.

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu.____________________

Validation Rules are entered in the ____

A field data type that allows text values to be entered up to 65,535 characters.

A field that allows the user to select a value from a list of possible values to enter data in the field.

The Top Values query property allows the user to limit the number of records in the query results by using a preset value,by entering an integer,or by selecting a(n)____________________.

TheLike comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*,?,#)in a query.____________________

Joining two or more fields in a calculated field using an expression such as =Title &" "&FirstName &" " &LastName is an example of concatenation.____________________

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

An input mask property cannot be changed after the Input Mask Wizard closes.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 5: Creating Advanced Queries and Enhancing Table Design

The value of a field containing no information is a ____ value.

To avoid the display of a security warning when opening a database,place the database ____.

Crosstab queries may use which of the following aggregate functions?

The standard naming convention prefix tag for a query used to identify the object type is ____.

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

In an input mask,the letter ____ indicates that a letter or digit must be entered,and the entry is required.

A select query that finds duplicate records in a table or query.

The calculated expression =City &"," &State &" " &ZipCode is an example of ____.

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu.____________________

Validation Rules are entered in the ____

A field data type that allows text values to be entered up to 65,535 characters.

A field that allows the user to select a value from a list of possible values to enter data in the field.

The Top Values query property allows the user to limit the number of records in the query results by using a preset value,by entering an integer,or by selecting a(n)____________________.

TheLike comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*,?,#)in a query.____________________

Joining two or more fields in a calculated field using an expression such as =Title &" "&FirstName &" " &LastName is an example of concatenation.____________________

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

An input mask property cannot be changed after the Input Mask Wizard closes.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters