Deck 4: Maintaining and Querying a Database

Question 1

Access database objects are divided into categories on the Navigation Pane. ____________________

Answer 1

True

Question 2

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

Answer 2

True

Question 3

Access may base queries on one or more tables or queries . ____________________

Answer 3

True

Question 4

Hiding a field in Datasheet view removes the field from the current table.

Question 5

The most simple technique to use for filtering records is Filter By Form . ____________________

Question 6

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

Question 7

In the accompanying figure, the sort order for the VisitDate field is descending . ____________________

Question 8

In the accompanying figure, a criterion is set for a field in the Visit table. ____________________

Question 9

It is not possible to create a query from more than one table.

Question 10

The process of rearranging records in a specified order or sequence is referred to as sorting . ____________________

Question 11

The contents of query datasheet are permanent . ____________________

Question 12

Expression Builder is found in the Query Setup group on the DESIGN tab. ____________________

Question 13

When a question is asked of a database using a select query, the answer is returned as a datasheet.

Question 14

Logical operators must be used in order to combine two or more conditions in a query.

Question 15

A sort field is unique if more than one record can have the same value for the sort field. __________________

Question 16

Results of a query are narrowed by using the Or logical operator.

Question 17

Fields included in a query may be modified after the query is saved.

Question 18

The default query type for Access is the Crosstab query.

Question 19

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

Question 20

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

Question 21

Queries based on more than one table, must have a ____ field.

A) common
B) similar
C) text
D) calculated

Question 22

In the accompanying figure, how is the Match type specified to find the characters "1638"?

A) current field value
B) any part of the field
C) entire field value
D) unformatted field value

Question 23

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

A) navigation mode
B) design mode
C) editing mode
D) selection mode

Question 24

Which view must be used to delete an entire record?

A) Design
B) Query
C) Navigation
D) Datasheet

Question 25

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

A) table
B) chronological
C) primary
D) adjacent

Question 26

In the accompanying figure, the arrow outlined to the right of the field name "First Name"  gives the user access to the ____ feature when clicked.

A) AutoFilter
B) Sort
C) Selection
D) Replace

Question 27

A field with the Short Text data type sorted in descending order will display the data in which order?

A) A to Z
B) lowest to highest
C) Z to A
D) highest to lowest

Question 28

A query based on more than one table is a(n) ____query.

A) multiple
B) advanced
C) relationship
D) multitable

Question 29

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

A) crosstab
B) append
C) query by example (QBE)
D) update

Question 30

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

A) Tab
B) Home + Up Arrow
C) Up Arrow
D) Ctrl+Home

Question 31

The AutoFilter sort method works on a(n)____ field(s).

A) multiple
B) 10 fields
C) adjacent
D) single

Question 32

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

A) Run
B) Append
C) Show
D) Design

Question 33

In the accompanying figure, which field is the primary sort field?

A) City
B) Patient
C) VisitDate
D) Visit

Question 34

Data may be sorted in a table datasheet, a form, and a ____.

A) report
B) query datasheet
C) record
D) related table

Question 35

In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

A) leftmost
B) rightmost
C) adjacent to the leftmost field
D) adjacent to the rightmost field

Question 36

In the accompanying figure, which field is the secondary sort field?

A) City
B) FirstName
C) VisitDate
D) LastName

Question 37

When the sort field data for each record in a database is different, the sort field is ____.

A) ascending
B) unique
C) nonunique
D) descending

Question 38

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A) reconstructing
B) maintaining
C) developing
D) editing

Question 39

The ____ command removes the display of one or more fields in Datasheet view.

A) Hide Fields
B) Unhide Fields
C) Remove Fields
D) Display Fields

Question 40

In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

A) does not have a related record in another table
B) does have a related record in another table
C) has been selected to be deleted
D) has been selected to unhide

Question 41

In the criterion,

A) less than 250
B) equal to 250
C) less than or equal to 250
D) greater than or equal to 250

Question 42

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

A) modify
B) rename
C) delete the existing query
D) include comparison operators

Question 43

Which comparison operator matches a pattern that includes wildcards?

A) Between...And...
B) Or
C) Not
D) Like

Question 44

A calculated field created in a query generates results when ____.

A) the database is opened
B) the query's underlying table is opened
C) when a report is created
D) when the query is run

Question 45

The default group in the Navigation Pane is ____.

A) Object Type
B) All Access Objects
C) Table
D) Design Grids

Question 46

In the accompanying figure, which field represents a calculated field?

A) Visit ID
B) Invoice Amt
C) Late Fee
D) Date of Visit

Question 47

The criteria entered in the figure above are an example of which logical operator?

