Question 1

One purpose of a data manipulation language is to:

Accepted Answer

A)  Create data fields
B)  Define the record structure
C)  Create queries on the data
D)  all of these

Question 2

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

Accepted Answer

A)  Customers, Employees, and Cash Receipts
B)  Customers, Employees, and Sales
C)  Sales, Inventory, and Cash Receipts
D)  Sales, Inventory, and the relationship table Sales/Inventory

Question 3

All of the following are advantages of drop-down boxes in Access except:

Accepted Answer

A)  It limits users to valid input choices
B)  It takes a small amount of room, even if the number of choices is large
C)  It always limits users to numeric entries
D)  The entries for the combo box can be stored in a separate table

Question 4

A dynaset is the set of records that results from a query.

Accepted Answer

A) True 
 B)False

Question 5

DDL is an acronym for "data definition language."

Accepted Answer

A) True 
 B)False

Question 6

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

Accepted Answer

A)  Short Text
B)  Number
C)  Long Text
D)  Percent
E)  all of these are legitimate data types

Question 7

Using Access, which of these terms is not associated with defining a data field within a record?

Accepted Answer

A)  Field name
B)  Data type
C)  Currency value
D)  Description

Question 8

You could add the term "Jr." to selected names in a customer database using Microsoft's:

Accepted Answer

A)  Append query
B)  Update query
C)  Make table query
D)  Select query
E)  none of these (this is not possible using an action query)

Question 9

If you want to require a data entry in an Access database to fall between two dates (rather than between two numeric values) :

Accepted Answer

A)  You should use a select query using one line
B)  You should use a select query, using two lines
C)  You should use a validation rule and the word "between"
D)  This is impossible to require in Access

Question 10

Using Access, which of the following is not a recognized data type?

Accepted Answer

A)  yes/no
B)  Year
C)  Currency
D)  Date

Question 11

Sorting records is unlike indexing records in that:

Accepted Answer

A)  Sorting physically rewrites records on disks whereas indexing does not
B)  Sorting requires a primary key whereas indexing does not
C)  Indexing requires a separate database file whereas sorting does not
D)  none of these

Question 12

A DBMS is a type of software.

Accepted Answer

A) True 
 B)False

Question 13

DML stands for:

Accepted Answer

A)  Distributed management logic
B)  Data management logic
C)  Data management language
D)  Data manipulation language

Question 14

An example of a data type for a database record field is "short text."

Accepted Answer

A) True 
 B)False

Question 15

Foreign keys are necessary in a database because every record must have a foreign key.

Accepted Answer

A) True 
 B)False

Question 16

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

Accepted Answer

A)  Spell accurately
B)  Don't worry about capitalization
C)  Join each table at least twice to ensure their connectivity
D)  Name each query you create "Query"

Question 17

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

Accepted Answer

A) True 
 B)False

Question 18

The value that a database will use if the user does not provide an alternate value is called a(n) :

Accepted Answer

A)  Asset value
B)  Text value
C)  Control value
D)  Default value

Question 19

You can instruct Access to display a particular error message if you use this property:

Accepted Answer

A)  Validation rule
B)  Validation text
C)  Validation message
D)  Validation error

Question 20

A "default value" for an Access data field is:

Accepted Answer

A)  The value of last resort
B)  A value that Access will assume if the user does not enter one
C)  A value that Access will take from the last record entered into the system
D)  none of these

Exam 15: Organizing and Manipulating the Data in Databases

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

Correct AnswerverifiedShow Answer

If you want to require a data entry in an Access database to fall between two dates (rather than between two numeric values) :

Correct AnswerverifiedShow Answer

One purpose of a data manipulation language is to:

Correct AnswerverifiedShow Answer

Using Access, which of these terms is not associated with defining a data field within a record?

Correct AnswerverifiedShow Answer

Sorting records is unlike indexing records in that:

Correct AnswerverifiedShow Answer

Foreign keys are necessary in a database because every record must have a foreign key.

Correct AnswerverifiedShow Answer

A dynaset is the set of records that results from a query.

Correct AnswerverifiedShow Answer

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

Correct AnswerverifiedShow Answer

You could add the term "Jr." to selected names in a customer database using Microsoft's:

Correct AnswerverifiedShow Answer

The value that a database will use if the user does not provide an alternate value is called a(n) :

Correct AnswerverifiedShow Answer

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

Correct AnswerverifiedShow Answer

A "default value" for an Access data field is:

Correct AnswerverifiedShow Answer

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

Correct AnswerverifiedShow Answer

DDL is an acronym for "data definition language."

Correct AnswerverifiedShow Answer

An example of a data type for a database record field is "short text."

Correct AnswerverifiedShow Answer

A DBMS is a type of software.

Correct AnswerverifiedShow Answer

Using Access, which of the following is not a recognized data type?

Correct AnswerverifiedShow Answer

DML stands for:

Correct AnswerverifiedShow Answer

All of the following are advantages of drop-down boxes in Access except:

Correct AnswerverifiedShow Answer

You can instruct Access to display a particular error message if you use this property:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified