Reference no: EM131383994
Question 1.Data aggregates
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. All of the following are Access data types EXCEPT:
autonumber.
date/time.
number.
string.
Question 3. Which of the following is NOT true of a single-table query?
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. Access has __________ data types.
six
eight
10
12
Question 5. The command language used with relational databases is
PNPI
RDBMS
SQL
tuple.
Question 6. Another term for an expression is
formula.
function.
parameter.
query.
Question 7.A function used to isolate a specific portion of a date such as year, month, or day in a date field is
Date.
DateDiff.
DateParse.
DatePart.
Question 8. A primary key
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. A parameter query is
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.Which of the following is true about a crosstab query?
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.
|
Find the angle through which the comet is deflected
: By using the path equation, find the angle through which the comet is deflected and the distance of closest approach.
|
|
Describe the envelope seal
: Describe the "envelope", seal, and the early Mesopotamian writing process. Identify the issue being kept "on file," and comment on what this reveals about Mesopotamian society and the primary ways it compares to modern society in these respects.
|
|
Explain why the navy is likely to choose your company
: Imagine that you have received a Request for Proposal (RFP).You also find out through a reliable source that a local competitor has also received an RFP for a similar type of product and service.you will be required to negotiate the contract, and w..
|
|
What is the probability of either x or y occurring
: The eventsXandYare mutually exclusive. SupposeP(X)_.05 andP(Y)_.02. What is the probability of either X or Y occurring? What is the probability that neitherXnorYwill happen?
|
|
Which of the following is true about a crosstab query
: A function used to isolate a specific portion of a date such as year, month, or day in a date field is.Which of the following is true about a crosstab query?A function used to isolate a specific portion of a date such as year, month, or day in a date..
|
|
Which divides each line in the given ratio
: Show that the lines AP, B Q, C R, DS all meet in a point (called the centroid of the tetrahedron), which divides each line in the ratio 3:1.
|
|
Give the answer of muliple choice question
: The Acme Products case study notes that the senior management at Acme is concerned because the company takes so long to bring new products to the market. Which of the following approaches would your trainees identify as the most likely solution to..
|
|
Find the protein concentration in a fraction
: The equation from the BSA standard curve is y=0.0264x+0.0129 where y is the absorbance and x is the concentration in µg/mL
|
|
What is the purpose of sds in the cell lysis solution
: What is the purpose of SDS in the cell lysis solution? What is the function of the alcohol solution?
|