Question 1

Data input forms are designed to simplify the task of entering new information.

Accepted Answer

A) True 
 B)False

Question 2

What is the name of a field that uniquely describes each record in a database?

Accepted Answer

A) Composite key 
B) Foreign key 
C) Primary key 
D) Integrity key 
A) Composite key 
B) Foreign key 
C) Primary key 
D) Integrity key

Question 3

Which of the following is a key that consists of the primary key fields from two intersecting relations (files)?

Accepted Answer

A) Simple primary key 
B) Metakey 
C) Composite primary key 
D) Integrity key 
A) Simple primary key 
B) Metakey 
C) Composite primary key 
D) Integrity key

Question 4

When you drag and drop a primary key onto a foreign key,what relationship does Microsoft Access assume it to be?

Accepted Answer

A) 1:1 
B) M:M 
C) 1:M 
D) M:N 
A) 1:1 
B) M:M 
C) 1:M 
D) M:N

Question 5

When developing a database structure in Microsoft Access,what icon is shown to the left of the field name to indicate that the field is a primary field?

Accepted Answer

A) Bullet 
B) Format 
C) Arrow 
D) Key 
A) Bullet 
B) Format 
C) Arrow 
D) Key

Question 6

What happens when you attempt to input incorrect information into a field that has an Enforce Referential Integrity option in effect?

Accepted Answer

A) Access automatically gives you a choice of file menus to correct the problem. 
B) Access will automatically shut down. 
C) Access will display a dialog box informing you of the problem. 
D) Access will accept the information but warn you that there might be a problem. 
A) Access automatically gives you a choice of file menus to correct the problem. 
B) Access will automatically shut down. 
C) Access will display a dialog box informing you of the problem. 
D) Access will accept the information but warn you that there might be a problem.

Question 7

When creating a simple query with one relation,you first open the file.Following this step,what area would you drag and drop the field names in order to run the query?

Accepted Answer

A) Table Grid 
B) QBE Grid 
C) Report Grid 
D) Form Grid 
A) Table Grid 
B) QBE Grid 
C) Report Grid 
D) Form Grid

Question 8

What key is a primary key of one file that appears in another file?

Accepted Answer

A) Composite key 
B) Foreign key 
C) Secondary key 
D) Intersecting key 
A) Composite key 
B) Foreign key 
C) Secondary key 
D) Intersecting key

Question 9

When you drag and drop a foreign key onto a primary key,what does Microsoft Access assumes the relationship is?

Accepted Answer

A) 1:1 
B) M:M 
C) 1:M 
D) M:1 
A) 1:1 
B) M:M 
C) 1:M 
D) M:1

Question 10

Once a QBE has been designed what do you click on,to actually get it to run?

Accepted Answer

A) Infinity symbol 
B) Ampersand Mark 
C) Exclamation point 
D) Lightening Bolt 
A) Infinity symbol 
B) Ampersand Mark 
C) Exclamation point 
D) Lightening Bolt

Question 11

When creating a query in Query Design,you can drag and drop the fields that you want in the query results into the QBE grid.

Accepted Answer

A) True 
 B)False

Question 12

Before information can be entered into a database,what is the first step you need to do?

Accepted Answer

A) Determine the many-to-many relationships 
B) Determine who will have access to the information 
C) Define the correct structure of the database 
D) Establish user responsibility 
A) Determine the many-to-many relationships 
B) Determine who will have access to the information 
C) Define the correct structure of the database 
D) Establish user responsibility

Question 13

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is a many-to-many.

Accepted Answer

A) True 
 B)False

Question 14

The two main ways for creating a data dictionary in Microsoft Access are in Report View and Design View.

Accepted Answer

A) True 
 B)False

Question 15

When generating a report,_____ lets you specify groups within the top grouping.

Accepted Answer

further grouping
Exp

Question 16

Which of the following could you use to create a data dictionary in Microsoft Access?

Accepted Answer

A) Field view 
B) Information view 
C) Query view 
D) Design view 
A) Field view 
B) Information view 
C) Query view 
D) Design view

Question 17

A primary key is a field that uniquely identifies a record within a relation or table.

Accepted Answer

A) True 
 B)False

Question 18

_____ is the most popular database management system software.

Accepted Answer

Microsoft Access
Exp

Question 19

If you needed to print the date in the report footer,what function would you use?

Accepted Answer

A) dt.now 
B) date? 
C) &date 
D) =Now() 
A) dt.now 
B) date? 
C) &date 
D) =Now()

Question 20

Access assumes that the first field name is ID and that its Data Type is ____,meaning that the first record will have an ID of 1,the second will have 2,and so on.

Accepted Answer

AutoNumber
Explanation: Access assumes t

Exam 19: Implementing a Database With Microsoft Access

Data input forms are designed to simplify the task of entering new information.

What is the name of a field that uniquely describes each record in a database?

Which of the following is a key that consists of the primary key fields from two intersecting relations (files)?

When you drag and drop a primary key onto a foreign key,what relationship does Microsoft Access assume it to be?

When developing a database structure in Microsoft Access,what icon is shown to the left of the field name to indicate that the field is a primary field?

What happens when you attempt to input incorrect information into a field that has an Enforce Referential Integrity option in effect?

When creating a simple query with one relation,you first open the file.Following this step,what area would you drag and drop the field names in order to run the query?

What key is a primary key of one file that appears in another file?

When you drag and drop a foreign key onto a primary key,what does Microsoft Access assumes the relationship is?

Once a QBE has been designed what do you click on,to actually get it to run?

When creating a query in Query Design,you can drag and drop the fields that you want in the query results into the QBE grid.

Before information can be entered into a database,what is the first step you need to do?

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is a many-to-many.

The two main ways for creating a data dictionary in Microsoft Access are in Report View and Design View.

When generating a report,_____ lets you specify groups within the top grouping.

Which of the following could you use to create a data dictionary in Microsoft Access?

A primary key is a field that uniquely identifies a record within a relation or table.

_____ is the most popular database management system software.

If you needed to print the date in the report footer,what function would you use?

Access assumes that the first field name is ID and that its Data Type is ____,meaning that the first record will have an ID of 1,the second will have 2,and so on.

The Information Age in Which You Live: Changing the Face of Business

Major Business Initiatives: Gaining Competitive Advantage With It

Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Analytics, Decision Support, and Artificial Intelligence: Brain-Power for Your Business

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Infrastructure, Cloud Computing, Metrics, and Business Continuity Planning: Building and Sustaining the Dynamic Enterprise

Protecting People and Information: Threats and Safeguards

Emerging Trends and Technologies: Business, People, and Technology Tomorrow

Computer Hardware and Software

The World Wide Web and the Internet

Designing Databases and Entity-Relationship Diagramming

Decision Analysis With Spreadsheet Software

Network Basics

Building a Web Page With Html

Object-Oriented Technologies

Computer Crime and Digital Forensics

Building an E-Portfolio

Careers in Business

Building Web Sites With Front-page

Programming in Excel With VBA

Filters