Deck 11: Working With Data

Question 1

Because a(n) filter is a database object, you can save it for later use

Answer 1

False

Question 2

Greater Than is one of the available Number Filters.

Answer 2

True

Question 3

You can create a query in Design view

Answer 3

True

Question 4

The simplest way to sort a table is to select a field that matches your criterion, and then use the Equals command to display those records that match the selection

Question 5

To specify a relationship between two tables, you must share a(n) common field and one must be the primary key field in one of the tables

Question 6

For greater flexibility and control, a filter is sometimes more helpful than a query.

Question 7

You can save a filter as part of the table or form you are working on.

Question 8

The simplest way to create a query is to use the Query Wizard

Question 9

One way to modify an existing query is to specify a sort order for a(n) field in a query

Question 10

You can open an Access database and save it with a new name.

Question 11

You cannot sort records using more than one field at a time.

Question 12

One difference between opening an Access database and opening a file in Word or Excel is that you can only open two Access database files at a time.

Question 13

Records resulting from a(n) sort look like a table but are actually a view

Question 14

When a filter is applied to a table, the word "Filtered" appears in the record navigation bar

Question 15

You can save a filter as a database object.

Question 16

One way to modify a(n) query is to set criteria for the fields

Question 17

After sorting fields in a table, you can remove a sort order setting by clicking the Remove Sort button in the Sort & Filter group.

Question 18

You can enable a disabled database by clicking Enable Content in the Security Warning bar

Question 19

To perform a sort, you must first indicate the field on which you want Access to sort.

Question 20

A filter can be toggled on and off to remove it and then reapply it.

Question 21

In the accompanying figure, what is stopping the user from working in this database?

A) Security warning
B) Wrong software version
C) There is no relationship between the tables
D) The file is locked

Question 22

In the accompanying figure, item 3 points to the ____.

A) Available Fields list
B) Properties list
C) fields used in the query
D) Tables/Queries list arrow

Question 23

You can set up a ____ between two tables so that you can use the fields from both tables in a query.

A) link
B) bridge
C) relationship
D) bar

Question 24

You can apply a(n) ____ Filter to a selected field to filter records that are greater than, less than, or equal to a specific number, or between two different numbers.

A) Number
B) Mathematical
C) Equation
D) Limiting

Question 25

In the accompanying figure, item 4 points to the ____.

A) Tables/Queries list arrow
B) Select Single Field button
C) fields to be used in the query
D) available fields list

Question 26

You can rearrange, or ____, the records in a table in alphabetical or numerical order.

A) filter
B) organize
C) update
D) sort

Question 27

A ____ is a database object that extracts data from one or more tables in a database according to criteria that you set.

A) table
B) query
C) filter
D) mirror

Question 28

In the accompanying figure, what must you do to work in this database?

A) Unlock the file
B) Go to preferences and disable the security warning
C) Create a relationship between the tables
D) Click Enable Content

Question 29

A query that retrieves or selects data from one or more tables or queries according to your criteria is known as a(n) ____ query.

A) filter
B) object
C) select
D) retrieve

Question 30

Sorting in order alphabetically from A to Z or numerically from 0 to 9 is known as ____ order.

A) descending
B) negative
C) ascending
D) positive

Question 31

In the accompanying figure, there are how many tables?

A) 1
B) 2
C) 2
D) none

Question 32

____ are conditions that must be met for a record to be displayed.

A) Filters
B) Delimiters
C) Criteria
D) Search conditions

Question 33

To open an existing Access database, click the  ____command from the Access Start screen.

A) Existing Files
B) Open Other Files
C) Recent Files
D) Recent Databases

Question 34

Sorting in order alphabetically from Z to A or numerically from 9 to 0 is known as ____ order.

A) descending
B) negative
C) ascending
D) positive

Question 35

When sorting on more than one field, the field that is the primary sort field,  is called the ____ sort field.

A) outside
B) outermost
C) innermost
D) inside

Question 36

In the accompanying figure, item 2 points to the ____.

A) Available Fields list
B) Select Single Field button
C) fields used in the query
D) Tables/Queries list arrow

Question 37

The simplest way to create a query is to use  _____.

A) the Query Wizard
B) Design View
C) the Query Design Tool
D) the Ribbon

Question 38

When sorting on more than one field, the field that is the secondary sort field, is called the ____ sort field.

A) outside
B) outermost
C) innermost
D) inside

Question 39

In Query Design view, the lower pane is called the ____.

A) query grid
B) design grid
C) query grid view
D) query design grid

Question 40

In the accompanying figure, item 5 points to the ____.

A) Tables/Queries list arrow
B) Select Single Field button
C) fields to be used in the query
D) available fields list

Question 41

Explain how to capture a screen shot of a sorted table.

Question 42

Explain the difference between sorting and filtering data in Access.

Question 43

____________ fields are fields that contain a mathematical expression.

Question 44

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State.
Describe the process of sorting your customer records in ascending order by the name of the customer in the field called "Customer Name."

Question 45

The Enforce Referential ___________ feature tells Access to reject any attempts to enter data that would be inconsistent.

Question 46

Explain the importance of good database design.

Question 47

In the second table of two related tables, the common field shared with the first table is called the ____ key.

A) foreign
B) primary
C) secondary
D) master

Question 48

In the accompanying figure, item 6 points to the ____ list arrow.

A) Grid
B) Query
C) Filter
D) Sort

Question 49

In the accompanying figure, item 4 points to the ____.

A) query design grid
B) Sort cell
C) table field list
D) View button

Question 50

When you click Click to Add, point to Calculated Field, and then click Currency, the _______________ Builder dialog box opens so that you can easily create the expression you want by specifying fields, values, and operators.

Question 51

In the accompanying figure, item 2 points to a ____.

A) record
B) field
C) query
D) filter

Question 52

In a customer database you could _____________ records by the Sales field in descending order to quickly identify the customers who purchased the most products.

Question 53

In the accompanying figure, item 5 points to the ____.

A) query design grid
B) Sort cell
C) table field list
D) View button

Question 54

A huge benefit to using referential ___________________ is that the data in your databases is consistent.

Question 55

The symbols >,

Question 56

In the accompanying figure, item 1 points to the ____ button.

A) Record
B) View
C) Query
D) Filter

Question 57

In the accompanying figure, item 3 points to the ____.

A) query design grid
B) Sort cell
C) table field list
D) View button

Question 58

A calculated field is useful is you want to show the _________________ of calculations based on values in certain fields.

Question 59

The tables you wish to relate must share a(n) ____ field.

A) identifying
B) singular
C) objective
D) common

Question 60

The most common type of relationship to set up is a(n) ____ relationship, in which the primary key field in one table is associated with multiple records in a second table.

A) one-to-one
B) referential
C) one-to-many
D) integral

Question 61

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State.
Your supervisor would like you to remove a sort and revert the fields to their original listing. How do you go about this?

Question 63

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State.
Your supervisor wants a list of only those customers who live in the city of Bellview. How can you create this list?

Question 64

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?

Question 65

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.