devry bis245 full course [ all discussion all ilab all quiz and final ]

| June 12, 2016

Question

WEEK 1

Databases and Gathering Requirements (graded)
Why are databases important to business? How do databases generate sales and-or profits? What databases do you interact with, and how do they benefit you?
What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating it?
Read the General Business Example on page 7 of the Frost section of the text. This page describes how to categorize data requirements from a form used by a company called Reading Fool. Turn to page 12 of the text, and pick one of the practice exercises: 1, 2, 3, 4, or 5. Present your solution here. List the category first, and then put all of the data items in parentheses after the category.

Choosing a Database (graded)
Microsoft Access is one of the most popular database platforms on the market. However, there are many competitors. Why do you think that Access is so popular? What are some of the other types of databases available?
Discuss the differences between Access and its competitors. Are there truly any differences or are they the same technology implemented in different ways?
Do you think that Access can serve as a corporate database solution, or is it strictly a personal database solution? What might be the difference between a personal and corporate database solution?

WEEK 2

Entity Relationship (ER) Modeling (graded)
What role does the entity-relationship (ER) diagram play in the design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. Discuss the meaning of an entity as related to ER diagrams. How would you approach the diagramming process?

This section lists options that can be used to view responses.

Database Table Design (graded)
When designing database tables, the difference between a good design and a bad design can be a few seconds in response time and several minutes. You may think that this is not a huge difference, but imagine waiting several minutes on a web page for your results to load. How long would you wait? A slow database can mean the loss of customers. So let’s begin by discussing some of the common elements of tables and how you would approach the table design. What would you do to ensure that your page loads in a few seconds? Discuss the relationship types and how they affect your design.

WEEK 3

Conceptual Database Design (graded)
Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?

Requirements Analysis (graded)
Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.

WEEK 4

Creating Queries from Woodcraft Database (graded)
For purposes of this discussion, assume that Woodcraft is an online store that sells wooden craft kits to churches, scouting organizations, and other groups that need crafts for children. Save Woodcraft’s database to your computer or space in our iLab environment; it’s found at this link: Week 4 Woodcraft Database. The database is also found in the first page of Doc Sharing. View the content and structure of the database, and then choose one of the questions that follow to answer.

Later in the week, you may answer a second or third question, but let’s start off with everyone answering one at a time.

a. What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business? Describe what information you might want to select from the database in the form of a query, and list the specific columns and data that the query would produce. Assume that they have hundreds of customers, rather than the short list found in the database file.

b. Suggest additional tables and information that you would like to see in a database like this, the kinds of queries that it would facilitate, and how such queries would help the company improve its business goals of profitability, cost reduction, or other business strategies.

c. Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week’s lab. Post a screenshot of your query design and result set in a Word document.

d. Research one new feature that you haven’t studied as it relates to query generation, and show how you could use that feature to create a useful query. Use the Woodcraft database to showcase this query-generation technique and post it in this discussion.

Creating Queries from Northwind Database (graded)
In Doc Sharing, you will find an Access database labeled Week 4 Discussion Northwind. Save the database to your computer and open the database using Access. Answer the questions below. Please assist one another.

a. View the design of the database in the Database Tools-Relationships window. Describe some queries that would be useful to Northwind Traders as it strives to increase sales, profits, or reduce expenses. Be specific, listing the tables, columns, and data that you would extract from the Northwind Database. Also, indicate why such queries are useful from a business standpoint.

b. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document

c. Create a few queries that allow you to practice concepts from the Lab. Please, don’t simply post queries from this week’s lab assignment! Post a screenshot of the query design and the results set in a Word document. Also, describe how this query could help managers make a business decision.

d. Relying on the textbook, the lecture, or Internet research, describe query generation techniques that you haven’t yet applied in this week’s lab. Describe what the querying technique is and how it is useful. For example, you might research the concept of a parameter query, describe what it is, and then create such a query in the Northwind database. Post a screenshot of the

WEEK 5

Data Normalization (graded)
Explain the difference between good and bad table structures. How do you recognize the difference between good and bad structures? What role does normalization play in good and bad table structures, and why is normalization so important to a good table structure?

Data Validation (graded)
What is the importance of data validation? How can we avoid data-entry errors? How can forms help us reduce data-entry errors? What features does Access offer to help validate data? What are the different kinds of validations that are required?

WEEK 6

