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.