Question 1

What does the Special Effect button on the formatting toolbar do?

Accepted Answer

A)  It lets you add animation to your forms and reports to make them more entertaining and amusing
B)  It lets you select a transitional effect for how a form opens and closes.
C)  It applies a 30d effect to a selected control
D)  None of theseE) B) and D)
F) B) and C)

Question 2

What is the corresponding text for the <#1/1/ 95# validation rule setting?

Accepted Answer

A)  Neter a value less or more than 1,195
B)  Value must be less than 95 characters
C)  Enter a date before 1995
D)  All of aboveE) B) and D)
F) None of the above

Question 3

Which of the following is NOT a type of Microsoft Access database object?

Accepted Answer

A)  Queries
B)  Workbooks
C)  Forms
D)  TablesE) A) and C)
F) B) and C)

Question 4

How do you filter by selection?

Accepted Answer

A)  Right click the field value and select filter by selection from the shortcut menu
B)  Find and double click the value on which you want to base the filter
C)  Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
D)  None of the aboveE) None of the above
F) A) and B)

Question 5

What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library's available objects and members?

Accepted Answer

A)  Object Viewer
B)  Object Browser
C)  Type Library Spy
D)  None of aboveE) A) and B)
F) A) and C)

Question 6

Data items groped together for storage purposes are called a

Accepted Answer

A)  Record
B)  Title
C)  List
D)  stringE) C) and D)
F) B) and C)

Question 7

A subset of characters within a data field is known as

Accepted Answer

A)  Record
B)  File
C)  Data string
D)  ByteE) B) and C)
F) A) and B)

Question 8

Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

Accepted Answer

A)  Relational
B)  Structural
C)  Network
D)  All of the aboveE) B) and C)
F) None of the above B

Question 9

A command that lets you cange one or more fields in a record is

Accepted Answer

A)  Insert
B)  Modify
C)  Look up
D)  All of the aboveE) B) and C)
F) None of the above

Question 10

The executive responsible for the data processing function in an organization is

Accepted Answer

A)  PM
B)  DBMS
C)  DP
D)  DPME) None of the above
F) All of the above

Question 11

What is the purpose of the page field on a pivot table report?

Accepted Answer

A)  It creates a new page for each type of data
B)  It allows the data within the the Pivot Table report to be filtered
C)  It displays a title for the Pivot Table report
D)  None of the aboveE) A) and C)
F) A) and D)

Question 12

Which program do you use to edit code for data access pages?

Accepted Answer

A)  Microsoft script editor
B)  Microsoft code editor
C)  Microsoft data access pages editor
D)  None of aboveE) A) and B)
F) All of the above

Question 13

The complete picture of data stored in database is known as

Accepted Answer

A)  Record
B)  Scheme
C)  System flowchart
D)  DBMSE) A) and B)
F) None of the above B

Question 14

In a relational schema, each tuple is divided into fields called

Accepted Answer

A)  Relations
B)  Domains
C)  Queries
D)  All of the aboveE) A) and D)
F) None of the above

Question 15

Pivot Table report data must meet which of the following criteria?

Accepted Answer

A)  It must be in tabular form, have unique column labels, and each row must represent a unique piece of data
B)  Any dates should be formatted with the data format and blank rows or columns should be removed
C)  It must be in tabular form, have unique column lagels, and all rows must be sorted
D)  Both (
A)   and (
B)  E) B) and C)
F) A) and B) D

Question 16

A top to bottom relationship among the items in a database is established by a

Accepted Answer

A)  Hierarchical schema
B)  Network Schema
C)  Relational schema
D)  All of the aboveE) B) and C)
F) A) and D)

Question 17

Which of the following is not a data type ?

Accepted Answer

A)  Picture/graphic
B)  Data/time
C)  Texst
D)  NumberE) C) and D)
F) B) and C)

Question 18

Customers, Orders. What's their best relationship?

Accepted Answer

A)  Many-to-many
B)  One-to-one
C)  One-to-many
D)  All of the aboveE) None of the above
F) A) and B)

Question 19

A file containing relatively permanent data is

Accepted Answer

A)  Random file
B)  Transaction file
C)  Master file
D)  Sequential fileE) C) and D)
F) None of the above

Question 20

Which control does access use to link data access page components to access data?

Accepted Answer

A)  Microsoft Dynamic Data Control
B)  Microsoft Data Connection Control
C)  Microsoft Office Data Source Control
D)  None of the aboveE) A) and C)
F) A) and B)

Exam 6: Database Management System DBMS

What does the Special Effect button on the formatting toolbar do?

Correct AnswerverifiedShow Answer

What is the corresponding text for the <#1/1/ 95# validation rule setting?

Correct AnswerverifiedShow Answer

Which of the following is NOT a type of Microsoft Access database object?

Correct AnswerverifiedShow Answer

How do you filter by selection?

Correct AnswerverifiedShow Answer

What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library's available objects and members?

Correct AnswerverifiedShow Answer

Data items groped together for storage purposes are called a

Correct AnswerverifiedShow Answer

A subset of characters within a data field is known as

Correct AnswerverifiedShow Answer

Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

Correct AnswerverifiedB

A command that lets you cange one or more fields in a record is

Correct AnswerverifiedShow Answer

The executive responsible for the data processing function in an organization is

Correct AnswerverifiedShow Answer

What is the purpose of the page field on a pivot table report?

Correct AnswerverifiedShow Answer

Which program do you use to edit code for data access pages?

Correct AnswerverifiedShow Answer

The complete picture of data stored in database is known as

Correct AnswerverifiedB

In a relational schema, each tuple is divided into fields called

Correct AnswerverifiedShow Answer

Pivot Table report data must meet which of the following criteria?

Correct AnswerverifiedD

A top to bottom relationship among the items in a database is established by a

Correct AnswerverifiedShow Answer

Which of the following is not a data type ?

Correct AnswerverifiedShow Answer

Customers, Orders. What's their best relationship?

Correct AnswerverifiedShow Answer

A file containing relatively permanent data is

Correct AnswerverifiedShow Answer

Which control does access use to link data access page components to access data?

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
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified