Deck 2: Access

Question 1

You can save a filter as a database object.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

You can create a query in Design view. _________________________

Answer 3

True

Question 4

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

Question 5

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

Question 6

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 7

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

Question 8

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 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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 17

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

Question 18

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 19

Greater Than is one of the available Number Filters.

Question 20

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

Question 21

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

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

Question 22

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

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

Question 23

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 24

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

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

Question 25

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 26

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 27

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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

Question 36

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 37

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 38

____________ fields are fields that contain a mathematical expression.

Question 39

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 40

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 41

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 42

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

Question 43

Explain the difference between sorting and filtering data in Access.

Question 44

Explain the importance of good database design.

Question 45

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

Question 46

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.

Question 48

A query extracts data from one or more database tables according to criteria that you set.

Question 49

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 50

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

Question 51

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 54

A database is an organized collection of unrelated information.

Question 55

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 58

The symbols >,

Question 59

A form is a summary of database information specifically designed for printing.

Question 60

A relational database contains only one table.

Question 61

The column headings in a database table are called field names.

Question 62

Tables, forms, queries, and reports are program components called objects. __________________________

Question 63

A(n) form extracts data from one or more database tables. __________________________

Question 64

Records consist of  ____, which contain information about one aspect of a record.

A) objects
B) reports
C) queries
D) fields

Question 65

Each row in a database table is called a(n) record. __________________________

Question 66

Short Text is a(n) data type. __________________________

Question 67

Each text box in a(n) form corresponds with a field in a table.  __________________________

Question 68

A database containing two or more tables of related information is called a ____ database.

A) simple
B) relational
C) complex
D) related

Question 69

A database stores data in one or more spreadsheet-like lists called ____.

A) cells
B) records
C) tables
D) sheets

Question 70

Access is a database management system. __________________________

Question 71

You can save a table in Datasheet view by clicking the Save button on the Quick Access toolbar.

Question 72

Creating a database from a(n) template saves time since it contains many ready-made database objects. __________________________

Question 73

In Design view, you use a grid to enter fields and specify field data types.

Question 74

When you start working in a new database, a blank form opens in Datasheet view. __________________________

Question 75

Every table in a database must contain one field that is designated as the ID key field. __________________________

Question 76

To add a field to a table, you need to specify its data type.

Question 77

Every new table in Access includes a blank ID field which is automatically designated as the primary key field. __________________________

Question 78

When you save a database, all of the database objects within it are automatically saved too.

Question 79

It is easier to add fields to new or existing tables in Datasheet view.

Question 80

A database containing just one table is called a ____ database.

A) simple
B) relational
C) query
D) report