Deck 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Question 1

To switch between a filtered table and a whole table,use the ________ or the Filtered indicator.

A) Change Filter button
B) switch button
C) Toggle Filter
D) change view button

Answer 1

C

Question 2

If you have a table that has records that have no matching records in a second table or query,you can find the request using the ________ query.

A) Find Duplicates
B) Find Unmatched
C) Orphan
D) Cross-Tab

Answer 2

B

Question 3

A condition applied temporarily to a table or query is called a(n)________

A) input mask
B) calculation
C) format
D) filter

Answer 3

D

Question 4

In the ________ window,relationships between tables are represented by lines that connect the tables.

A) Datasheet
B) Design
C) Relationships
D) Format

Question 5

To retrieve information from more than one table or query,you would use a ________ query.

A) single-table
B) cross-tab
C) multiple-table
D) normal

Question 6

When you want to describe one field in terms of two or more other fields in a table you use a(n)________.

A) find duplicates query
B) cross-tab query
C) matched query
D) find unmatched query

Question 7

A query based on ONLY one table in your database is called a(n)________ query.

A) single-table
B) Cross-Tab
C) Find
D) Research

Question 8

When looking for specific values in a record,you should use the ________ command to keep from scrolling.

A) Update
B) Replace
C) Find
D) Cascade

Question 9

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A) duplicate
B) stray
C) orphan
D) widow

Question 10

A(n)________ operator allows you to combine two or more criteria.

A) criteria
B) logical
C) example
D) comparison

Question 11

When you suspect that you have multiple instances of a record in a table,you should use the ________ query wizard.

A) Cross-Tab
B) Orphan
C) Find Unmatched
D) Find Duplicates

Question 12

To view all the table records at one time,use the ________ view.

A) spreadsheet
B) datasheet
C) design
D) worksheet

Question 13

When developing a query,you should only add ________ that have fields you are going to use in the query to prevent incorrect or inconsistent results.

A) forms
B) records
C) tables
D) reports

Question 14

To compare the values in a table or query to a specific criteria value you set up in the query,you use ________ operators.

A) logical
B) query
C) comparison
D) example

Question 15

The ________ occurs when Access joins two tables that do not have a common field.

A) exponential effect
B) cross-tab effect
C) lost data effect
D) multiplier effect

Question 16

The ________ work by asking a series of questions about the tables and fields,then creating a query based upon your responses.

A) form wizards
B) Access wizards
C) report wizards
D) query wizards

Question 17

A ________ gives you less control and fewer options to manage the details of a query design than the query window.

A) Simple Query Wizard
B) Find Unmatched Query wizard
C) Find Duplicates Query wizard
D) Combination Query wizard

Question 18

When a data entry clerk types the name "Smith" as "Smyth" the table will have ________ data.

A) Lazy
B) Careless
C) Inconsistent
D) Incorrect

Question 19

When you are creating a query,all the tables added to the query should be connected by relationships and have a ________.

A) common field
B) filter defined
C) form design
D) common row

Question 20

AND and OR are examples of ________ operators.

A) logical
B) comparison
C) criteria
D) example

Question 21

When you sort text in A to Z order,you are using a(n)________ sorting option.

A) normal
B) forward
C) descending
D) ascending

Question 22

A complex query designed by combining search criteria and aggregate functions in a single query can make it more difficult to ________ the query if it does not work.

A) redesign
B) format
C) rebuild
D) trouble-shoot

Question 23

LIKE,IN,and BETWEEN are called ________.

A) comparison operators
B) different operators
C) special operators
D) logical operators

Question 24

To calculate multiple functions on the same field,you must add the field to the ________ multiple times.

A) form
B) query
C) grid
D) total row

Question 25

In Query Design view,you can select up to ________ fields to sort by.

A) 50
B) 10
C) 25
D) 5

Question 26

One method to increase the width of columns in a query result to best fit the data is to double-click the ________.

A) row header
B) cell
C) column selector bar
D) column header

Question 27

An Access tool that helps you format your calculated fields correctly is called ________.

A) Formula Builder
B) Expression Builder
C) Expression Designer
D) Calculation Designer

Question 28

If you forget to put ________ around a date,Access will add them for you.

A) brackets
B) pound signs
C) quotation marks
D) exclamation marks

Question 29

Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.

A) form design wizard
B) total row grid
C) query design wizard
D) query design grid

Question 30

In the expression Total Tax:[Invoice!QtySold]*[Tax!Rate] the exclamation mark is used to indicate that the columns are located on different ________.

A) queries
B) forms
C) tables
D) reports

Question 31

Rearranging records in a specific order is called ________.

A) sorting
B) categorizing
C) classifying
D) moving

