Question 1. 1.(TCO 1) Data aggregates (Points : 4)<\/p>\n
are used to perform calculations on individual records in a table or query.<\/p>\n
cannot be used in a report.<\/p>\n
perform calculations on entire columns of data.<\/p>\n
return multiple values.<\/p>\n
Question 2. 2.(TCO 2) All of the following are Access data types EXCEPT (Points : 4)<\/p>\n
autonumber.<\/p>\n
date\/time.<\/p>\n
number.<\/p>\n
string.<\/p>\n
Question 3. 3.(TCO 2) Which of the following is NOT true of a single-table query? (Points : 4)<\/p>\n
It can be created using the Simple Query Wizard.<\/p>\n
Queries can be created using the Query Design Tool.<\/p>\n
You can overwrite Table data using the Datasheet View of a Query.<\/p>\n
The top portion of the Query Design View displays the fields and criteria.<\/p>\n
Question 4. 4.(TCO 2) Access has __________ data types. (Points : 4)<\/p>\n
six<\/p>\n
eight<\/p>\n
10<\/p>\n
12<\/p>\n
Question 5. 5.(TCO 2) The command language used with relational databases is (Points : 4)<\/p>\n
PNPI<\/p>\n
RDBMS<\/p>\n
SQL<\/p>\n
tuple.<\/p>\n
Question 6. 6.(TCO 2) Another term for an expression is (Points : 4)<\/p>\n
formula.<\/p>\n
function.<\/p>\n
parameter.<\/p>\n
query.<\/p>\n
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)<\/p>\n
Date.<\/p>\n
DateDiff.<\/p>\n
DateParse.<\/p>\n
DatePart.<\/p>\n
Question 8. 8.(TCO 2) A primary key (Points : 4)<\/p>\n
can be computer generated.<\/p>\n
consists of one field only that uniquely identifies each record in a table.<\/p>\n
is a relationship between two or more tables.<\/p>\n
All of the above<\/p>\n
Question 9. 9.(TCO 6) A parameter query is (Points : 4)<\/p>\n
a select query where the user provides the criterion at run time.<\/p>\n
an action query used to modify data.<\/p>\n
an aggregate query used to summarize field data.<\/p>\n
used to backup databases.<\/p>\n
Question 10. 10.(TCO 6) Which of the following is true about a crosstab query? (Points : 4)<\/p>\n
It is an action query.<\/p>\n
It is used to retrieve parameter data.<\/p>\n
It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.<\/p>\n
It summarizes unmatched records from a data source.<\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-174430","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/174430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=174430"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/174430\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=174430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=174430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=174430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}