Question 1. All of the following are Access objects EXCEPT criteria. form. query
ID: 444194 • Letter: Q
Question
Question 1. All of the following are Access objects EXCEPT criteria.form.
query.
table. Question 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. Question 3. The Navigation Pane allows you to: Open Tables
Open Views
Filter By Datatype
Filter By Group and Navigate to Category Question 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. Question 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. Question 6. A field that uniquely identifies each record in a table is a link.
relationship.
primary key.
foreign key. Question 7 Which of the following is supported by a primary key? (Points : 5) Changeable over time
May be null
Unique
Updateable Question 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. Question 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. Question 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. Question 11 When building a calculated field, formulas can be created using the form wizard.
expression builder.
report builder.
table wizard.
Explanation / Answer
Question 1. All of the following are Access objects EXCEPT criteria. form. query
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.