ACCESS DATABASE - 6

It is a database object that allows you to retrieve data from a table, modify it and even store the result in another table.

• Entity

• Reports

• Forms

• Queries

Types of queries with which we can extract and display data when certain criteria are met.

• Action

• Selection

• Upgrade

• Elimination

What are the two ways Access provides for me to design a query?

• Query Layout and Datasheet View

• Query wizard and query design

• Datasheet Design and Query Wizard

• Data Design and Design Wizard

In the following image, how this window is called in which we can design the queries.

• Grid grid

• Query design

• Datasheet Grid

• None of the above

It is an element within the grid grid as it will be useful for defining queries based on multiple tables.

• Order

• Show

• Criteria

• Tables

Inside the grid, it is used to specify a search, it is a condition that the records that will appear in the result must meet.

• Criteria

• Order

• Show

• Field

Element that works similar to a table field, but the value it stores is entered by the user when the query is run.

• Criteria

• Parameters

• Totaled

• Search

When creating a query with parameters, when placing the name of the parameter it is important to place it in:

• Parenthesis

• Quotation marks

• Brackets

• Apostrophes

What are the orders that we can use within the queries?

• Upward

• Texto

• Falling

• Form

When we want to classify a query it is necessary that more than one of the fields is organized. this type of classification is called:

• Criterion

• Aggregation

• Multilevel

• Selection