Deck 15: Access: Introduction to Powerpoint

Question 1

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

A) filter
B) relational database
C) foreign key
D) primary key

Answer 1

C

Question 2

A field, or a combination of fields, that has a unique value is a:

A) primary key /
B) foreign key /
C) table /
D) field value /

Answer 2

A

Question 3

A form can be used to:

A) select records that meet specific criteria.
B) automate the retrieval and update process.
C) sort data in ascending or descending order.
D) enter, edit, and view records in a database.

Answer 3

D

Question 4

The navigation buttons allow you to:

A) delete records.
B) edit records.
C) sort records.
D) browse records.

Question 5

You can click the ________ button on the table toolbar to sort records in alphabetical order, from A to Z.

A) form
B) descending
C) order
D) ascending

Question 6

-In the table pictured above, the column labeled Last Name is an example of a:

A) record.
B) field.
C) table.
D) query.

Question 7

Access differs from other Microsoft software because it:

A) works primarily from memory.
B) works primarily from storage.
C) does not save your work as soon as changes are made.
D) does not allow more than one user to work on a file at a time.

Question 8

The ________ organizes and lists the database objects in an Access database.

A) report wizard
B) navigation pane
C) query tool
D) form wizard

Question 9

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:

A) create a query.
B) create a new table.
C) create a form.
D) create a report.

Question 10

Selecting data by means of a query:

A) deletes unrelated data.
B) displays only the data that matches the query selection criteria.
C) locks all other users out of the database.
D) creates a report.

Question 11

-In the table pictured above, the ________ field would make the best primary key.

A) First Name
B) Last Name
C) Telephone Number
D) Client ID

Question 12

Which of the following is NOT an example of an Access object?

A) Query
B) Sort
C) Report
D) Table

Question 13

Data from two or more tables can be connected by specifying a:

A) hyperlink.
B) field value.
C) common field.
D) form.

Question 14

A form can best be described as a(n):

A) record.
B) object.
C) attribute.
D) table.

Question 15

A primary key:

A) must include letters.
B) must contain a unique value for each record within the table.
C) has the same value for all records.
D) is not usually necessary.

Question 16

________ a database rearranges data and objects in a database to make its size smaller.

A) Backing up
B) Compressing
C) Compacting
D) Realigning

Question 17

A ________ is a question you ask about data stored in a database.

A) query
B) form
C) report
D) macro

Question 18

-In the table pictured above, each column represents a:

A) field.
B) record.
C) table.
D) primary key.

Question 19

-In the table pictured above, the last row of data shown ( 2734, Riker, William, 212-566-1701.) is a:

A) form.
B) field.
C) key.
D) record.

Question 20

A relational database is a collection of:

A) forms.
B) field values.
C) common fields.
D) related tables.

Question 21

The ________ tab contains all the tools necessary for producing tables, forms, and queries in Access.

A) External Data
B) Database Tools
C) Create
D) Home

Question 22

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) ________ to the data in order to show only records that meet the criteria.

A) Filter
B) Report
C) Form
D) Sort

Question 23

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:

A) you need to create complex charts or graphs.
B) you require multiple tables to manage data.
C) you are managing a large quantity of data.
D) multiple users need to work with data simultaneously.

Question 24

A ________ produces professional appearing formatted information derived from the information contained in tables or queries.

A) primary key
B) criterion
C) report
D) form

Question 25

Irene is working in a database that organizes city court case information. Irene must find court cases in either one of two cities. Irene should use the Filter by Form ________ condition.

A) query
B) sort
C) OR
D) AND

Question 26

The ________ view in Access looks similar to an Excel Spreadsheet.

A) Report
B) Form
C) Datasheet
D) Design

Question 27

When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:

A) you only need a single worksheet to manage data.
B) you need to manage primarily of numeric data.
C) you need to run a series of "what if" scenarios .
D) you need to group, sort, and total data based on various parameters.

Question 28

The ________ tab holds some of the more advanced features in Access.

A) External Data
B) Database Tools
C) Create
D) Home

Question 29

The ________ tab is the default Access tab and contains basic editing functions.

A) External Data
B) database Tools
C) Create
D) Home

Question 30

You can use ________ to create a relationship between two tables using a common field.

A) join lines
B) objects
C) forms
D) reports

Question 31

A ________ displays a subset of records based on specified criteria.

A) filter
B) form
C) table
D) primary key

Question 32

