Reference no: EM131200747
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.
What type of descriptive chart would be most useful
: A researcher is interested in determining whether there is a relationship between the number of room air conditioning units sold each week and the time of year.- What type of descriptive chart would be most useful in performing this analysis? Expla..
|
Investigating the marked mass
: A meat packer is investigating the marked mass shown on Vienna sausages. A pilot study showed a mean of 11.8kg per pack and a standard deviation of 0.7kg.
|
Explain the value and weaknesses of the gordon model
: Explain the relationship observed between the required rate of return, growth rate and the dividend paid, and the estimated value of the stock using the Gordon Model.
|
What fraction of the seats are now left for open seating
: Mr. Larson's principal tells him that he needs to reserve one eighth of seats for teachers and school officials the remainder can be used for open seating what fraction of the seats are now left for open seating.
|
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?
|
Differentiate the types of authorities in an organization
: Identify effective delegation practices. Explain the key principles of delegation. Differentiate the types of authorities in an organization. Analyze how those in authority can effectively delegate responsibility authority.
|
Perform audience analysis while planning your presentation
: Perform an audience analysis while planning your presentation. Ensure that you consider issues such as arrangement of the room, content and length of the presentation, and handouts and visual aids.
|
Find a formula for the median income
: The median income is approximately linear and is a function of time. Find a formula for the median income, I, as a function of the year t, where t is the number of years since 1900. Source: U.S Census Bureau.
|
Effectiveness of garlic in reducing ldl cholesterol
: a. What is the best point estimate of the population mean net change in LDL cholesterol after the garlic treatment? b. Construct a 90% confidence interval of the mean net change in LDL cholesterol after the garlic treatment.
|