Chat with us, powered by LiveChat devry bis245 final exam | Writedemy

devry bis245 final exam

08 Jun devry bis245 final exam

Posted at 11:30h in Essay Writing Services by

Question

Page 1

Question 1.1. (TCO 1) All of the following are Access objects EXCEPT (Points : 5)

criteria.

form.

query.

table.

Question 2.2. (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? (Points : 5)

Criteria

Form

Query

Table

Question 3.3. (TCO 1) All of the following are Report Wizard Layout types EXCEPT (Points : 5)

block.

outline.

stepped.

summary.

Question 4.4. (TCO 1) Which of the following is NOT a Report Section? (Points : 5)

Detail

Group Footer

Page Footer

Summary

Question 5.5. (TCO 1) A Detail line is used to (Points : 5)

print more detailed information on one record only.

provide additional field information on a record.

repeat data for each record in the record source.

All of the above

Question 6.6. (TCO 2) The number of records in a relationship is a(n) (Points : 5)

cardinality.

domain.

entity.

key.

Question 7.7. (TCO 2) Which of the following is supported by a primary key? (Points : 5)

Changeable over time

May be null

Unique

Updateable

Question 8.8. (TCO 3) All of the following are reasons to save first name and last name as separate fields EXCEPT (Points : 5)

fewer fields are used.

first name could be used in a salutation.

last name could be used in a salutation.

you can sort on last name then first name.

Question 9.9. (TCO 3) All of the following summarize characteristics of a PivotTable EXCEPT (Points : 5)

can display information that is typically found in Datasheet totals.

can only be created from a table.

data is organized and summarized in an easy-to-read view.

is created by dragging fields from a field list into appropriate drop zones.

Question 10.10. (TCO 3) Which of the following does NOT describe a caption property? (Points : 5)

A label can substitute for a field name in Datasheet View.

The caption appears in Datasheet View, Form, and Report.

The label allows spaces between words.

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

Question 11.11. (TCO 4) In a ________ dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time and room number. Course would uniquely identify an instructor. (Points : 5)

Structural

Functional

Referential

Transitive

Page 2

Question 1.1.(TCO 5) To edit a form, use (Points : 5)

datasheet view.
design view.
layout view.
layout view or design view.
Question 2.2.(TCO 5) Clicking on the form tool will open a(n) (Points : 5)

existing form.

new form in design view.

new form in layout view.

wizard to design a form.
Question 3.3.(TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)

Forms
Modules
Tables
Macros
Question 4.4.(TCO 6) Data aggregates (Points : 5)

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.
Question 5.5.(TCO 7) When making vertical data comparisons, you should use the following chart. (Points : 5)

Bar
Column
Pie
Scatter Plot
Question 6.6.(TCO 7) Effective PivotTables and PivotCharts are usually based on a (Points : 5)

form.
query.
report.
table.
Question 7.7.(TCO 8) All of the following describe a Navigation Form EXCEPT (Points : 5)

click the Create tab and then Navigation in the Forms group to create a Navigation form.
is another term for a Switchboard Manager.
helps users open forms and reports.
has the look and feel of a Web form.
Question 8.8.(TCO 9) An encrypted file is (Points : 5)

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 9.9.(TCO 9) All of the following are true when a user creates their own self-signed digital signature EXCEPT (Points : 5)

a time stamp is not required to go through a commercial service or local server for processing.
a time stamp will prove when the file was last used.
it is created through another software application.
it will prove that the creator owns the database.
Question 10.10.(TCO 10) To examine the efficiency and performance of an Access database, you should (Points : 5)

migrate the database out of Access and into a larger DBMS.
move the database to its own dedicated server.
redesign your database applying 3NF principles.
use the Performance Analyzer and Table Analyzer to optimize the performance of the database.
Question 11.11.(TCO 4) Which statement below is NOT true of the one-to-many relationships?

(Points : 5)

It is the least used type of relationship.
OrderID is a unique identification number that would be used in the Orders table and Order Details table.
Each record in the Orders table may match one, more than one, or no records in the Order Details table.
Each record in a Orders table matches only one record in the Customers table.

Page 3

Question 1. 1. (TCO 1) What role do databases play in today’s business world and why are they important? Provide two specific examples of how a database might be used by a business. (Points : 40)

Spellchecker

Question 2. 2. (TCO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. (Points : 40)

Spellchecker

Question 3. 3. (TCO 4) Explain the importance of determining relationships before establishing primary keys in the design sequence? (Points : 40)

Spellchecker

Question 4. 4. (TCO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40)

Spellchecker

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Writedemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Print page