Final answer:
In a Microsoft Access query, criteria on different lines are connected by the OR logical operator, which broadens the search to include records that match any of the separate criteria.
Step-by-step explanation:
The criteria on different lines in a Microsoft Access query are connected with the OR logical operator. When you place criteria on separate lines in a query design grid, Access retrieves records that match any of the individual criteria, rather than all of them. This broadens your search results, allowing any of the terms to appear in the records that Access finds. For example, if you were looking for records of sales in either 2020 or 2021, placing these two years on separate lines with the OR operator would give you results for sales from both years.
The criteria on different lines in a Microsoft Access query are connected with the AND logical operator.
The AND operator is used to narrow down search results and tells the database to include all search terms in finding sources.
For example, if you have a query with criteria like Age > 18 AND Gender = 'Female', the results will only include records that meet both criteria, meaning the age is greater than 18 and the gender is female.