“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 2Entity 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 3Conceptual 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 4Creating 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 documentc. 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 theWEEK 5Data 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 6Data 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 7Database 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 silabsBIS 245 Week 1 iLab Devry UniversityA. Lab # : BSBA BIS245A-1B. Lab 1 of 7 : Introduction to MS Visio and MS AccessC. Lab OverviewScenario/SummaryTCOs: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 to1. 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; and3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.D. DeliverablesYourName_Lab1.vsd (Visio Diagram)YourName_Lab1C_Questions.docxA.Lab # : BSBA BIS245A-2B.Lab 2 of 7 :Skills Development in Visio; Creation of MS Access DatabaseC.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 MSweek 3A.Lab # : BSBA BIS245A-3B.Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business RulesC.Lab Overview–Scenario/SummaryTCOs: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.ScenarioYou 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 to1. 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; and3. create a new MS Access database based on the ERD.D. DeliverablesSectionDeliverablePointsPart A StepYourNameLab3.vsd (Visio Diagram)7Part B StepYourNameLab3.accdb (Access Database)3E. Lab StepsPage1 of 6week 5A.Lab # : BSBA BIS245A-5AB.Lab 5A of 7 :Database design using Visio, and based on data requirementsand business rules focusing on normalizing data to third normal form.Cweek 4DeVry UniversityStudent Lab ActivityBIS245 Database Essentials for Business with LabA.Lab # : BSBA BIS245A-4BB.Lab 4B of 7:Completing QueriesC.Lab Overview Scenario / Summary:TCOs:# 6: Given a physical database containing tables and relationships and business requirements, create the necessary queries.Scenario/SummaryThe 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 queriesD.Deliverables:Submit the MS Access Database file that contains the queries created in this lab.StepDeliverablePoints1Query #1 step-by-step2Query #2 Compound Statements3Query #3 Suppliers step-by-step4Query #4 Suppliers (more advanced)5Query #5 Customers using SQL Statements6Query #6 Putting it all togetherE. 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 20week 6DeVry UniversityStudent Lab ActivityBIS245 Database Essentials for Business with LabA.Lab # BSBA BIS245A-6B.Lab 6 of 7 :Creating ReportsC.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 20DeVry UniversityStudent Lab ActivityBIS245 Database Essentials for Business with LabA.Lab # : BSBA BIS245A-7B.Lab 7 of 7 :Database NavigationC.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 databases 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 theWeek 7 iLab Dropbox.StepDeliverablePointsPart ADevelop the Enter Data, View Reports, Print Reports, and CustomerDatabase Navigation FormsPart BCreate the Close Database Form and add it to the Main DatabaseNavigation 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 20quizesweek 3(TCO 2) In a relational database, entities areevents.persons.things.All of the aboveInstructor Explanation: Chapter 3: Frost section of bookPoints Received: 4 of 4Comments:Question 2. Question : (TCO 2) Logical design refers todeveloping 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 LecturePoints Received: 4 of 4Comments:Question 3. Question : (TCO 3) Database design refers todeveloping 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 LecturePoints Received: 4 of 4Comments: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 bookPoints Received: 0 of 4Comments:Question 5. Question : (TCO 2) A one-to-many relationship isa 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 bookPoints Received: 4 of 4Comments:Question 6. Question : (TCO 2) An associative table isused 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 bookPoints Received: 4 of 4Comments:Question 7. Question : (TCO 3) Data validation refers toa 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 bookPoints Received: 4 of 4Comments:Question 8. Question : (TCO 4) What Access data type would you use to store $23.58?CalculatedCurrencyMoneyNumberInstructor Explanation: Chapter 1: Grauer section of bookPoints Received: 4 of 4Comments: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 bookPoints Received: 4 of 4Comments: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 LecturePoints Received: 4 of 4Comments:week 5(TCO 2) A required field that is used in entering data is a field thatappears 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 isone to a million.2010.AL, CA, NC, NY, TX.IN SSN, Date, 111-22-3333, AZ.Comments:Question 3. Question :(TCO 2) An input maskallows 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 ViewFields GroupLookup ListLookup WizardComments: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 controlalways 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 macroexecutes 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 6Question Offered Price $11.00DEVRY BIS245 WEEK 6 QUIZ 2015 GRADED 100 % CORRECTQuestion # 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 ReportReportReport DesignIN Report WizardInstructor Explanation: Chapter 4: Grauer section of bookPoints Received: 0 of 4Comments:Question 2. Question :(TCO 1) Which of the following is NOT a Report Wizard Layout type?BlockOutlineSteppedSummaryInstructor Explanation: Chapter 4: Grauer section of bookComments:Question 3. Question :(TCO 1) Which of the following statements best describes the image below?Datasheet view of the Employees reportDesign view of the Employees reportLayout view of the Employees reportDesign view of the Employees queryInstructor Explanation: Chapter 4: Grauer section of bookComments:Question 4. Question :(TCO 1) A tabular layout resembles aform that you fill out.spreadsheet.group of index cards.All of the aboveInstructor Explanation: Chapter 4: Grauer section of bookComments:Question 5. Question :(TCO 1) A tool that creates a report through a series of dialog boxes on the Create tab is theBlank Report.Label Wizard.Report.Report Wizard.Instructor Explanation: Chapter 4: Grauer section of bookComments:Question 6. Question :(TCO 1) Modifications to a report can be done inDetail View.Layout View.Print View.IN All of the aboveInstructor Explanation: Chapter 4: Grauer section of bookPoints Received: 0 of 4Comments:Question 7. Question :(TCO 7) PivotTables and PivotCharts that summarize data based on multiple sources use aform.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 thecolumn field.filter field.row field.All of the aboveComments:Question 9. Question :(TCO 7) A bar chart is used to displaycontinuous 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 EXCEPTaverage.count.select.sum.Comments:week 2(TCO 2) How many data types does Access recognize?57910Question 2. Question :(TCO 2) Which of the following is used as a symbol for an entity?BoxDiamondLineTriangleInstructor Explanation: Chapter 2: Frost section of bookPoints Received: 4 of 4Comments:Question 3. Question :(TCO 2) Primary keys can be createdas computer-generated fields.from an existing single field.from several existing fields.All of the aboveInstructor Explanation: Chapter 2: Frost section of bookPoints Received: 4 of 4Comments:Question 4. Question :(TCO 3) A relational table includes the following conditions EXCEPTIN 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 LecturePoints Received: 0 of 4Comments: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/201112/11/2011IN #12/11/2011#Between #10/01/2011# And #11/12/2011#Instructor Explanation: Chapter 2: Grauer section of bookPoints Received: 0 of 4Comments:Question 6. Question :(TCO 3) Which data type will increment automatically each time a new record is entered into a table?AutoNumberCurrencyDate/TimeNumberInstructor Explanation: Chapter 2: Grauer section of bookPoints Received: Comments:Question 7. Question :(TCO 3) All of the following are true about a property EXCEPTa 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 bookPoints 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 bookPoints Received: Comments:Question 9. Question :(TCO 4) Storage space for a field is reserved with thePNPI.field size property.indexed property.validation rule property.Instructor Explanation: Chapter 2: Grauer section of bookPoints Received: Comments:Question 10. Question :(TCO 2) In Access, which item below is NOT considered a logical operator?EqualAndNotOrInstructor Explanation: Chapter 2: Grauer section of bookPoints Received: Comments:week 4(TCO 1) A storage location in a database that holds related information is aquery.form.report.table.Instructor Explanation: Chapter 2: Grauer section of bookPoints Received: 4 of 4Comments:Question 2. Question :(TCO 2) When constructing criteria for a query, you should useno 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 bookPoints Received: 4 of 4Comments: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 bookPoints Received: 4 of 4Comments:Question 4. Question :(TCO 2) Access has __________ data types.sixeight1012Instructor Explanation: Chapter 2: Grauer section of bookPoints Received: 4 of 4Comments:Question 5. Question :(TCO 2) All of the following describe a many-to-many relationship in Access EXCEPTa 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 bookComments: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 tableQuery 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 theIN Form Wizard.Expression Builder.Report Builder.Table Wizard.Instructor Explanation: Chapter 3: Grauer section of bookComments:Question 8. Question :(TCO 2) A primary keycan 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 aboveInstructor Explanation: Chapter 2: Grauer section of bookPoints Received: 0 of 4Comments: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 bookComments:Question 10. Question :(TCO 6) A make table querycreates 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.final1.Question :(TCO 1) Which object would you use to enter, delete, or
modify data?Points Received:5 of 5Comments:2.Question :(TCO 1) Which object would you use to retrieve customers who
live in Germany and the United States?Points Received:5 of 5Comments:3.Question :(TCO 1) To design a report you should do all of the
following EXCEPTPoints Received:5 of 5Comments:4.Question :(TCO 1) Which of the following is NOT a Report Section?Points Received:5 of 5Comments:5.Question :(TCO 1) A Detail line is used toPoints Received:0 of 5Comments:6.Question :(TCO 2) For the following image, which of the following is
TRUE?Points Received:5 of 5Comments:7.Question :(TCO 2) A symbol used in ER diagrams for an entity is aPoints Received:5 of 5Comments:8.Question :(TCO 3) A property that provides a “”user friendly””
name to a column in Datasheet View is aPoints Received:5 of 5Comments:9.Question :(TCO 3) Summarized data in an easy-to-read view is known as
aPoints Received:0 of 5Comments:10.Question :(TCO 3) Which of the following is NOT true of a property?Points Received:0 of 5Comments:11.Question :(TCO 4) Which of the following does NOT describe the
following one-to-one relationship?Points Received:5 of 5Comments: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 5Comments:2.Question :(TCO 5) A calculated controlPoints Received:5 of 5Comments: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 5Comments:4.Question :(TCO 6) Data aggregatesPoints Received:5 of 5Comments:5.Question :(TCO 7) When making vertical data comparisons, you should
use the following chart.Points Received:5 of 5Comments:6.Question :(TCO 7) Discrete dataPoints Received:5 of 5Comments:7.Question :(TCO 8) A switchboard is aPoints Received:5 of 5Comments:8.Question :(TCO 9) To secure an Access database, all of the following
should be done EXCEPTPoints Received:5 of 5Comments:9.Question :(TCO 9) All of the following describe a certification
authority EXCEPTPoints Received:5 of 5Comments: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 5Comments:11.Question :(TCO 4) The term “”cascading”” refers toPoints Received:5 of 5Comments:1.Question :(TCO 1) Describe three-tier architecture. Explain the
functions performed by each tier.Points Received:40 of 40Comments:ok2.Question :(TCO 2) Explain business logic and describe how it relates
to a relational database.Points Received:40 of 40Comments:ok3.Question :(TC”