Make your own free website on Tripod.com

True/False

Indicate whether the sentence or statement is true or false.

 

____††††††††† 1.†† Access provides query capabilities that allow you to update data in the tables in a database.

 

____††††††††† 2.†† You cannot update data while viewing a query datasheet.

 

____††††††††† 3.†† In Design view, the Select Query window contains the standard title bar, menu bar, status bar,

††††††††††††††††††††††††††††††††††† and the Query Design toolbar.

 

____††††††††† 4.†† Fields to be included in a query are selected from the design grid in query Design view.

 

____††††††††† 5.†† One way to transfer all the fields from the field list to the design grid is to double-click the

††††††††††††††††††††††††††††††††††† asterisk in the field list; the advantage of using this method is that changes to the table

††††††††††††††††††††††††††††††††††† structure are reflected automatically in the query.

 

____††††††††† 6.†† An orphaned record is a record in a primary table that does not have a corresponding entry in

††††††††††††††††††††††††††††††††††† a related table.

 

____††††††††† 7.†† Multiple fields can be used as sort keys using the Sort buttons on the toolbar no matter where

††††††††††††††††††††††††††††††††††† they are in relation to each other in the query datasheet.

 

____††††††††† 8.†† A table has at most three primary keys, which must be unique, whereas any field in a table

††††††††††††††††††††††††††††††††††† can serve as a primary sort field.

 

____††††††††† 9.†† If more than one sort field has been selected, the first one is called the primary sort key and

††††††††††††††††††††††††††††††††††† the others are called related sort fields.

 

____††††††††† 10.Multiple selection conditions can be specified in a query by using relational operators.

 

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

 

____††††††††† 11.A query can be run at any time during the creation of the query by clicking the ____ button on the Query Design toolbar.

a.

Display

b.

Show

c.

View

d.

Query

 

 

____††††††††† 12.You can avoid problems with inconsistent data in related tables by using ____.

a.

the Query Wizard

b.

referential integrity

c.

common fields

d.

joins

 

 

____††††††††† 13.The Edit Relationships dialog box shows the type of current relationship ____.

a.

in the design grid

b.

at the bottom of the dialog box

c.

in a drop-down list

d.

if you click the Help button

 

 

____††††††††† 14.When you save a query with sort fields defined in it, the sort fields ____.

a.

must be redefined the next time the query is run

b.

are discarded

c.

are saved with the query

d.

are saved as a separate object

 

 

 

Figure 3-27

 

____††††††††† 15.The query shown in Figure 3-27 will select a record if ____.

a.

EndDate is blank

b.

StartDate is 7/1/2006 and State/Prov is PE

c.

StartDate is 7/1/2006 or State/Prov is PE

d.

Any of the above

 

 

____††††††††† 16.Calculations can be performed in a query by defining a(n) ____.

a.

logical operator

b.

comparison operator

c.

expression

d.

condition

 

 

____††††††††† 17.A calculation can be defined in a query by typing it directly into a Field text box in the ____.

a.

design grid

b.

field list

c.

Relationship window

d.

criteria box

 

 

 

Figure 3-2

 

____††††††††† 18.The item shown in Figure 3-2 is the ____.

a.

navigation pane

b.

editing pane

c.

design grid

d.

criteria matrix

 

 

 

Figure 3-2b

 

____††††††††† 19.Item ____ in Figure 3-2 is the Query Type button, which changes according to the type of query you are creating.

a.

1

b.

2

c.

3

d.

4

 

 

____††††††††† 20.The join line for a one-to-many relationship will show the ____ symbol on the "many" end of the line.

a.

number

b.

asterisk

c.

infinity

d.

anchor

____††††††††† 21.Some of the Action Languages of Userís Requests includes the following EXCEPT:

 

a.

Menu Interaction & Command Language

b.

Questions and Answers

c.

Frequently Asked Questions

d.

Form interaction and Natural language

____††††††††† 22.The following is/are reason(s) for the need for input control for any information system.

a.

The need to have correct data into systems

b.

Causes of Incorrect data may bring about more errors within the systems

c.

Unforeseeable problems with incorrect data

d.

All the above are reasons

____††††††††† 23.Events related to the distribution of goods and services to other entities and the collection of

††††††††††††††††††††††† related payment is known as ___________________.

a.

Expenditure cycle

b.

Production cycle

c.

Revenue cycle

d.

Finance cycle

____††††††††† 24.A system that is tailored to the strategic information needs of top-level management is known

††††††††††††††††††††††† as __________________.

a.

Executive Information System

b.

Decision Support System

c.

Expert System

d.

Accounting Information System

____††††††††† 25.There are 7 phases in a Systems Planning and Feasibility Analysis.Identifying the

††††††††††††††††††††††† companyís key success factors is which of the 7 phases?

a.

Establishing systems planning steering committee

b.

Establishing overall objectives and constraints

c.

Developing a strategic information systems plan

d.

Identifying and prioritize specific areas within the company