How should we approach the design of the menu?

 

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-7-discussion-1-2-latest/

 

Devry BIS 245 Week 7 Discussion 1 & 2 Latest

Discussion 1
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?

Discussion 2
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 security and restrict access?

 

 

Download File Now

 


Click on the Table tab, select your fields, and then click the Finish button.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-6-quiz-latest/

 

Devry BIS 245 Week 6 Quiz Latest

  1. 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:

 

Download File Now

 

 


What questions would you ask of the users?

Just Click on Below Link To Download This Course:

Devry BIS 245 Week 6 Discussion 1 & 2 Latest

Devry BIS 245 Week 6 Discussion 1 & 2 Latest
Discussion 1
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?

Discusion 2
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?

Download File Now


An input mask placed on a form will apply to Student Answer: all forms based on that table.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-5-quiz-latest/

 

Devry BIS 245 Week 5 Quiz Latest

  1. 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:

 

Download File Now

 


What is the importance of data validation?

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-5-discussion-1-2-latest/

 

Devry BIS 245 Week 5 Discussion 1 & 2 Latest

Discussion 1
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?

Discussion 2
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?

 

Download File Now

 


perform calculations on entire columns of data.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-4-quiz-latest/

 

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:

 

 

Download File Now

 

 


Describe what the querying technique is and how it is useful.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-4-discussion-1-2-latest/

 

Devry BIS 245 Week 4 Discussion 1 & 2 Latest

Discussion 1
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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Discussion 2
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.

  1. 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.
  2. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document
  3. 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.
  4. 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 query design and the query results as an MS Word document to this thread for discussion.
  5. Assist your classmates in modifying their queries if they run into difficulties.

Download File Now

 


More tables can be joined to either table.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-3-quiz-latest/

 

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%20a.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%20c.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.

 

 

Download File Now

 


Explain why you think that a particular relationship applies to that pair of entities.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-3-discussion-1-2-latest/

 

Devry BIS 245 Week 3 Discussion 1 & 2 Latest

Discussion 1
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?

Discussion 2
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.

 

Download File Now

 

 


Number data types require no delimiters.

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-bis-245-week-2-quiz-latest/

 

Devry BIS 245 Week 2 Quiz Latest

  1. 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:

 

Download File Now