2_Queries_presentation_l1_v1

  • ppt
  • 09.05.2020
Публикация в СМИ для учителей

Публикация в СМИ для учителей

Бесплатное участие. Свидетельство СМИ сразу.
Мгновенные 10 документов в портфолио.

Иконка файла материала 2_Queries_presentation_l1_v1.ppt

Queries

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 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.

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.