Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

ECDL Exam ECDL-ADVANCED Topic 2 Question 103 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 103
Topic #: 2

[All ECDL-ADVANCED Questions]

Which of the following are the types of action queries?

Each correct answer represents a complete solution. Choose all that apply.

AUpdate

BDelete

CInsert

DAppend
Explanation:
An action query is used to update multiple records in one operation.
Following are the four types of action queries:
Delete queries: A delete query is used to delete records from one or more tables.
Update queries: An update query is used to modify fields. It is used to update a field with an expression or data from another table.
Append queries: An append query is used to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query is used to create a new table from all or part of the data in one or more tables.
Answer option C is incorrect. It is not a valid type of action query.

Show Suggested Answer

Suggested Answer: B

by Mike at Nov 14, 2024, 02:05 AM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Roosevelt

10 months ago

I'm not sure about Split Form. Can you explain why it's the right choice?

upvoted 0 times

...

Raylene

10 months ago

I wish I had a split personality to complete this form. Oh wait, that's not what they're asking for. B is the correct answer!

upvoted 0 times

Marguerita

9 months ago

B is the correct answer!

upvoted 0 times

...

Darci

10 months ago

Oh wait, that's not what they're asking for.

upvoted 0 times

...

Gaynell

10 months ago

I wish I had a split personality to complete this form.

upvoted 0 times

...

...

Leota

10 months ago

I agree with you, Fanny. Split Form is the correct tool to use for this task.

upvoted 0 times

...

Fanny

10 months ago

I think the answer is B) Split Form because it displays both Form view and Datasheet view at the same time.

upvoted 0 times

...

Darrin

10 months ago

B is the answer for sure. I've used split forms before and they're super handy when you need to see the data in multiple formats at the same time.

upvoted 0 times

Shenika

10 months ago

Yes, B is the correct answer. Split forms make it easier to work with data in Access.

upvoted 0 times

...

Lashaunda

10 months ago

I've never used split forms before, but it sounds like a great feature to have in Access.

upvoted 0 times

...

Garry

10 months ago

I agree, split forms are really useful for displaying data in different views simultaneously.

upvoted 0 times

...

...

Emilio

11 months ago

The split form definitely looks like the way to go here. I like how it gives you both the form view and the datasheet view in one place.

upvoted 0 times

Christiane

10 months ago

Split form definitely makes it easier to work with the data.

upvoted 0 times

...

Marjory

10 months ago

I agree, it's convenient to have both views in one place.

upvoted 0 times

...

Wei

10 months ago

It's a great tool for displaying form view and datasheet view together.

upvoted 0 times

...

Marshall

11 months ago

Split form provides two views of the same data at the same time.

upvoted 0 times

...

...