devry BIS155 week 4 quiz

| September 28, 2018

Page 1 Question 1. 1.(TCO 1) When designing a database, you should (Points : 4) determine the input and then design the tables. determine the output and then design the tables. develop the forms and then input the data. input the data and then design the reports.Question 2. 2.(TCO 2) To locate a blank field, your criterion in a query would be (Points : 4) blank. empty. null. void.Question 3. 3.(TCO 2) In Access, query results are displayed in which view? (Points : 4) datasheet. form. recordset. report.Question 4. 4.(TCO 2) Which of the following is not a recommended practice for designing multi-table queries? (Points : 4) Include only related tables in your query. Remove join lines in Query Design to speed up query processing. Related tables should be established before you design a multitable query. Print a Relationship Report to guide you in selecting related tables.Question 5. 5.(TCO 2) A memo field (Points : 4) is a link to text information in another file. holds important information that needs to be flagged. is used to store descriptive information up to 65,536 characters. is used to store text information up to 255 characters.Question 6. 6.(TCO 2) Which of the following statements is true about queries? (Points : 4) 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.Question 7. 7.(TCO 2) A function used to isolate a specific portion of a date such as year, month, or day in a date field is (Points : 4) Date. DateDiff. DateParse. DatePart.Question 8. 8.(TCO 2) You can add records through the (Points : 4) DataSheet View of a table. Design View of a table. Report View. All of the aboveQuestion 9. 9.(TCO 6) A parameter query is (Points : 4) a select query where the user provides the criterion at run time. an action query used to modify data. an aggregate query used to summarize field data. used to backup databases.Question 10. 10.(TCO 6) All of the following are true about a delete query EXCEPT (Points : 4) A delete query is an action query. Access will display a warning message before running the delete query. It can be created by clicking the Create tab, Query Wizard, and then select Delete Query. It selects records from a table and then removes them from the table.

Get a 30 % discount on an order above $ 100
Use the following coupon code:
RESEARCH
Order your essay today and save 30% with the discount code: RESEARCHOrder Now
Positive SSL