A) Or
B) Not
C) And
D) Between

Question 48

The + symbol is an example of a(n) ____ operator.

A) arithmetic
B) logical
C) comparison
D) calculation

Question 49

Which aggregate function would be used to calculate the lowest field value for the selected records?

A) Average
B) Minimum
C) Maximum
D) Count

Question 50

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

A) Query Type
B) Show/Hide
C) Query Setup
D) Results

Question 51

A calculated field is formatted using the ____ for the field.

A) Property Sheet
B) Criteria
C) Expression Builder
D) Operator

Question 52

Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

A) on or after 12/31/1956
B) after 12/31/1956
C) before 12/31/1956
D) on or before 12/31/1956

Question 53

Date criteria are automatically enclosed in ____ when entered in a query design.

A) quotes
B) parenthesis
C) brackets
D) number signs

Question 54

A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.

A) sort order
B) condition
C) operator
D) match

Question 55

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.

A) builder
B) expression
C) operator
D) query

Question 56

____ is the default entry for each field in the Total row of the query design grid.

A) Group By
B) SUM
C) Totals
D) Maximum

Question 57

The condition "Seattle" for the field City in a student database is an example of what type of value?

A) text value
B) field value
C) comparison value
D) criteria value

Question 58

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

A) SUM
B) New Row
C) Totals
D) Add All

Question 59

Which aggregate function supports the Yes/No field data type?

A) Count
B) Average
C) Minimum
D) Sum

Question 60

The comparison operator, , is used to insert a condition that means ____.

A) greater than
B) And
C) less than
D) not equal to

Question 61

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Question 62

The ___________________ command allows hidden fields to be redisplayed.

Question 63

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Question 64

Case-Based Critical Thinking Questions Case 3-2 Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query.  The Perennial field has a data type of Yes/No.  Which criterion should Jorge use in the query for the Perennial field?

A) Yes
B) >No
C) check=yes
D) 'yes'

Question 65

Case-Based Critical Thinking Questions Case 3-2 Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
When creating a query to determine which plants need full sun, which fields must be included in the query?

A) Plant Name and When to Plant
B) Amount of Sun and Annual
C) Plant Name and Amount of Sun
D) Amount of Sun and When to Plant

Question 66

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

A) Table Name
B) Custom
C) Query Name
D) Relationship

Question 67

To locate a specific field value or part of a field value, a user may search a table datasheet, a query datasheet, or a form using the ____________________.

Question 68

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field.  What is the common field between the two tables?

A) Product ID
B) Customer ID
C) Date
D) Product

Question 69

Case-Based Critical Thinking Questions Case 3-1 Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities.  The data has been entered into a database.  Mrs. Godwin has asked the students to answer the following questions using the Access database.
What was the highest recorded wind speed?
Which city had the highest temperature and what was the highest temperature?

Figure Case 3-1-1

Figure Case 3-1-2
To save the HighestTemp query, Mrs. Godwin's students had to perform which of the following tasks?

A) run the query
B) type the query name in the query design window as a new field
C) save the database
D) save the query object with a new name

Question 70

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

Now that Ja'nice has chosen the table to use for the query, for which field will she create criteria?

A) Account Start Date
B) Date
C) Cost
D) Product ID

Question 71

In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

Question 72

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.
Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015.  Which table does Ja'nice need to use for this query?

A) Customer Info
B) Product Info
C) Vendors
D) Order Info

Question 73

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers.  To do this, she must use at last two tables to create the query.  Which two tables would be best to use for this query?

A) Customer Info and Product Info
B) Order Info and Product Info
C) Customer Info and Order Info
D) Order Info and Vendors

Question 74

The default name for a new Access query is ____________________.

Question 75

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Question 76

Case-Based Critical Thinking Questions Case 3-1 Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities.  The data has been entered into a database.  Mrs. Godwin has asked the students to answer the following questions using the Access database.
What was the highest recorded wind speed?
Which city had the highest temperature and what was the highest temperature?

Figure Case 3-1-1

Figure Case 3-1-2
Using the datasheet in Figure 3-1-1, which is the quickest method to help students determine the highest wind speed from the recorded data?

A) create a query that includes the fields: City and Wind mph
B) sort the Wind mph field in Datasheet view using the largest to smallest AutoFilter option
C) use the Ascending sort option from the Sort & Filter group on the Ribbon to sort the City field
D) create a query that includes all fields in the table and sort the Wind mph field

Question 77

Statistical information such as totals and averages is calculated using ____.

A) comparison operators
B) mathematical operators
C) aggregate functions
D) logical functions

Question 78

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Question 79

A ____________________ is a set of records that answers the question resulting from a query.

Question 80

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.