LIVE CHAT
Place An Order

Want To Save Your Precious Time But Still Get High-Quality Work?     Most Definitely YES!

ScholarMatic | 24/7 Homework Help

ScholarMatic Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

(TCO 1) Data aggregates

by | Nov 30, 2023 | questions

BIS245 Week 4 Quiz:

Question
1. 1.(TCO 1)
Data aggregates
(Points : 4)


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.

Question
2. 2.(TCO 2)
All of the following are Access data types EXCEPT (Points : 4)


autonumber.

date/time.

number.

string.

Question
3. 3.(TCO 2)
Which of the following is NOT true of a single-table query? (Points : 4)


It can be created using the
Simple Query Wizard.

Queries can be created using the
Query Design Tool.

You can overwrite Table data
using the Datasheet View of a Query.

The top portion of the Query
Design View displays the fields and criteria.

Question
4. 4.(TCO 2) Access
has __________ data types.
(Points : 4)


six

eight

10

12

Question
5. 5.(TCO 2)
The command language used with relational databases is (Points : 4)


PNPI.

RDBMS.

SQL.

tuple.

Question
6. 6.(TCO 2)
Another term for an expression is (Points : 4)


formula.

function.

parameter.

query.

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) 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
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) Which of the following is true about a crosstab query? (Points : 4)


It is an action query.

It is used to retrieve parameter
data.

It summarizes a data source into
rows and columns with aggregate data displayed at the intersection of the
rows and columns.

It summarizes unmatched records
from a data source.
ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99

  

Click Order Now to get 100% Original Answer Customized to your instructions!

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

 

Your Paper Is In Safe Hands

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

ScholarMatic: Get Started

Assignment Writing Service

Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!

Write My Paper