Question

Typing criteria on the same row for several fields perform an ___________ query

between the fields.​

Answer 1

Answer:

basic query

Explanation:

basic query is correct ans.follow me for more ans

Answer 2

Answer:

hope this will help u

plz follow me yar

plz mark my ans as brainlist

Explanation:

FMS Home

Home MS Access Queries Tips and Techniques

Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and 97Microsoft Access Query Tips and Techniques (SQL and VBA)

Provided by Luke Chung, President of FMS, Inc.

This paper is featured on:

This paper is featured on MSDN

Microsoft Access is the most popular Windows database program. A primary reason for its success is its interactive query interface. Once data is collected in a database, analysis and updates need to be performed. Queries offer the ability to retrieve and filter data, calculate summaries (totals), and update, move and delete records in bulk. Mastering Microsoft Access queries will improve your ability to manage and understand your data and simplify application development.

Examples are for Microsoft Access 2016, 2013, 2010 and 2007. Also applies to Microsoft Access 2003 and earlier.

Queries Hide the Complexity of Microsoft Access SQL Syntax

The visual representation of tables and the graphical links between them makes Microsoft Access queries extremely easy to use and hides the complexity of writing the raw Microsoft Access SQL. Fortunately, the nice user interface still allows very powerful and advanced analysis. The entire query engine is modeled on SQL systems and can switch between the graphical query design and SQL syntax. Many Microsoft Access users and developers learned SQL from this feature.

Knowing the many features of Microsoft Access queries allows you to perform advanced analysis quickly without programming. This presentation covers the basics of queries revealing a variety of subtleties. It quickly moves to more advanced topics with hints and techniques for creating sophisticated queries. Finally, programmatic use of queries is presented:

Query Types

Basic Select Queries

Setting Criteria

Advanced Select Queries

Using Parameters

Using Access Functions

Using Custom Functions

Other Advanced Queries

Percent of Total

Frequency Distribution

Union Queries to Combine Queries

Action Queries

Using Queries in Forms, Reports, and Macros

Using and Running Queries with VBA Code