Reference no: EM13901901
1. All of the following are Access objects EXCEPT
criteria.
form.
query.
table.
2. In what situation would Excel be a better choice than Access?
You have a limited amount of data.
You have an extensive amount of data.
You need to maintain constant connectivity to an external database.
You require a relational view of your data.
3. The Navigation Pane allows you to:
Open Tables
Open Views
Filter By Datatype
Filter By Group and Navigate to Category
4. Filters are used to do all of the following EXCEPT
a filter can be removed by selecting Remove Filter from the Sort & Filter group.
all records in a table will be displayed if all of the filters are removed.
filter effects are cumulative.
it does not matter whether you apply a filter or a sort first.
5.. A report creation tool that will automatically pull in the fields from a table or query is the
report tool.
report design.
report wizard.
blank report.
6. A field that uniquely identifies each record in a table is a
link.
relationship.
primary key.
foreign key.
7 Which of the following is supported by a primary key? (Points : 5)
Changeable over time
May be null
Unique
Updateable
8. All of the following apply to the relationships image found below EXCEPT
a one-to-many relationship is found between the Suppliers table and the Products table.
a relationship exists between the two primary keys of the Suppliers table and the Products table.
one table is not joined to the two other tables.
the primary key for the Categories table is CategoryID.
9. All of the following summarize characteristics of a PivotChart EXCEPT
a PivotChart is created automatically each time a PivotTable is created.
changes made to a PivotTable will be made automatically to the PivotChart.
some chart types are bar, line, column, pie, scatter, doughnut, and radar.
PivotChart elements are modified in the Design View.
10. Which of the following is NOT true of a property?
A property is an object's characteristic or attribute.
Tables, forms, queries, and reports have a set of properties.
A property sheet is used to make changes.
Design properties are displayed in Datasheet View.
11. When building a calculated field, formulas can be created using the
form wizard.
expression builder.
report builder.
table wizard.
|
What is rationale for offering stock options as compensation
: What is the rationale for offering stock options as compensation? Why has this form of compensation been particularly popular with technology firms in the past?
|
|
Operations can include all except
: Operations can include all except; A company has been working a six-sigma program for several years, with a focus on improving yield on a key process. Prior to the program, the typical yields were averaging 70%. Presently, yields are consistently abo..
|
|
What is typically common about financial statement accounts
: Provide several examples of financial statement accounts that are often loosely referred to as reserves. What is typically common about all financial statement accounts that are informally referred to as reserves?
|
|
Test hypothesis that median salary of financial accountants
: Use these data to test the hypothesis that the median salary of financial accountants in 2007 was not greater than in 2004. What is the p-value?
|
|
In what situation would excel be better choice than access
: All of the following are Access objects EXCEPT. In what situation would Excel be a better choice than Access? Filters are used to do all of the following EXCEPT. A field that uniquely identifies each record in a table is a. All of the following summ..
|
|
Compute the times interest earned for park company
: Interpret its times interest earned (assume that its competitors average a times interest earned of 4.0).
|
|
Prepare chart that lists line items reporte on balance sheet
: From the perspective of the lessee, prepare a chart that lists the line items reported on the (a) income statement, (b) balance sheet, and (c) statement of cash flows under each reporting technique.
|
|
What is the p-value
: To test the hypothesis that the median weight of 16-year-old females from Los Angeles is at least 110 pounds, a random sample of 200 such females was chosen. If 120 females weighed less than 110 pounds, does this discredit the hypothesis? U..
|
|
Text offers evidence of evolution
: Your text offers evidence of evolution including: the fossil record, biogeography, comparative anatomy, comparative embryology, and molecular biology.
|