2_Queries_presentation_l1_v1
Оценка 4.9

2_Queries_presentation_l1_v1

Оценка 4.9
ppt
09.05.2020
2_Queries_presentation_l1_v1
2_Queries_presentation_l1_v1.ppt

Queries

Queries

Queries

What is a query? A query is actually the name for any database manipulation operation

What is a query? A query is actually the name for any database manipulation operation

What is a query?

A query is actually the name for any database manipulation operation.
The most commonly used type is a select query, which is a way of selecting what fields in what records are to be displayed.

Types of queries you can create in

Types of queries you can create in

Types of queries you can create in Microsoft Access

Select queries
Crosstab queries (actually a special kind of select query)
Action queries
Make-table queries
Delete queries
Update queries
Append queries)

In addition, any of these types can be designed to prompt the user for information, in which case it is called a parameter query

In addition, any of these types can be designed to prompt the user for information, in which case it is called a parameter query

In addition, any of these types can be designed to prompt the user for information, in which case it is called a parameter query.

2_Queries_presentation_l1_v1

2_Queries_presentation_l1_v1

2_Queries_presentation_l1_v1

2_Queries_presentation_l1_v1

2_Queries_presentation_l1_v1

2_Queries_presentation_l1_v1

Creating a query You can create only very simple queries by using the

Creating a query You can create only very simple queries by using the

Creating a query

You can create only very simple queries by using the Query Wizard.
We’ll create all our queries using the Design View for queries.
Once designed, the results of a query can be displayed in Datasheet View.

Скачать файл