2. (TCO 1) In what situation would Excel be a better choice than Access? (Points

2. (TCO 1) In what situation would Excel be a better choice than Access? (Points : 5)
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. (TCO 1) All of the following are Report Wizard Layout types EXCEPT (Points : 5)
block.
outline.
stepped.
summary.4. (TCO 1) Which of the following is NOT a Report Section? (Points : 5)
Detail
Group Footer
Page Footer
Summary5. (TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5)
report tool.
report design.
report wizard.
blank report.6. (TCO 2) Which of the following is not a database system? (Points : 5)
Hierarchical
Network
Relational
SQL7. (TCO 2) SQL is a fourth-generation language that is (Points : 5)
flat-file oriented and nonprocedural.
oriented toward static data.
procedural and record oriented.
table oriented and nonprocedural.8. (TCO 3) All of the following apply to the relationships image found below EXCEPT (Points : 5)
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. (TCO 3) All of the following summarize characteristics of a PivotChart EXCEPT (Points : 5)
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. (TCO 3) Which of the following is NOT true of indexed property? (Points : 5)
An example of a setting is Yes (No Duplicates).
Indexing a table speeds the retrieval time.
Primary keys must be indexed.
Setting the index requires each record to be scanned sequentially.11. (TCO 4) When building a calculated field formulas can be created using the (Points : 5)
form wizard.
expression builder.
report builder.
table wizard.
TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics? (Points : 5)
Datasheet Form
Multiple Items Form
Split Form
Subform2. (TCO 5) A calculated control (Points : 5)
contains a formula that displays the result.
is a bound box.
is a text box containing a description.
is an unbound box that the user will fill in with a numeric value.3. (TCO 6) Which of the following is a term used to describe the names of controls fields or properties? (Points : 5)
Function
Identifier
Operator
Value4. (TCO 6) Which of the following expressions is NOT correct? (Points : 5)
Cost: [Price] * [Qty]
DiscountAmt = [Price] * [Qty] * [Discount]
PrPerSqFt: [SalePr] / [SqFt]
Sales: [GP] * [Qty]
5. (TCO 7) To display data as percentages of a whole use the following chart. (Points : 5)
Bar
Line
Pie
Scatter Plot6. (TCO 7) Continuous data (Points : 5)
are measured in integer values.
cannot be subdivided into meaningful information.
could be subdivided into smaller and smaller units.
describe classifications or categories.7. (TCO 8) The Switchboard Manager is an Access utility that is used (Points : 5)
by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.8. (TCO 9) To secure an Access database all of the following should be done EXCEPT (Points : 5)
digitally sign a database and open it in a trusted location.
require a password to open a database.
run the Table Analyzing Wizard and Performance Analyzer.
save a database with the .accde file extension.9. (TCO 9) All of the following describe a certification authority EXCEPT (Points : 5)
a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database.
a certification authority is a commercial company that is highly regulated in most countries.
a fee is charged for the service of issuing and validating identities using a digital signature.
certification authority companies establish their own rules and regulations that users must follow.10. (TCO 10) To examine the efficiency and performance of an Access database you should (Points : 5)
migrate the database out of Access and into a larger DBMS.
move the database to its own dedicated server.
redesign your database applying 3NF principles.
use the Performance Analyzer and Table Analyzer to optimize the performance of the database.11. (TCO 4) Which of the following is NOT true of a ship date field? (Points : 5)
A ship date is considered a constant.
A ship date would be defined as a date/time field.
A ship date would be defined as a calculated field.
Date arithmetic can be applied to a ship date field.