Deck 3: Maintaining and Querying a Database

Question 1

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

Answer 1

  True

Question 2

 The default query type for Access is the Crosstab query. ____________________ 

Answer 2

  False

Question 3

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

Answer 3

  False

Question 4

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

Question 5

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

Question 6

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

Question 7

 The contents of query datasheet are permanent.____________________

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

 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 16

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

Question 17

 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 18

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

Question 19

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

Question 20

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

Question 21

 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 22

 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 23

 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 24

 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 25

 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 26

 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 27

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

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

Question 28

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

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

Question 29

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

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

Question 30

 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 31

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

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

Question 32

 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 33

 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 34

 Which view must be used to delete an entire record? 

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

Question 35

 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 36

 In the criterion,<=250,the operator will return values for the specified field that are ____. 

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

Question 37

 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 38

 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 39

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

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

Question 40

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

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

Question 41

 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 42

 The default group in the Navigation Pane is ____. 

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

Question 43

 ____ 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 44

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

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

Question 45

 The default name for a new Access query is ____________________.

Question 46

 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 47

 Which comparison operator matches a pattern that includes wildcards? 

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

Question 48

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

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

Question 49

Working with the Navigation Pane
Case-Based Critical Thinking Questions
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 50

 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 51

 ____ 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 52

Working with the Navigation Pane
Case-Based Critical Thinking Questions
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 53

 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 54

 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 55

Working with the Navigation Pane
Case-Based Critical Thinking Questions
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?
 After creating the query,Jorge must set criteria to have the query return only those plants that need full sun.  Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun? 

A) =>full sun
B) <=fullsun 
C) <> full sun
D) "full sun"

Question 56

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

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

Question 57

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

Question 58

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

Question 59

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

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

Question 60

 The ___________________ command allows hidden fields to be redisplayed.

Question 61

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

Question 62

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

Question 63

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 Functions that perform arithmetic operations on selected records in a database.

Question 64

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 Operators that allow two or more conditions to be combined such as And.

Question 65

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 A dialog box used to enter text,expressions,or other values.

Question 66

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Question 67

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Question 68

 A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Question 69

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Question 70

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

Question 71

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 A type of query in which you specify the fields and records you want Access to select.

Question 72

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Question 73

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 The field used to determine the order of records in a datasheet.

Question 74

Identify the letter of the choice that best matches the phrase or definition.
a.aggregate functions
b.Zoom box
c.theme
d.logical operators
e.comparison operator
f.condition
g.Ctrl + End
h.Home
i.sort field
j.select query
 A criterion or rule that determines which records are selected when a query is run.

Question 75

 The first field specified in the sorting process is called the ____________________ field.