Devry BIS 245 All Quizes Latest

Description

Devry BIS 245 All Quizes Latest

Devry BIS 245 Week 1 Quiz Latest

1. 1.Question : (TCO 1) A database that organizes data in a set of overlapping tables is which of the following?

Student Answer: Flat-file

Hierarchical

Object-oriented

Relational

Comments:

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

Student Answer: server setup.

presentation task.

client browsing.

systems application.

Comments:

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

Student Answer: 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.

Comments:

Devry BIS 245 Week 2 Quiz Latest

2. 2.Question : (TCO 2) Which of the following does NOT describe a many-to-many relationship?

Student Answer: There must be at least two tables.

Many matching records exist in each direction between the tables.

A junction table is used.

You can connect to tables in other databases such as Oracle.

Comments:

Question 4. Question : (TCO 3) Queries can do all of the following EXCEPT

Student Answer: display specific records from tables and other queries.

perform calculations.

provide parameters at run time.

run from a table Datasheet View.

Comments:

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

Student Answer: 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.

Comments:

Question 10. Question : (TCO 2) What is the special character called to represent one or more characters in the Criteria area of a query?

Student Answer: Delimiter

Operand

Wildcard

Operator

Comments:

Devry BIS 245 Week 4 Quiz Latest

1. 1.Question : (TCO 1) Data aggregates

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

cannot be used in a report.

perform calculations on entire columns of data.

return multiple values.

Comments:

Question 7. Question : (TCO 2) A function used to isolate a specific portion of a date such as year, month, or day in a date field is

Student Answer: Date.

DateDiff.

DateParse.

DatePart.

Comments:

Devry BIS 245 Week 5 Quiz Latest

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

Student Answer: >.

“.

‘.

<>.

Comments:

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

Student Answer: –/–/–

CurrentDate()

Date

Date()

Comments:

Question 5. Question : (TCO 2) An input mask placed on a form will apply to

Student Answer: 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.

Comments:

Question 6. Question : (TCO 5) To edit a form, use the

Student Answer: design view.

datasheet view.

layout view.

layout view or design view.

Comments:

Question 8. Question : (TCO 5) All of the following are form creation tools EXCEPT

Student Answer: blank form.

form design.

form layout.

form wizard.

Comments:

Question 9. Question : (TCO 5) The title for a form should be placed in the

Student Answer: details area.

form header.

textbox in the details area.

textbox in the form header.

Comments:

Devry BIS 245 Week 6 Quiz Latest

2. 2.Question : (TCO 1) A report footer

Student Answer: is used to print page numbers on the report.

prints group statistics at the end of the report.

prints grand totals at the end of the report.

All of the above

Comments:

Question 4. Question : (TCO 1) The following steps will create a report.

Student Answer: 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.

Comments:

Question 6. Question : (TCO 1) The expression “= [Price] * [Quantity]” would most likely be found in

Student Answer: a bound control.

a calculated control.

a label control.

an unbound control.

Comments:

Question 10. Question : (TCO 7) Based on the values in aggregate data, a calculated total field in a PivotTable

Student Answer: allows for grouped data.

generates a new field.

provides for Average, Standard Deviation, and Sum totals.

All of the above

Comments:

Devry BIS 245 Week 3 Quiz Latest

Page 1

Question 1.1.(TCO 2) In a relational database, entities are (Points : 4) events. persons. things. All of the above Question 2.2.(TCO 2) Which of the following is NOT a step in the Database Life Cycle? (Points : 4) Database Design Maintenance and Redevelopment Performance Testing Question 3.3.(TCO 3) Database design refers to (Points : 4) 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. Question 4.4.(TCO 2) A crow’s foot (Points : 4) is a Boolean field. is used to describe attributes. points to the child table. points to the parent table. Question 5.5.(TCO 2) The term cardinality refers to (Points : 4) 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. Question 6.6.(TCO 2) A primary key (Points : 4) 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. Question 7.7.(TCO 3) Which does NOT apply to the following relationship image? .googleusercontent.com/proxy/Un8xM_Ucs59sXr9mw4h0kKKJTo-Q1U4Ge6pmYaAeEzkivh4LWhKDk0wp3LAY8CSdj_-zsgdK-hiNQX4F9Uzke1EK0xkFncR3j_oRAzZBa4gyXmS4qCBRhwIKmFM=s0-d-e1-ft#http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Quiz3 a.jpg”> (Points : 4) A one-to-many relationship is shown between Orders and Order Details. The display is showing the Design View of relationships. Order Details has a composite primary key. Within the Orders Details table, the ProductID field will contain unique values only. Question 8.8.(TCO 4) Entity attributes are represented as (Points : 4) fields. files. records. tables. Question 9.9.(TCO 4) Validation text (Points : 4) changes the way text data is formatted. determines the maximum length of a Text field. requires correct text data input. specifies the error message when a rule is violated. Question 10.10.(TCO 4) Based on the image, which statement does NOT describe the following one-to-one relationship? .googleusercontent.com/proxy/dVFPDjkDipDe0670XPCQJG8Ix2jd5IfRXS6hf3D9unPyEhB7nUJsDB8RDsN3fMdReSkIEK2MMjhw7hjJtcbVaPLRecCsfMu7C8O7fc1VmJ5YwayT5MuikfcdBZs=s0-d-e1-ft#http://takeexam.next.ecollege.com/CurrentCourse/Graphics/Quiz3 c.jpg”> (Points : 4) An excel upload would impact the integrity of the data based on the table design. Author and AuthorNew tables use the same primary key. More tables can be joined to either table. It may be used for security reasons to protect data availability.

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry BIS 245 All Quizes Latest, then contact us through call or live chat.

Devry BIS 245 All Quizes Latest