BIS245 Quiz Week 1

$4.75

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

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

Description

BIS245 Quiz Week 1

BIS245 Quiz Week 1

A+

(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