Chapter#4: Querying a Database

Question 1

What is a Select Query?

Answer 1

allows you to select records based upon certain criteria that you set.

Question 2

What are two ways to create a query?

Answer 2

Query Wizard and

Query Design

Question 3

What does Query Design View allow you to do?

Answer 3

Select fields from multiple tables.

Set criteria to locate records based on data contained in one or more fields.

Calculate totals.

Show or hide fields containing criteria that are in the query results datasheet.

Question 4

What are some ways of adding fields to the query grid?

Answer 4

1. Double-click a field name to add the field to the next available column of the query design grid.
2. Drag a field to the next column in the grid.
3. Click the Field row of a column in the query grid and select the field from the drop-down list.
4. Double-click the asterisk (*) that appears at the top of the field list to add all fields to the grid.

Question 5

How can you rearrange query columns?

Answer 5

in Design View or Datasheet View by dragging and dropping them into position

Question 6

What are the two most frequent wildcards?

Answer 6

asterisk and question mark

Question 7

What do you select when you build a query?

Answer 7

you select only those tables and fields that you want to display in the query

Question 8

What happens when you run a query?

Answer 8

Access lists only those records containing data that meet the criteria

Question 9

in what views can you filter and sort records?

Answer 9

Table Design, Form Design and to a limit Report Design View

Question 10

whats the best way to sort and filter data?

Answer 10

Through a query

Question 11

When it comes to Wildcard Symbols, What is an Asterisk?

Answer 11

Substitutes for a group of characters that appear at the position of the asterisk

Question 12

When it comes to Wildcard Symbols, What is a Question Mark?

Answer 12

Substitutes for a single character that might appear at the position of the question mark

Question 13

When it comes to Wildcard Symbols, What is a Open/Close Bracket?

Answer 13

Matches text or individual characters placed within the brackets individually

Question 14

When it comes to Wildcard Symbols, What is a Exclamation Point?

Answer 14

Matches any character within the brackets except those characters that follow the !

Question 15

When it comes to Wildcard Symbols, What is a Hypen?

Answer 15

Matches characters at the wildcard position that fall within a range of ascending values

Question 16

When it comes to Wildcard Symbols, What is a number sign?

Answer 16

Locates any numeric digit at the position of the #

Question 17

What are the two basic criteria conditions that can be applied?

Answer 17

AND/OR

Question 18

Define the “And” Operator

Answer 18

Use to select records that meet all criteria set in all query grid fields

Question 19

Define the “Or” Operator

Answer 19

Use to select records meeting one condition or another condition whether the criteria are set for the same field or different fields

Question 20

Whats the first Sort Field identified as?

Answer 20

The primary sort field

Question 21

Whats the next sort field after the first sort field?

Answer 21

The Secondary Sort field

Question 22

What is a calculated field?

Answer 22

includes a field and expression elements.

Question 23

What is calculated field name?

Answer 23

The unique name you assign to the field, followed by a colon (:) to separate the field name from the expression

Question 24

What is field names for existing tables?

Answer 24

The field containing the data used in the calculation. Access will add brackets [ ] around field names

Question 25

What is Arithmetic or comparison operators

Answer 25

+, -, *, /, ( ), ^, to perform mathematical operations or compare values

Question 26

What is Concatenation?

Answer 26

Combining fields and expressions by using the ampersand (&) to join text values from multiple fields

Question 27

What is the Return Feature?

Answer 27

Enables you to set the number of records to be displayed or returned

Question 28

in which way does Access do mathematical operations?

Answer 28

from Left to Right

Question 29

What does PEMDAS mean?

Answer 29

Please Excuse My Dear Aunt Sally

Question 30

What does Aggregate Functions do?

Answer 30

They are designed to summarize Data

Question 31

What can Crosstab Queries use?

Answer 31

use both tables and queries as the basis of the query.

Question 32

What is Find Unmatched Query?

Answer 32

Locates records in one table that have no related records in another table

Question 33

What is Duplicates Query?

Answer 33

Locates records containing duplicate field values in a single table or query