Answered You can hire a professional tutor to get the answer.

QUESTION

1. (TCO 1) Which object, by definition, allows you to ask questions about the data stored in a database, such as which customers live in New Orleans

1. (TCO 1) Which object, by definition, allows you to ask questions about the data stored in a database, such as which customers live in New Orleans and Seattle? (Points : 4) CriteriaFormQueryTable2. (TCO 2) When constructing criteria for a query, you should use (Points : 4) 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.3. (TCO 2) In Access, query results are displayed in which view? (Points : 4) datasheet.form.recordset.report.4. (TCO 2) Access has __________ data types. (Points : 4) sixeight10125. (TCO 2) The command language used with relational databases is (Points : 4) PNPI.RDBMS.SQL.tuple.6. (TCO 2) Another term for an expression is (Points : 4) formula.function.parameter.query.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.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 above9. (TCO 6) Which of the following does NOT describe data redundancy? (Points : 4) 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.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.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question