Question 32

When you sort numbers in highest to lowest order,you are using a(n)________ sorting option.

A) ascending
B) sloping
C) descending
D) reverse

Question 33

The ________ operator will return results that include and fall within the criteria you enter.

A) LIKE
B) IN
C) BETWEEN
D) AND

Question 34

Before opening the Expression Builder to create a(n)________ field,you should save your query first.

A) calculated
B) totals
C) new
D) aggregate

Question 35

When you sort by multiple fields,the first field you select to sort on is called the ________ sort field.

A) secondary
B) primary
C) principle
D) beginning

Question 36

A field may be sorted in either ascending order or ________ order.

A) reverse
B) descending
C) inclining
D) sloping

Question 37

To format query fields in the query grid,you use the ________ properties sheet.

A) Database
B) Field
C) Query
D) Form

Question 38

The view that allows you to view all records in a table at one time is the design view.

Question 39

When you add a total row to a table or a query in datasheet view,you are using a(n)________.

A) calculation function
B) computation function
C) aggregate function
D) complex function

Question 40

To show aggregate functions for one or more fields at the end of a datasheet,you would use the ________.

A) aggregate row
B) sum row
C) total column
D) total row

Question 41

To create a query that will return all invoices that include and fall within January 1,2012 and January 1,2014,you would use the BETWEEN special operator.

Question 42

When using multiple criteria in a query,you MUST also use logical operators.

Question 43

A single table query pulls data from two or more tables.

Question 44

If columns are not wide enough to display all the contents,you can double-click on the right border of the column selector bar to increase the column width.

Question 45

Since everyone in the United States has a unique Social Security number,it is the best choice for primary key in a database table.

Question 46

If you were trying to find all customers who lived in California,the best way to do this would be to type "<>CA" in the State field criteria box.

Question 47

In a datasheet,a special row that uses the aggregate function for one or more fields is called the total row.

Question 48

Access ignores unnecessary tables selected as part of a query,so it is ok to have unused tables in the query.

Question 49

When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.

Question 50

Query by example allows you to specify the data you want see by entering sample data.

Question 51

The Simple Query Wizard allows you to chose the tables and fields to include in the query,as well as select the criteria for the field values,create calculated fields,and select sorting options.

Question 52

The Find command quickly locates specific records using all or part of a field value in the Datasheet view.

Question 53

To perform calculations on selected fields and records in a query,use an aggregate function.

Question 54

A condition that is temporarily applied to a table or query to hide all unmatching records is called a filter.

Question 55

After you locate records with the Find command,you can replace them with the Change command.

Question 56

When inconsistent data,such as multiple spellings for the same name,are entered into a database,query results are not valid.

Question 57

The view that allows you to enter,edit,and delete records directly is the Datasheet view.

Question 58

To calculate an average or total on records displayed in a table or query,you would use a calculation function.

Question 59

The Find Duplicates Query Wizard finds duplicate records in related tables.

Question 60

In Design view,tables can be added to a query by dragging them from the Navigation Pane.

Question 61

If you think you may have duplicate records in a table,you should run the ________ query.

Question 62

You can add tables to the query by dragging them from the ________.

Question 63

A condition you apply temporarily to a table to display a subset of records is called a(n)________.

Question 64

Sorting is the process of pulling matching records from several different tables.

Question 65

In the Relationship window,the field the line is pointing to in each table is the ________ field between the tables.

Question 66

Changing the font type,font size,column width and background colors can make your datasheet appear more ________.

Question 67

Using the ________ command,you can easily trade one value to another.

Question 68

The ________ query wizard helps you identify orphan records.

Question 69

To view all the records in a table at one time,open the ________ view.

Question 70

The ________ effect occurs when you query two or more tables that do not have common fields.

Question 71

The ________ gives you more control and options to manage the details of a query design than does the Simple Query Wizard.

Question 72

Combining search criteria and aggregate functions in a single query can make troubleshooting more difficult due to the complexity of the query.

Question 73

A(n)________ works by prompting you to answer a series of questions about the tables and fields to display,then creating the query based on your response.

Question 74

When changing the field name assigned in an aggregate query,the field name in the query design grid must also be changed.

Question 75

Databases have a robust set of selection ________ that can be used to make queries well focused.

Question 76

For a field to be used in a query,it must first be added to the ________.

Question 77

________ characters are used as placeholders for unknown parts of values or to match certain patterns in a value.

Question 78

A custom filter that matches all or part of the text in a field that you specify is called a(n)________.

Question 79

The Access tool that helps you format calculated fields correctly is called Expression Builder.

Question 80

A multiple-table ________ retrieved information from more than one table or query.