Quiz 4

Question 1

Which of the following is NOT a guideline for adding fields to a database table?

Answer 1

Link tables using foreign keys

Question 2

An example of a ________ field is a field for sales associates’ bonus–.05 multiplied by quarterly sales.

Answer 2

Calculated

Question 3

Storing the date of birth of clinic patients should be a ________ field

Answer 3

Constant

Question 4

wo or more tables that contain duplicate data are an example of:

Answer 4

Data redundancy

Question 5

Which of the following is NOT a way to create a table in Access

Answer 5

Typing a field name in a row in design view

Question 6

Which of the following is FALSE about CamelCase notation

Answer 6

Field names should include spaces when the name is more than one word.

Question 7

The value in a field with the ________ data type will be automatically increased each time a new record is entered

Answer 7

Auto number

Question 8

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to a Web page. Sarah should apply a(n) ________ type.

Answer 8

Hyperlink

Question 9

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. Jose should apply a(n) ________ data type.

Answer 9

OLE Object

Question 10

The maximum size of the ________ data type is ________ characters

Answer 10

Short text 255

Question 11

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Answer 11

Default Value

Question 12

Referential integrity should be enforced in a database with related tables because it

Answer 12

helps ensure invalid data is not entered into a table.

Question 13

The ________ group on the External Data tab has options that you can use to send a portion of a database to other applications.

Answer 13

Export

Question 14

Which of the following statements is TRUE about how Access and Excel share data?

Answer 14

Access can import data from Excel, and export data to Excel.

Question 15

If data from an Excel worksheet is imported into Access and no column headings exist, the data will import using

Answer 15

Field1, Field2, Field3, etc.

Question 16

Which of the following statements best describes a one-to-many relationship between two tables?

Answer 16

A primary key in the first table matches several foreign keys in the second table.

Question 17

Which of the following is NOT a type of relationship available in Access 2013?

Answer 17

Many to one

Question 18

Which statement accurately describes the function of a query?

Answer 18

Queries allow a user to ask questions about data and then provide answers by providing subsets or summaries of data.

Question 19

A ________ query is a type of query that displays on records that match criteria entered in Query Design view.

Answer 19

Select

Question 20

Which of the following is TRUE regarding the running of queries and the size of a database?

Answer 20

The queries in larger databases may take longer to run than queries in smaller databases.

Question 21

In a query, which of the following statements is TRUE regarding delimiters in the criterion of a field?

Answer 21

Number data types that use plain digits require no delimiter.

Question 22

Which of the following statements is TRUE about data types and delimiters?

Answer 22

Different data types require different delimiters.

Question 23

A(n) ________ operator, such as the greater than or less than symbol, can be used in a query criterion to limits the results produced by the query.

Answer 23

Comparison

Question 24

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12, 2010?

Answer 24

12/12/2010

Question 25

Which of the following is TRUE about the NOT operator?

Answer 25

The NOT operator returns all records except those that meet the specified criteria.

Question 26

Where do you change the order of query fields to change the order of query results?

Answer 26

In the design grid of a query’s Datasheet view

Question 27

It is more efficient to copy and use an existing query for a new query when

Answer 27

the query criteria needed will be similar to the original query.

Question 28

Which of the following statements is TRUE regarding multitable queries

Answer 28

Skill is required in choosing the right tables and managing table relationships.

Question 29

Which of the following is FALSE about multitable queries?

Answer 29

You can add fields by clicking a field selector and clicking Add.

Question 30

Which of the following is FALSE about changes in multitable queries?

Answer 30

Deleting a join line affects all relationships in all tables of the database.