Data Reporting (graded)
Database reports provide us with the ability to further analyze our data and provide it in a format that can be used to make business decisions. Discuss the steps that you would take to ensure that we create an effective report. What questions would you ask of the users?

This section lists options that can be used to view responses.

Presenting Data Effectively (graded)
Data presentation should be designed to display correct conclusions. What issues should we think about as we prepare data for presentation? Discuss the different methods that we can use to present data in a report. What role does the audience play in selecting how we present the data?

WEEK 7

Database Navigation (graded)
Finding information in a database can be difficult unless you know what information you need and how to look for it. Creating a navigation system or menu allows Access to act like a point-and-click system. What are some of the types of navigation that you can create in Access 2010? How should we approach the design of the menu?

Database Security (graded)
Why is data security important now more than ever? What are some of the steps that we can take to ensure that our database is protected and secure? How can you use user views to enhance s

ilabs

BIS 245 Week 1 iLab Devry University

A. Lab # : BSBA BIS245A-1
B. Lab 1 of 7 : Introduction to MS Visio and MS Access
C. Lab Overview–Scenario/Summary

TCOs:
1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements.
2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.

Scenario:
You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models.
You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships.
Upon completing this lab, you will be able to
1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio;
2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and
3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.

D. Deliverables
YourName_Lab1.vsd (Visio Diagram)
YourName_Lab1C_Questions.docx

A.Lab # : BSBA BIS245A-2

B.Lab 2 of 7 :Skills Development in Visio; Creation of MS Access Database

C.Lab Overview–Scenario / Summary:

TCOs:

1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.

2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.

3. Given an existing relational database schema, evaluate and alter the database design for efficiency.

4. Given an existing database structure demonstrating efficiency and integrity, design the physical tables.

Scenario:

You have been asked to create a conceptual database model using MS

week 3

A.Lab # : BSBA BIS245A-3

B.Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business Rules

C.Lab Overview–Scenario/Summary

TCOs:

2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.

3. Given an existing relational database schema, evaluate and alter the database design for efficiency.

4. Given an existing database structure demonstrating efficiency and integrity, design the physical tables.

Scenario

You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules.

You will then complete an MS Access database based on the model developed in Visio, creating the necessary tables and relationships.

Upon completing this lab, you will be able to

1. create a new Visio file for database design;

2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and

3. create a new MS Access database based on the ERD.

D. Deliverables

Section

Deliverable

Points

Part A Step

YourNameLab3.vsd (Visio Diagram)

7

Part B Step

YourNameLab3.accdb (Access Database)

3

E. Lab Steps

Page1 of 6

week 5

A.Lab # : BSBA BIS245A-5A

B.Lab 5A of 7 :Database design using Visio, and based on data requirementsand business rules focusing on normalizing data to third normal form.

C

week 4

DeVry University
Student Lab Activity

BIS245 Database Essentials for Business with Lab

A.Lab # : BSBA BIS245A-4B

B.Lab 4B of 7:Completing Queries

C.Lab Overview – Scenario / Summary:

TCOs:

# 6: Given a physical database containing tables and relationships and business requirements, create the necessary queries.

Scenario/Summary

The lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. The student can create a query with the wizard, with query design view, or with SQL statements. The Northwind database will be used again in this lab.

Upon completing this lab, you should be able to:

• Create a query by following lab instruction.

• Create a query by using either query designer, or query wizard.

• Create a query by using SQL statements.

• Interpret the results of queries

D.Deliverables:

Submit the MS Access Database file that contains the queries created in this lab.

Step

Deliverable

Points

1

Query #1 – step-by-step

2

Query #2 – Compound Statements

3

Query #3 – Suppliers – step-by-step

4

Query #4 – Suppliers (more advanced)

5

Query #5 – Customers – using SQL Statements

6

Query #6 – Putting it all together

E. Lab Steps:

.jpg”>

Copyright © 2010 by DeVry Educational Development Corporation.

All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

.jpg”>

BIS245_W4b_iLab_Instructions.docx Page 1 of 20

week 6

DeVry University

Student Lab Activity

BIS245 Database Essentials for Business with Lab

A.Lab # BSBA BIS245A-6

B.Lab 6 of 7 :Creating Reports

C.Lab Overview – Scenario / Summary:

TCO(s):

7. Given a database application with a completed relational schema, populated tables, and business reporting requirements, create the necessary reports and make a business decision.

Scenario:

The purpose of this lab is to create Access Reports. After a report is created, the student will sort the fields in different ways. Also the Student can also delete fields in layout view and modify the appearance of the report by applying Themes. In addition to the report generated by Access, the lab also uses Report Design to allow users to design their own reports.

Upon completing this lab, you should be able to:

ocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

.jpg”>

BIS245_W7_iLab_Instructions.docx Page 1 of 20

DeVry University

Student Lab Activity

BIS245 Database Essentials for Business with Lab

A.Lab # : BSBA BIS245A-7

B.Lab 7 of 7 :Database Navigation

C.Lab Overview – Scenario / Summary:

TCOs:

8. Given a database application containing forms, queries and reports, automate tasks and create a menu system which allows for efficient navigation and operation of the database’s functionality.

Scenario:

The purpose of this lab is to show the student how to create navigation systems for an Access application. Students will create a main navigation form which links to additional navigation forms called Enter Data and View Reports. Additionally, students will create forms to automate printing reports and Closing/Exiting the Database. The Enter Data form allows you to open Customer and City forms automatically. The View Reports form allows the user to automatically open the Customer List and Customers by City reports. The Print Reports form will allow users to automatically print the reports. The Exit Database form allows users to close the database and exit the application entirely.

The navigation forms can provide some measure of security to the database as they may prevent users unfamiliar with Access from accessing database objects directly; they make using Access more intuitive to use, and can prevent new users from inadvertently damaging your database objects.

D. Deliverables:

Upload the modified Lab7_Start.accdb file that you saved as YourName_Lab7.accdb to the

Week 7 iLab Dropbox.

Step

Deliverable

Points

Part A

Develop the Enter Data, View Reports, Print Reports, and Customer

Database Navigation Forms

Part B

Create the Close Database Form and add it to the Main Database

Navigation Form. Set the Database Options.

.jpg”>

Copyright © 2010 by DeVry Educational Development Corporation.

All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

.jpg”>

BIS245_W7_iLab_Instructions.docx Page 1 of 20

quizes

week 3

(TCO 2) In a relational database, entities are

events.

persons.

things.

All of the above

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 4 of 4

Comments:

