Question 1

(CO 1) Which object would you use to enter, delete, or modify data?  

Criteria  

Form  

Calculation  

Report

Question 2

(CO 1) Which object would you use to retrieve customers who live in Germany and the United States?  

Criteria  

Form  

Query  

Table

Question 3

(CO 1) When creating a report in Access, what report tool best outlines the following description? This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given.  

Label tool  

Tabular layout report  

Blank report tool  

Report wizard

Question 4

(CO 1) Which of the following is NOT a report section? 

Detail  

Group footer  

Page footer  

Summary

Question 5

(CO 1) Which of the following is NOT one of the query wizards in Access? 

Find duplicates query  

Simple query 

Multitabular query  

Crosstab query

Question 6

(CO 2) A field that uniquely identifies each record in a table is a 

link. 

relationship.  

primary key.  

foreign key.

Question 7

(CO 2) A symbol used in ER diagrams for an entity is a 

box.

diamond.

line. 

triangle.

Question 8

(CO 3) All of the following describe a caption property except  

allows for placing spaces between words.  

can take the place of a field name in datasheet view.  

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

the caption appears in datasheet, report, and form views.

Question 9

(CO 3) A functional dependency is 

a logical relationship between attributes of a table.  

a logical primary key.  

a composite key.  

a unique identifier.

Question 10

(CO 3) Which of the following is NOT true of indexed property? 

An example of a setting is yes (no duplicates).

Indexing a table speeds the retrieval time.  

Primary keys must be indexed. 

Setting the index requires each record to be scanned sequentially and saves time searching data.

Question 11

(CO 4) In terms of data types and their uses, which one of the following is NOT correct? 

The TEXT data type can be used for Last Name.  

The Date/Time data type can be used for 10/31/2012.  

The Currency data type can be used for Account balance.  

The AutoNumber data type can be used for Customer Name.

Question 12

(CO 5) Which form type displays records in a tabular format similar to a datasheet view but has more editing options, such as adding graphics?  

Datasheet form  

Multiple items form  

Split form  

Subform

Question 13

(CO 5) Which database property type increases the efficiency of a search on the designated field in the physical database?

Correct Answer  

Validation rule  

Validation text

You Answered  

Indexed  

Expression

See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive.

Question 14

(CO 6) Queries are objects in a database based on one or more underlying 

forms.  

modules. 

tables. 

macros.

Question 15

(CO 6) Data aggregate functions

are used to perform calculations on individual records in a table or query. 

cannot be used on a row.  

perform calculations on entire columns of data. 

return multiple values.

Question 16

(CO 9) All of the following are drawbacks to normalization, except 

less tables and larger columns.  

CPU usage.  

memory usage.  

input/output resources.

Question 17

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

Question 18

(CO 8) The switchboard manager is an Access utility that is used 

by all database users. 

to create and manage the menu items for a switchboard. 

to make certain objects unavailable to some users and available to others.  

to manage and optimize the database.

Question 19

(CO 9) An encrypted file is 

created by scrambling the content. 

protected by a password. 

saved with a specific file extension. 

unreadable if it is opened through a tampering tool or another program.

Question 20

(CO 9) When a user creates his or her own self-signed digital signature,

only a commercial service or local server for processing will work. 

only provides users proof that the software can be trusted.

it is created through anyone.

it will prove that the creator does not own the database.

Question 21

(CO 10) Which of the following file format types removes all VBA code from the database, produces only text unless content is enabled, and prohibits users from making changes to forms and reports? 

ACCDB 

ACCDC

ACCDE 

ACCDT

Question 22

(CO 4) The term cascading refers to

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.

Question 23

(CO 1) Explain the benefits an organization gains by using a relational database?

Question 24

(CO 2) What is a conceptual model? Explain its importance. Conceptual models are typically made up of three main parts. Name these parts giving a full definition and purpose. Give two possible examples of each part.

Question 25

(CO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain how that normal form is often violated by inexperienced database designers and how to correct such a violation of that normal form.

Question 26

(CO 4) Describe what the term data redundancy means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of a normalized database.

SmartExpert

(118)

Status NEW Posted 02 Mar 2019 07:03 PM My Price 14.00

BIS----------- 24-----------5 W-----------eek----------- 8 -----------Fin-----------al -----------Exa-----------m A-----------nsw-----------ers-----------

Attachments

file 1551554694-BIS 245 Week 8 Final Exam Answers.docx preview (1659 words )

S-----------cor-----------e f-----------or -----------thi-----------s a-----------tte-----------mpt-----------: -----------270----------- o-----------ut -----------of -----------270-----------  ----------- Qu-----------est-----------ion----------- 1 ----------- 5Â----------- / -----------5 -----------pts----------- (-----------CO -----------1) -----------Whi-----------ch -----------obj-----------ect----------- wo-----------uld----------- yo-----------u u-----------se -----------to -----------ent-----------er,----------- de-----------let-----------e, -----------or -----------mod-----------ify----------- da-----------ta?----------- Â----------- Â ----------- C-----------rit-----------eri-----------a -----------  ----------- Co-----------rre-----------ct!----------- Â----------- Â ----------- F-----------orm----------- Â-----------  ----------- Â-----------  -----------Cal-----------cul-----------ati-----------on -----------  ----------- Â----------- Â ----------- R-----------epo-----------rt -----------  ----------- Â-----------  -----------Que-----------sti-----------on -----------2 -----------5 -----------/ 5----------- p-----------ts ----------- (C-----------O 1-----------) W-----------hic-----------h o-----------bje-----------ct -----------wou-----------ld -----------you----------- us-----------e t-----------o r-----------etr-----------iev-----------e c-----------ust-----------ome-----------rs -----------who----------- li-----------ve -----------in -----------Ger-----------man-----------y a-----------nd -----------the----------- Un-----------ite-----------d S-----------tat-----------es?----------- Â----------- Â ----------- C-----------rit-----------eri-----------a -----------  -----------  -----------  ----------- Fo-----------rm -----------  ----------- C-----------orr-----------ect-----------! ----------- Â-----------  -----------Que-----------ry -----------  ----------- Â----------- Â ----------- T-----------abl-----------e -----------  -----------

Not Rated(0)

• Buy Answer