BIS245 Quiz Week 1-6

$19.50

BIS245 Quiz Week 1-6
(CO 1) A database that organizes data in a set of overlapping tables is which of the following…

 

SKU: BIS 245 Quiz Week 1-6  Categories: , Tags: , , ,

Description

BIS245 Quiz Week 1-6

BIS245 Quiz Week 1-6

A+

Quiz Week 1 

https://www.hiqualitytutorials.com/product/bis245-quiz-week-1/

(CO 1) A database that organizes data in a set of overlapping tables is which of the following?

Flat-file

Hierarchical

Object-oriented

Relational

(CO 1) To create a filtered list on a particular field in a record

Click on the home tab, advanced filter, and then filter by form.

Click on the home tab, filter, and then the find option.

Click on the home tab, filter, selection, and then pick your criteria.

Right click on an item in your field column and then click sort.

(CO 1) Which view best describes the image below?

Datasheet

Design

Form

Report

(CO 2) To add, delete, and edit fields in a table, use which of the following?

Datasheet view of a table

Design view of a table

Design view of a query

Report view

(CO 2) Types of relationships between tables do NOT include

one-to-one.

many-to-many.

primary-to-foreign.

many-to-one.

(CO 1) To display a subset of records based on certain criteria, use which of the following?

Filter

Form

Report

Table

(CO 1) A database management system (DBMS) is a collection of programs that

Store data.

Manage data.

Use collections of data.

All of the above

(CO 1) A filter is best described as

A subset of records from an object based on specified criteria.

A sorted list of records in an object.

A record list from a table.

Another name for a query.

(CO 1) To locate the tool to compact an Access database, click on the

File tab, options, current database, and select compact and repair database tools.

Home tab, advanced, and select compact and repair database tools.

Database tools tab, and select compact and repair database tools.

External data tab, and select compact and repair database tools.

(CO 2) To add, delete, and edit a record, use

Datasheet view of a table.

Design view of a table.

Design view of a query.

Report view.

(CO 1) Excel should be used instead of Access when

You have a small amount of data.

Your data needs to be regrouped in various views.

Your data needs connectivity to external databases.

Your data requires a relational database.

(TCO 1) A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a_____.

Field

Record

Table

Database

(TCO 1) Which database object would you use to find customers who are located in the same state?

Criteria

Form

Query

Report

(TCO 1) Examining the image below, which statement best describes what we see?

Six records have been filtered from a query called Employees.

Six records have been filtered on the Title field containing Sales Representative from the Employees table.

A table called Employees has been created from six filtered records.

A query called Employees has been created from a filtered table.

(TCO 1) The view in Access which looks similar to an Excel spreadsheet is:

Datasheet

Design

Form

Report

(TCO 1) On which tab is the Sort and Filter group found?

File

Home

Create

External Data

(TCO 2)  In using a web search engine, typing the website address in the proper place in the brower and then hitting enter is called:

Server setup

Presentation task

Client browsing

Systems application

(TCO 2) How many data types does Access recognize?

5

7

9

10

(TCO 1) You should use Excel over Access when:

You have a large amount of data

You need to group, sort, and total data based on various parameters

You need multiple related tables to store data

You require a series of What-if scenarios on your data

BIS245 Quiz Week 1-6

Quiz Week 2

https://www.hiqualitytutorials.com/product/bis245-quiz-week-2/

(CO 2) Which of the following is not an Access table property?

Allow Zero Length

Format

Hyperlink

Unicode Compression

(CO 2) All of the following describe a large database system except

Different users may have different levels of access to data in the database.

Simultaneous logging into a database is not recommended.

Multiple users in the database are common.

The database could be split into a front and back end.

(CO 2) Primary keys can be created

As computer-generated fields.

From an existing single field.

From several existing fields.

All of the above

(CO 3) A relational table includes the following conditions except

Column entries and attributes must be the same data type.

Rows must be in order.

Cells contain a single data value.

Columns or attributes have a well defined range of values.

