Question 1

After entering information into a table,and closing the tab for that table,the information is automatically saved by Access.

Accepted Answer

A) True 
 B)False

Question 2

When entering text into the _____ box,you must be careful that you have the right letters (and digits and spaces,if applicable)in the right places.

Accepted Answer

Criteria
Explanation: When ent

Question 3

Which of the following tasks do you need to be careful of,when making changes to the information in any of the relations (tables or files)of the database structure?

Accepted Answer

A) Deleting fields which establish relationships to other tables 
B) Adding additional information in the tables 
C) Deleting records in a relation 
D) Changing records in a relation 
A) Deleting fields which establish relationships to other tables 
B) Adding additional information in the tables 
C) Deleting records in a relation 
D) Changing records in a relation

Question 4

In Access,a report can be created using either Design View or with the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 5

_____ are rules that help ensure the quality of the information.

Accepted Answer

Integrity constraints
Explanat

Question 6

If you wanted to limit the output of data to transactions occurring after April 1,2009,what tab or object would you select?

Accepted Answer

A) Table 
B) Queries 
C) Forms 
D) Reports 
A) Table 
B) Queries 
C) Forms 
D) Reports

Question 7

A composite primary key consists of the primary key fields from two intersection relations.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following options would be the correct way to construct a conditional query in one relation whereby to pass this course,you must have at passing grade of 75 or more?

Accepted Answer

A) Enter =75 in the Criteria parameter and then >75 right below B) Enter =75 in the Criteria parameter and nothing anywhere else C) Enter >75 in the Criteria parameter only D) Enter >75 in the Criteria parameter and then <100 right below A) Enter =75 in the Criteria parameter and then >75 right below B) Enter =75 in the Criteria parameter and nothing anywhere else C) Enter >75 in the Criteria parameter only D) Enter >75 in the Criteria parameter and then <100 right below

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Microsoft Access's application _____ subsystem is used to create reports and input forms.

Accepted Answer

generation
Explanation: Micros

Question 11

When a primary key field is established,the ampersand icon is shown to the left of the field name.

Accepted Answer

A) True 
 B)False

Question 12

When creating the structure of a relation,the result of changing the Allow Zero Length to No,means that something must be entered into this field when a new record is added.

Accepted Answer

A) True 
 B)False

Question 13

If you needed to identify inventory items whose stock was running low,which Access tool could help you find the answer?

Accepted Answer

A) Table Properties 
B) Query-by-example 
C) Referential Integrity 
D) Forms 
A) Table Properties 
B) Query-by-example 
C) Referential Integrity 
D) Forms

Question 14

The fundamental difference between tables (or queries)and reports is that a report is designed for human consumption.

Accepted Answer

A) True 
 B)False

Question 15

After entering information into each field of an Access table,you use the Shift key to get into the next field or row.

Accepted Answer

A) True 
 B)False

Question 16

When viewing a report where information in a field has been cut off,it is said to be truncated.

Accepted Answer

A) True 
 B)False

Question 17

How can you change the structure of the form?

Accepted Answer

A) Click on File Menu and then click Display Properties. 
B) Double-click Insert tab and then select Change View. 
C) Double click View tab and select Edit Relationships. 
D) Right-click on the Order tab and then select Design View. 
A) Click on File Menu and then click Display Properties. 
B) Double-click Insert tab and then select Change View. 
C) Double click View tab and select Edit Relationships. 
D) Right-click on the Order tab and then select Design View.

Question 18

A(n)_____ is a primary key of one file (relation)that appears in another file (relation).

Accepted Answer

foreign key
Explanation: A for

Question 19

In MS Access,to show that a field is a foreign key,Access will place an image of a key to the left of the field name.

Accepted Answer

A) True 
 B)False

Question 20

There are a specific set of tasks that need to be completed when building a business report.Which of these is not a part of the first three tasks?

Accepted Answer

A) Choose tables and/or queries 
B) Edit relationships 
C) Choose fields 
D) Click on Create and Report Wizard 
A) Choose tables and/or queries 
B) Edit relationships 
C) Choose fields 
D) Click on Create and Report Wizard

Exam 19: Implementing a Database With Microsoft Access

After entering information into a table,and closing the tab for that table,the information is automatically saved by Access.

When entering text into the _____ box,you must be careful that you have the right letters (and digits and spaces,if applicable)in the right places.

Which of the following tasks do you need to be careful of,when making changes to the information in any of the relations (tables or files)of the database structure?

In Access,a report can be created using either Design View or with the Report Wizard.

_____ are rules that help ensure the quality of the information.

If you wanted to limit the output of data to transactions occurring after April 1,2009,what tab or object would you select?

A composite primary key consists of the primary key fields from two intersection relations.

Which of the following options would be the correct way to construct a conditional query in one relation whereby to pass this course,you must have at passing grade of 75 or more?

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

Microsoft Access's application _____ subsystem is used to create reports and input forms.

When a primary key field is established,the ampersand icon is shown to the left of the field name.

When creating the structure of a relation,the result of changing the Allow Zero Length to No,means that something must be entered into this field when a new record is added.

If you needed to identify inventory items whose stock was running low,which Access tool could help you find the answer?

The fundamental difference between tables (or queries)and reports is that a report is designed for human consumption.

After entering information into each field of an Access table,you use the Shift key to get into the next field or row.

When viewing a report where information in a field has been cut off,it is said to be truncated.

How can you change the structure of the form?

A(n)_____ is a primary key of one file (relation)that appears in another file (relation).

In MS Access,to show that a field is a foreign key,Access will place an image of a key to the left of the field name.

There are a specific set of tasks that need to be completed when building a business report.Which of these is not a part of the first three tasks?

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