-In the table pictured above, if you wanted to organize the data from the lowest Client ID to the highest Client ID, you would ________ the Client ID field.

A) sort
B) report
C) query
D) form

Question 33

You can make a(n) ________ copy of a database file to protect your database against loss or damage.

A) master
B) secure
C) backup
D) restore

Question 34

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in two cities. The vendors must have offices in both cities in order to meet Ryan's requirements. Ryan should use the Filter by Form ________ condition.

A) query
B) sort
C) OR
D) AND

Question 35

You can create or modify a table's field names and data types in ________ view.

A) Report
B) Form
C) Datasheet
D) Design

Question 36

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers in that offer services in the Washington area and that service rare flowers. The best way for her to search for this data is to perform a:

A) Filter by Form.
B) Filter by Selection.
C) Sort Ascending.
D) Sort Descending.

Question 37

Database design begins with:

A) creating the correct forms.
B) creating the correct queries.
C) grouping data into the correct tables.
D) grouping the data in alphabetical order.

Question 38

Dianna wants to compact an Access database. She can find the tool to compact the database by clicking on the ________ tab.

A) File
B) Home
C) Create
D) External

Question 39

An expression used in queries to filter records in a table is called a(n):

A) primary key.
B) criterion.
C) report.
D) form.

Question 40

By selecting the ________ option, you can make sure that data entered into a related table first exists in the primary table.

A) sort
B) form wizard
C) query wizard
D) referential integrity

Question 41

Data is a finished product that is the result of a query or report in Access.

Question 42

A query is used to display all records in a database.

Question 43

A form allows you to view and maintain your data in a customized format.

Question 44

A form can be used to make users view or edit only one record at a time.

Question 45

A database is a collection of one or more related tables.

Question 46

Editing a table through a query does not update the data in that table.

Question 47

You can use a spreadsheet, like a database, to handle massive amounts of data and easily form relationships among multiple tables.

Question 48

The navigation buttons allow you to step through a table record by record, or to quickly go to the first or last record in the table.

Question 49

A query cannot be used to add new records or modify existing records.

Question 50

Backing up a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.

Question 51

The heart of a database is forms because they contain the actual data.

Question 52

A complete set of data elements within a table is called a record.

Question 53

The ________ tab holds all of the operations necessary to carry out data import and export.

A) External Data
B) Database Tools
C) Create
D) Home

Question 54

A collection of related fields describing a person, place, object, event, or idea is called a table.

Question 55

Like Access, Excel can be used to manage large quantities of data.

Question 56

When making a change to an Access database, you must first save the change in order for the change to take effect.

Question 57

A primary key in one table cannot be used as a foreign key in a different table.

Question 58

By defining a report, you can create a formatted printout or display of the data contained in one or more tables.

Question 59

The navigation bar at the bottom of the database window shows the number of records in a table.

Question 60

Database information should be presented using an Access report.

Question 61

You can ________ a database in order to protect your data against loss or damage.

Question 62

Both Access and Excel contain tools that can be used to extract and analyze information.

Question 63

The ________ is a field or collection of fields whose values uniquely identify each record in a table.

Question 64

Access speed measures the time it takes for Access to start up.

Question 65

When using Filter by Form, you can use comparison operators in the criteria to evaluate relationships.

Question 66

You can ________ a database to rearrange the data and objects in the database and decrease its file size.

Question 67

The ________ allows you to organize different types of database objects into groups.

Question 68

If there is a power failure while you are working on a database, all your changes will be lost unless you saved them first.

Question 69

A(n) ________ is a collection of fields that describe a person, place, object, event, or idea.

Question 70

A sort can only list records in a specific numeric sequence.

Question 71

Tables, queries, reports, and forms are all examples of ________.

Question 72

A group of related tables is called a(n) ________ database.

Question 73

A(n) ________ is a single characteristic or attribute of a person, place, object, event, or idea contained in a database.

Question 74

A descending sort organizes a list of numeric data in lowest to highest order.

Question 75

In order to find specific information in a database, you can run a(n) ________ which asks a question about data stored in a database.

Question 76

Filter by Form displays records based on single criteria.

Question 77

A set of data such as first name, last name, address, etc. for a specific person is a(n) ________.

Question 78

Access is best used for managing numeric data.

Question 79

A primary key from one table that is used to form a relationship with a second table is called a(n) ________.

Question 80

Two users cannot work on the same table in a database.