(CO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?

11/12/2011

12/11/2011

#12/11/2011#

Between #10/01/2011# And #11/12/2011#

(CO 4) Which of the following is NOT true of a hire date field?

A hire date is considered a constant.

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

Date arithmetic can be applied to a hire date field.

The years of service field, which shows how long an employee has been with the company.

(CO 4) Which of the following is NOT an Access data type?

Text

Currency

Name

Date/Time

(CO 2) Which of the following is NOT a data type in Access?

AutoNumber

Date/Time

Number

String

(CO 2) Which of the following is used as a symbol for an entity?

Box

Diamond

Line

Triangle

(CO 3) Which data type will increment automatically each time a new record is entered into a table?

AutoNumber

Currency

Date/Time

Number

(CO 3) All of the following are true about a property except

A datasheet view is used to display properties.

Referenced as an attribute.

Changes can be made with a property sheet.

Tables, forms, queries, and reports can have properties.

(CO 4) Storage space for a field is reserved with the

PNPI.

Field size property.

Indexed property.

Validation rule property.

(CO 2) What is the special character called to represent one or more characters in the criteria area of a query?

Delimiter

Operand

Wildcard

Operator

(TCO 2) To create a relationship between two tables, you need at least a

Data type

Query

Hyperlink

Primary key

(TCO 2) In an ER diagram, a crow’s foot is used

As a symbol for an entity.

To establish tuples.

To model attributes.

To point toward a child table.

(TCO 2) SQL is

Nonprocedural and record oriented.

Nonprocedural and table oriented.

Procedural and object oriented.

Procedural and record oriented.

(TCO 3) An associative table is which of the following?

A child of two parent tables that are in a many-to-many relationship

A child of a parent table that is in a one-to-many relationship

A child of a parent table that is in a one-to-one relationship

None of the above

(TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?

Date/Time data types need no delimiters.

Date/Time data types need to be enclosed in single quotes.

Number data types require no delimiters.

Text data types require pound signs.

(TCO 3) A Text data type has a maximum character size of

50.

200.

255.

Limited only by memory

(TCO 3) The following describes characteristics of the caption property EXCEPT

Allows for spaces between words.

Appears in Datasheet, Report and Form views.

Can be used in place of a field name in an expression.

Can substitute a field name in Datasheet View.

(TCO 4) Which of the following is NOT an example of a primary key?

ISBN number for a textbook

Last name

Social Security Number

Student ID

(TCO 4) To ensure that a value of 15 or greater was entered into a field, you would use a

Field size

Field type

Sarbanes-Oxley Act

Validation rule

(TCO 2) In Access, which item below is NOT considered a logical operator?

Equal

And

Not

Or

BIS245 Quiz Week 1-6

Quiz Week 3 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-3/

(CO 2) Physical design refers to

Developing a database model that will support company operations.

Purchasing your hardware components.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
(CO 2) A domain is a

Group of data types that describe what kind of information that may be stored in a field.

Model of the database.

Set of values.

The set of primary and foreign keys in a database.

(CO 2) A one-to-many relationship is

A relationship that guarantees that a record is unique.

An association between a record and its fields.

Used to describe attributes.

When a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

(CO 2) An associative table is

used to identify primary keys between tables.

a child of two parent tables that are in a many-to-many relationship.

an integrity element within a table relationship.

a tool that allows you to locate an excel file.

(CO 3) What does not define a composite key?

Using two or more fields as a primary key

Using three fields as a primary key

Using two fields as a primary key

Using one field as a primary key

(CO 4) All of the following are examples of primary keys except

employee ID.

social security number.

ISBN number on a textbook.

last name.

BIS245 Quiz Week 1-6
(CO 2) Which of the following is an example of an entity in a business?

Company

Business owner

CEO

Employees

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 3) Database design refers to

Developing a database model that will support company operations.

Focusing on understanding the business and its functional areas or business processes.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 2) The term cardinality refers to

A count of the total records in a table.

A field which is a candidate for a primary key.

The number of records in a relationship.

The most important field in a table.

(CO 4) Which statement below is NOT true of one-to-many relationships?

It is the least-used type of relationship.

The table with the primary key must only have one occurrence of each value for the primary key.

The foreign key in the related table may have repeating values for the foreign key.

An example is that one employee may take multiple orders.

(CO 4) Which is NOT true of validation rules?

They enforce a size limit.

They check authenticity of data entered in a field.

An error message will appear if a rule is violated.

They protect from fraudulent practices.

(TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT:

Can you envision more than one instance of the entity?

Is there a variation over time?

Is the item to be modeled a person, place, thing, or an event?

Is the item to be modeled an attribute?

(TCO 2) Logical design refers to

Developing a database model that will support company operations.

Developing a thorough understanding of what needs to be done in developing a database.

Translating the conceptual design into the selected model for use in a database system.

Understanding the business and its functional areas or business processes.

(TCO 3) When troubleshooting a relationship, all of the following should be done EXCEPT

Creating a relationship between like data types.

Checking the size of fields to be used in the relationship.

Checking that the correct type of relationship is established.

Deleting the relationship and field, and then rebuilding.

(TCO 2) All of the following should be considered in designing a relational database EXCEPT

Compliance with PNPI regulations.

Design for safety with redundant data.

Design your database for 100-year usage.

Store data in its smallest parts.

BIS245 Quiz Week 1-6

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

A junction (associative) 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 two tables.

(TCO 2) A primary key

Can be computer generated.

Consists of one field only that uniquely identifies each record in a table.

Is a relationship between two or more tables.

All of the above

(TCO 3) 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 4) To which of the following does the term cascading refer?

Data changes travel from one table to another.

Data is put in sequential order.

Queries can retrieve data at a faster rate.

Records are arranged in order.

(TCO 4) Which is NOT true of a calculated field?

It cannot be added to queries or reports.

The value of a calculated field is produced from an expression.

A calculated field references other fields.

The result is useful at the moment the calculation is made.

BIS245 Quiz Week 1-6

(TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire?

Date arithmetic

Constant

Date/time field

Calculated field

Quiz Week 4 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-4/

(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.

BIS245 Quiz Week 1-6

(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.

BIS245 Quiz Week 1-6

(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

BIS245 Quiz Week 1-6

Quiz Week 5 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-5/

(CO 2) A validation rule

Can prohibit values from being entered that may not meet a criterion.

Compares a field to a table.

Is an error message that appears when a value is incorrectly entered into a field.

Makes a value entered into a field appear in a particular format.

(CO 2) A field can be added to a report to

Values for two or more fields.

Show a default value.

Appear in a predefined dropdown list.

Add a picture or logo.

(CO 2) Using an input mask is complex, however, MS Access provides common input masks, such as

Phone number or social security number.

Social security number and date and time.

Phone number and address.

Social security number and last name.

(CO 2) A label wizard enables you to create

Reports.

A table.

Mailing labels.

A new window.

(CO 2) An input mask placed on a form will apply to

All forms based on that table.

All forms in the database.

All forms based on that table and the table itself.

That specific form only.

(CO 5) To edit a form, use the

design view.

datasheet view.

layout view.

layout view or design view.

(CO 5) A multiple items form displays

multiple records in a tabular layout similar to a datasheet.

a formula that displays the result.

information from only a query.

a macro to process field information.

BIS245 Quiz Week 1-6

(CO 2) A default value is

A predefined list of values that can be selected by the user.

A value that cannot be lower or higher than the selected limit.

A specific value that automatically appears in a field and has edit capabilities.

A specific value that automatically appears in a field that cannot be changed by the user.

(CO 2) Validation text is

An error message that provides instruction on what to fix when an incorrect value is entered into a field.

A list of predefined values that can be entered in a field.

A comparison of values entered in two fields.

A field that requires a value of characters or text only.

(CO 2) An input mask

Allows one record to have more than two field values.

Allows the user to type a social security number as 111223333 and it would display as 111-22-3333.

Confirms that a value greater than 100 is a valid value.

Is a list of values that are previously defined from which the user can select one item.

(CO 2) Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables?

Design view

Fields group

Lookup group

Lookup wizard

(CO 2) An input mask that will NOT accept a letter (A to Z) in a field value is

?

A

L

#

(CO 5) All of the following are performed in the design view of a form except

Adding pictures, lines, calculations, and controls.

Changing the size of the form sections.

Entering a data value.

Modifying the properties of a form.

(CO 5) A form type that displays records in a tabular format, but has more editing options is a(n)

Datasheet form.

Multiple items form.

Split form.

subform.

(CO 5) If you click on the form tool, you will open a(n)

Existing form.

New form in design view.

New form in layout view.

Wizard to design a form.

(CO 5) A split form is best defined as

Most effective when run again on one table.

A form that combines two views of the same record source. Sections may be displayed differently depending on the view.

Can perform complex What-if analyses.

Require a macro in order to be effective.

(CO 5) A form is altered in what view?

Layout view or design view

Database view

Datasheet view

Table view

(TCO 2) A required field that is used in entering data is a field that

Appears with a specific value

Can be left blank

Cannot be left blank

Is selected from a list of values

BIS245 Quiz Week 1-6

(TCO 2) An example of a lookup is

one to a million

2010

AL, CA, NC, NY, TX

SSN, Date, 111-22-3333, AZ

(TCO 2) Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is

>

<>

(TCO 2) Which of the following below will provide the current computer data as a default?

–/–/–

CurrentDate()

Date

Date()

(TCO 2) Which of the following is NOT an example of a table event?

Add

Delete

Edit

View

(TCO 5) All of the following are performed in the design view of a form EXCEPT

Adding pictures, lines, calculations, and controls

Changing the size of the form sections

Entering a data value

Modifying the properties of a form

(TCO 5) A bound control

Is a textbox that is connected to a field in a query or a table

Contains a formula that displays the result

Is used to display aggregate information

Uses a macro to process field information

(TCO 5) All of the following are form creation tools EXCEPT

Blank form

Form design

Form layout

Form wizard

(TCO 5) In the design view of a form, which of the following would NOT be performed?

Add calculations, controls, pictures, and lines

Change the size of a form section

Enter a data value

Modify the properties of the form

(TCO 5) Use the Arrange Form Layout Tool to

Change the form layout

Move fields

Insert space

All of the above

Quiz Week 6 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-6/

(CO 1) Summary options are found

In the print layout view.

In the report wizard with sorting options.

All of the above

in the options toolbar.

(CO 1) A report can be created from

Queries and tables.

A database

A spreadsheet.

Forms.

(CO 1) When designing a report, make sure that your report

Uses all report sections.

Has grouped data.

Has a date and time.

Is easy to understand.

(CO 1) The easiest way to create a report is to use the following report tool.

Blank report

Report wizard

Report layout

Report design

(CO 1) Which of the following is NOT a report wizard layout type?

Summary

Outline

Block

Stepped

BIS245 Quiz Week 1-6

(CO 1) When creating a report, which view works best?

Design view of a query

Datasheet view

Layout view of the report

Design view

(CO 1) To preview the report, which view(s) work best?

Report view or design view.

Layout view or print view.

Design view.

Print view.

(CO 1) Grouping data in a report will

Let you organize and summarize your data.

Provide grand totals for your report.

Make a report more attractive.

Allow you to edit data in a record.

(CO 1) The expression “= [Price] * [Quantity]” would most likely be found in

A calculated control.

An unbound control.

A label control.

A bound control.

(TCO 1) When creating a report, you should consider all of the following EXCEPT

Who will use the report

The purpose of the report

Data that should be considered confidential

Number of records input into the report

(TCO 1) All of the following are report sections EXCEPT

Detail

Group footer

Page footer

Summary

(TCO 1) Which report section would be used to summarize grouped field data?

Detail

Group Header

Group Footer

Report Footer

(TCO 1) The following steps will create a report

Set focus on a table or query object, click on the Create tab, then click the Report button in the Reports group.

Set focus on a table or query object, click on the Design tab, open the table or query object, then click Design Report.

Click on the Create tab, select the Report Wizard, select your tables or queries, and then your fields.

Click on the Table tab, select your fields, and then click the Finish button.

(TCO 1) A tool that creates a report through a series of dialog boxes on the Create tab is the

Blank Report.

Label Wizard.

Report.

Report Wizard.

(TCO 1) Column headings in a report are based on

The captions used in the source table or query.

The text controls you place in a report.

Group labels.

Report labels.

(CO 7) Summary options offer all these calculations except

Minimum

Average

Print preview

Maximum

BIS245 Quiz Week 1-6

(TCO 7) A good use of a report is to

Create a telephone directory or a financial statement.

Ask the database a question.

Create a table or query.

Create detailed charts.

(TCO 7) Using Grouping when building a report accomplishes the following.

Grouped data can be sorted.

Grouped data can be summarized.

Summary options allow for Sum, Average, Min and Max.

All of the above.

(TCO 7) Which is not a report view?

Print preview

Datasheet view

Report view

Layout view

(TCO 7) When modifying a report, the arrange option does the following.

To move fields up or down

To insert space above or below your position

To change the layout of the report

All of the above

BIS245 Quiz Week 1-6