Question 2. Question : (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.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

Question 3. Question : (TCO 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.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

Question 4. Question : (TCO 2) A crow’s foot

$ is a Boolean field.

is used to describe attributes.

points to the child table.

points to the parent table.

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 0 of 4

Comments:

Question 5. Question : (TCO 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.

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 4 of 4

Comments:

Question 6. Question : (TCO 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.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 7. Question : (TCO 3) Data validation refers to

a set of constraints that helps control illegal data entry.

correcting data errors after they are entered into a table.

duplicating a primary key in a table.

typing data accurately into a table.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 8. Question : (TCO 4) What Access data type would you use to store $23.58?

Calculated

Currency

Money

Number

Instructor Explanation: Chapter 1: Grauer section of book

Points Received: 4 of 4

Comments:

Question 9. Question : (TCO 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.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 10. Question : (TCO 4) Which question is part of a requirements analysis?

What is the organization’s structure and core business?

What are the existing problems with the current database?

Will the database interface with other systems?

All of the above.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

week 5

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

appears with a specific value.

IN can be left blank.

cannot be left blank.

is selected from a list of values.

Comments:

Question 2. Question :

(TCO 2) An example of a lookup is

one to a million.

2010.

AL, CA, NC, NY, TX.

IN SSN, Date, 111-22-3333, AZ.

Comments:

Question 3. Question :

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

Comments:

Question 4. Question :

(TCO 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 List

Lookup Wizard

Comments:

Question 5. Question :

(TCO 2) To add a list of available choices to a form, use a(n)

checkbox.

combo box.

option button.

tab control.

Comments:

Question 6. Question :

(TCO 5) A bound control

always contains a label.

contains a calculation.

must be unique and contain a data field from another underlying source.

must contain a formula.

Comments:

Question 7. Question :

(TCO 5) Which statement below best describes how designers and users work with forms?

IN The designer and the users will edit and update forms.

The designer of a form will make it functional and easy to use the first time.

The designer of a form will need to keep revising a form as suggested by the users.

The designer and users will never need to edit a well designed form.

Comments:

Question 8. Question :

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

Comments:

Question 9. Question :

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

IN Add calculations, controls, pictures, and lines.

Change the size of a form section.

Enter a data value.

Modify the properties of the form.

Comments:

Question 10. Question :

(TCO 5) A data macro

executes a series of actions when a table event occurs or whenever a named macro is executed.

identifies fields to compare.

is a switchboard.

is a table event.

week 6

Question Offered Price $11.00
DEVRY BIS245 WEEK 6 QUIZ 2015 GRADED 100 % CORRECT
Question # 00050010
Subject:.homeworkminutes.com/search/subject/10/Computer-Science”>Computer Science /.homeworkminutes.com/search/subcategory/129/General-Computer-Science”>General Computer Science
Due on: 02/28/2015
Posted On: 02/22/2015 08:23 AM Posted By:.homeworkminutes.com/assets/img/f.gif”>spqr.homeworkminutes.com//assets/img/tiny_arrow_up.gif”>Questions:6235Tutorials:6139 Spent$0.00 Earned$42,758.63 Feedback Score:96% (1384 ratings).homeworkminutes.com//assets/img/sendemail.gif”>Send Message.homeworkminutes.com/welcome/report/q/50010″>Report this Question as InappropriateQuestion
(TCO 1) The easiest way to create a report is to use the following report tool.

Blank Report

Report

Report Design

IN Report Wizard

Instructor Explanation: Chapter 4: Grauer section of book

Points Received: 0 of 4

Comments:

Question 2. Question :

(TCO 1) Which of the following is NOT a Report Wizard Layout type?

Block

Outline

Stepped

Summary

Instructor Explanation: Chapter 4: Grauer section of book

Comments:

Question 3. Question :

(TCO 1) Which of the following statements best describes the image below?

Datasheet view of the Employees report

Design view of the Employees report

Layout view of the Employees report

Design view of the Employees query

Instructor Explanation: Chapter 4: Grauer section of book

Comments:

Question 4. Question :

(TCO 1) A tabular layout resembles a

form that you fill out.

spreadsheet.

group of index cards.

All of the above

Instructor Explanation: Chapter 4: Grauer section of book

Comments:

Question 5. Question :

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

Instructor Explanation: Chapter 4: Grauer section of book

Comments:

Question 6. Question :

(TCO 1) Modifications to a report can be done in

Detail View.

Layout View.

Print View.

IN All of the above

Instructor Explanation: Chapter 4: Grauer section of book

Points Received: 0 of 4

Comments:

Question 7. Question :

(TCO 7) PivotTables and PivotCharts that summarize data based on multiple sources use a

form.

query.

report.

table.

Comments:

Question 8. Question :

(TCO 7) In addition to the detail field, the primary drop zone in a PivotTable design grid is the

column field.

filter field.

row field.

All of the above

Comments:

Question 9. Question :

(TCO 7) A bar chart is used to display

continuous data.

data in horizontal bars.

percentages of a whole.

vertically stacked data.

Comments:

Question 10. Question :

(TCO 7) All of the following are Aggregate Functions EXCEPT

average.

count.

select.

sum.

Comments:

week 2

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

5

7

9

10

Question 2. Question :

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

Box

Diamond

Line

Triangle

Instructor Explanation: Chapter 2: Frost section of book

Points Received: 4 of 4

Comments:

Question 3. Question :

(TCO 2) Primary keys can be created

as computer-generated fields.

from an existing single field.

from several existing fields.

All of the above

Instructor Explanation: Chapter 2: Frost section of book

Points Received: 4 of 4

Comments:

Question 4. Question :

(TCO 3) A relational table includes the following conditions EXCEPT

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

Instructor Explanation: Week 2 Lecture

Points Received: 0 of 4

Comments:

Question 5. Question :

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

IN #12/11/2011#

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

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 0 of 4

Comments:

Question 6. Question :

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

AutoNumber

Currency

Date/Time

Number

Instructor Explanation: Chapter 2: Grauer section of book

Points Received:

Comments:

Question 7. Question :

(TCO 3) All of the following are true about a property EXCEPT

a Datasheet View is used to display properties.

referenced as an attribute.

IN changes can be made with a property sheet.

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

Instructor Explanation: Chapter 2: Grauer section of book

Points Received:

Comments:

Question 8. Question :

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

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

Instructor Explanation: Chapter 2: Grauer section of book

Points Received:

Comments:

Question 9. Question :

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

PNPI.

field size property.

indexed property.

validation rule property.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received:

Comments:

Question 10. Question :

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

Equal

And

Not

Or

Instructor Explanation: Chapter 2: Grauer section of book

Points Received:

Comments:

week 4

(TCO 1) A storage location in a database that holds related information is a

query.

form.

report.

table.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 2. Question :

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

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 3. Question :

(TCO 2) In Access, query results are displayed in which view?

datasheet.

form.

recordset.

report.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 4. Question :

(TCO 2) Access has __________ data types.

six

eight

10

12

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 5. Question :

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

a junction table is used.

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

Instructor Explanation: Chapter 2: Grauer section of book

Comments:

Question 6. Question :

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

Query results are not saved after the query is executed.

The instructions to create a query are not stored in the database.

Instructor Explanation: Chapter 2: Grauer section of book

\

Comments:

Question 7. Question :

(TCO 2) When building a calculated field, formulas can be created using the

IN Form Wizard.

Expression Builder.

Report Builder.

Table Wizard.

Instructor Explanation: Chapter 3: Grauer section of book

Comments:

Question 8. Question :

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

IN All of the above

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 0 of 4

Comments:

Question 9. Question :

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

Instructor Explanation: Chapter 2: Grauer section of book

Comments:

Question 10. Question :

(TCO 6) A make table query

creates the structure of a table but does not populate the table with records.

is another name for an append query.

selects records from one or more tables and uses them to create a new table.

requires the destination table to exist first.

final

1.

Question :

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

Points Received:

5 of 5

Comments:

2.

Question :

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

Points Received:

5 of 5

Comments:

3.

Question :

(TCO 1) To design a report you should do all of the following EXCEPT

Points Received:

5 of 5

Comments:

4.

Question :

(TCO 1) Which of the following is NOT a Report Section?

Points Received:

5 of 5

Comments:

5.

Question :

(TCO 1) A Detail line is used to

Points Received:

0 of 5

Comments:

6.

Question :

(TCO 2) For the following image, which of the following is TRUE?

Points Received:

5 of 5

Comments:

7.

Question :

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

Points Received:

5 of 5

Comments:

8.

Question :

(TCO 3) A property that provides a “user friendly” name to a column in Datasheet View is a

Points Received:

5 of 5

Comments:

9.

Question :

(TCO 3) Summarized data in an easy-to-read view is known as a

Points Received:

0 of 5

Comments:

10.

Question :

(TCO 3) Which of the following is NOT true of a property?

Points Received:

0 of 5

Comments:

11.

Question :

(TCO 4) Which of the following does NOT describe the following one-to-one relationship?

Points Received:

5 of 5

Comments:

1.

Question :

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

Points Received:

0 of 5

Comments:

2.

Question :

(TCO 5) A calculated control

Points Received:

5 of 5

Comments:

3.

Question :

(TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties?

Points Received:

5 of 5

Comments:

4.

Question :

(TCO 6) Data aggregates

Points Received:

5 of 5

Comments:

5.

Question :

(TCO 7) When making vertical data comparisons, you should use the following chart.

Points Received:

5 of 5

Comments:

6.

Question :

(TCO 7) Discrete data

Points Received:

5 of 5

Comments:

7.

Question :

(TCO 8) A switchboard is a

Points Received:

5 of 5

Comments:

8.

Question :

(TCO 9) To secure an Access database, all of the following should be done EXCEPT

Points Received:

5 of 5

Comments:

9.

Question :

(TCO 9) All of the following describe a certification authority EXCEPT

Points Received:

5 of 5

Comments:

10.

Question :

(TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms and reports?

Points Received:

5 of 5

Comments:

11.

Question :

(TCO 4) The term “cascading” refers to

Points Received:

5 of 5

Comments:

1.

Question :

(TCO 1) Describe three-tier architecture. Explain the functions performed by each tier.

Points Received:

40 of 40

Comments:

ok

2.

Question :

(TCO 2) Explain business logic and describe how it relates to a relational database.

Points Received:

40 of 40

Comments:

ok

3.

Question :

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

Points Received:

40 of 40

Comments:

ok

4.

Question :

(TCO 4) Explain 1NF, 2NF, and 3NF as related to database design.

Points Received:

40 of 40

Comments:

ok

Order your essay today and save 30% with the discount code: RESEARCHOrder Now