BIS 245 Quiz Week 4

$4.75

BIS 245 Quiz Week 4 
(CO 1) Which object, by definition, allows you to ask questions about the data stored…

SKU: BIS 245 Quiz Week 4  Categories: , Tags: , ,

Description

BIS 245 Quiz Week 4

BIS 245 Quiz Week 4

A+

(CO 1) When running a query, it is important to

Remember that the information can not be used for decision making.

Remember that the information can not be used in a report.

Evaluate the results for accuracy.

Return multiple text messages.

(CO 2) When constructing criteria for a query, you should use

No delimiters for number data types.

Quotes to enclose date/time data types.

Single quotes for number data types.

The pound sign to enclose text data.

(CO 2) Which of the following is NOT true of a single-table query?

It can be created using the simple query wizard.

Queries can be created using the query design tool.

You can overwrite table data using the datasheet view of a query.

The top portion of the query design view displays the fields and criteria for two tables.

(CO 2) Which of the following is a naming convention for field names?

Autonumber

Camelcase

Primary key

PPNI

(CO 2) A calculated field may contain the following elements except

An arithmetic operator.

A hyperlink.

A built in function with built in calculations.

A constant or value that doesn’t change.

(CO 2) Which of the following is NOT true of a birth date field?

A birth date is considered a constant.

A birth date would be defined as a date/time field.

A birth date should not be considered a calculated field.

Date arithmetic can be applied to a process date field.

(CO 6) An expression can be built to

Locate a record.

Complete a calculation or function.

Summarize a data source, such as a table or query.

Build only calculations.

(CO 6) Which of the following is true about a crosstab query?

It is an action query.

It is used to retrieve parameter data.

It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.

It summarizes unmatched records from a data source.

(CO 1) Which object, by definition, allows you to ask questions about the data stored in a database, such as which customers live in New Orleans and Seattle?

Criteria

Form

Query

Table

(CO 2) To locate a blank field, your criterion in a query would be

Blank

Empty

Null

Void

(CO 2) Which of the following is not a recommended practice for designing multitable queries?

Include only related tables in your query.

Remove join lines in query design to speed up query processing.

Related tables should be established before you design a multitable query.

Print a relationship report to guide you in selecting related tables.

(CO 2) Which of the following statements is true about queries?

Forms and queries are actually the same thing.

Queries can only be based on one table.

Queries can be based on one or more related tables.

The instructions to create a query are not stored in the database.

(CO 2) Which Access data type would you use to store $23.58?

Calculated

Currency

Money

Number

(CO 2) In Access, the bottom portion of query design view that displays the fields and criteria is known as the

Query design grid.

Show tables dialog.

Simple query wizard.

Query datasheet.

(CO 6) A parameter query is

A select query where the user provides the criterion at run time.

An action query used to modify data.

An aggregate query used to summarize field data.

Used to backup databases.

(CO 6) All of the following are true about a delete query except

A delete query is an action query.

Access will display a warning message before running the delete query.

It can be created by clicking the create tab, query wizard, and then select delete query.

It selects records from a table and then removes them from the table.

(TCO 1) Entity attributes are represented as

Fields

Files

Records

Tables

(TCO 2) All of the following are Access data types EXCEPT

Autonumber

Date/time

Number

String

(TCO 2) In Access, query results are displayed in which view?

Datasheet

Form

Recordset

Report

(TCO 2) Access has _____ data types

Six

Eight

10

12

(TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

A junction table is used

Many matching records are found in each direction between tables

May be used to connect to Oracle and other databases

There must be at least four tables

(TCO 2) Another term for an expression is

Formula

Function

Parameter

Query

(TCO 2) Validation text

Changes the way text data is formatted

Determines the maximum length of a text field

Requires text data to be inputted correctly

Specifies the error message when a rule is violated

(TCO 2) In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the

Query design grid

Show Tables dialog

Simple Query Wizard

Query datasheet

(TCO 6) Which of the following does NOT describe data redundancy?

The same data exists in multiple tables

The data is always in linked tables

Data updating must be done in multiple table locations

Data redundancy can result in data anomalies

(TCO 6) Which of the following is NOT an action query?

Append

Delete

Make Table

Summarize