Question 1

Once you have entered all the information into a given table and closed the tab for that table,what happens to the information?

Accepted Answer

A) Access automatically gives you a choice of file menus. 
B) Access automatically closes the table. 
C) Access automatically saves the information. 
D) Access automatically opens an empty table. 
A) Access automatically gives you a choice of file menus. 
B) Access automatically closes the table. 
C) Access automatically saves the information. 
D) Access automatically opens an empty table.

Question 2

Once a query has been constructed,you click on the lightning bolt icon in the button bar to run it.

Accepted Answer

A) True 
 B)False

Question 3

If you needed to create a statement of accounts that would be printed at the end of each month,what Access tool would you use?

Accepted Answer

A) QBE tools 
B) Reports 
C) Word processor 
D) Editing tools 
A) QBE tools 
B) Reports 
C) Word processor 
D) Editing tools

Question 4

Restricting new orders to customers with an ID already in the database is an example of integrity constraints.

Accepted Answer

A) True 
 B)False

Question 5

If you needed a title to print on the first page of a multi-page report,where would you place this title in the report design?

Accepted Answer

A) Report header 
B) Page header 
C) Detail 
D) Legend 
A) Report header 
B) Page header 
C) Detail 
D) Legend

Question 6

Once the structure of the database has been created,what is the next step?

Accepted Answer

A) Create the data dictionary 
B) Determine what reports will be needed 
C) Determine how the database can be queried 
D) Determine integrity constraints 
A) Create the data dictionary 
B) Determine what reports will be needed 
C) Determine how the database can be queried 
D) Determine integrity constraints

Question 7

Microsoft Access allows you to create relations among the various tables by identifying primary keys.

Accepted Answer

A) True 
 B)False

Question 8

What does the query-by-example tool in Access allow you to do?

Accepted Answer

A) Graphically design the answer to a question 
B) Quickly change data found in a table 
C) Create business reports 
D) Learn how to use the features available to you in Access 
A) Graphically design the answer to a question 
B) Quickly change data found in a table 
C) Create business reports 
D) Learn how to use the features available to you in Access

Question 9

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add,modify,or delete existing records?

Accepted Answer

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

Question 10

To save the structure,you must click on the disk icon in the upper left corner of the screen.

Accepted Answer

A) True 
 B)False

Question 11

One of the downfalls of Microsoft Access as a database management system is that it does not enable you to query information that resides in two or more tables.

Accepted Answer

A) True 
 B)False

Question 12

You need to assign a field _____ and a data _____ for each field in a given relation in Microsoft Access.

Accepted Answer

name;type
Explanation: You nee

Question 13

The default length for a text field is 225 characters.

Accepted Answer

A) True 
 B)False

Question 14

The competitive advantage for many people seeking employment is knowledge of _____ software,of which Microsoft Access is the most popular.

Accepted Answer

database management system
Exp

Question 15

Once a query has been constructed,you click on the _____ point button to run it.

Accepted Answer

exclamation
Explanation: Once

Question 16

When creating an advanced query using more than one relation,you must ensure that the tables that need to reference each other have relationships already defined.

Accepted Answer

A) True 
 B)False

Question 17

What are rules that help ensure the quality of information?

Accepted Answer

A) Information assurance 
B) Composite constraints 
C) Integrity constraints 
D) Quality control 
A) Information assurance 
B) Composite constraints 
C) Integrity constraints 
D) Quality control

Question 18

If you want to place the date at the bottom of each page (Page Footer)of a report,the command _____ is used.

Accepted Answer

"=Now("
Explanation: In the Pa

Question 19

The data dictionary contains the _____ structure for the information in a database.

Accepted Answer

A) physical 
B) logical 
C) reporting 
D) querying 
A) physical 
B) logical 
C) reporting 
D) querying

Question 20

When generating a report,Further Grouping allows you to choose the top level ordering of your information for presentation.

Accepted Answer

A) True 
 B)False

Exam 19: Implementing a Database With Microsoft Access

Once you have entered all the information into a given table and closed the tab for that table,what happens to the information?

Once a query has been constructed,you click on the lightning bolt icon in the button bar to run it.

If you needed to create a statement of accounts that would be printed at the end of each month,what Access tool would you use?

Restricting new orders to customers with an ID already in the database is an example of integrity constraints.

If you needed a title to print on the first page of a multi-page report,where would you place this title in the report design?

Once the structure of the database has been created,what is the next step?

Microsoft Access allows you to create relations among the various tables by identifying primary keys.

What does the query-by-example tool in Access allow you to do?

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add,modify,or delete existing records?

To save the structure,you must click on the disk icon in the upper left corner of the screen.

One of the downfalls of Microsoft Access as a database management system is that it does not enable you to query information that resides in two or more tables.

You need to assign a field _____ and a data _____ for each field in a given relation in Microsoft Access.

The default length for a text field is 225 characters.

The competitive advantage for many people seeking employment is knowledge of _____ software,of which Microsoft Access is the most popular.

Once a query has been constructed,you click on the _____ point button to run it.

When creating an advanced query using more than one relation,you must ensure that the tables that need to reference each other have relationships already defined.

What are rules that help ensure the quality of information?

If you want to place the date at the bottom of each page (Page Footer)of a report,the command _____ is used.

The data dictionary contains the _____ structure for the information in a database.

When generating a report,Further Grouping allows you to choose the top level ordering of your information for presentation.

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

You need to assign a field _ and a data _ for each field in a given relation in Microsoft Access.