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

BIS245/ BIS245 WEEK 4 QUIZ (A+++++ ANSWER)

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.

Show more >
  • mastersolution
    mastersolution
    152 orders completed
    $10.00
    ANSWER
    Tutor has posted answer for $10.00. See answer's preview

    ******** * 1(TCO ** Data ********** (Points * ***

    ***

    **** ** ******* ************ ** ********** records ** * table ** ****** cannot

    **

    **** in * ******* ******* ************

    **

    ****** ******* ** ***** return ******** values

    ********

    2 ***** **

    ***

    ** the ********* *** ****** **** ***** EXCEPT ******* * *** autonumber date/time number string ********

    *

    *****

    **

    *****

    of

    ***

    *********

    **

    ***

    **** ** a ************ ****** ******* : *** ** *** be ******* ***** the Simple ***** Wizard *******

    can

    ** created ***** *** Query ****** Tool You ***

    *********

    ***** **** ***** the ********* **** of a Query

    ***

    *** ******* ** *** ***** ****** View ******** the ****** *** criteria

    Question * ***** ** ****** *** __________ data types (Points : *** six

    ******

    10 *** ******** * ***** ** *** ******* language used **** **********

    *********

    **

    *******

    :

    ***

    *****

    ******

    ****

    ******

    ******** 6 ***** 2) Another **** for ** ********** ** (Points * *** ******** *********

    **********

    query

    ********

    *

    *****

    2)

    *

    ********

    ****

    to ******* * specific ******* ** a **** such ** **** month or

    day

    **

    *

    ****

    *****

    **

    *******

    :4)

    *****

    ********* ********** DatePart ******** 8 8(TCO 2) * primary *** ******* : *** *** ** ******** ********** ******** ** *** field **** that ******** ********** each ****** in

    *

    table

    **

    a

    ************

    *******

    ***

    **

    ****

    ******* All ** *** ****** ******** * ***** 6) *

    *********

    ***** ** ******* *

    ***

    a ****** query ***** *** **** ******** *** ********* ** run ***** **

    ******

    ***** used ** ****** data ** ********* query

    ****

    to ********* field data

    ****

    to ****** ********** ******** ** ****** ** ***** ** *** *********

    **

    **** ***** a ******** query? (Points * *** It is an ******

    query

    It ** **** to ******** ********* *****

    It

    ********** * **** ****** into **** and *******

    with

    aggregate **** ********* **

    ***

    ************ of *** **** and columns ** summarizes ********* ******* **** * **** ******

    Click here to download attached files:

    BIS245 Week 4 Quiz-Data aggregates.docx

Learn more effectively and get better grades!

Ask a Question