homeworkstudyhelp

Our Services

Get 15% Discount on your First Order

QUESTION 3   An action query adds, changes, or deletes multiple…

QUESTION 3

 

An action query adds, changes, or deletes multiple table records at one time.

 

 True

 False

 

 

1 points   

QUESTION 4

 

If you want to add records from one table to a backup table, create a(n) Append query.

 

 True

 False

 

 

1 points   

QUESTION 5

 

The outer join is the default join operation in Access.

 

 True

 False

 

 

1 points   

QUESTION 6

 

How can you display the indexes for a table?

 

  a.

In Table Design view, click the Properties button.

 

  b.

In Table Datasheet view, click the Show Hidden Properties button.

 

  c.

In Table Datasheet view, click the Object Dependencies button.

 

  d.

In Table Design view, click the Indexes button.

 

 

 

2 points   

QUESTION 7

 

Create a(n) _____ query to change the name of a supervisor in an Employee table.

 

  a.

Update

 

  b.

Target

 

  c.

Make-Table

 

  d.

Self-Join

 

 

 

2 points   

QUESTION 8

 

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

 

  a.

red asterisk

 

  b.

red X

 

  c.

exclamation point

 

  d.

question mark

 

 

 

2 points   

QUESTION 9

 

A(n) _____ query changes the values in a field.

 

  a.

Make-Table

 

  b.

Update

 

  c.

Append

 

  d.

Change Value

 

 

 

2 points   

QUESTION 10

 

A(n) _____ query adds records from an existing table to the end of another table.

 

  a.

Crosstab

 

  b.

Append

 

  c.

Apply

 

  d.

Make-Table

 

 

 

2 points   

QUESTION 11

 

If you often sort on a field, you should set its_____ property to Yes.

 

  a.

Required

 

  b.

Bound Column

 

  c.

Caption

 

  d.

Indexed

 

 

 

2 points   

QUESTION 12

 

If you want to find records in the table on the “one” side of a one-to-many relationship that do not have related records in the “many” side, which join do you use?

 

  a.

self

 

  b.

outer

 

  c.

cascading

 

  d.

inner

 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions