Question

1. how do you create queries in base?

2.What is a group- field ?

3.What are different types of queries ?​

Answer 1

Answer:

good morning

Explanation:

1.Select Create > Query Wizard . Select Simple Query, and then OK.

2.

Group field is a way to group together one or more fields on a page for visual and practical purposes. Visually, a group helps to tie similar fields together into a common category. Grouped fields also provide organization and structure to the form. ... Group fields also have several practical purposes.

3

They are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries. Select Queries Select query is the simplest and the most common type of query.

Answer 2

1)the steps to create query in the database are

1) open the database on whose table you want to create a quary

2) in the database window,select queries from the left pane and click use wizard to create query

3) query wizard will start. and click on next

4) in the next , you can specify the sort order by selecting the sort field

5) select field and condition and specify value for the condition under value

6) simply click next

7) click finish here

2) a non-primary key field which has same value for multiple records can act as group field